WordPress.org

Ready to get started?Download WordPress

Forums

WP Slimstat
[resolved] WordPress database error Deadlock (2 posts)

  1. robertorod
    Member
    Posted 1 year ago #

    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/

  2. camu
    Member
    Plugin Author

    Posted 1 year ago #

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

    Camu

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.