WordPress.org

Support

Support » Plugins and Hacks » Slim Stat Analytics » [Resolved] WordPress database error Deadlock

[Resolved] WordPress database error Deadlock

  • This error is generated by Slim Stat. I’m trying to find out what causes it. I still don’t know how it is affecting SlimStat functioning.
    ===========================================================
    WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT INTO wp_slim_stats ( ip, language, country, searchterms, resource, content_info_id, browser_id, dt )
    SELECT ‘1296595422’,’xx’,’ru’,”,’/fb/e-cluster-pack-two’,’3′,’85’,’1351854747′
    FROM DUAL
    WHERE NOT EXISTS ( SELECT id
    FROM wp_slim_stats
    WHERE ip = ‘1296595422’ AND language = ‘xx’ AND country = ‘ru’ AND searchterms = ” AND resource = ‘/fb/e-cluster-pack-two’ AND content_info_id = ‘3’ AND browser_id = ’85’ AND (TIME_TO_SEC(TIMEDIFF(FROM_UNIXTIME(‘1351854747’),FROM_UNIXTIME(dt))) < 30) LIMIT 1) made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array, call_user_func_array, wp_slimstat::slimtrack
    [03-Nov-2012 16:31:48] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query INSERT INTO wp_slim_stats ( ip, language, country, searchterms, resource, content_info_id, browser_id, dt )
    SELECT ‘1541099955’,’xx’,’ua’,”,’/fb/?page_id=410′,’3′,’85’,’1351960308′
    FROM DUAL
    WHERE NOT EXISTS ( SELECT id
    FROM wp_slim_stats
    WHERE ip = ‘1541099955’ AND language = ‘xx’ AND country = ‘ua’ AND searchterms = ” AND resource = ‘/fb/?page_id=410’ AND content_info_id = ‘3’ AND browser_id = ’85’ AND (TIME_TO_SEC(TIMEDIFF(FROM_UNIXTIME(‘1351960308’),FROM_UNIXTIME(dt))) < 30) LIMIT 1) made by require(‘wp-blog-header.php’), wp, WP->main, do_action_ref_array, call_user_func_array, wp_slimstat::slimtrack
    ============================================================

    http://wordpress.org/extend/plugins/wp-slimstat/

Viewing 1 replies (of 1 total)
  • Plugin Author Jason Crouse

    @coolmann

    Yes, I’m aware of the problem, which is going to be fixed in the next version. Thank you for pointing that out.

    Camu

Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] WordPress database error Deadlock’ is closed to new replies.
Skip to toolbar