Cannot COMMENT – Lock wait timeout

  • picos

    (@picos)


    19 years, 4 months 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’, ‘[email protected]’, ‘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

The topic ‘Cannot COMMENT – Lock wait timeout’ is closed to new replies.