Not a bug MySQL query error [1062]: Duplicate entry '1597117-79' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217

rdn · Oct 15, 2019

Code:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '1597117-79' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Oct 15, 2019 at 4:00 AM
Stack trace
INSERT  INTO `xf_forum_watch` (`node_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) 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(1452): XF\Db\AbstractAdapter->insert('xf_forum_watch', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/ForumWatch.php(45): XF\Mvc\Entity\Entity->save()
#7 src/XF/Pub/Controller/Forum.php(942): XF\Repository\ForumWatch->setWatchState(Object(SV\ElasticSearchEssentials\XF\Entity\Forum), Object(Datio\AllowedEmails\XF\Entity\User), 'message', true, true)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Forum->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Watch', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(16) "/forums/79/watch"
  ["referrer"] => string(36) "https://domain.com/forums/79/watch"
  ["_GET"] => array(1) {
    ["/forums/79/watch"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["notify"] => string(7) "message"
    ["send_alert"] => string(1) "1"
    ["send_email"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}

Code:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '777446-250' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Oct 15, 2019 at 3:11 AM
Stack trace
INSERT  INTO `xf_forum_watch` (`node_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) 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(1452): XF\Db\AbstractAdapter->insert('xf_forum_watch', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/ForumWatch.php(45): XF\Mvc\Entity\Entity->save()
#7 src/XF/Pub/Controller/Forum.php(942): XF\Repository\ForumWatch->setWatchState(Object(SV\ElasticSearchEssentials\XF\Entity\Forum), Object(Datio\AllowedEmails\XF\Entity\User), 'thread', true, true)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Forum->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Watch', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(17) "/forums/250/watch"
  ["referrer"] => string(37) "https://domain.com/forums/250/watch"
  ["_GET"] => array(1) {
    ["/forums/250/watch"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["notify"] => string(6) "thread"
    ["send_alert"] => string(1) "1"
    ["send_email"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}

Code:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '777446-250' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Oct 15, 2019 at 3:11 AM
Stack trace
INSERT  INTO `xf_forum_watch` (`node_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) 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(1452): XF\Db\AbstractAdapter->insert('xf_forum_watch', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/ForumWatch.php(45): XF\Mvc\Entity\Entity->save()
#7 src/XF/Pub/Controller/Forum.php(942): XF\Repository\ForumWatch->setWatchState(Object(SV\ElasticSearchEssentials\XF\Entity\Forum), Object(Datio\AllowedEmails\XF\Entity\User), 'message', true, true)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Forum->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Watch', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(17) "/forums/250/watch"
  ["referrer"] => string(37) "https://domain.com/forums/250/watch"
  ["_GET"] => array(1) {
    ["/forums/250/watch"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["notify"] => string(7) "message"
    ["send_alert"] => string(1) "1"
    ["send_email"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}

Code:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '777446-134' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Oct 15, 2019 at 3:10 AM
Stack trace
INSERT  INTO `xf_forum_watch` (`node_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) 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(1452): XF\Db\AbstractAdapter->insert('xf_forum_watch', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Repository/ForumWatch.php(45): XF\Mvc\Entity\Entity->save()
#7 src/XF/Pub/Controller/Forum.php(942): XF\Repository\ForumWatch->setWatchState(Object(SV\ElasticSearchEssentials\XF\Entity\Forum), Object(Datio\AllowedEmails\XF\Entity\User), 'thread', true, true)
#8 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Forum->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'Watch', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#13 src/XF.php(390): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(17) "/forums/134/watch"
  ["referrer"] => string(37) "https://domain.com/forums/134/watch"
  ["_GET"] => array(1) {
    ["/forums/134/watch"] => string(0) ""
  }
  ["_POST"] => array(4) {
    ["notify"] => string(6) "thread"
    ["send_alert"] => string(1) "1"
    ["send_email"] => string(1) "1"
    ["_xfToken"] => string(8) "********"
  }
}

Kier · Nov 4, 2019

Can you provide some steps to reproduce, please?

rdn · Nov 4, 2019

It only happens that day and haven't appear anymore.
Can't reproduce also.

Chris D · Nov 4, 2019

It will just be a typical race condition. Usually safe to ignore, and probably doesn't require any significant changes.

Not a bug MySQL query error [1062]: Duplicate entry '1597117-79' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217

rdn

Well-known member

Kier

XenForo developer

rdn

Well-known member

Chris D

XenForo developer

Similar threads

We value your privacy