mariadb/storage/maria/ma_delete_all.c

/* Copyright (C) 2006 MySQL AB & MySQL Finland AB & TCX DataKonsult AB

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; version 2 of the License.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA */

/* Remove all rows from a MARIA table */
/* This clears the status information and truncates files */

#include "maria_def.h"
#include "trnman.h"

/**
   @brief deletes all rows from a table

   @param  info             Maria handler

   @note It is important that this function does not rely on the state
   information, as it may be called by ma_apply_undo_bulk_insert() on an
   inconsistent table left by a crash.

   @return Operation status
     @retval 0      ok
     @retval 1      error
*/

int maria_delete_all_rows(MARIA_HA *info)
{
  MARIA_SHARE *share= info->s;
  my_bool log_record;
  LSN lsn;
#ifdef HAVE_MMAP
  my_bool mmap_file= share->file_map != 0;
#endif
  DBUG_ENTER("maria_delete_all_rows");

  if (share->options & HA_OPTION_READ_ONLY_DATA)
  {
    DBUG_RETURN(my_errno=EACCES);
  }
  /**
     @todo LOCK take X-lock on table here.
     When we have versioning, if some other thread is looking at this table,
     we cannot shrink the file like this.
  */
  if (_ma_readinfo(info,F_WRLCK,1))
    DBUG_RETURN(my_errno);
  log_record= share->now_transactional && !share->temporary;

  if (log_record)
  {
    /*
      This record will be used by Recovery to finish the deletion if it
      crashed. We force it to have a complete history in the log.
    */
    LEX_CUSTRING log_array[TRANSLOG_INTERNAL_PARTS + 1];
    uchar log_data[FILEID_STORE_SIZE];
    my_bool error;
    log_array[TRANSLOG_INTERNAL_PARTS + 0].str=    log_data;
    log_array[TRANSLOG_INTERNAL_PARTS + 0].length= sizeof(log_data);
    if (unlikely(translog_write_record(&lsn, LOGREC_REDO_DELETE_ALL,
                                       info->trn, info, 0,
                                       sizeof(log_array)/sizeof(log_array[0]),
                                       log_array, log_data, NULL) ||
                 translog_flush(lsn)))
      goto err;
    /*
      If we fail in this function after this point, log and table will be
      inconsistent.
    */
    if (_ma_mark_file_changed(share))
      goto err;

    /*
      Because LOGREC_REDO_DELETE_ALL does not operate on pages, it has the
      following problem:
      delete_all; inserts (redo_insert); all pages get flushed; checkpoint:
      the dirty pages list will be empty. In recovery, delete_all is executed,
      but redo_insert are skipped (dirty pages list is empty).
      To avoid this, we need to set skip_redo_lsn now, and thus need to sync
      files.
      Also fixes the problem of:
      bulk insert; insert; delete_all; crash:
      "bulk insert" is skipped (no REDOs), so if "insert" would not be skipped
      (if we didn't update skip_redo_lsn below) then "insert" would be tried
      and fail, saying that it sees that the first page has to be created
      though the inserted row has rownr>0.

      We use lsn-1 below to ensure that the above redo will be executed
    */
     error= _ma_state_info_write(share,
                                 MA_STATE_INFO_WRITE_DONT_MOVE_OFFSET |
                                 MA_STATE_INFO_WRITE_LOCK) ||
       _ma_update_state_lsns(share, lsn-1, info->trn->trid, FALSE, FALSE) ||
       _ma_sync_table_files(info);
     info->trn->rec_lsn= LSN_IMPOSSIBLE;
     if (error)
       goto err;
  }
  else
  {
    if (_ma_mark_file_changed(share))
      goto err;
    /* Other branch called function below when writing log record, in hook */
    _ma_reset_status(info);
  }
  /* Remove old history as the table is now empty for everyone */
  _ma_reset_state(info);
  share->state.changed= 0;

  /*
    If we are using delayed keys or if the user has done changes to the tables
    since it was locked then there may be key blocks in the page cache. Or
    there may be data blocks there. We need to throw them away or they may
    re-enter the emptied table or another table later.
  */

#ifdef HAVE_MMAP
  if (mmap_file)
    _ma_unmap_file(info);
#endif

  if (_ma_flush_table_files(info, MARIA_FLUSH_DATA|MARIA_FLUSH_INDEX,
                            FLUSH_IGNORE_CHANGED, FLUSH_IGNORE_CHANGED))
    goto err;
  /*
    Avoid truncate of internal temporary tables as this can have a big
    performance overhead when called by mysql_handle_single_derived()
    tables in MariaDB as part of split materialization.
  */
  if (!share->internal_table &&
      (mysql_file_chsize(info->dfile.file, 0, 0, MYF(MY_WME)) ||
       mysql_file_chsize(share->kfile.file, share->base.keystart, 0,
                         MYF(MY_WME))))
    goto err;

  if (_ma_initialize_data_file(share, info->dfile.file))
    goto err;

  if (log_record)
  {
    /* Update lsn to signal that the above redo does not have to be executed anymore */
    if ( _ma_update_state_lsns(share, lsn, info->trn->trid, FALSE, FALSE) ||
         _ma_sync_table_files(info))
      goto err;
  }

  if (info->opt_flag & WRITE_CACHE_USED)
    reinit_io_cache(&info->rec_cache, WRITE_CACHE, 0, 1, 1);

  _ma_writeinfo(info, WRITEINFO_UPDATE_KEYFILE);
#ifdef HAVE_MMAP
  /* Map again */
  if (mmap_file)
    _ma_dynmap_file(info, (my_off_t) 0);
#endif
  DBUG_RETURN(0);

err:
  {
    int save_errno=my_errno;
    _ma_writeinfo(info, WRITEINFO_UPDATE_KEYFILE);
    info->update|=HA_STATE_WRITTEN;	/* Buffer changed */
    DBUG_RETURN(my_errno=save_errno);
  }
} /* maria_delete_all_rows */


/*
  Reset status information

  SYNOPSIS
    _ma_reset_status()
    maria	Maria handler

  DESCRIPTION
    Resets data and index file information as if the file would be empty
    Files are not touched.
*/

void _ma_reset_status(MARIA_HA *info)
{
  MARIA_SHARE *share= info->s;
  MARIA_STATE_INFO *state= &share->state;
  uint i;
  DBUG_ENTER("_ma_reset_status");

  state->split= 0;
  state->state.records= state->state.del= 0;
  state->changed=  0;                            /* File is optimized */
  state->dellink= HA_OFFSET_ERROR;
  state->sortkey=  (ushort) ~0;
  state->state.key_file_length= share->base.keystart;
  state->state.data_file_length= 0;
  state->state.empty= state->state.key_empty= 0;
  state->state.checksum= 0;
  share->state.open_count= 0;
  share->global_changed= 0;

  share->changed= 1;                            /* We must write state */

  *info->state= state->state;

  /* Drop the delete key chain. */
  state->key_del= HA_OFFSET_ERROR;
  /* Clear all keys */
  for (i=0 ; i < share->base.keys ; i++)
    state->key_root[i]= HA_OFFSET_ERROR;
  DBUG_VOID_RETURN;
}