Nirjonadda
Customer
Getting lot of Server error logs.
Code:
XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:212
Generated by: Laal Aug 7, 2018 at 11:29 PM
Stack trace
INSERT IGNORE INTO xf_dbtech_security_fingerprintlog
(`fingerprint`, `userid`, `dateline`, `ipaddress`, `components`)
VALUES
('0fd7b83e6900b024954a3eaea73a6433', '118', '1533662988', '103.213.237.42', 'a:24:{i:0;a:2:{s:3:\"key\";s:10:\"user_agent\";s:5:\"value\";s:130:\"Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36 OPR/54.0.2952.64\";}i:1;a:2:{s:3:\"key\";s:8:\"language\";s:5:\"value\";s:5:\"en-US\";}i:2;a:2:{s:3:\"key\";s:11:\"color_depth\";s:5:\"value\";s:2:\"24\";}i:3;a:2:{s:3:\"key\";s:11:\"pixel_ratio\";s:5:\"value\";s:1:\"1\";}i:4;a:2:{s:3:\"key\";s:20:\"hardware_concurrency\";s:5:\"value\";s:1:\"4\";}i:5;a:2:{s:3:\"key\";s:10:\"resolution\";s:5:\"value\";a:2:{i:0;s:4:\"1366\";i:1;s:3:\"768\";}}i:6;a:2:{s:3:\"key\";s:20:\"available_resolution\";s:5:\"value\";a:2:{i:0;s:4:\"1366\";i:1;s:3:\"728\";}}i:7;a:2:{s:3:\"key\";s:15:\"timezone_offset\";s:5:\"value\";s:4:\"-360\";}i:8;a:2:{s:3:\"key\";s:15:\"session_storage\";s:5:\"value\";s:1:\"1\";}i:9;a:2:{s:3:\"key\";s:13:\"local_storage\";s:5:\"value\";s:1:\"1\";}i:10;a:2:{s:3:\"key\";s:10:\"indexed_db\";s:5:\"value\";s:1:\"1\";}i:11;a:2:{s:3:\"key\";s:13:\"open_database\";s:5:\"value\";s:1:\"1\";}i:12;a:2:{s:3:\"key\";s:9:\"cpu_class\";s:5:\"value\";s:7:\"unknown\";}i:13;a:2:{s:3:\"key\";s:18:\"navigator_platform\";s:5:\"value\";s:5:\"Win32\";}i:14;a:2:{s:3:\"key\";s:12:\"do_not_track\";s:5:\"value\";s:7:\"unknown\";}i:15;a:2:{s:3:\"key\";s:15:\"regular_plugins\";s:5:\"value\";a:3:{i:0;s:82:\"Chromium PDF Plugin::Portable Document Format::application/x-google-chrome-pdf~pdf\";i:1;s:42:\"Chromium PDF Viewer::::application/pdf~pdf\";i:2;s:66:\"News feed handler::::application/atom+xml~,application/rss+xml~rss\";}}i:16;a:2:{s:3:\"key\";s:6:\"canvas\";s:5:\"value\";s:33859:\"canvas winding:yes~canvas fp:data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAB9AAAADICAYAAACwGnoBAAAgAElEQVR4XuzdeZhdVZ3v//c+VZXKPJCQgRCGhBBkCmMQBAUnFG1nxLYVAjaD3dfptrcVu1tRbId7r1fEXyuDQhDbXyvdXmwVB2hBRSDIFOYEAoGEEEgCmaeqOvs+311nV05Vajin6lSlirwXTz2QOnuvtfbrnPDP53y/K2GQj5R0BHAoMAc4pPTvacB4YEzpZ2LpMdYCG0s/64DngcfLfxKSrfkjp6QjS3MfDuQ/44DhQKyb/8Sf49oYcX/8bOvw3y8DjwIP5zwebgl fragment shader low int precision rangeMin:31~webgl fragment shader low int precision rangeMax:30\";}i:18;a:2:{s:3:\"key\";s:7:\"adblock\";s:5:\"value\";s:5:\"false\";}i:19;a:2:{s:3:\"key\";s:18:\"has_lied_languages\";s:5:\"value\";s:5:\"false\";}i:20;a:2:{s:3:\"key\";s:19:\"has_lied_resolution\";s:5:\"value\";s:5:\"false\";}i:21;a:2:{s:3:\"key\";s:11:\"has_lied_os\";s:5:\"value\";s:5:\"false\";}i:22;a:2:{s:3:\"key\";s:16:\"has_lied_browser\";s:5:\"value\";s:5:\"false\";}i:23;a:2:{s:3:\"key\";s:13:\"touch_support\";s:5:\"value\";a:3:{i:0;s:1:\"0\";i:1;s:5:\"false\";i:2;s:5:\"false\";}}}')
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/addons/DBTech/Security/Application/Db.php(785): XF\Db\AbstractAdapter->query('INSERT IGNORE I...')
#4 src/addons/DBTech/Security/Application/Db.php(403): DBTech\Security\Application\Db->query('INSERT IGNORE I...', Array, 'query_write')
#5 src/addons/DBTech/Security/Application/Db.php(427): DBTech\Security\Application\Db->insert('dbtech_security...', Array, Array, true, 'ignore')
#6 src/addons/DBTech/Security/Action/Fingerprint.php(28): DBTech\Security\Application\Db->insertIgnore('dbtech_security...', Array)
#7 src/addons/DBTech/Security/Application/Core.php(173): DBTech\Security\Action\Fingerprint->actionIndex()
#8 src/addons/DBTech/Security/Pub/Controller/Route.php(42): DBTech\Security\Application\Core->runAction('DBTech\\Security...')
#9 src/XF/Mvc/Dispatcher.php(249): DBTech\Security\Pub\Controller\Route->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('DBTech\\Security...', 'Index', 'json', Object(XF\Mvc\ParameterBag), 'forums', Object(DBTech\Security\Pub\Controller\Route), NULL)
#11 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#13 src/XF.php(328): XF\App->run()
#14 index.php(13): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
["url"] => string(38) "/index.php?dbtech-security/fingerprint"
["referrer"] => string(51) "/threads/help.12865/page-74"
["_GET"] => array(1) {
["dbtech-security/fingerprint"] => string(0) ""
}
["_POST"] => array(6) {
["fingerprint"] => string(32) "0fd7b83e6900b024954a3eaea73a6433"
["components"] => array(24) {
[0] => array(2) {
["key"] => string(10) "user_agent"
["value"] => string(130) "Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36 OPR/54.0.2952.64"
}
[1] => array(2) {
["key"] => string(8) "language"
["value"] => string(5) "en-US"
}
[2] => array(2) {
["key"] => string(11) "color_depth"
["value"] => string(2) "24"
}
[3] => array(2) {
["key"] => string(11) "pixel_ratio"
["value"] => string(1) "1"
}
[4] => array(2) {
["key"] => string(20) "hardware_concurrency"
["value"] => string(1) "4"
}
[5] => array(2) {
["key"] => string(10) "resolution"
["value"] => array(2) {
[0] => string(4) "1366"
[1] => string(3) "768"
}
}
[6] => array(2) {
["key"] => string(20) "available_resolution"
["value"] => array(2) {
[0] => string(4) "1366"
[1] => string(3) "728"
}
}
[7] => array(2) {
["key"] => string(15) "timezone_offset"
["value"] => string(4) "-360"
}
[8] => array(2) {
["key"] => string(15) "session_storage"
["value"] => string(1) "1"
}
[9] => array(2) {
["key"] => string(13) "local_storage"
["value"] => string(1) "1"
}
[10] => array(2) {
["key"] => string(10) "indexed_db"
["value"] => string(1) "1"
}
[11] => array(2) {
["key"] => string(13) "open_database"
["value"] => string(1) "1"
}
[12] => array(2) {
["key"] => string(9) "cpu_class"
["value"] => string(7) "unknown"
}
[13] => array(2) {
["key"] => string(18) "navigator_platform"
["value"] => string(5) "Win32"
}
[14] => array(2) {
["key"] => string(12) "do_not_track"
["value"] => string(7) "unknown"
}
[15] => array(2) {
["key"] => string(15) "regular_plugins"
["value"] => array(3) {
[0] => string(82) "Chromium PDF Plugin::Portable Document Format::application/x-google-chrome-pdf~pdf"
[1] => string(42) "Chromium PDF Viewer::::application/pdf~pdf"
[2] => string(66) "News feed handler::::application/atom+xml~,application/rss+xml~rss"
}
}
[16] => array(2) {
["key"] => string(6) "canvas"
["value"] => string(33859) "canvas winding:yes~canvas fp:data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAB9AAAADICAYAAACwGnoBAAAgAElEQVR4XuzdeZhdVZ3v//c+VZXKPJCQgRCGhBBkCmMQBAUnFG1nxLYVAjaD3dfptrcVu1tRbId7r1fEXyuDQhDbXyvdXmwVB2hBRSDIFOYEAoGEEEgCmaeqOvs+311nV05Vajin6lSlirwXTz2QOnuvtfbrnPDP53y/K2GQj5R0BHAoMAc4pPTvacB4YEzpZ2LpMdYCG0s/64DngcfLfxKSrfkjp6QjS3MfDuQ/44DhQKyb/8Sf49oYcX/8bOvw3y8DjwIP5z
}
[17] => array(2) {
["key"] => string(5) "webgl"
["value"] => string(7905) "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASwAAACWCAYAAABkW7XSAAAM80lEQVR4Xu2dXYgkVxXHT/XMIBJEQUSDBF1Qwj7ETxKEPFgj5CEoKARRQR+CgoLmIaAoKEy3+iBBIiioEEEfVERBRURFwRkVP2A1s8wsOzCzZDYZHTeJGM3GXZKNU3K7e+yanv6o7q6695x7f rangeMin:31~webgl fragment shader low int precision rangeMax:30"
}
[18] => array(2) {
["key"] => string(7) "adblock"
["value"] => string(5) "false"
}
[19] => array(2) {
["key"] => string(18) "has_lied_languages"
["value"] => string(5) "false"
}
[20] => array(2) {
["key"] => string(19) "has_lied_resolution"
["value"] => string(5) "false"
}
[21] => array(2) {
["key"] => string(11) "has_lied_os"
["value"] => string(5) "false"
}
[22] => array(2) {
["key"] => string(16) "has_lied_browser"
["value"] => string(5) "false"
}
[23] => array(2) {
["key"] => string(13) "touch_support"
["value"] => array(3) {
[0] => string(1) "0"
[1] => string(5) "false"
[2] => string(5) "false"
}
}
}
["_xfRequestUri"] => string(29) "/threads/help.12865/page-74"
["_xfWithData"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}