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

Crash on prepare partitial backup

salossalos EntrantInactive User Role Beginner
I'm trying to prepare my backup to restore on another server and I have
InnoDB: End of page dump
2014-06-23 06:36:45 7f40e17c3700 InnoDB: uncompressed page, stored checksum in field1 3735928559, calculated checksums for field1: crc32 177807968, innodb 3475755373, none 3735928559, stored checksum in field2 3735928559, calculated checksums for field2: crc32 177807968, innodb 1624572976, none 3735928559, page LSN 0 0, low 4 bytes of LSN at page end 0, page number (if stored to page already) 0, space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be a freshly allocated page
2014-06-23 06:36:45 7f40e17c3700 InnoDB: Assertion failure in thread 139916637648640 in file line 577
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to
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: about forcing recovery.
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/innobackupex line 2610.

If I try to restore it by table it also error
Internal error: Cannot reset LSNs in table '"hero_db"."map_save"' : Data structure corruption */

It seems that is because there are no exp file.

command for prepare
innobackupex --apply-log --export /var/mysql-backup/2014-06-20_10-00-01

command for create backup
innobackupex --user=<user> --password=<password> --compact --databases="hero_db" /var/mysql-backup

Probably it is because we use COMPRESSED tables
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.