各位用过xtrabackup做主从搭建的时候,从库搭起来后没法正常访问,可能因为备份出来的单库文件过大,导致新的mysql服务起来后,那个库没法访问;增加innodb_force_recovery配置强制后,能访问表数据,但是无法创建表了。如果利用单表备份的话,一切正常,再根据日志显示如下,觉得可能是因为文件过大导致,各位有解决过吗,先谢过了:
2017-04-18 09:57:51 18963 [ERROR] InnoDB: InnoDB: Unable to allocate memory of size 18446744073709540768.
2017-04-18 09:57:51 7f6376233700 InnoDB: Assertion failure in thread 140065160509184 in file ha_innodb.cc line 18178
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.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.