when innodb foudn a error, it start repari thread right? how could i check if repair thread is running?
2015-12-10 22:23 GMT-02:00 Roberto Spadim <[email protected]>: > 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 > -- 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
