Hi, Based on this log InnoDB has started, error in the log is because mysql_upgrade might not yet have been run. Is this full error log or do you have more of it after 151210 21:44:57 ?
R: Jan On Fri, Dec 11, 2015 at 1:56 AM, Roberto Spadim <[email protected]> wrote: > 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 > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
