[mythtv-users] Corrupt mysql

[Gerald Brandt]

Hi,

I had a power failure last night, and now I have a corrupt DB.  This is 
the error.log.  Any ideas how to fix it?

140709  8:07:39 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

140709  8:07:39 [Note] Plugin 'FEDERATED' is disabled.

140709  8:07:39 InnoDB: The InnoDB memory heap is disabled

140709  8:07:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins

140709  8:07:39 InnoDB: Compressed tables use zlib 1.2.3.4

140709  8:07:39 InnoDB: Initializing buffer pool, size = 128.0M

140709  8:07:39 InnoDB: Completed initialization of buffer pool

140709  8:07:39 InnoDB: highest supported file format is Barracuda.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

140709  8:07:39  InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Error: trying to add tablespace 34 of name './mythconverg.25/#sql-1329_d58.ibd'

InnoDB: to the tablespace memory cache, but tablespace

InnoDB: 34 of name './mythconverg/#sql-1329_d58.ibd' already exists in the tablespace

InnoDB: memory cache!

140709  8:07:40 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

140709  8:07:40 [Note] Plugin 'FEDERATED' is disabled.

140709  8:07:40 InnoDB: The InnoDB memory heap is disabled

140709  8:07:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins

140709  8:07:40 InnoDB: Compressed tables use zlib 1.2.3.4

140709  8:07:40 InnoDB: Initializing buffer pool, size = 128.0M

140709  8:07:40 InnoDB: Completed initialization of buffer pool

140709  8:07:40 InnoDB: highest supported file format is Barracuda.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

140709  8:07:40  InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Error: trying to add tablespace 34 of name './mythconverg.25/#sql-1329_d58.ibd'

InnoDB: to the tablespace memory cache, but tablespace

InnoDB: 34 of name './mythconverg/#sql-1329_d58.ibd' already exists in the tablespace

InnoDB: memory cache!

140709  8:07:41 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

140709  8:07:41 [Note] Plugin 'FEDERATED' is disabled.

140709  8:07:41 InnoDB: The InnoDB memory heap is disabled

140709  8:07:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins

140709  8:07:41 InnoDB: Compressed tables use zlib 1.2.3.4

140709  8:07:41 InnoDB: Initializing buffer pool, size = 128.0M

140709  8:07:41 InnoDB: Completed initialization of buffer pool

140709  8:07:41 InnoDB: highest supported file format is Barracuda.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

140709  8:07:41  InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Error: trying to add tablespace 34 of name './mythconverg.25/#sql-1329_d58.ibd'

InnoDB: to the tablespace memory cache, but tablespace

InnoDB: 34 of name './mythconverg/#sql-1329_d58.ibd' already exists in the tablespace

InnoDB: memory cache!

140709  8:08:21 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

140709  8:08:21 [Note] Plugin 'FEDERATED' is disabled.

140709  8:08:21 InnoDB: The InnoDB memory heap is disabled

140709  8:08:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins

140709  8:08:21 InnoDB: Compressed tables use zlib 1.2.3.4

140709  8:08:21 InnoDB: Initializing buffer pool, size = 128.0M

140709  8:08:21 InnoDB: Completed initialization of buffer pool

140709  8:08:21 InnoDB: highest supported file format is Barracuda.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

140709  8:08:21  InnoDB: Database was not shut down normally!

InnoDB: Starting crash recovery.

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Error: trying to add tablespace 34 of name './mythconverg.25/#sql-1329_d58.ibd'

InnoDB: to the tablespace memory cache, but tablespace

InnoDB: 34 of name './mythconverg/#sql-1329_d58.ibd' already exists in the tablespace

InnoDB: memory cache!


-- 
Gerald Brandt
Majentis Technologies
204-229-6595
gbr at majentis.com