This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Senator crash problem with mysql
#1
[Not Solved] Senator crash problem with mysql
Hello,

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


Quote: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
Reply
Thanks given by:
#2
[Not Solved] RE: Senator crash problem with mysql
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
'' Life is full of important choices ''
Help Sentora Donate now => http://sentora.org/donate Blush
Reply
Thanks given by:
#3
[Not Solved] RE: Senator crash problem with mysql
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
'' Life is full of important choices ''
Help Sentora Donate now => http://sentora.org/donate Blush
Reply
Thanks given by:
#4
[Not Solved] RE: Senator crash problem with mysql
Did you solve this error?

I also got stuck here.
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
MySQL Database user prefix MosleyCale 1 92 10-17-2020, 09:11 PM
Last Post: Ron-e
Problem with CPanel to Sentora WilliamCawley 0 261 07-20-2020, 01:26 PM
Last Post: WilliamCawley
MySQL remote access... pixelbat 11 21 709 05-02-2020, 07:40 PM
Last Post: upendra.sahu1990@gmail.com

Forum Jump:


Users browsing this thread: 1 Guest(s)