← Back to team overview

maria-discuss team mailing list archive

Re: INNODB not loading

 

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@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>

References