Bug Server error logs

Status
Not open for further replies.

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"
  }
}
 
Hello @Nirjonadda,

We hope your ticket regarding DragonByte Security has been addressed to your satisfaction. This ticket has now been closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.
 
Status
Not open for further replies.

DragonByte Security

XenForo 1.5.3+ XenForo 2.0.x XenForo 2.1.x XenForo 2.2.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
2,177
Customer rating
5.00 star(s) 1 ratings
Back
Top