ELF>@@HD1fHHDLH9uHHDHGPH@@H8ff.H=u6HH1HHHHHtHu*HHFHÐFHH HHFHúffff.HHtHuNHw,@7HGHHwF@7HHG@wHúS/HHXHHHtfHt0HtHuQH[Ht7HHt1[[úUHSHHhHw(t#Ht$Ht$H^0HHHuH[]ffff.H\$Hl$HLd$HILHHǾHH1ҾH$Hl$Ld$Hf.AT1AOjbUHSHt:DHHHH5OjbH1HHH5>WH uHH5OjbHHJP1H1HAHHufH[8HH{HuC'@tAtH[]A\H HKH=1=t#H 6H[]A\H 1q[HD]A\@H\$Hl$HLd$Ll$HxHHIHHw@Ht~1HHItHHDHHCu6MtH1LH\$XHl$`Ld$hLl$pHxfDLHHE1HSHHtH@HtHC1҆HCHu[fDH[ffffff.SHxHuTHHtH=HtHHuH=H=HCx[úAUIATIUHSHXHxHHH5H1HHHt.HHDL HPHtQHHLL1HtH1H(HExHX[]A\A]fA?L%A%?D 1냺ff.AUATIUHSHHHHGHHLhP2HHwPDLLHHǃIHu2HHIH tH[]A\A]f.H uI|$8t!HH~ HHHHHHHZHHHHHHHH9~1HHD$HD$ef.H\$Ld$HHl$Ll$ILt$L|$H8H=Ho6HhHEHRMHD$ HD$(HDŽ$XHDŽ$`L|$ HDŽ$HDŽ$HDŽ$HDŽ$HDŽ$'HLsxLkpvMpLXLPAE0AE0(%IIFAVD`HI P@HHI AI AFHH H I L9tAHPHSxHHHhvHPHXHH`LHE H$H$L$L$ L$(L$0H8@HspM=HhLsxLkpHH$L$AHLLHDŽ$HDŽ$dH$cEe0HAAuSAE0IE L@&HT$fƁHcHHT$HtHL$A?MH$IFAVD`HI P@HHI AI AFHH H I H h HPMImH} H IM A&f%HpAE4Hk I1AH$Hq(1 HI}@fGu H;7HHL9r۸ff.UHSHHHH\nuAHHoufHG`HsHtHpPHChHtHhPH0HtHhPH[]H=1Hf1H=1HCH=HHHH5 Hs1SH0Ht[H0HS0HsHH@H0H@X[fHHHHt9Ht1D HHHH9HNHH)HHLFIvbu^LHL M&fo1HHHH9f0wM9Jt-HHfHH9@@@ HwHHH9sHNHH)HHLFI vwusLHL MtGfo1ɐHHHH9f0wM9JHtHH@ H9HvHH9@ HwHHH9@ HwCHH9@@@ HwHú&/fffff.H\$Hl$HLd$Ll$IH(HI1HIHUwSIIw\HHD(HIH9uLd+H\$Hl$Ld$Ll$ H(HwHwHrH\$Ld$HHl$H(HIH pHEHǃ H+v1H=H11D$fH=uVHtAHHHH t)I$Hǃ 1H\$Hl$Ld$ H(@I,$f.1H@H H=1mH HHT$H $H HT$t;HHHT$H $H 8I$ff.H@HHDHIH11Ht H@H@8H@0H@ H@(H@AVIAUIATIUSHH0HoHHE/HXpHHMLt$fH}HCHHuHH1HDLH HD$Ht6H1HHLHuHED$H[]A\A]A^HHLd$H}HCHHuHHIPIv1HH HD$HtH1HHLHu^I0ffffff.H\$Hl$HLd$Ll$Lt$L|$H8HG8HoHt.H@@H\$Hl$Ld$Ll$ Lt$(L|$0H8HW0HH{@IHC8H{0Dm&HG(LxXfAAOtmIIv0J>H9P@IN<8HPXIW0IWHLIMoMoLLHS0HsLH@HC`H@XHC8H{0HxHG(LnIHPXILH9H@r3HHXHHC@5E1H0bLxXK>IHtHPXH{0ILH{0fff.AV AUIATUSHHWHoLg8H9`MHEIE`Lt$HHXpHf.H}LLuHHIu1HٺH HD$Ht7H1HHLHuD$HEH[]A\A]A^ÐHHkMe8@fH\$Hl$H(HG(HjHHrHHHXLD L9@@r(H<L@XHHl$ H\$H(fDHT$1HHT$tHHXLD H\$Hl$Ld$Ll$ILt$HH(IHH@HH@8H@@H@hHCpIF(LcxEl$&HhXHfAAHMH9H@H,*HJXLmHEKtHPXHIH H9H@HHHXHUHAD$&HǃHǃHǃHǃHǃHǃHǃf%HHHl$H$Ld$Ll$Lt$ H(fLHHt tHHEe} DHuLG1JHHHH9uH|$ JfE<DEgfffAAA)McIIIt01fD|> EHH|$ Hu2fIDH<8HWDGH9tHH>H9@:uEuH|$ f.MHHC HD$0HC`LhpID$`Lt$0L|$(HLDMMLHH HD$(lLIDžLLHLHIDžuD$(HEHH[]A\A]A^A_D%H|$ HL$LL$LT$HHH|$ HL$LL$LT$ID$`c fDHHH|$ w=@|>|>|> HHH|$ l|>t`HHH|$ w'L@|> =HHH|$ *|>tfDLD$LD$@LHH{HHHu HLJHHHHHHHHHHHH9_1NHLD$yLc8LD$2H  H=1HCH=HHHH5 H1H=HCH=HP1 fffff.AWIAVAUIATUSHG&LgPfHAD$6H f%H9GAl$41AHHFH4+H1HvH H1HH H@H@8H@0HB HB(LpXI H9H@VN40HHXAL @@1@Hz@X?AN I~pIV0MnIoL,[IdžoHT$IIPHT$IdžPIu0IdžXIHB(HxXHL>L9@@[LAXHHq0LlmHHYHYHXXIHqI8Iu0H H9H@ItHHHXHS0HkHkLHSHHHIHIdžLIdžIdžIdžMxH[]A\A]A^A_fH@H@|fH@( I~A@@)fH@fHfDHHHHT$tqHxXHB(MD=~H׾ HT$E1HHT$LpXI wDH1H0HXXILf0HB(ff.AWAAVAUIATUH1SHHt$0HD$pd@H1HDŽ$H H@H@8IH@0H@ HH@(HZXH@H9J@HHJXHCL911AdHt H@H@8H@0H@ H@(E11HHH$IHD$pHD$@E1HD$8AHD$I ItRH=H "HuHT$0H=H=L1H{HkHstHHt$ Ht$ Hu fDHH^0HHuH$H}hHu(tHHt$ Ht$ HuHH^0HHuHD$@Hĸ[]A\A]A^A_DIEHt$0L$DsHT$pAHHI CHI CH$HI N43LMHD$(L$H$HLLHDŽ$HDŽ$HT$0z2fIO11y IDHHH9rH *HuHT$0H=H H=LH HT$(H=LH5 HD$@HT$H9T$(%L|$pHD$PH$HT$(HD$(HR`Hp(HT$HHt[Lt$XHl$`ILl$hHI@HHHFXH9w H9 H^0LHuLHl$`Lt$XLl$h1HD$HH)H9t$(HFXt H;F`HT$(HzhtHL$HT$0L$LLH|$PI1AHHHl$8ILH}HHD$8,HHD$0@0H9$H @@LHl$`Lt$XLl$hHP(E1 H|$(@H1HHHHZXH@1R#H|$P(HD$(L8ILHt$(LHHD$PIATIUSHHH}hHu(tHHt$Ht$Huf.HH^0HHuIDŽ$H[]A\AVIAUATUHSHHHoHHoH0HLJ0HpHPHE(Ht>HxL`HptLHt$Ht$HufHH^0LHuH}`HtH0HtH}hHtLMt?I|$hIt$(tLHt$Ht$Hu DHH^0LHuLMtHHH@1L\$HHA AAd$M,$L$HAD$ HL`PLLAMHHD$PHD$XHDŽ$HDŽ$HDŽ$HDŽ$HDŽ$HDŽ$HDŽ$Hl$H$ L$f.AD$ Ht$HHLLHøL$H9H$(LI<HHHI蹮 LHD$PHD$XHDŽ$HDŽ$HDŽ$HDŽ$HDŽ$HDŽ$HDŽ$L$HDŽ$DQL?HpeHt[AD$AT$LHHH C*H?I?H,L$L%?L$HDŽ$DQHcvHelHpbHtXL%?Hct@Het:Hpt4Htt.H$01LH$0Ht$8I<H9 H$HtPHxL`HptLHt$0Ht$0Hu HH^0LHuHDŽ$HHDŽ$HDŽ$HDŽ$HDŽ$DQHDŽ$DŽ$HDŽ$IhIw(tLHt$0Ht$0HuHH^0LHuI^PHAE1H[PHHHtHHtHHu HǃHHHHuHHtHLL*HH=H[PHwfH$811AV HǾHIH߾H$8H߾HL$@1H߾H HtH$8LLLLL11H|$@H|$@Ll$@IEHD$@Hx(bH- qHHHINHt$@HH4HKHt$@H H )fDH@(H$0HHH$0HmH$011InPH L$MHH01LH1L8HmPHHLHt&HHtLHIz1L뤾HLH0HXXHSHLHHPXHJH$HX`HS [ BHH ZRHHH H кH9t$@HLL$L%?HpHtuH?ZHC"k"H{MpDHHH hGIHH kI HH oHHH H H=H$111H11E1H$0HIv1AHH H$0IFPHT$HAV T$HP(H@PHuHl$PH$0HD$PHD$XHHDŽ$HDŽ$HDŽ$HDŽ$HDŽ$HDŽ$HDŽ$HqA01AHD$AAHD$8I^PAE1HtOHHtHHtHHu HǃHLHHt5H[PH= IVH=1AN$HHtHHL"HH=HT$@1 HHǂ L\$@H=Iǃ H 5INHt$@H=H K H= H INHt$@H=H L ffff.H\$Hl$HLd$L|$ILl$Lt$HHHIHDŽ$HDŽ$fHDH=uH=H E1A MuTM,HCLH$H$L$L$L$L$HHfDuZHEHaHLU:u P:u@:$@LHCHHD$ 1LI脷HHD$x$1ME1HHD$E1.fDHAUHAdHD$HuHIHǾLL1LHپH IIHǃ 1HHǃ H=H1E1A DdHT$H$L$HHIH IH|$H$HT$H|$HHHYE1H|$ AMt 1H{(11HLD$H ILD$7H|$MHD$HD$HcH=A8H H=LHH FHD$H$x'@LHDŽ$pHD$0DŽ$HH|$8'HH|$0/LH|$0Iƾ/IvHxH$@$HIHǾLLHT$0LH$p@H/HH$p/HD$(Ht$(HxH$@H$$H$pL1LHپH IDHǃ 1HA Hǃ LHPLLH$HD$(21%fDLcI aHH9$ H$Ht$(LHL$L4LHH荲HHL$H u/LHHL$uHL^HL$HzH$p@HH|$0@L bL荱H=H H=HH޺H ^H=LH޺H H=HH޺H H=LD$MLH H=HHH yH|$1LH7MH=E1AH H=LHH H=E1AH H=LHH SH 'H=HH޺H rfffff.AUIATIUSHH~HFuHL LLBA$1ɸOjbt7fHHHH5OjbH1HHH5>WH uHH5OjbHHJP1H1HAHHufH[8HH{LuC'@tZH HKH=1=H 6K H HHt$HE(H9tH9E(HHuH|$111HLHǾHHT$H1HLH HIDž 1LIDž LLIEH[]A\A]@I}(KH 躮HHHٺH=LLHٺHMH=L(H޿ #@Ht$H{ HtK%K$ IDž 1L IDž H H= H *HKH=LH ^@1ҾLHHýVH= H H=LLH AAUATIUHSHXH~uHLHID$HHHH1HHItHHHCXMtH1LHHHLk@tHHtHCX1҆HC`Ht H{PLHHnN LH,U1ɸOjbt:DHHHH5OjbH1HHH5>WH uHH5OjbHHJP1H1HAHHuH[8HH{HuC'@tZH HKH=1=H 6{ C%<C$1HK<HE֋s Hu?{$f LLID$HX[]A\A]f.c$c% H{PH H=H H=HLH c*E1U1ҾHHHuH= H ?H=HLH bH=H WH=HLH .WH uHH5OjbHHJP1H1HAH,HufHm8HH}LuMLMtI9l$(H{(HHHmHHsHD$h H|$HCD$hHx[]A\A]A^A_ÿHHHIt$ LHH{(BM$f.HLePHEChMHXDA@Md$PM*HM$HI$HH|$ HH HHD$ 01L HD$1HH8AL$9HHtI$HtI$Hu IDŽ$LIHI$HI$1ɸH I$H=Md$PMLIHǾ1HپLHHD$hH.H  1DH}HrH=H 1HMH=HH kHD$h fDHHHHHHF ULHIHuID} HLAHD$H1ҾLHHDH L"HmPHLt$ AHmPHHLHHHLHIHH 01L繕 H1L8e9HHtHHtHHu HDžLI$H'HHH1ɸH HH=H|$h11HHD$h %LHH?H=HD$hH H=LH޺H J@H|$h Ht$M1ILHHurH RHD$h H=LH޺H Dm$HD$IA<1HHUH RH=LHH H=H=H1H=LHH HD$h M$MI9l$(tH{(H- HD$h(SHHHLHHHIL$HHH 薝 1LjH=H *H=LHH HD$h ]H=H 'H=HHH sHD$h /*  1Lmffffff.AWAVIAUIATUSHMIwA|/RI}IEuHL\LLHHM9HLLQU1HOjbt?f.HHHH5OjbH1HHH5>WH uHH5OjbHHJP1H1HAHHufH[8HH{HuC'@tZH HKH=1=H 6HCLHL H}L}HutLHt$Ht$HuHH^0LHuLHHh1HLHA|/LHHǾ1HL HʼntGH H=LLH=1LLIEH[]A\A]A^A_H LeH=LLH=HcӾ1H=HLH5 H}HutLHt$Ht$Hu<HHn0LHuH cLH=H 4H=LLH 6H=HLH @BH}wVU1ҾHHH_fAWAVAUATUSH HH@HD$11A HIt H@H@8H@0IE IE(HL$Hl$ AALL$HHD$ HD$(HDŽ$XHDŽ$`HDŽ$HpPHDŽ$HDŽ$HDŽ$HDŽ$HDŽ$PHDŽ$HDŽ$XDQHDŽ$HDŽ$`H,$DŽ$HDŽ$DL$HDŽ$XDQL?HpHt AFAVLHHH C*vHcI?HPL4L%?L$HDŽ$XDQHcxHenHpdHtZHeHtLLH$ALLH$ADL1LH$HH9I4L=HLHHHDŽ$P1ҾHDŽ$HtHt$H1H|$ILHD$ HD$(HDŽ$XHDŽ$`HDŽ$HDŽ$HDŽ$HDŽ$HDŽ$H$HX`HS [ BHH ZRHHH H кH9t'HLL$L%?HptHtuH$HtOHxL`HptLHt$Ht$Hu HH^0LHuHDŽ$HHDŽ$HDŽ$HDŽ$`HDŽ$XDQHDŽ$PDŽ$HDŽ$I}hIu(tLHt$Ht$HuHH^0LHuH|$H|$H[]A\A]A^A_1E1H?HC"k"H{MpDHHH hGIHH kI HH oHHH H H=H$111H1AWAVAUAATE1USHxLt$ HD$HHHHs@H1LHHtHHHCDHtH1HH=QHH-HD$HHHtH{@HtHCDHCHtHHHHHHs@H1LHItHHHCDMtH1LL}1ɸOjbALt?f.HHHH5OjbH1HHH5>WH uHH5OjbHHJPHT$1H1HAHHu@H[8H H{LuC'@tfH HKH=1={H 6HHD$HHtHT$Hz@HtHD$DHHT$HBHtHHtIL}1HHLH@(AHHA HD$HHH$Hs@H1LHItHHHCDMtH1LHHHHHEHHUHPHUHHBH=H HMH=1H HEHxLxHptLH4$H4$Hu HH^0LHuH}L}HutLH4$H4$Hu fDHH^0LHuHHHtH{@HtHCDHCHWH uHH5OjbHHJP1H1HAL4MusfMv8M]I~HuAF'@tZH INH=1=H 6I|$uHLA}4 8AV$ME@ H1LHHH9QHtHtH9HBH vL51LIDŽ$ 1LHLIDŽ$ H{ID$LcHstLHt$Ht$Hu fDHH^0LHuH[]A\A]A^A_HHH9s+QHtHtH9HBHv'f11A-HHt H@H@8H@0HE HE(HLAD$hHLHHxHH9HM$H} I DLtBL1fHHH9/Af%f= vA@HHH9Ff%f=vHH(1WH E1dHHHT$H1HHHT$0HyXI4?81ҾHI#fDH\$Hl$HLd$Ll$H(H=HtPH HH H\$Hl$Ld$Ll$ H(HFHWHukHBHt6Ht%: u:H: u.@:u"fH=1KH{uHHHU/HHiL`LHH~HHu.LuEH=H,@HHuL11AHIt"H@H@8H@0ID$ ID$(LHChLHHHxII9LLII.I tHǃ 1HHI|$HCDL H=HLH=HLH=HHt@} 1HH=U H=1HMH=H޺H f1HHǃ H=H 'HMH=HH H}1H#H}1HHH H 5v/data/packages/packages/mysql-5.5.36/storage/innobase/row/row0mysql.cPROCEDURE DELETE_CONSTRAINT () IS BEGIN DELETE FROM SYS_FOREIGN_COLS WHERE ID = :id; DELETE FROM SYS_FOREIGN WHERE ID = :id; END; is corrupted, but innodb_force_load_corrupted is set trx->dict_operation_lock_mode == RW_S_LATCHtrx->dict_operation_lock_mode == 0InnoDB: Error: calling row_unlock_for_mysql though InnoDB: innodb_locks_unsafe_for_binlog is FALSE and InnoDB: this session is not using READ COMMITTED isolation level. 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 name col_len - 8 > 2 || len < 256 * 256col_len - 8 > 3 || len < 256 * 256 * 256InnoDB: 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/refman/5.5/en/forcing-innodb-recovery.html for help. InnoDB: Cannot delete/update rows with cascading foreign key constraints that exceed max depth of %lu Please drop excessive foreign constraints and try again InnoDB: unknown error code %lu 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 InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html InnoDB: how you can resolve the problem. InnoDB: Error: trying to free a corrupt InnoDB: table handle. Magic n %lu, table name InnoDB: 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. !(dtype_get_len(dtype) % dtype_get_mbmaxlen(dtype))2 * dict_table_get_n_cols(table) >= clust_index->n_fields/data/packages/packages/mysql-5.5.36/storage/innobase/include/mem0mem.ic(byte*)heap == (byte*)buf - MEM_BLOCK_HEADER_SIZE - MEM_FIELD_HEADER_SIZE InnoDB: Warning: CHECK TABLE on InnoDB: index records in a wrong order in InnoDB: Error: trying to free a corrupt InnoDB: table handle. Magic n %lu, magic n2 %lu, table name InnoDB: Error: trying to free a corrupt fetch buffer. node->pcur->rel_pos == BTR_PCUR_ONtrx->dict_operation_lock_mode == RW_X_LATCHtrx->dict_operation_lock_mode == 0 || trx->dict_operation_lock_mode == RW_X_LATCHInnoDB: A new raw disk partition was initialized: InnoDB: we do not allow database modifications by the user. InnoDB: Shut down mysqld and edit my.cnf so that newraw is replaced with raw. by DROP+CREATE InnoDB: because it is referenced by InnoDB: Cannot truncate table by DROP+CREATE InnoDB: because there is a foreign key check running on it. /data/packages/packages/mysql-5.5.36/storage/innobase/include/dict0dict.ic InnoDB: TRUNCATE TABLE %s failed to create a new tablespace InnoDB: Next record offset is nonsensical %lu in record at offset %lu InnoDB: rec address %p, space id %lu, page %lu /data/packages/packages/mysql-5.5.36/storage/innobase/include/page0page.icPROCEDURE RENUMBER_TABLESPACE_PROC () IS BEGIN UPDATE SYS_TABLES SET ID = :new_id, SPACE = :space 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, SPACE = :space WHERE TABLE_ID = :old_id; COMMIT WORK; END; InnoDB: Unable to assign a new identifier to table InnoDB: after truncating it. Background processes may corrupt the table! 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 InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html does not have an .ibd file in the database directory. InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html InnoDB: Error: in ALTER TABLE InnoDB: a FOREIGN KEY check is running. InnoDB: Cannot rename table. PROCEDURE RENAME_TABLE () IS BEGIN UPDATE SYS_TABLES SET NAME = :new_table_name WHERE NAME = :old_table_name; END; PROCEDURE RENAME_CONSTRAINT_IDS () IS 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; offset INT; found INT; BEGIN 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_utf8, '_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) LOCK IN SHARE MODE; 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 offset := INSTR(foreign_id, '_ibfk_') - 1; new_foreign_id := CONCAT(:new_table_utf8, SUBSTR(foreign_id, offset, id_len - offset)); 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); END; 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 to 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/refman/5.5/en/innodb-troubleshooting.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 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. 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. PROCEDURE DISCARD_TABLESPACE_PROC () IS old_id CHAR; BEGIN SELECT ID INTO old_id FROM SYS_TABLES WHERE NAME = :table_name LOCK IN SHARE MODE; 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; /data/packages/packages/mysql-5.5.36/storage/innobase/include/log0log.ic 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 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/refman/5.5/en/innodb-troubleshooting.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. PROCEDURE DROP_TABLE_PROC () IS sys_foreign_id CHAR; table_id CHAR; index_id CHAR; foreign_id CHAR; found INT; DECLARE CURSOR cur_fk IS SELECT ID FROM SYS_FOREIGN WHERE FOR_NAME = :table_name AND TO_BINARY(FOR_NAME) = TO_BINARY(:table_name) LOCK IN SHARE MODE; DECLARE CURSOR cur_idx IS SELECT ID FROM SYS_INDEXES WHERE TABLE_ID = table_id LOCK IN SHARE MODE; BEGIN SELECT ID INTO table_id FROM SYS_TABLES WHERE NAME = :table_name LOCK IN SHARE MODE; IF (SQL % NOTFOUND) THEN RETURN; END IF; found := 1; SELECT ID INTO sys_foreign_id FROM SYS_TABLES WHERE NAME = 'SYS_FOREIGN' LOCK IN SHARE MODE; 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; OPEN cur_fk; WHILE found = 1 LOOP FETCH cur_fk INTO foreign_id; 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; CLOSE cur_fk; found := 1; OPEN cur_idx; WHILE found = 1 LOOP FETCH cur_idx INTO index_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; CLOSE cur_idx; DELETE FROM SYS_COLUMNS WHERE TABLE_ID = table_id; DELETE FROM SYS_TABLES WHERE ID = table_id; END; 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 memcmp(table_name, name, namelen) == 0 InnoDB: Warning: MySQL is trying to drop database InnoDB: though there are still open handles to table failed with error %lu for table PROCEDURE DROP_ALL_FOREIGN_KEYS_PROC () IS foreign_id CHAR; for_name CHAR; found INT; DECLARE CURSOR cur IS SELECT ID, FOR_NAME FROM SYS_FOREIGN WHERE FOR_NAME >= :dbname LOCK IN SHARE MODE ORDER BY FOR_NAME; BEGIN found := 1; OPEN cur; WHILE found = 1 LOOP FETCH cur INTO foreign_id, for_name; IF (SQL % NOTFOUND) THEN found := 0; ELSIF (SUBSTR(for_name, 0, LENGTH(:dbname)) <> :dbname) THEN found := 0; ELSIF (1=1) THEN DELETE FROM SYS_FOREIGN_COLS WHERE ID = foreign_id; DELETE FROM SYS_FOREIGN WHERE ID = foreign_id; END IF; END LOOP; CLOSE cur; COMMIT WORK; END; failed with error %d while dropping all foreign keys/data/packages/packages/mysql-5.5.36/storage/innobase/include/btr0pcur.ic(row_mysql_drop_list).count > 0thr == 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 lenlen == 1len < 256 * 256len < 256name != NULLidInnoDB: table is corrupted unlock_row!(len % 2)!(len % 4)col_len - 8 > 1 || len < 256err != DB_SUCCESSsetting table locksetting auto-inc lockinserting returned %lu InnoDB: prev record InnoDB: record InnoDB: duplicate key in updating or deletingtruncating table Cannot truncate table spaceold_idnew_idold_name != NULLnew_name != NULLmysql/hostuserdbrenaming table/#sql InnoDB: Error: table new_table_nameold_table_nameold_table_name_utf8new_table_utf8discarding tablespace Cannot DISCARD table because it is referenced by table_nameimporting tablespace InnoDB: table dropping table Cannot drop table from the dictionary cache! . ! name[namelen - 1] == '/'dropping databasetableInnoDB: DROP DATABASE name[strlen(name) - 1] == '/'dbnamedropping temporary tables InnoDB: Dropped table in background drop queue. sql_stringadding foreign keyscreating indexcreating table because tablespace full innodb_monitorinnodb_lock_monitorinnodb_tablespace_monitorinnodb_table_monitorinnodb_mem_validate GCC: (GNU) 4.4.7 20120313 (Red Hat 4.4.7-11)zRx -0DHXSDZ B Y A xD` D \ A (A[ D D D F A $CADD0wAAVMI @ LBKD  ABH Z ABA cLB$PMN G xAHi G DxA] A 8BED D(D (A ABBJ 8&BBD D(G@| (A ABBK (0M^ E (\ADG J AAA >AN A m,D@ L  A  A  A $MMD0o A MI0 E $LDG@<qBEE D(A0D@ 0A(A BBBA $MX@s H @BGE A(A0D@ 0A(A BBBB yN0 K $ WL0* C 4ZAX G rLT2BEB B(A0A8G 8A0A(B BBBF HBEB E(A0A8DP> 8A0A(B BBBD L(BMB E(A0F8G 8A0A(B BBBF ,@iBDA D0Y AAB@pCBEB A(D0D@ 0A(A BBBA doBBB E(A0A8D`t 8A0A(B BBBA  8A0A(B BBGJ 4 AAG  AAF P AAA TDj B XpBBB A(A0G 0A(A BBBH  0F(A BBBD <qBEA D(J (A ABBB 4 rBDA J  AABD HDBBE B(A0A8G v 8C0A(B BBBJ (b MMQ I 8?BED A(D@ (C ABBE <BBD D(D_ (A ABBK 8MIp] E d\ BBE E(A0A8Gr 8F0A(B BBBH  8A0A(B BBBA HBBE E(A0A8DP 8A0A(B BBBA L BBB B(A0A8G  8A0A(B BBBA L` ^BBB H(D0A8D 8A0A(B BBBA MI0 F H BBB E(D0D8DP 8C0A(B BBBD MN0U H .symtab.strtab.shstrtab.rela.text.data.bss.rodata.str1.8.rodata.str1.1.rela.rodata.rodata.cst16.comment.note.GNU-stack.rela.eh_frame @&܄,(124@2TO| \ j0.s޿@ (     (<Xop``CVL` A`L20Ny_49r      -0PH"S>V\y%3FVaqpx#7&Tax@9NiP @ > 7Onsq !6IjqPZ`2,<IYmP#( % 3 J ] j )i )C   @-o  0 - 1T f `8q  `;    ' 8 L g        1 H O c z     Ib   1 L _ g    `S? W  0Q\t] 9Xhhm0Phs^z{2Jaqrow0mysql.crow_mysql_drop_list_initedrow_mysql_drop_listS_innodb_tablespace_monitorS_innodb_table_monitorS_innodb_lock_monitorS_innodb_mem_validateS_innodb_monitormem_heap_free_funcrow_delete_constraint_lowdict_table_get_lowpfs_mutex_enter_funcpfs_mutex_exit_funcmem_heap_create_func.clone.1row_get_prebuilt_insert_rowmem_heap_strduplrow_add_table_to_background_drop_listrow_mysql_lock_data_dictionary_func.clone.3.LC20.LC18.LC72row_mysql_read_blob_refrow_table_got_default_clust_indexrow_get_background_drop_list_len_lowrow_mysql_read_true_varcharut_dbg_assertion_failedabortrow_mysql_store_true_var_lenrow_is_magic_monitor_tablestrchrstrlenmem_heap_free_block_freemem_heap_block_freepars_info_createpars_info_add_str_literalque_eval_sqldict_sysstrcmpstderrfwriteut_print_namesrv_load_corrupteddict_load_tablePSI_servermutex_spin_waitmutex_signal_objectrow_mysql_unfreeze_data_dictionarydict_operation_lockos_event_setsync_primary_wait_arraysync_array_object_signalledrow_mysql_freeze_data_dictionary_funcrw_lock_s_lock_spinrow_update_cascade_for_mysqlrow_upd_stepque_thr_stop_for_mysqlsrv_suspend_mysql_threadsrv_n_rows_deletedsrv_n_rows_updateddict_update_statisticsrow_unlock_for_mysqlsrv_locks_unsafe_for_binloglock_rec_unlockmtr_commitbtr_pcur_restore_position_funcrec_get_offsets_funcdict_index_get_nth_col_posrow_update_prebuilt_trxfprintfmem_analyze_corruption_IO_putcrow_prebuild_sel_graphsel_node_createpars_complete_graph_for_execrow_mysql_pad_colmemsetrow_mysql_store_blob_refrow_mysql_handle_errorsrow_rollback_on_timeouttrx_general_rollback_for_mysqlexitmem_heap_create_blockrow_lock_table_for_mysqlque_thr_move_to_run_state_for_mysqltrx_startlock_tableque_thr_stop_for_mysql_no_errorins_node_createdict_table_copy_typesins_node_set_new_rowmem_heap_add_blockrow_lock_table_autoinc_for_mysqlmemcpyrow_create_update_node_for_mysqlupd_node_createbtr_pcur_create_for_mysqlrow_get_prebuilt_update_vectorrow_insert_for_mysqlsrv_created_new_rawsrv_force_recoverysrv_dml_needed_delaytrx_savept_takerow_ins_stepos_thread_sleepsrv_n_rows_insertedut_print_timestamprow_create_prebuiltbtr_pcur_resetdict_index_copy_typesrow_check_index_for_mysqlrow_search_for_mysqldict_index_name_printcmp_dtuple_rec_with_matchdtuple_printrec_print_newrow_rec_to_index_entrytrx_is_interruptedmem_heap_duprow_mysql_prebuilt_free_blob_heaprow_prebuilt_freeque_graph_free_recursivedict_table_decrement_handle_countrow_update_for_mysqlbtr_pcur_copy_stored_positionrow_mysql_unlock_data_dictionaryrow_mysql_store_col_in_innobase_formatkernel_mutex_temprow_mysql_lock_data_dictionary_funcrw_lock_x_lock_funcrow_truncate_table_for_mysqllock_remove_all_on_tablebtr_pcur_open_on_user_rec_funcdict_truncate_index_treerec_get_nth_field_offs_oldmlog_write_ulintdict_hdr_get_new_idpars_info_add_int4_literalpars_info_add_ull_literaldict_table_change_id_in_cachedict_table_autoinc_lockdict_table_autoinc_initializedict_table_autoinc_unlocktrx_commit_for_mysqlsrv_wake_master_threaddict_foreign_err_filedict_foreign_err_mutexrewindfil_space_get_flagsfil_discard_tablespacebtr_pcur_move_to_next_pagebuf_page_printfil_create_new_single_table_tablespacefsp_header_initrow_rename_table_for_mysqlstrstros_thread_yielddict_foreign_parse_drop_constraintsdict_table_rename_in_cachedict_load_foreignsstrncpyinnobase_convert_to_system_charsetdict_get_db_name_lenmem_heap_strcatrow_discard_tablespace_for_mysqlrow_import_tablespace_for_mysqllog_sysfil_reset_too_high_lsnsibuf_delete_for_discarded_spacefil_open_single_table_tablespacerow_unlock_table_autoinc_for_mysqllock_trx_holds_autoinc_lockslock_release_autoinc_locksrow_drop_table_for_mysqlsrv_print_innodb_monitorsrv_print_innodb_lock_monitordict_tables_have_same_dbsrv_print_innodb_tablespace_monitorsrv_print_innodb_table_monitormem_heap_strdupdict_table_remove_from_cachefil_space_for_table_exists_in_memfil_delete_tablespacerow_drop_database_for_mysqldict_get_first_table_name_in_dbrow_mysql_drop_temp_tablestrx_allocate_for_backgroundbtr_cur_open_at_index_side_funcbtr_pcur_store_positiontrx_free_for_backgroundrow_drop_tables_for_mysql_in_backgroundlog_buffer_flush_to_diskrow_table_add_foreign_constraintsdict_create_foreign_constraintsrow_create_index_for_mysqldict_mem_index_freeind_create_graph_createque_fork_start_commandque_run_threadsque_graph_freerow_create_table_for_mysqldict_mem_table_freesrv_lock_timeout_thread_eventtab_create_graph_createS]hu  $%K P U$Z%d i n$s%z   $%()   p ! `E J &O$T%z*+, 3- H.h/01 621341 2)18 D?2~6667#6~6:<::$;<=  $%6!:<G6i:r: :?6:l:T:l  8$%bABCDE(FnH S I I J ^= G K  L M{   K 1 ` 2 1  O P  $ % 1 X O 1 3 1 Q P( / $4 %U Se T  $ %"f k _p$u%  j$%V: ? uD$I%Y ^ c$h%|  $%1 O $% Y&ZvZ1 21 PO1 2[C B0 5 :$?%~\ ^$_4`NB^Xk ^a_`BXRbcd/Tee "^P_c`}BX ^a.ewijee%h9Tmno _ $%Zp^qBX ^<#r7aBsF1 21 O131&Q.P8 ?$D%K1Pt[1` kO   $% % \ v v!w"e"e"e2# 7# 8 <#$A#%Y# #\$ $\Q$y$1$t$1$  $2$1$z$1$ $O$*%+@%*[%+% %L&{h&1w& @ |&2&1&z&1& &2&1&|&1& &2&1&}&1&Q'+'*'~(y6((1(  (2(+(e) x )  )$ )%/) H) l))*)+=*vI*vn***+*****++.+*K+++*,+:,V,*{,+,1,  ,2,P, ,$,%,1, p ,O,1-3-1-Q-P#- *-$/-%v-m-n-o- '-_-.p%.^M.Ar.B.X. ^.r.a/Dt/F/ ^//E/D/1/ /2 0 0  0$0%#01(0 /0O:01K03R01\0Qd0Pn0 u0$z0%010t010 0O060/08161:< 1:31:S1:c1:x1:1:1;1<1=1 1 8 1$1%,2 32$82%4 4  4$4%464465 +56=5K5u505655855556 6\o6)6 x 6\6g 77 -757B76I7787 7777e 8e>8 x C8  H8$M8%868:<868 :88686 9/796A9 b969 979 :99 9 h 9$9%:6::<F:6N: [: :c: h:o:6:6:/:6: :6; ;7$; +; :0;?; D; h I;$N;%w;m;1;  ;2; <;_J<<6< 0 < 0 <<6<6= 0 =A= K=\>/>w> 5?k????J? 5@K#AhA*A+AJB*+B+hB6B;B<B=BC,C fC!C l&C6C s;CJC OC.lCtCCCCFCCC ^CCC C CCt D MD2(D3:D  ?D2ZD3gDQlD DDDD6D 0 E 0 EE63E6oE 0 yEEeEeFF  F1FOFF 8F$F%GGGJ$H6sH1zHtH1H  HOH;H<H=HZH1 ItI1!I &I2;I1@I3GI1VI [I2gI1qItxI1I  I2I1I3I1I  I2I I 8I$I%NJmXJnfJ1uJ J2J ^JJ K K 2K>KJKYK dK iKnK {KKKL,L L-L #L-0L 05L.aLZ{L1L 8LOL LMMMM1MtM1M M2M1M3M1M M2MNZN(lN(NN,N N-N N-N N-NN(O('OFO KO-XO ]O.OZOP9P(oPPP P P$P%P P zP$P%P P1PtP1P hP2Q1Q3Q1(Q (-Q24Q1DQ3KQ1ZQ _Q2fQ1vQ3}Q1Q XQ2Q1QtQ1Q Q2Q1Q3Q1Q @Q2 RR $R ` )R$.R%5R1CRtJR1YR ^R2eR1uR3|R1R R2R1RtR1R R2R1R3R1R R2S1S S2S1.S35S1DS IS2yS S_S/%T06T1ET 6JT2UT1aT3gT4uT1T T2TTT,T jU-U sU!U p!&U.HUZ[UcUkU ^UU U UUtU 4U2U1U3U LU2V1V3!VQ&V AVIVuVZV1V DV2V1VtV1V  V2V1V3V1 W !W2"W5?W1IWtPW1_W dW2kW1{W3W1W  W2W_W6W uWX6X #>X6PX6WXX8XY/5Y0FY1UY 6ZY2eY1qY3wY4Y1Y Y2YYYYZ ^:Z #?Z7KZ1ZZ D_Z2fZ1pZtwZ1Z Z2Z1Z3Z1Z #Z2Z5Z1Zt[1[ x$[2[1-[34[1C[ $H[2T[1Y[t`[1o[  %t[2{[1[3[1[ #[2[1[t[1[ [2[1[3[1\ 0$ \2\1\t&\15\ h#:\2A\1Q\3X\1g\ #l\2\\6\]6] 0]6C]J]6Q]]8] ]7]m]1]  ]2^ *^_7^(L^)U^ `^/5_0_ ^__ p__`I``6`6` ` `a6a6a;a<a=a,a ja-a (a.b  b$b%-b12bt9b1Hb &Mb2Xb1eb3lb1{b 'b2bbb bb bb c7cDcSc5rc c6c6c d dd65d6d;d<d=dXd5e1ete1%e *e21e1Ae3He1We x%\e2ee1e .e2e1e3e1e e2 ff1)f ..f25f1Ef3Lf1[f `f2gf1lftsf1{f .fOf1f3f1f f2ff f ggt+g 0g2Cg3Ug LZg2og3|gQg g gg1gtg1g h.g2g1g3g1g g2h1hth1-h p'2h29h1Ih3Ph1_h 'dh2|h h jh$h%h h &h$h%h hh) i i_0ii/i0i1j 6 j2j1!j3'j45j1Dj Ij2gjqjj*j+jj,k Hk-k /k.)k18k =k2Dk1Tk3[k1bk 2ikOqkykk ^k1k k2k1k3k1k /kOk1k3k1lQl*Cl+Tl1cl Dhl2rl wl  |l$l%l l *l$l%ll1ltl1l X/l2l1l3l1l /l2m1m3m1(m -m27mrEm Ym ^m cm$hm%rm wm &|m$m%m5m m 0/m$m%mm Om n\4n/Mn 2op{ x K{\{g|/E|0W|1f| 6k|2v|1|3|4|1| |2|_>}T}Za}i}} ^}*}+~ %~\a~o~T{~~~*19 DA2Ve  `3$%5 x   $%m1  2L Z j { 1 8O_()+ >EN;i  \с߁T2Z:DL ^a x; `;т p; 015t?1D .KOV1c3j1y ~2Z1t1Ã 4ȃ2Ӄ131 2%11@ 3E2L1[ h4`2o t jy$~%  `3$%X5]8 Vg p(08@HPX`hpxp (08@HPX 40HP\|`T`| p4@`P @  (`@0P8X`P#D)t)@- 0X1t4`89H`;I`SW<\`]h md s z {$