none
How to fix my SQL database?

    Question

  • I have recently moved a WordPress blog into a new servor which has these caracteristics : debian, mysql 5.0.51a-24, 16GB of ram.

    The mysql crashed regularly with this log info:

    Feb 8 12:17:14 ns210031 mysqld[998]: 100208 12:17:14 - mysqld got signal 11;

    Feb 8 12:17:14 ns210031 mysqld[998]: This could be because you hit a bug. It is also possible that this binary

    Feb 8 12:17:14 ns210031 mysqld[998]: or one of the libraries it was linked against is corrupt, improperly built,

    Feb 8 12:17:14 ns210031 mysqld[998]: or misconfigured. This error can also be caused by malfunctioning hardware.

    Feb 8 12:17:14 ns210031 mysqld[998]: We will try our best to scrape up some info that will hopefully help diagnose

    Feb 8 12:17:14 ns210031 mysqld[998]: the problem, but since we have already crashed, something is definitely wrong

    Feb 8 12:17:14 ns210031 mysqld[998]: and this may fail.

    Feb 8 12:17:14 ns210031 mysqld[998]:

    Feb 8 12:17:14 ns210031 mysqld[998]: key_buffer_size=16777216

    Feb 8 12:17:14 ns210031 mysqld[998]: read_buffer_size=131072

    Feb 8 12:17:14 ns210031 mysqld[998]: max_used_connections=38

    Feb 8 12:17:14 ns210031 mysqld[998]: max_connections=2000

    Feb 8 12:17:14 ns210031 mysqld[998]: threads_connected=8

    Feb 8 12:17:14 ns210031 mysqld[998]: It is possible that mysqld could use up to

    Feb 8 12:17:14 ns210031 mysqld[998]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 4368368 K

    Feb 8 12:17:14 ns210031 mysqld[998]: bytes of memory

    Feb 8 12:17:14 ns210031 mysqld[998]: Hope that's ok; if not, decrease some variables in the equation.

    Feb 8 12:17:14 ns210031 mysqld[998]:

    Feb 8 12:17:14 ns210031 mysqld[998]: thd=0x7f58701cf510

    Feb 8 12:17:14 ns210031 mysqld[998]: Attempting backtrace. You can use the following information to find out

    Feb 8 12:17:14 ns210031 mysqld[998]: where mysqld died. If you see no messages after this, something went

    Feb 8 12:17:14 ns210031 mysqld[998]: terribly wrong...

    Feb 8 12:17:14 ns210031 mysqld[998]: Cannot determine thread, fp=0x7f58701cf510, backtrace may not be correct.

    Feb 8 12:17:14 ns210031 mysqld[998]: Bogus stack limit or frame pointer, fp=0x7f58701cf510, stack_bottom=0x446d0000, thread_stack=131072, aborting backtrace.

    Feb 8 12:17:14 ns210031 mysqld[998]: Trying to get some variables.

    Feb 8 12:17:14 ns210031 mysqld[998]: Some pointers may be invalid and cause the dump to abort...

    Feb 8 12:17:14 ns210031 mysqld[998]: thd->query at 0x24b6d70 = SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id = wp_posts.ID AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN (8975) ) ORDER BY wp_posts.post_date DESC LIMIT 0, 30

    Feb 8 12:17:14 ns210031 mysqld[998]: thd->thread_id=28238

    Feb 8 12:17:14 ns210031 mysqld[998]: The manual page athttp://www.mysql.com/doc/en/Crashing.html contains

    Feb 8 12:17:14 ns210031 mysqld[998]: information that should help you find out what is causing the crash.

    Can anyone help me to fix this strange bug ?

    Tuesday, September 23, 2014 3:54 PM

Answers

  • Hi,

    Check with these options:

    - Username and password information in your wp-config.php file is incorrect. Please check with PHPMyAdmin and correct it or reset it. Also make necessary changes in wp-config.php file.

    - Make sure that you have typed correct host name in wp-config.php file.

    - Your hosting service provider’s database server is down. Hence, take a support from your hosting service provider.

    Read more on this specialized forum: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server

    But if all else fails, try to restore using this program: http://www.mysql.recoverytoolbox.com/

    Thanks.

    • Marked as answer by WalterStark Wednesday, September 24, 2014 6:48 PM
    Wednesday, September 24, 2014 5:45 PM

All replies

  • Not really - these forums are for MS SQL Server, not MySQL. 
    • Proposed as answer by Olaf HelperMVP Wednesday, September 24, 2014 6:42 AM
    Tuesday, September 23, 2014 5:08 PM
  • Well I can say that in 15+ years of using SQL Server I personally have never seen SQL Server crash nor have I worked with anyone in that time who's had it crash.

    That certainly is a reasonable track record.

    Tuesday, September 23, 2014 7:03 PM
  • Hi,

    Check with these options:

    - Username and password information in your wp-config.php file is incorrect. Please check with PHPMyAdmin and correct it or reset it. Also make necessary changes in wp-config.php file.

    - Make sure that you have typed correct host name in wp-config.php file.

    - Your hosting service provider’s database server is down. Hence, take a support from your hosting service provider.

    Read more on this specialized forum: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server

    But if all else fails, try to restore using this program: http://www.mysql.recoverytoolbox.com/

    Thanks.

    • Marked as answer by WalterStark Wednesday, September 24, 2014 6:48 PM
    Wednesday, September 24, 2014 5:45 PM