[mythtv-users] Corrupt mysql

[Gerald Brandt]

On 2014-07-09, 8:18 AM, Gerald Brandt wrote:
> 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!
>
>
OKay, so I found the #sql-1329_d58 files and renamed them.  Mysql now 
comes up, and so does myth.  Is there anything I may have broken?

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