Bug MySQL query error [1062]: Duplicate entry '05fd116c58a3f48cc2689fa322f58b0f-8' for key 'xf_dbtech_security_fingerprint_log.fingerprint_user_id'

Status
Not open for further replies.

Nirjonadda

Customer
Server error log:

Code:
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '05fd116c58a3f48cc2689fa322f58b0f-8' for key 'xf_dbtech_security_fingerprint_log.fingerprint_user_id' src/XF/Db/AbstractStatement.php:228

Generated by: arn43 Oct 15, 2020 at 11:02 AM

Stack trace

INSERT  INTO `xf_dbtech_security_fingerprint_log` (`user_id`, `fingerprint`, `ipaddress`, `components`, `fingerprint_log_id`, `dateline`) VALUES (?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1510): XF\Db\AbstractAdapter->insert('xf_dbtech_secur...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1242): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/DBTech/Security/Watcher/NewStaffFingerprint.php(72): XF\Mvc\Entity\Entity->save()
#7 src/addons/DBTech/Security/Watcher/AbstractHandler.php(190): DBTech\Security\Watcher\NewStaffFingerprint->preCheck(Array, Object(Datio\AllowedEmails\XF\Entity\User))
#8 src/addons/DBTech/Security/Pub/Controller/Fingerprint.php(36): DBTech\Security\Watcher\AbstractHandler->trigger(Array, Object(Datio\AllowedEmails\XF\Entity\User))
#9 src/XF/Mvc/Dispatcher.php(350): DBTech\Security\Pub\Controller\Fingerprint->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('DBTech\\Security...', 'Index', Object(XF\Mvc\RouteMatch), Object(DBTech\Security\Pub\Controller\Fingerprint), NULL)
#11 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(DBTech\Security\Pub\Controller\Fingerprint), NULL)
#12 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#14 src/XF.php(465): XF\App->run()
#15 index.php(20): XF::runApp('XF\\Pub\\App')
#16 {main}

Request state

array(4) {
  ["url"] => string(38) "/index.php?dbtech-security/fingerprint"
  ["referrer"] => string(46) "/threads/68839/page-3671"
  ["_GET"] => array(1) {
    ["dbtech-security/fingerprint"] => string(0) ""
  }
  ["_POST"] => array(6) {
    ["fingerprint"] => string(32) "05fd116c58a3f48cc2689fa322f58b0f"
    ["components"] => array(23) {
      [0] => array(2) {
        ["key"] => string(10) "user_agent"
        ["value"] => string(101) "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.75 Safari/537.36"
      }
      [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(13) "device_memory"
        ["value"] => string(1) "4"
      }
      [4] => array(2) {
        ["key"] => string(20) "hardware_concurrency"
        ["value"] => string(1) "2"
      }
      [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(15) "regular_plugins"
        ["value"] => array(3) {
          [0] => string(80) "Chrome PDF Plugin::Portable Document Format::application/x-google-chrome-pdf~pdf"
          [1] => string(40) "Chrome PDF Viewer::::application/pdf~pdf"
          [2] => string(57) "Native Client::::application/x-nacl~,application/x-pnacl~"
        }
      }
      [15] => array(2) {
        ["key"] => string(6) "canvas"
        ["value"] => string(32867) "canvas winding:yes~canvas fp:data:image/png;base64,"
      }
      [16] => array(2) {
        ["key"] => string(12) "webgl_vendor"
        ["value"] => string(74) "Google Inc.~ANGLE (Intel(R) G41 Express Chipset Direct3D9Ex vs_3_0 ps_3_0)"
      }
      [17] => array(2) {
        ["key"] => string(7) "adblock"
        ["value"] => string(5) "false"
      }
      [18] => array(2) {
        ["key"] => string(18) "has_lied_languages"
        ["value"] => string(5) "false"
      }
      [19] => array(2) {
        ["key"] => string(19) "has_lied_resolution"
        ["value"] => string(5) "false"
      }
      [20] => array(2) {
        ["key"] => string(11) "has_lied_os"
        ["value"] => string(5) "false"
      }
      [21] => array(2) {
        ["key"] => string(16) "has_lied_browser"
        ["value"] => string(5) "false"
      }
      [22] => array(2) {
        ["key"] => string(13) "touch_support"
        ["value"] => array(3) {
          [0] => string(1) "0"
          [1] => string(5) "false"
          [2] => string(5) "false"
        }
      }
    }
    ["_xfRequestUri"] => string(24) "/threads/68839/page-3671"
    ["_xfWithData"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
    ["_xfResponseType"] => string(4) "json"
  }
}
 
Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future release (4.5.1).

Change log:
Fix: Fixed a race condition where the same fingerprint could be inserted twice, generating a server error

 
Hello @Nirjonadda,

We hope your ticket regarding DragonByte Security has been addressed to your satisfaction. This ticket has now been scheduled to be 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.
 
Hello @Nirjonadda,

As we have not heard back from you, your ticket regarding DragonByte Security has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

If you have time, please leave a review on XenForo.com's Resource Manager.

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,183
Customer rating
5.00 star(s) 1 ratings
Back
Top