Nirjonadda
Customer
I am getting this Server error log.
Code:
XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:212
Generated by: Unknown account Dec 24, 2018 at 11:27 PM
Stack trace
INSERT IGNORE INTO xf_dbtech_security_fingerprintlog
(`fingerprint`, `userid`, `dateline`, `ipaddress`, `components`)
VALUES
------------
#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(1934): XF\Mvc\Dispatcher->run()
#13 src/XF.php(333): 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(37) "/threads/43995/"
["_GET"] => array(1) {
["dbtech-security/fingerprint"] => string(0) ""
}
["_POST"] => array(6) {
["fingerprint"] => string(32) "02f8951eb73ae54a521ec32926c079a2"
["components"] => array(19) {
[0] => array(2) {
["key"] => string(10) "user_agent"
["value"] => string(89) "Opera/9.80 (SpreadTrum; Opera Mini/4.4.33961/127.81; U; en) Presto/2.12.423 Version/12.16"
}
[1] => array(2) {
["key"] => string(8) "language"
["value"] => string(2) "en"
}
[2] => array(2) {
["key"] => string(11) "color_depth"
["value"] => string(1) "4"
}
[3] => array(2) {
["key"] => string(11) "pixel_ratio"
["value"] => string(1) "1"
}
[4] => array(2) {
["key"] => string(20) "hardware_concurrency"
["value"] => string(7) "unknown"
}
[5] => array(2) {
["key"] => string(10) "resolution"
["value"] => array(2) {
[0] => string(3) "255"
[1] => string(3) "230"
}
}
[6] => array(2) {
["key"] => string(20) "available_resolution"
["value"] => array(2) {
[0] => string(3) "255"
[1] => string(3) "230"
}
}
[7] => array(2) {
["key"] => string(15) "timezone_offset"
["value"] => string(4) "-360"
}
[8] => array(2) {
["key"] => string(9) "cpu_class"
["value"] => string(7) "unknown"
}
[9] => array(2) {
["key"] => string(18) "navigator_platform"
["value"] => string(21) "Pike v8.0 release 610"
}
[10] => array(2) {
["key"] => string(12) "do_not_track"
["value"] => string(7) "unknown"
}
[11] => array(1) {
["key"] => string(15) "regular_plugins"
}
[12] => array(2) {
["key"] => string(6) "canvas"
["value"] => string(5694) "canvas winding:no~canvas
[13] => array(2) {
["key"] => string(7) "adblock"
["value"] => string(5) "false"
}
[14] => array(2) {
["key"] => string(18) "has_lied_languages"
["value"] => string(5) "false"
}
[15] => array(2) {
["key"] => string(19) "has_lied_resolution"
["value"] => string(5) "false"
}
[16] => array(2) {
["key"] => string(11) "has_lied_os"
["value"] => string(4) "true"
}
[17] => array(2) {
["key"] => string(16) "has_lied_browser"
["value"] => string(4) "true"
}
[18] => array(2) {
["key"] => string(13) "touch_support"
["value"] => array(3) {
[0] => string(1) "0"
[1] => string(5) "false"
[2] => string(5) "false"
}
}
}
["_xfRequestUri"] => string(15) "/threads/43995/"
["_xfWithData"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
}
}