Innodb crashing again and again

ravijas

• December 19, 2014 01:05

Hello, We are facing issue with mysql-innodb. Innodb crashing 2/3 times in a month on a server. My.cnf is as follows.
[mysqld] performance_schema=off default-storage-engine=MyISAM skip-external-locking key_buffer_size=3G max_allowed_packet=8M max_connections=350 max_user_connections=25 wait_timeout=40 connect_timeout=10 table_cache=2048 join_buffer_size=512K sort_buffer_size=2M read_buffer_size=2M read_rnd_buffer_size=8M myisam_sort_buffer_size=64M thread_cache_size=128 query_cache_size=128M tmp_table_size=256M max_heap_table_size=256M server-id = 1 innodb_fast_shutdown=0 innodb_buffer_pool_size=2G innodb_file_per_table=1 open_files_limit=50000 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout

Server/WHM version WHM 11.46.1 CloudLinux Server release 5.11 x86_64
Please help us to stop such issue and the possible reasons to crash the innodb? Thanks, RaviJas.

• 

  cPanelMichael

  • December 19, 2014 13:56

  Hello :) Do you have the output from /var/lib/mysql/$hostname.err when MySQL crashes? Thank you.

  0
• 

  ravijas

  • December 20, 2014 05:50

  Hi, Logs: 141220 1:42:03 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 679812795 141220 1:42:03 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 437 of name './zzzzzz_prod/weee_tax.ibd' InnoDB: to the tablespace memory cache, but tablespace InnoDB: 437 of name './aebdfdfcom_db/aebdfdfcom_cms_category_lang.ibd' already exists in the tablespace InnoDB: memory cache!
  

  0
• 

  cPanelPeter cPanel Staff

  • December 20, 2014 15:01

  Hello, The following Innodb Corruption Repair Guide written by one of our analysts might help.

  0
• 

  ravijas

  • December 22, 2014 17:15

  Hi, Yes we can repair it no doubt, but its happening 3/4 time in a month. Thats our problem. Why this is happening? Also seen many recent post with the same issue on the forum. Not sure what exactly going with mysql 5.5 version. Thanks, Ravijas.

  0
• 

  cPanelMichael

  • December 22, 2014 17:18

  Have there been any hard resets of the server that would prevent MySQL from shutting down properly? Thank you.

  0

Please sign in to leave a comment.