ELF $4( UE ]Ð&UE]@<@8xÍUu(]Ðt&U1҉VS] uL3A9uED3[^]ÍUS]S`t[]ËC<$SD$$D$ D$$t $D$D$ D$D$$$ʚ;$$D$D$ D$D$$D$8D$$D$ D$$t $D$D$ D$D$$$ʚ;UVS ut=F1ۋP<9t Ћ@@9uB8x [^]á$$D$1D$ D$D$$D$!D$$LD$ D$$t $D$1D$ D$D$$$ʚ;1tXtC$D$<D$ D$D$$$ʚ; [^]á$$D$<D$ D$D$$D$!D$$pD$ D$$ UWVS]C0x4E CTCX$u%$$ tɃ[^_]à uM A(M|MEMB5wwGU苑EӉى19]K~!E$[^_]Ã{9Mԃ_Et&UH]] u}s{Ft>$C@D$D$$ ]u}]Ë=oD$D$$C@D$CD$$BB" $$$D$hD$ D$D$$D$$8!tID$ D$$pD$ $ D$2uG  CLSXE܋F<;C\U܉D$BH$U܋BHxD tC$D$D$ D$D$$$ʚ;<$ECTUpDE@l|$4$U܉VTVX4$ E 4$}EUD$ t$|$$uEG!iT$$ $$D$D$ D$D$$D$>D$$D$ D$$0h$ |$4$E܋P(s|B5wwPUЋEӉى19] 9Mt4$t&cLJ G!T$U܋BH$FD$<$s2 t&UWVS,}G`wF"1G`XDt$$E uaE\$ $D$E D$ E$ED$ \$t$$C~ [TCXuD$4$D$4$t&\$ GtD$G$PD$ Et8$ED$ \$t$$tC~ [TCXu눉t$$EF!,[^_]ËG<$W$C@D$D$$ ]u}]Ë=oD$D$$C@D$CD$$BB< $$$D$D$ D$D$$D$$8!tID$ D$$pD$ $ D$2uMAKUu~ UEą_UċC(R,UuEE/Bu tCE@EM̃E$9K(6uiMVUUUS8v MԋJuJ Br RMЋMуM؋KDt ttEԋU؉p녋UB#t2Zt-v%t֋M؀| t B< uu뵃t&vE؀|u| u&zuB< vwiE؍< 7J9BtʋMAB9uEЉ}؅/}$u4$ECPU{ pDE@<C M}4$L$EĉFTFX4$U E4$EML$ t$<$D$uUEB!OT$$ UB<lE1ҍLA;MuM؋D։EE/4$T$s udždžB5wwHUEӉى19]|9Mv4$uEF!>$D$4$Q0EЉA0MPP UxxRD$$hD$ UM$$$D$D$ D$D$$D$$EU{G8_t<$us\$<$uE}UB$MyWAu܉ځOjbX,1sCuC$UË@T$$u݋CS $CS$D$T$ CC ICL$CLD$yD$$GE$c$D$D$$D$ E UD$T$$D$cD$$P D$ $D$?D$$ D$ E UD$T$$D$bD$$8 D$ D$$ $D$D$$D$ E UD$T$$D$@D$$ D$ {C k$D$WD$$ D$ E UD$T$$D$.D$$ D$ U1VS uk$A1=HtC$D$oD$ UD$D$$$ʚ;1 tI$D$lD$ oD$D$$$ʚ;B88$dž [^]É$$D$D$ D$D$$D$GD$$ D$ D$$t $D$D$ D$D$$$ʚ;$D$hD$o$$$D$oD$ UD$D$$D$1D$$D$ D$$)1$t&D$$$$D$lD$ oD$D$$D$2D$$< D$ D$$'U1S]$1=@tC$D$oD$ UD$D$$$ʚ;=^}$^D$ vD$D$$ǃ[]Ív$$D$tD$ D$D$$D$>D$$p D$ D$$t $D$tD$ D$D$$$ʚ;$/D$D$o$=^T\v$$ǃ[]Ív$$D$oD$ UD$D$$D$1D$$D$ D$$1"$&U1WVSl}EEZ1} tY5D$ D$$pD$ E$ l[^_]á$$D$ D$ D$D$$D$,D$$ D$ D$$8)$D$ D$ D$D$$$ʚ;$$D$ D$ D$D$$D$,D$$ D$ D$$u[t&$D$ D$ D$D$$$ʚ; u Ex @ UD$$M D$ $EE؋E $U ktrEMOjbt01Љ5Ojb15>W Fu܉ʁOjbX,1sCu%UB$EM@L$$uًMQU 1tU 1<'\BuU1t&<'LBu1}qE ]EE}ȃD$$ D$D$ D$|$$Å۾ CC C[[EwڃC09C$ B0<B0G9 tC$D$D$ D$D$$$ʚ;} MD$ D$` $E 4$D$'D$'; o@ld_t@able@ _nam@e :=f@ 'UD$'$T$D$LD$É$sLEЅ EPEDELEF)FTE FFROM F SYS_FFOREFIGN_FCOLSF WHEF RE IF$D = F('MЋUD$'$L$ T$}̋U:D$'$T$'; D@ELET@E FR@ OM S@YS_F@OREI@GN W@HERE@ ID f@$= @&'MЃ'UD$'$L$ T$U:D$'$T$f';@ pED$/8$EM9MEND;fF EMȍTF9R=tC$D$^ D$ D$D$$$ʚ;E$E7tC$D$b D$ D$D$$$ʚ;}@O8_t<$us\$<$uUMB, J4ǁ$tC$D$j D$ D$D$$$ʚ;$E B Uǂ D$D$$Mǁ E$E`Et M $ut3EX8pt$uދ^Ut$$uMA!E$E~M $E$D$D$$D$ EUD$T$$D$@D$$ D$ EE] HU D$ T$$M $ U$CDELES,FTE FFROM F SYS_FFOREFIGN_FCOLSF WHEF RE IF$D = F('E8$D$'D$'; D@ELET@E FR@ OM S@YS_F@OREI@GN W@HERE@ ID f@$= @&'U':D$'$T$pf';@ $D$D$$D$ EMD$L$$D$D$$ D$ EED$$ D$D$ D$D$@$5M $D$ D$D$ D$D$dE$U@@ @@@EEMD$ED$ ET$ $D$E ?E1UEt<'tBuMUʉM1Ʉt<'LBuE)؉EȋE܅E1E‹St1<'LBut SD$/$7uȃ;}U릡$$D$^ D$ D$D$$D$3D$$D$ D$$ $$D$j D$ D$D$$D$?D$$4D$ D$${$$D$b D$ D$D$$D$!D$$D$ D$$0;"4$BD$D$gD$$$$D$D$ D$D$$D$eD$$tD$ D$$u]|$1$¸%1U}D$E $D$ 1۸}ÅtMAD$E $ $D$ D$$LD$ U M$T$L$D$yD$$pD$ MED$L$$$D$ D$ D$D$$$ʚ;$D$D$$tD$ MU L$T$$D$[D$$0D$ EUD$T$$D$D$$D$ EM D$L$$D$D$$`D$ Mǁ $D$D$Eǀ $D$.D$$D$ UMT$L$$D$D$$D$ E UD$T$$<BBD D$'D$$D$ E UD$T$$D$rD$$D$ +$$D$ D$ D$D$$D$ND$$D$ D$$ $ D$T$ $ &'UWVSWAu܉ځOjbX,1sCu`F$UUƋ@T$$u݋FvFl^Tu [W Fu܉ʁOjbX,1sCu0F$$UƋ@T$$u݋^Tt"U?;sM A~h^lI E EE $u̅]ȅt9}ȃ@O8wt<$u ދ^t$<$uMĉ $E @!EC D$E$vU B-[< M $E$D$D$$D$ EU D$T$$D$ND$$PD$ E&D$ D$D$ D$D$@$w$$D$ D$ D$D$$D$&D$$(D$ D$$4U $$$D$ D$ D$D$$D$!D$$D$ D$$0[<;stM A5E)$1=tC$D$oD$ UD$D$$$ʚ;4$4$t$ D$D$$U E4$T$D$t$ D$D$$QC M 4$D$L$FF  $aE/$$D$D$ D$D$$D$eD$$tD$ D$$\Dt$1$¸ $$D$D$ D$D$$D$eD$$tD$ D$${c|$1$¸!+4$M A@VADEĉQH$tC$D$ D$ D$D$$$ʚ;$U EX tC$D$ D$ D$D$$$ʚ;M EE D$ \$L$$$$D$ D$ D$D$$D$$E!$D$1D$$D$ FD$E D$$D$kD$$D$ E ED$$t$$ |$E'D$. D$$$$D$ D$ D$D$$D$?D$$4D$ D$$$D$'D$$@D$ FU D$T$$D$sD$$hD$ E EVF҉EU$ED$@D$D$ D$D$$ÅCC C[[E}ԉڃC09C$9B0 B0ȉMЃ@9htC$D$D$ D$D$$$ʚ;EԿUMЉD$T$ $EȉÉ4$E$$D$*D$$D$ UM T$L$$D$D$$D$ E $$D$oD$ UD$D$$D$1D$$D$ D$$$$D$ D$ D$D$$D$7D$$D$ D$$} EED$D$ |$\$$E D$RD$D$ $@UM T$L$$D$D$$D$ ]1EWD$@D$D$ D$D$@$@t$$ $$D$D$ D$D$$D$eD$$tD$ D$$ Eԉ$D$E¸E$D$RD$$@D$ UM T$L$$D$D$$D$ $ED$D$$UM T$L$$D$D$$ D$ E &'UWVS,E$E1}5EU|/ jU z BE E $U$EdUƋ}9҉ tC$D$ D$ D$D$$$ʚ;UOjbt8u1ɍ&Љ5Ojb15>W Fu܉ʁOjbX,1sCuC$UË@T$$u݉tC$D$ D$ D$D$$$ʚ;ChE UD$D$$]@sEC8t$u~t$$u} ,D$D$$ D$ EU D$T$$ED$D$$E UD$T$$=BB E $U $E @!E,[^_]á$$D$ D$ D$D$$D$4D$$D$ D$$t $D$ D$ D$D$$$ʚ;U z BSD$$>$$D$ D$ D$D$$D$(D$$D$ D$$8t $D$ D$ D$D$$$ʚ;E$Éq$$D$ D$ D$D$$D$!D$$PD$ D$$$$D$ D$ D$D$$D$BD$$ D$ D$$QBU $$D$4D$$tD$ EU D$T$$D$6D$$D$ EU D$T$$D$D$$D$ $@Bu@F8^t4$ {\$4$$ D$\T$$ Et&'UWVS,EC$f1;[=tC$D$oD$ UD$D$$$ʚ;5u(EC$UCw]C$1;tC$D$oD$ UD$D$$$ʚ;MOjb1t71ɍ&Љ5Ojb15>W Cu܉ʁOjb=1ҋ_,sCunt&C$^Ë@t$$uG$GtKU@Ɖ$D$D$4$4$  EC$1;>tC$D$oD$ UD$D$$$ʚ;1tI$D$D$ D$D$$$ʚ;MBQAMBAP$UD$DD$$M9@G8_t<$us\$<$u}@G8wt<$uދ^t$<$uC$C$4$=$]EE,[^_]D$mD$$D$D$$<$V$$D$D$ D$D$$D$;D$$D$ D$$D$D$$b$$D$oD$ UD$D$$D$1D$$D$ D$$$$D$oD$ UD$D$$D$1D$$D$ D$$bS$$D$oD$ UD$D$$D$1D$$D$ D$$3$AQMA'UWVSE ]f{ C7t&E$v#Ukt 8tmEU C@$D$T$ bǃ D$D$$UD$\$$ǃ [^_]Ív$$D$ D$ D$D$$D$&D$$|D$ D$$t $D$ D$ D$D$$$ʚ;{ C7\D$$G&ED$$ 'UWVS,E x @KUR4҉UE1E@8EEUE1ۋp 9@UDt$$u١($D$D$$ZD$ UB8UDD$E D$$D$D$$sD$ E UD$T$$D$(D$$D$ U ǂ $D$D$E UD$D$B$E ǀ U B!,[^_]ËUz ~E;}U}UZ$v tk 8tD$D$D$ D$D$$UÉCC@@ @E @@\$$U \$T$$Ë@$9tC$D$D$ D$D$$$ʚ;$E C $ z$D$$"$$D$D$ D$D$$D$SD$$D$ D$$UH]u}tD D$ D$$pD$ E $]u}]ËMU BYMy0tOU11U,B09v3B4D$tڋM $E $tM y  E@E$EEvUktMD$/ $4 tC$D$ D$ D$D$$$ʚ;$&t&D$BD$D$ D$D$$U@@ @CCE @@$\$M \$L$$Nj@$9tC$D$JD$ D$D$$$ʚ;<$E tAǀ D$D$$ E ǀ G$U B!CEܹ| \$D$ $U $$$D$ D$ D$D$$D$&D$$(D$ D$$0>%$$D$JD$ D$D$$D$SD$$D$ D$$uܿouܿUD$ $MD$ $sEUD$ND$D$ D$T$$1CC C[[uڃC09C$B0 B0ȉM@9tC$D$D$ D$D$$$ʚ;EUMT$$L$ËE+xD;#UDM UL$B$@D$s]NjC8t$uދ^Mt$ $u$*D$D$$$D$ D$5D$$D$ l$P;$D$ND$D$ D$D$@$z$D$'D$$,D$ UM BL$D$$D$D$$D$ EOjb@Et1]1Љ5Ojb15>W Cu܉ʁOjbX,1sCuC$U؉Ë@T$$u݋U MD$T$ $$D$D$$D$ UM BL$D$$D$D$$TD$ M؉ $rE@EF$$D$D$ D$D$$D$eD$$tD$ D$$M$L$E¸6E$7E f $row0mysql.cupdating or deletingsetting table locksetting auto-inc lockinserting./../include/sync0sync.ic./../include/sync0rw.icimporting tablespace./../include/log0log.ic InnoDB: table InnoDB: Error: table mysql/hostuserdbrenaming table/#sql./../include/mem0mem.ic to discarding tablespace Cannot DISCARD table because it is referenced by checking table InnoDB: prev record InnoDB: record InnoDB: duplicate key in Error: dropping table Cannot drop table from the dictionary cache! . ! dropping databaseInnoDB: DROP DATABASE adding foreign keyscreating index InnoDB: Error: column appears twice in creating table/rsql because tablespace full InnoDB: Failing assertion: err != DB_SUCCESS InnoDB: The database cannot continue operation because of InnoDB: lack of space. You must add a new data file to InnoDB: my.cnf and restart the database. InnoDB: We detected index corruption in an InnoDB type table. InnoDB: You have to dump + drop + reimport the table or, in InnoDB: a case of widespread corruption, dump all InnoDB InnoDB: tables and recreate the whole InnoDB tablespace. InnoDB: If the mysqld server crashes after the startup or when InnoDB: you dump the tables, look at InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html for help. InnoDB: unknown error code %lu InnoDB: Failing assertion: col_len - 8 > 1 || len < 256 InnoDB: Failing assertion: col_len - 8 > 2 || len < 256 * 256 InnoDB: Failing assertion: col_len - 8 > 3 || len < 256 * 256 * 256 InnoDB: Failing assertion: index InnoDB: Failing assertion: i > 0 InnoDB: Error: InnoDB: MySQL is trying to use a table handle but the .ibd file for InnoDB: table %s does not exist. InnoDB: Have you deleted the .ibd file from the database directory under InnoDB: the MySQL datadir, or have you used DISCARD TABLESPACE? InnoDB: Look from http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html InnoDB: how you can resolve the problem. InnoDB: Error: trying to free a corrupt InnoDB: table handle. Magic n %lu, table nameInnoDB: A new raw disk partition was initialized or InnoDB: innodb_force_recovery is on: we do not allow InnoDB: database modifications by the user. Shut down InnoDB: mysqld and edit my.cnf so that newraw is replaced InnoDB: with raw, and innodb_force_... is removed. InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON InnoDB: Error: trying to use a corrupt InnoDB: trx handle. Magic n %lu InnoDB: Error: trying to use a corrupt InnoDB: table handle. Magic n %lu, table nameInnoDB: Failing assertion: trx->dict_operation_lock_mode == 0 || trx->dict_operation_lock_mode == RW_X_LATCH InnoDB: Failing assertion: mutex->lock_word == 0 InnoDB: Error: trying to free a corrupt InnoDB: table handle. Magic n %lu, magic n2 %lu, table nameInnoDB: Error: trying to free a corrupt InnoDB: fetch buffer. InnoDB: Failing assertion: trx->dict_operation_lock_mode == RW_X_LATCH InnoDB: Error: cannot reset lsn's in table InnoDB: in ALTER TABLE ... IMPORT TABLESPACE InnoDB: does not exist in the InnoDB data dictionary InnoDB: in ALTER TABLE ... IMPORT TABLESPACE InnoDB: is in the system tablespace 0 which cannot be imported InnoDB: Error: you are trying to IMPORT a tablespace InnoDB: , though you have not called DISCARD on it yet InnoDB: during the lifetime of the mysqld process! InnoDB: cannot find or open in the database directory the .ibd file of InnoDB: table InnoDB: Failing assertion: trx->dict_operation_lock_mode == RW_S_LATCH InnoDB: Failing assertion: lock->reader_count > 0 InnoDB: Failing assertion: trx->dict_operation_lock_mode == 0 InnoDB: Failing assertion: old_name != NULL InnoDB: Failing assertion: new_name != NULL InnoDB: Error: trying to create a MySQL system table %s of type InnoDB. InnoDB: MySQL system tables must be of the MyISAM type! does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to rename the table. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from section 15.1 of InnoDB: http://www.innodb.com/ibman.php does not have an .ibd file in the database directory. InnoDB: You can look for further help from section 15.1 of InnoDB: http://www.innodb.com/ibman.php InnoDB: Failing assertion: (byte*)heap == (byte*)buf - MEM_BLOCK_HEADER_SIZE - MEM_FIELD_HEADER_SIZE InnoDB: Failing assertion: sqlend == sql + len + 1 InnoDB: Failing assertion: graph InnoDB: Failing assertion: thr = que_fork_start_command(graph) InnoDB: Error; possible reasons: InnoDB: 1) Table rename would cause two FOREIGN KEY constraints InnoDB: to have the same internal name in case-insensitive comparison. InnoDB: 2) table exists in the InnoDB internal data InnoDB: dictionary though MySQL is trying rename table to it. InnoDB: Have you deleted the .frm file and not used DROP TABLE? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html InnoDB: If table is a temporary table #sql..., then it can be that InnoDB: there are still queries running on the table, and it will be InnoDB: dropped automatically when the queries end. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another InnoDB: database and copying the .frm file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed. InnoDB: Error in table rename, cannot rename InnoDB: Error: in ALTER TABLE InnoDB: has or is referenced in foreign key constraints InnoDB: which are not compatible with the new table definition. InnoDB: Error: in RENAME TABLE table InnoDB: is referenced in foreign key constraints InnoDB: which are not compatible with the new table definition. InnoDB: Failing assertion: dict_table_rename_in_cache(table, old_name, FALSE) InnoDB: is in the system tablespace 0 which cannot be discarded InnoDB: You are trying to DISCARD table InnoDB: though there is a foreign key check running on it. InnoDB: Cannot discard the table. InnoDB: index records in a wrong order in contains %lu entries, should be %lu InnoDB: Failing assertion: name != NULL InnoDB: Failing assertion: table_name does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html InnoDB: Warning: MySQL is trying to drop table InnoDB: though there are still open handles to it. InnoDB: Adding the table to the background drop queue. InnoDB: You are trying to drop table InnoDB: though there is a foreign key check running on it. InnoDB: Adding the table to the background drop queue. InnoDB: Failing assertion: err == DB_OUT_OF_FILE_SPACE InnoDB: Error: not able to remove table InnoDB: We removed now the InnoDB internal data dictionary entry InnoDB: of table InnoDB: Error: not able to delete tablespace %lu of table InnoDB: Failing assertion: name[namelen - 1] == '/' InnoDB: Failing assertion: memcmp(table_name, name, namelen) == 0 InnoDB: Failing assertion: table InnoDB: Warning: MySQL is trying to drop database InnoDB: though there are still open handles to table failed with error %lu for table InnoDB: Failing assertion: (row_mysql_drop_list).count > 0 InnoDB: Dropped table %s in background drop queue. InnoDB: Failing assertion: sql_string InnoDB: This is not allowed in InnoDB. InnoDB: Failing assertion: thr == que_fork_start_command(que_node_get_parent(thr)) Validating InnoDB memory: to use this feature you must compile InnoDB with UNIV_MEM_DEBUG defined in univ.i and the server must be quiet because allocation from a mem heap is not protected by any semaphore. Memory NOT validated (recompile with UNIV_MEM_DEBUG) InnoDB: Warning: cannot create table already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used DROP DATABASE InnoDB: for InnoDB tables in MySQL version <= 3.23.43? InnoDB: See the Restrictions section of the InnoDB manual. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another InnoDB: database and copying the .frm file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed. InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html found := 1; old_db_name_len := INSTR(old_table_name, '/') - 1; new_db_name_len := INSTR(new_table_name, '/') - 1; new_db_name := SUBSTR(new_table_name, 0, new_db_name_len); old_t_name_len := LENGTH(old_table_name); gen_constr_prefix := CONCAT(old_table_name, '_ibfk_'); WHILE found = 1 LOOP SELECT ID INTO foreign_id FROM SYS_FOREIGN WHERE FOR_NAME = old_table_name AND TO_BINARY(FOR_NAME) = TO_BINARY(old_table_name); IF (SQL % NOTFOUND) THEN found := 0; ELSE UPDATE SYS_FOREIGN SET FOR_NAME = new_table_name WHERE ID = foreign_id; id_len := LENGTH(foreign_id); IF (INSTR(foreign_id, '/') > 0) THEN IF (INSTR(foreign_id, gen_constr_prefix) > 0) THEN new_foreign_id := CONCAT(new_table_name, SUBSTR(foreign_id, old_t_name_len, id_len - old_t_name_len)); ELSE new_foreign_id := CONCAT(new_db_name, SUBSTR(foreign_id, old_db_name_len, id_len - old_db_name_len)); END IF; UPDATE SYS_FOREIGN SET ID = new_foreign_id WHERE ID = foreign_id; UPDATE SYS_FOREIGN_COLS SET ID = new_foreign_id WHERE ID = foreign_id; END IF; END IF; END LOOP; UPDATE SYS_FOREIGN SET REF_NAME = new_table_name WHERE REF_NAME = old_table_name AND TO_BINARY(REF_NAME) = TO_BINARY(old_table_name); '; UPDATE SYS_TABLES SET NAME = new_table_name WHERE NAME = old_table_name; PROCEDURE RENAME_TABLE_PROC () IS new_table_name CHAR; old_table_name CHAR; gen_constr_prefix CHAR; new_db_name CHAR; foreign_id CHAR; new_foreign_id CHAR; old_db_name_len INT; old_t_name_len INT; new_db_name_len INT; id_len INT; found INT; BEGIN new_table_name := '_recover_innodb_tmp_tableinnodb_monitorinnodb_lock_monitorinnodb_tablespace_monitorinnodb_table_monitor; SELECT ID INTO table_id FROM SYS_TABLES WHERE NAME = table_name; IF (SQL % NOTFOUND) THEN COMMIT WORK; RETURN; END IF; found := 1; SELECT ID INTO sys_foreign_id FROM SYS_TABLES WHERE NAME = 'SYS_FOREIGN'; IF (SQL % NOTFOUND) THEN found := 0; END IF; IF (table_name = 'SYS_FOREIGN') THEN found := 0; END IF; IF (table_name = 'SYS_FOREIGN_COLS') THEN found := 0; END IF; WHILE found = 1 LOOP SELECT ID INTO foreign_id FROM SYS_FOREIGN WHERE FOR_NAME = table_name AND TO_BINARY(FOR_NAME) = TO_BINARY(table_name); IF (SQL % NOTFOUND) THEN found := 0; ELSE DELETE FROM SYS_FOREIGN_COLS WHERE ID = foreign_id; DELETE FROM SYS_FOREIGN WHERE ID = foreign_id; END IF; END LOOP; found := 1; WHILE found = 1 LOOP SELECT ID INTO index_id FROM SYS_INDEXES WHERE TABLE_ID = table_id; IF (SQL % NOTFOUND) THEN found := 0; ELSE DELETE FROM SYS_FIELDS WHERE INDEX_ID = index_id; DELETE FROM SYS_INDEXES WHERE ID = index_id AND TABLE_ID = table_id; END IF; END LOOP; DELETE FROM SYS_COLUMNS WHERE TABLE_ID = table_id; DELETE FROM SYS_TABLES WHERE ID = table_id; COMMIT WORK; END; PROCEDURE DROP_TABLE_PROC () IS table_name CHAR; sys_foreign_id CHAR; table_id CHAR; index_id CHAR; foreign_id CHAR; found INT; BEGIN table_name := '; new_id_high := %lu; new_id_low := %lu; new_id := CONCAT(TO_BINARY(new_id_high, 4), TO_BINARY(new_id_low, 4)); SELECT ID INTO old_id FROM SYS_TABLES WHERE NAME = table_name; IF (SQL %% NOTFOUND) THEN COMMIT WORK; RETURN; END IF; UPDATE SYS_TABLES SET ID = new_id WHERE ID = old_id; UPDATE SYS_COLUMNS SET TABLE_ID = new_id WHERE TABLE_ID = old_id; UPDATE SYS_INDEXES SET TABLE_ID = new_id WHERE TABLE_ID = old_id; COMMIT WORK; END; PROCEDURE DISCARD_TABLESPACE_PROC () IS old_id CHAR; new_id CHAR; new_id_low INT; new_id_high INT; table_name CHAR; BEGIN table_name := 'innodb_mem_validateGCC: (GNU) 4.2.1 20070719 [FreeBSD].symtab.strtab.shstrtab.rel.text.data.bss.rodata.str1.1.rodata.str1.4.rodata.comment@| 8HS %+02?2tN`> V&_  r |)kD` OMZf  YW@ W:*Pq0; p4K&Cf 62>Qho`J@ ;&9Pc x =Eeo`l`a 6KPlPOZ 3I h|P#F$'@Rq@)q,  , A H h   P27 6X  9b   ! , 7 > G ^ n }     `O   ! 9 O f m   @`      4 J W a x  jB     + O l   0  $=U#wЗ +IVrow0mysql.crow_get_prebuilt_insert_rowS_recover_innodb_tmp_tablestr1.16316str3.16318str4b.16322discard_tablespace_proc1.16049discard_tablespace_proc2.16050row_add_table_to_background_drop_listS_innodb_monitorS_innodb_table_monitorstr1.16138str2.16139S_innodb_lock_monitorS_innodb_tablespace_monitorS_innodb_mem_validaterow_mysql_read_var_ref_noninlinerow_table_got_default_clust_indexrow_get_background_drop_list_len_lowrow_mysql_drop_list_initedrow_mysql_drop_listrow_mysql_read_blob_refrow_prebuild_sel_graphsel_node_createpars_complete_graph_for_execrow_unlock_table_autoinc_for_mysqllock_table_unlock_auto_incrow_mysql_handle_errorsut_dbg_stop_threadsos_thread_get_curr_idos_thread_pfut_dbg_msg_stop__stderrpfprintfos_thread_sleepsrv_suspend_mysql_threadque_thr_stop_for_mysqlut_dbg_zerout_print_timestamput_dbg_msg_assert_failfwriteut_dbg_msg_trapfputsut_dbg_null_ptrtrx_general_rollback_for_mysqlexitrow_mysql_store_blob_refmemsetrow_get_mysql_key_number_for_indexrow_update_cascade_for_mysqlrow_upd_stepsrv_n_rows_deleteddict_update_statisticssrv_n_rows_updatedrow_update_for_mysqlut_print_name__isthreadedmem_analyze_corruptionsrv_created_new_rawputcsrv_force_recoverysrv_dml_needed_delaybtr_pcur_copy_stored_positiontrx_savept_takeque_thr_move_to_run_state_for_mysql__swbufque_thr_stop_for_mysql_no_errortrx_startrow_lock_table_for_mysqllock_tablerow_create_update_node_for_mysqlupd_node_createbtr_pcur_create_for_mysqlmem_heap_add_blockrow_get_prebuilt_update_vectorins_node_createdict_table_copy_typesins_node_set_new_rowrow_lock_table_autoinc_for_mysqlrow_insert_for_mysqlrow_ins_stepsrv_n_rows_insertedrow_update_prebuilt_trxrow_mysql_prebuilt_free_blob_heapmem_heap_free_block_freemem_heap_block_freerow_create_prebuiltmem_heap_create_blockdict_index_copy_typesrow_mysql_lock_data_dictionarydict_operation_lockrw_lock_x_lock_funcdict_syspthread_mutex_trylockmutex_spin_waitrow_prebuilt_freebtr_pcur_free_for_mysqlque_graph_free_recursivedict_table_decrement_handle_countrow_unlock_tables_for_mysqlkernel_mutex_templock_release_tables_off_kernelos_fast_mutex_unlockmutex_signal_objectrow_mysql_unlock_data_dictionarysync_primary_wait_arraysync_array_signal_objectrow_import_tablespace_for_mysqllog_sysfil_reset_too_high_lsnstrx_commit_for_mysqlstrcmpibuf_delete_for_discarded_spacefil_open_single_table_tablespacedict_load_tablerow_mysql_unfreeze_data_dictionaryrow_mysql_freeze_data_dictionaryrw_lock_s_lock_spinrow_rename_table_for_mysqlstrstrstrlenmemcpyut_strcpyqut_memcpyqstrchrpars_sqlque_fork_start_commandque_run_threadsque_graph_freedict_get_db_name_lendict_foreign_parse_drop_constraintsdict_table_rename_in_cachedict_load_foreignsrow_discard_tablespace_for_mysqldict_hdr_get_new_idsprintflock_reset_all_on_tabledict_foreign_err_filedict_foreign_err_mutexrewinddict_table_change_id_in_cachefil_discard_tablespacerow_check_table_for_mysqlsrv_fatal_semaphore_wait_thresholdbtr_validate_treedtuple_set_n_fieldsrow_search_for_mysqlcmp_dtuple_rec_with_matchdict_index_name_printdtuple_printrec_printrow_rec_to_index_entrybtr_search_validaterow_drop_table_for_mysqlsrv_print_innodb_table_monitorsrv_wake_master_threaddict_tables_have_same_dbsrv_print_innodb_monitorsrv_print_innodb_lock_monitorsrv_print_innodb_tablespace_monitordict_table_remove_from_cachefil_space_for_table_exists_in_memfil_delete_tablespacerow_drop_database_for_mysqldict_get_first_table_name_in_dbrow_drop_tables_for_mysql_in_backgroundtrx_allocate_for_backgroundlog_buffer_flush_to_disktrx_free_for_backgroundrow_table_add_foreign_constraintsdict_create_foreign_constraintsrow_create_index_for_mysqlind_create_graph_createrow_create_table_for_mysqldict_col_name_is_reserveddict_mem_table_freetab_create_graph_createsrv_lock_timeout_thread_eventos_event_setrow_mysql_identically_false1>HR\e 5$>%F&V_'h(p)|*+,-(.%&/"(*)/(FO0T(]1e2j3p$3447(CK)P(X.]%e&u~/()1()3$34(0&(=F0R57-$-$- $?(G.L%T&dm/v(~)(0(123$3%&'()*%(-.2%:&JS/\(d)i(0(123$3%&'()* (.% &09/B(J)O(fo0t(}123$3%&'()*-$E(M.R%Z&js/|()(0(123$3%& ' ( )! *3 -< $E %M &] f 'o (w ) * ( . % &  / ( ) (  0 ( 1 2 3 $- 3_ :r ,z + ;G <W = ( .  ( ) (  ) ( ?" @0 (S AX (` .e %m &}  / ( ) 1 ( ) 3 $ 3 B (  0 ( C D' E. i F - $ % &  ' ( ) * G H:),P#^sI}(.%&/()(0(123$3'*8Jx;<F3K>=wHM,#K(KJM`,{#J O*PQ2QN S{TU Q6QHM,#K#J-y(.()()(?@ (,A1(9.>%F&V_/h(p)u1~()3$3B(0(CDE GH X&,@#QfIJYU<bo*K()A(.%& /()!1*(2)73=$L3b(jr)(?@(A(.%&/( )1(")'3-$<3i(yCI\]9_PP`F Qc Q Q - $ !b !c!d&!e2G20i2-v2$2b2e2b2-2$2%2&22'2(2)2*2b3b3-#3$,3%43&D3M3'V3(^3)j3*p3by3b~3b3b3b3b3n3b3(3.3%3&44/4( 4)%4(<4E40J4(S41[42`43f4$v434%4&44'4(4)4*4b4e44b4f4(5.5%5&5'5/05(85)=5(T5]50b5(k51s52x53~5$535b5o5q5b5r5(5.5%5&66/6( 6)%6(<6E60J6(S61[62`63f6$z636-6$6b6e6b6-6$6%7&77'$7(,7)87*>7bH7bX7bc7bh7nm7b77b7}7(7.7%7&77/7(7)7( 8808(#81+8208368$F83Q8%Y8&i8r8'{8(8)8*8b8e88b8f8b8b8b88b8b8b9n9b9b9o19(99.>9%F9&V9_9/h9(p9)u9(9909(9192939$939b9o:-:$6:-@:$N:B[:(r:{:0:v:(:.:%:&::/:(:):(::0;( ;1;2;3;$1;%9;&I;R;'[;(c;)o;*y;(;.;%;&;;/;(;);(;;0;(;1;2;3;$<%<&)<2<';<(C<)O<*Z<3i<3x<D<<<<<<<<R=d=wA>a>_>->$>%>&>>'?( ?)?*7???V????<@\@@@ABA-PA$YA%aA&qAzA'A(A)A*AA-A$A%A&AA'A(A)B*B\/B]UB]B-jB$sB%{B&BB'B(B)B*BB4Cv.CJC\dC]tCCaCzC(C.C(CC0C(C?C(DD08DRD(ZDfD)qDvDpDXEnE({E.E(EE0E(E?E(EE0F'F_9FIFpF_FGG(G.G%G&GG/G(G)G(GH0 H(H1H2 H3&H$:H3HH(PH.UH%]H&mHvH/H(H)H(HH0H(H1H2H3H$H3H(H.H%I&II/&I(.I)3I(JISI0XI(aI1iI2nI3tI$I3IIIKI(I.I%I&II/J( J)J()J2J07J(@J1HJ2MJ3SJ$gJ3~JQJJJK$K(,K.9K(PKYK0^K(tK?yK(KK0KK-K$K%K&KK'K(L)L*L(#L.(L(?LHL0SL(cL?hL(LL0L(L?L(LL0L(L?L(LM02M4DM(LM.QM(hMqM0|M(M?M(MM0M(M?M@M( N( N)N08N(DN?IN(`NiN0sN({N.N%N&NN/N(N)N(NN0N(N1N2N3N$ O3O(/OCIOIOOaOd PwXPPP_?Q-MQ$VQ%^Q&nQwQ'Q(Q)Q*QQQQQQR-R$R%R&/R8R'AR(IR)UR*]RRR-R$R%R&RR'R(R)R*RS4.Sv9SpKS]SzrSv}SpSS(S.S(SS0S(S?S(ST0T(T.$T(;TDT0ST(_T?dT({TT0TT_TTTeTT-T$U% U&U&U'/U(7U)CU*IUUU]U.xU}U0U?UU0U?U@UV VnV!V&Vo;VKFV(NV.SV%[V&kVtV/}V(V)V(VV0V(V1V2V3V$V3V(V.V%W&WW/$W(,W)1W(HWQW0VW(_W1gW2lW3rW$W3WWW(W.W%W&X X/X(X)#X(:XCX0HX(QX1YX2^X3dX$xX3XQXXXfX4YC$Y(,Y.1Y%9Y&IYRY/[Y(cY)hY(YY0Y(Y1Y2Y3Y$Y3YIYlYeZ-Z$/Z9ZCZMZWZaZZwZlZnZoZZ_C[-Q[$Z[%b[&r[{['[([)[*[[[_J\-X\$y\\\\\\\l\n\o\(\.]%]&]!]/*](2])7](N]W]0\](e]1m]2r]3x]$]%]&]]'](])]*]^_^%^&&^/^'8^(@^)L^*a^i^fs^$y^3^(^.^%^&^^/^(^)^(^^0^(_1 _2_3_$(_3@_Q`_(h_.m_%u_&__/_(_)_(__0_(_1_2_3_$_3`Q.`Z`(b`.s`|`(`)`l``e`-`$`%`&aa'a(a)+a*7al=aRanaaa_Ib-Vb$_b%gb&wbb'b(b)b*bb_&cWcdRd(idrd0d(dd(dd0d(dd(dd0d(ee@e(je]e\eee\f],f\Cf]uf(ff0f(fff(f)g(g g0*g(:gCRg]hgyglgeg-g$g%g&gg'g(g)g*glhhn-hBhISh([h.`h%hh&xhh/h(h)h(hh0h(h1h2h3h$h3iQ:ioQiYiffioiifi(i.i%i&ii/i(i)i(ii0i(j1 j2j3j$,j3:j(Bj.Gj%Oj&_jhj/qj(yj)~j(jj0j(j1j2j3j$j3j-j$ kBk(0k9k0Qk(Yk.^k%fk&vkk/k(k)k(kk0k(k1k2k3k$k%k&kl'l(l)#l*2l3Ilbljl-wl$llllm$m_m-m$m%m&mm'm(m)m*n%n&+n4n'=n(En)Qn*fnn_nnnn o_po-}o$o%o&oo'o(o)o*ooppp5p\Op]npapp-p$p%p&pp'p(p)p*p\q]rqdqwrv@r\]r]lrvr{rrrzr(r.r(s s0s($s?)s(@sIs0lss_s(s.s%s&ss/s(s)s(st0t(t1t2t3!t$5t3ItpSt([t.`t%ht&xtt/t(t)t(tt0t(t1t2t3t$t3u'u,uez(Fz?Kz(bzkz0zKzzzCzzozz{f {({.{%{&/{8{/A{(I{)N{(e{n{0s{(|{1{2{3{${3{({.{({{0{({?{(||0M|i||_|-|$}%}&}'}'0}(8})D}*b}o}z}z}(}.}(}}0}(}?}(}}0~( ~.~%~&*~3~/<~(D~)I~(`~i~0n~(w~1~2~3~$~3~(~.~%~&~~/~(~)~(0(1&2+31$E3(0(?(0 D_[Ie(m.r%z&/()(ɀ0΀(׀1߀23$3Q<I(`i0t(?(0(.ʁ(ҁ)݁(?( 0@R-`$-$aǂ-$% &$'-(5)A*d˃w׃-$%&'()+*Pk\](0Ą(Є?ۄ()(? @(AvLpVf(n.s%{&/()(ʅ0υ(؅123$3% &%'.(6)B*PfKp(x.}%&/()(ˆԆ0ن(123$3%&&/'8(@)L*\zf-s({.%&/()(·ׇ0܇(123$ 3(".'%/&?H/Q(Y)^(u~0(123$3Ljp̈(Ԉ.و(0(?(090H(T?Y(py0*\]ʼn(ՉCIle3-A$J%R&bk't(|)*Ɗlˊъnde%-3$<%D&T]'f(n)z*΋dwn6SZbvj}le-$%&̌Ռ'ތ()* -$!%)&9B'K(S)_*ep(.()׍\] \"],l=nPo]zcdroff͎o׎(ߎ.%&/()(2;0@(I1Q2V3\$p3f(.%&ɏ/ҏ(ڏ)ߏ(0( 123 $43B(J.O%W&gp/y()(0(123ǐ$ې3(.%&/ (()-(DM0R([1c2h3n$3Α-ޑ$O|4(.%ƒ&֒ߒ/()( 0(#1+2036$F3Q%Y&ir'{()*Kϓdwm(z.(0(Ĕ?ɔ(0( ( )0N4kҕ_Re r-$%&'(Ȗ)Ԗ*ܖK)(1.6%>&NW/`(h)m(0(123$—3חB(0v0;vØ٘-$%%&5>'G(O)[*fϙ_ %3-@$I%Q&aj's({)*4(*2)=vG(O.T%\&lu/~()(0(12ƛ3̛$3(.%&/%(-)2(IR0W(`1h2m3s$3ϜKߜ/_-$%&ȝ'ѝ(ٝ)*3~J\g]vО(0( 0 4:FQekw_(ğ.ɟ(0(? (#,0wdw͠נ(ߠ.(0("?'(>G0Wzr(z.%&/()(֡͡0ۡ(123$ 3#QCIS_sv".(o