Not the answer you need?
Register and ask your own question!

Failure on start mysql clustered node

immortalimmortal EntrantCurrent User Role Beginner
Hi ,

We are having a problem starting mysql on a percona cluster service . The cluster has 4 nodes , 3 of them are running ok but the last one fail to start . Looking at mysql.err log file I can see :

141117 14:04:57 InnoDB: Error: table 'XXXXXXXX/tmp_ad_zone_impression'
InnoDB: in InnoDB data dictionary has tablespace id 105964,
InnoDB: but a tablespace with that id does not exist. There is
InnoDB: a tablespace of name ./XXXXXXXX/tmp_ad_zone_impression.ibd and id 105957, though. Have
InnoDB: you deleted or moved .ibd files?
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
141117 14:04:57 InnoDB: Error: table 'YYYYYYYYY/_cc_tmp'
InnoDB: in InnoDB data dictionary has tablespace id 105949,
InnoDB: but a tablespace with that id does not exist. There is
InnoDB: a tablespace of name ./YYYYYYYYY/_cc_tmp.ibd and id 105952, though. Have
InnoDB: you deleted or moved .ibd files?
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
141117 14:04:57 InnoDB: Waiting for the background threads to start
141117 14:04:57 InnoDB: Unable to allocate memory of size 18446744073709544232.
141117 14:04:57 InnoDB: Assertion failure in thread 139747344623360 in file mem0mem.c line 361
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html

Looking at the url included at last line , I can see that starting mysql with the innodb_force_recovery = 1 option should be tried .
(I was thinking of starting the mysql as a stand alone service , out of cluster of course) .

If this should not work , what would you recoment to get the server up and running ?

Thank you in advance,
Nick
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.