WordPress.org

Ready to get started?Download WordPress

Forums

WordPress 2.5.1 crashes database after saving (5 posts)

  1. Keilya
    Member
    Posted 6 years ago #

    Hello

    At this moment I'm not entirely sure if it's WP's fault, but it's the second time this is occuring.

    It doesn't happen all the time I publish or save a new post, but it does happen frequently whenever I do so.

    I get a "Page cannot be displayed" message upon clicking "Save" or "Publish", and immediately after this, the database crashes and WP is unable to connect.

    So far, the only solution is to repair the database. Which takes really long and I really do not want to do it on a daily basis. Any ideas?

    This only happened after I upgraded to 2.5.1. 2.5 was running smooth.

    My host server also recently suffered a "heavy /home2 partition damage" due to a downtime. So if any you guys can translate what that means for me and tell me what might be going wrong, I'll be much in your debt!

    Thanks!

  2. Keilya
    Member
    Posted 6 years ago #

    Sorry I must have been dumb not to post this, but I couldn't figure out where the SQL error logs were stored for the life of me till 2 hours later.

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 995 AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('42') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date ASC LIMIT 0, 6 made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy = 'category' AND wp_term_taxonomy.term_id IN ('42') AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date ASC LIMIT 0, 6 made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 1513 AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 570 AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC made by get_posts

    [01-May-2008 13:13:42] WordPress database error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) for query SELECT FOUND_ROWS() made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 1030 AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 990 AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 6 made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 815 AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 815 AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC made by get_posts

    [01-May-2008 13:13:42] WordPress database error Server shutdown in progress for query SELECT * FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_pingme' LIMIT 1 made by do_all_pings

    [01-May-2008 13:13:42] WordPress database error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) for query SELECT * FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = '_encloseme' LIMIT 1 made by do_all_pings

    [01-May-2008 13:13:42] WordPress database error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) for query SELECT ID FROM wp_posts WHERE to_ping <> '' AND post_status = 'publish' made by do_all_pings

    [01-May-2008 13:13:43] WordPress database error Lost connection to MySQL server during query for query SELECT FOUND_ROWS() made by get_posts

    [01-May-2008 13:13:43] WordPress database error Lost connection to MySQL server during query for query SELECT FOUND_ROWS() made by get_posts

    [01-May-2008 13:13:44] WordPress database error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) for query UPDATE wp_options SET option_value = '0' WHERE option_name = 'doing_cron' made by update_option

    Why is the server shutting down?

    Please help. x.x

    Plugins I have running:

    Akismet
    Subscribe to Comments
    Google Sitemap Generator
    Get Recent Comments
    SH Autolink
    Custom Query String
    Comment Analysis
    All-in-one SEO pack

  3. trininet
    Member
    Posted 6 years ago #

    I'm having the exact same issue... I see this issue posted a couple of time in these forums with no answers...

    Can some one help with the 2.5 to 2.5.1 database crashing issue?

    Note: I did get the upgrade wordpress screen after uploading the 2.5.1 and it seemed to have work like it should.

  4. f1f
    Member
    Posted 6 years ago #

    This sounds like the same problem I'm having here:

    http://wordpress.org/support/topic/190278?replies=2

    So far I've got no idea how to fix it - I hope someone can help.

  5. hotkee
    Member
    Posted 6 years ago #

    This is nothing to do with wordpress - talk to your host providers and ask them why their servers are messing up.

Topic Closed

This topic has been closed to new replies.

About this Topic