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 <roberto@spadim.com.br> 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 : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp