WordPress.org

Ready to get started?Download WordPress

Forums

Cannot COMMENT - Lock wait timeout (1 post)

  1. picos
    Member
    Posted 7 years ago #

    My blog is working perfectly for the past year.
    Today it started with this behaviour...It doesn't let me insert comments. It bangs with the following error:

    WordPress database error: [Lock wait timeout exceeded; Try restarting transaction]
    DELETE FROM wp_comments WHERE DATE_SUB('2007-01-22 14:38:52', INTERVAL 15 DAY) > comment_date_gmt AND comment_approved = 'spam'

    WordPress database error: [Lock wait timeout exceeded; Try restarting transaction]
    INSERT INTO wp_comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES ('329', 'picos', 'blog@estounanet.com', 'http://www.estounanet.com', '81.246.19.230', '2007-01-22 07:39:23', '2007-01-22 14:39:23', 'Test', '1', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)', '', '0', '1')

    I have AKISMET and even in the management area, when i start to delete the spam, it bangs again with the following error:

    WordPress database error: [Lock wait timeout exceeded; Try restarting transaction]
    DELETE FROM wp_comments WHERE comment_approved = 'spam' AND '2007-01-22 14:25:24' > comment_date_gmt

    Any suggestion?
    Thank yous
    Luís MOnteiro

Topic Closed

This topic has been closed to new replies.

About this Topic