Re: InnoDB table gets corrupt suddenly
I think it is a table problem. All queries inside transaction block. You can see errors here:
2015-07-03 16:05:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-07-03 16:05:08 26389 [Note] Plugin 'FEDERATED' is disabled.
2015-07-03 16:05:08 26389 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-03 16:05:08 26389 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-03 16:05:08 26389 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-03 16:05:08 26389 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-03 16:05:08 26389 [Note] InnoDB: Using Linux native AIO
2015-07-03 16:05:08 26389 [Note] InnoDB: Using CPU crc32 instructions
2015-07-03 16:05:08 26389 [Note] InnoDB: Initializing buffer pool, size = 12.0G
2015-07-03 16:05:09 26389 [Note] InnoDB: Completed initialization of buffer pool
2015-07-03 16:05:09 26389 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-03 16:05:09 26389 [Note] InnoDB: Log scan progressed past the checkpoint lsn 673593469067
2015-07-03 16:05:09 26389 [Note] InnoDB: Database was not shutdown normally!
2015-07-03 16:05:09 26389 [Note] InnoDB: Starting crash recovery.
2015-07-03 16:05:09 26389 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-07-03 16:05:09 26389 [ERROR] InnoDB: space header page consists of zero bytes in tablespace ./svbpanel/rate_list4.ibd (table svbpanel/rate_list4)
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size:1024 Pages to analyze:64
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size: 1024, Possible space_id count:0
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size:2048 Pages to analyze:32
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size: 2048, Possible space_id count:0
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size:4096 Pages to analyze:16
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size: 4096, Possible space_id count:0
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size:8192 Pages to analyze:8
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size: 8192, Possible space_id count:0
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size:16384 Pages to analyze:4
2015-07-03 16:05:09 26389 [Note] InnoDB: Page size: 16384, Possible space_id count:0
2015-07-03 16:05:09 7f48ed3f87e0 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: Error: could not open single-table tablespace file ./svbpanel/rate_list4.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
150703 16:05:09 mysqld_safe mysqld from pid file /var/lib/mysql/aki1.127.0.0.1.pid ended
150703 16:30:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Subject
Views
Written By
Posted
1920
July 03, 2015 09:02AM
1026
July 03, 2015 10:59AM
Re: InnoDB table gets corrupt suddenly
2952
July 03, 2015 12:42PM
1352
July 03, 2015 01:39PM
1232
July 03, 2015 02:52PM
1175
July 03, 2015 02:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.