Senator crash problem with mysql

[provokas]

Hello,

I m using Sentora 1.0.3 my mysql always crashing, so I have checked the error log and get this message:

161129 14:34:12 [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.
161129 14:34:12 [Note] Plugin 'FEDERATED' is disabled.
161129 14:34:12 InnoDB: The InnoDB memory heap is disabled
161129 14:34:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
161129 14:34:12 InnoDB: Compressed tables use zlib 1.2.8
161129 14:34:12 InnoDB: Using Linux native AIO
161129 14:34:12 InnoDB: Initializing buffer pool, size = 128.0M
161129 14:34:12 InnoDB: Completed initialization of buffer pool
161129 14:34:12 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!
161129 14:34:12  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
161129 14:34:13  InnoDB: Waiting for the background threads to start
161129 14:34:14 InnoDB: 5.5.53 started; log sequence number 21488340648
161129 14:34:14 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
161129 14:34:14 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
161129 14:34:14 [Note] Server socket created on IP: '127.0.0.1'.
161129 14:34:14 [Note] Event Scheduler: Loaded 0 events
161129 14:34:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.53-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
161129 14:34:15 [ERROR] /usr/sbin/mysqld: Table './sentora_core/x_bandwidth' is marked as crashed and should be repaired
161129 14:34:15 [Warning] Checking table:   './sentora_core/x_bandwidth'
161129 14:34:15 [ERROR] /usr/sbin/mysqld: Table './sentora_core/x_mysql_databases' is marked as crashed and should be repaired
161129 14:34:15 [Warning] Checking table:   './sentora_core/x_mysql_databases'

Do you have any idea? how can I fix it?

Thank you in advance

[wormsunited]

Hi, 

This might help:

http://dev.mysql.com/doc/refman/5.7/en/m...start.html

Also try this one:

http://article.my-addr.com/?show=linux_u...other_path

[wormsunited]

By the way... Since the InnoDB Storage Engine looks operational at the time mysql is restated, you should take the time to cleanup the InnoDB infrastructure.

• mysqldump the entire database instance
  
• reconfigure innodb from scratch
  
• Start over with a fresh ibdata1 file
  
• Empty Undo Space
  
• Empty Rollback Segments
  
• Empty Data Dictionary
  
• Empty List of Tablespace IDs
  
• Store Each InnoDB table in its own tablespace
  
• Configure Buffer Pool to be 4 times the Log File Size
  
• Perform Better Flushing of the Buffer Pool
  
• reload mysql data
  

Source => http://dba.stackexchange.com/questions/1...corruption

[Your Creator]

Did you solve this error?

I also got stuck here.