i can't access innodb tables, only aria memory myisam 2015-12-10 22:05 GMT-02:00 Peter Mclarty < [email protected]>:
> Hi Rorberto > That log looks like your innDB has started. > the “mysql”.”innodb_table_stats” not found is possibly an upgrade or > something removed or damaged that mysql table. That isn't innodb not > starting. Have you checked you can access any tables under the innodb > engine? > > Cheers > > Peter > > > > > > > On Fri, Dec 11, 2015 at 9: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 >> >> > > > *Peter McLarty* > *Data Analyst DBA* > Compare The Market > P: +61 7 3377 8952 > M: +61 4 0209 4238 > http://www.comparethemarket.com.au > > > Compare The Market is a brand and trading name of Compare The Market (Pty) > Ltd (CTM). This email is for the intended addressee and is confidential and > subject to copyright. > If you are not the intended addressee, confidentiality has not been waived > and any use, interference with, or disclosure of this email is unauthorised. > If you are not the intended addressee please immediately notify CTM and then > delete the email. CTM does not warrant that this email is error or virus free. > > -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
