maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

hi guys, i was using my database and it crashed, after restart innodb
(Xtradb) don't start

the log shows this:

151210 21:44:38 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151210 21:44:38 [Note] InnoDB: The InnoDB memory heap is disabled
151210 21:44:38 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
151210 21:44:38 [Note] InnoDB: Memory barrier is not used
151210 21:44:38 [Note] InnoDB: Compressed tables use zlib 1.2.3
151210 21:44:38 [Note] InnoDB: Using CPU crc32 instructions
151210 21:44:38 [Note] InnoDB: Initializing buffer pool, size = 32.0G
151210 21:44:48 [Note] InnoDB: Completed initialization of buffer pool
151210 21:44:54 [Note] InnoDB: Highest supported file format is Barracuda.
151210 21:44:54 [Note] InnoDB: The log sequence numbers 8739254920 and
8739254920 in ibdata files do not match the log sequence number 98318151020
in the ib_logfiles!
151210 21:44:54 [Note] InnoDB: Database was not shutdown normally!
151210 21:44:54 [Note] InnoDB: Starting crash recovery.
151210 21:44:54 [Note] InnoDB: Reading tablespace information from the .ibd
files...
151210 21:44:54 [Note] InnoDB: Restoring possible half-written data pages
151210 21:44:54 [Note] InnoDB: from the doublewrite buffer...
151210 21:44:57 [Note] InnoDB: 128 rollback segment(s) are active.
151210 21:44:57 [Note] InnoDB: Waiting for purge to start
151210 21:44:57 [Note] InnoDB:  Percona XtraDB (http://www.percona.com)
5.6.25-73.1 started; log sequence number 98318151020
151210 21:44:57 [Note] Plugin 'FEEDBACK' is disabled.
151210 21:44:57 [Note] Server socket created on IP: '::'.
151210 21:44:57 [Note] Event Scheduler: Loaded 0 events
2015-12-10 21:44:57 7fbfd435a700 InnoDB: Error: Table
"mysql"."innodb_table_stats" not found.
151210 21:44:57 [Note] /opt/mariadb/bin//mysqld: ready for connections.
Version: '10.0.21-MariaDB-log'  socket: '/tmp/mysql.BH.sock'  port: 3307
 MariaDB Server


any idea what could be done to start recovery from innodb?

-- 
Roberto Spadim