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
============================================================
- The topic ‘WordPress database error Deadlock’ is closed to new replies.