mirror of
				https://github.com/MariaDB/server.git
				synced 2025-10-31 10:56:12 +01:00 
			
		
		
		
	 47010ccffa
			
		
	
	
	47010ccffa
	
	
	
		
			
			- Major rewrite of ddl_log.cc and ddl_log.h
  - ddl_log.cc described in the beginning how the recovery works.
  - ddl_log.log has unique signature and is dynamic. It's easy to
    add more information to the header and other ddl blocks while still
    being able to execute old ddl entries.
  - IO_SIZE for ddl blocks is now dynamic. Can be changed without affecting
    recovery of old logs.
  - Code is more modular and is now usable outside of partition handling.
  - Renamed log file to dll_recovery.log and added option --log-ddl-recovery
    to allow one to specify the path & filename.
- Added ddl_log_entry_phase[], number of phases for each DDL action,
  which allowed me to greatly simply set_global_from_ddl_log_entry()
- Changed how strings are stored in log entries, which allows us to
  store much more information in a log entry.
- ddl log is now always created at start and deleted on normal shutdown.
  This simplices things notable.
- Added probes debug_crash_here() and debug_simulate_error() to simply
  crash testing and allow crash after a given number of times a probe
  is executed. See comments in debug_sync.cc and rename_table.test for
  how this can be used.
- Reverting failed table and view renames is done trough the ddl log.
  This ensures that the ddl log is tested also outside of recovery.
- Added helper function 'handler::needs_lower_case_filenames()'
- Extend binary log with Q_XID events. ddl log handling is using this
  to check if a ddl log entry was logged to the binary log (if yes,
  it will be deleted from the log during ddl_log_close_binlogged_events()
- If a DDL entry fails 3 time, disable it. This is to ensure that if
  we have a crash in ddl recovery code the server will not get stuck
  in a forever crash-restart-crash loop.
mysqltest.cc changes:
- --die will now replace $variables with their values
- $error will contain the error of the last failed statement
storage engine changes:
- maria_rename() was changed to be more robust against crashes during
  rename.
		
	
			
		
			
				
	
	
		
			165 lines
		
	
	
	
		
			5.9 KiB
		
	
	
	
		
			C
		
	
	
	
	
	
			
		
		
	
	
			165 lines
		
	
	
	
		
			5.9 KiB
		
	
	
	
		
			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 */
 | |
| 
 | |
| /*
 | |
|   Rename a table
 | |
| */
 | |
| 
 | |
| #include "ma_fulltext.h"
 | |
| #include "trnman_public.h"
 | |
| 
 | |
| /**
 | |
|    @brief renames a table
 | |
| 
 | |
|    @param  old_name        current name of table
 | |
|    @param  new_name        table should be renamed to this name
 | |
| 
 | |
|    @return Operation status
 | |
|      @retval 0      OK
 | |
|      @retval !=0    Error
 | |
| */
 | |
| 
 | |
| int maria_rename(const char *old_name, const char *new_name)
 | |
| {
 | |
|   char from[FN_REFLEN],to[FN_REFLEN];
 | |
|   int data_file_rename_error= 0, index_file_rename_error= 0;
 | |
| #ifdef USE_RAID
 | |
|   uint raid_type=0,raid_chunks=0;
 | |
| #endif
 | |
|   MARIA_HA *info;
 | |
|   MARIA_SHARE *share;
 | |
|   myf sync_dir= 0;
 | |
|   my_bool ddl_recovery= 0;
 | |
|   DBUG_ENTER("maria_rename");
 | |
| 
 | |
| #ifdef EXTRA_DEBUG
 | |
|   _ma_check_table_is_closed(old_name,"rename old_table");
 | |
|   _ma_check_table_is_closed(new_name,"rename new table2");
 | |
| #endif
 | |
|   /** @todo LOCK take X-lock on table */
 | |
|   if (!(info= maria_open(old_name, O_RDWR, HA_OPEN_FOR_REPAIR, 0)))
 | |
|   {
 | |
|     int error= my_errno;
 | |
|     /*
 | |
|       Check if we are in recovery from a rename that failed in the middle
 | |
|       and we are now renaming things back.
 | |
|     */
 | |
|     if (error == ENOENT)
 | |
|     {
 | |
|       char *index_file= from;
 | |
|       char *data_file= to;
 | |
|       fn_format(index_file, old_name, "", MARIA_NAME_IEXT,
 | |
|                 MY_UNPACK_FILENAME | MY_APPEND_EXT);
 | |
|       fn_format(data_file, old_name, "", MARIA_NAME_DEXT,
 | |
|                 MY_UNPACK_FILENAME | MY_APPEND_EXT);
 | |
|       if (!access(data_file, F_OK) && access(index_file, F_OK))
 | |
|       {
 | |
|         ddl_recovery= 1;
 | |
|         goto forced_rename;
 | |
|       }
 | |
|     }
 | |
|     DBUG_RETURN(error);
 | |
|   }
 | |
|   share= info->s;
 | |
| #ifdef USE_RAID
 | |
|   raid_type =      share->base.raid_type;
 | |
|   raid_chunks =    share->base.raid_chunks;
 | |
| #endif
 | |
| 
 | |
|   /*
 | |
|     the renaming of an internal table to the final table (like in ALTER TABLE)
 | |
|     is the moment when this table receives its correct create_rename_lsn and
 | |
|     this is important; make sure transactionality has been re-enabled.
 | |
|   */
 | |
|   DBUG_ASSERT(share->now_transactional == share->base.born_transactional);
 | |
|   if (share->now_transactional && !share->temporary && !maria_in_recovery)
 | |
|   {
 | |
|     LSN lsn;
 | |
|     LEX_CUSTRING log_array[TRANSLOG_INTERNAL_PARTS + 2];
 | |
|     size_t old_name_len= strlen(old_name)+1, new_name_len= strlen(new_name)+1;
 | |
|     sync_dir= MY_SYNC_DIR;
 | |
|     log_array[TRANSLOG_INTERNAL_PARTS + 0].str= (uchar*)old_name;
 | |
|     log_array[TRANSLOG_INTERNAL_PARTS + 0].length= old_name_len;
 | |
|     log_array[TRANSLOG_INTERNAL_PARTS + 1].str= (uchar*)new_name;
 | |
|     log_array[TRANSLOG_INTERNAL_PARTS + 1].length= new_name_len;
 | |
|     /*
 | |
|       For this record to be of any use for Recovery, we need the upper
 | |
|       MySQL layer to be crash-safe, which it is not now (that would require
 | |
|       work using the ddl_log of sql/sql_table.cc); when it is, we should
 | |
|       reconsider the moment of writing this log record (before or after op,
 | |
|       under THR_LOCK_maria or not...), how to use it in Recovery.
 | |
|       For now it can serve to apply logs to a backup so we sync it.
 | |
|     */
 | |
|     if (unlikely(translog_write_record(&lsn, LOGREC_REDO_RENAME_TABLE,
 | |
|                                        &dummy_transaction_object, NULL,
 | |
|                                        (translog_size_t)(old_name_len + new_name_len),
 | |
|                                        sizeof(log_array)/sizeof(log_array[0]),
 | |
|                                        log_array, NULL, NULL) ||
 | |
|                  translog_flush(lsn)))
 | |
|     {
 | |
|       maria_close(info);
 | |
|       DBUG_RETURN(1);
 | |
|     }
 | |
|     /*
 | |
|       store LSN into file, needed for Recovery to not be confused if a
 | |
|       RENAME happened (applying REDOs to the wrong table).
 | |
|     */
 | |
|     if (_ma_update_state_lsns(share, lsn, share->state.create_trid, TRUE,
 | |
|                               TRUE))
 | |
|     {
 | |
|       maria_close(info);
 | |
|       DBUG_RETURN(1);
 | |
|     }
 | |
|   }
 | |
| 
 | |
|   _ma_reset_state(info);
 | |
|   maria_close(info);
 | |
| 
 | |
| forced_rename:
 | |
|   /*
 | |
|     This code is written so that it should be possible to re-run a
 | |
|     failed rename (even if there is a server crash in between the
 | |
|     renames) and complete it.
 | |
|   */
 | |
|   fn_format(from,old_name,"",MARIA_NAME_IEXT,MY_UNPACK_FILENAME|MY_APPEND_EXT);
 | |
|   fn_format(to,new_name,"",MARIA_NAME_IEXT,MY_UNPACK_FILENAME|MY_APPEND_EXT);
 | |
|   if (mysql_file_rename_with_symlink(key_file_kfile, from, to,
 | |
|                                      MYF(MY_WME | sync_dir)))
 | |
|     index_file_rename_error= my_errno;
 | |
|   fn_format(from,old_name,"",MARIA_NAME_DEXT,MY_UNPACK_FILENAME|MY_APPEND_EXT);
 | |
|   fn_format(to,new_name,"",MARIA_NAME_DEXT,MY_UNPACK_FILENAME|MY_APPEND_EXT);
 | |
|   if (mysql_file_rename_with_symlink(key_file_dfile, from, to,
 | |
|                                      MYF(MY_WME | sync_dir)))
 | |
|     data_file_rename_error= my_errno;
 | |
|   if (data_file_rename_error && data_file_rename_error != ENOENT &&
 | |
|       !ddl_recovery)
 | |
|   {
 | |
|     /*
 | |
|       Now we have a renamed index file and a non-renamed data file, try to
 | |
|       undo a successful rename of the index file.
 | |
|     */
 | |
|     if (!index_file_rename_error)
 | |
|     {
 | |
|       fn_format(from, old_name, "", MARIA_NAME_IEXT,
 | |
|                 MYF(MY_UNPACK_FILENAME|MY_APPEND_EXT));
 | |
|       fn_format(to, new_name, "", MARIA_NAME_IEXT,
 | |
|                 MYF(MY_UNPACK_FILENAME|MY_APPEND_EXT));
 | |
|       mysql_file_rename_with_symlink(key_file_kfile, to, from,
 | |
|                                    MYF(MY_WME | sync_dir));
 | |
|     }
 | |
|   }
 | |
|   DBUG_RETURN(data_file_rename_error ? data_file_rename_error:
 | |
|               index_file_rename_error);
 | |
| }
 |