Confirmed xf_mg_album_watch: Race condition / DuplicateKeyException

[nocte]

Affected version

XFMG 2.3.11

Similar to this bug:

Fixed Thread 'xf_mg_media_watch: Race condition / DuplicateKeyException'

Aug 27, 2025

Just found this in my logs:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '573987-3509589' for key 'xf_mg_media_watch.PRIMARY' src/XF/Db/AbstractStatement.php:230
Generated by: *** 26.8.2025 at 13:00
Stack trace
INSERT  INTO `xf_mg_media_watch` (`media_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) VALUES (?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062...

• nocte
• Replies: 1
• Forum: Media Gallery resolved bugs

I found a few errors like this one from today in the logs:

XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '379930-508458' for key 'xf_mg_album_watch.PRIMARY' src/XF/Db/AbstractStatement.php:225
Generated by: *** 3.9.2026 at 22:13
Stack trace
INSERT  INTO `xf_mg_album_watch` (`album_id`, `user_id`, `notify_on`, `send_alert`, `send_email`) VALUES (?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1578): XF\Db\AbstractAdapter->insert('xf_mg_album_wat...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1306): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/XFMG/Repository/AlbumWatch.php(72): XF\Mvc\Entity\Entity->save()
#7 src/addons/XFMG/Pub/Controller/Album.php(580): XFMG\Repository\AlbumWatch->setWatchState(Object(***\***\XFMG\Entity\Album), Object(***\***\XF\Entity\User), 'watch', Array)
#8 src/XF/Mvc/Dispatcher.php(364): XFMG\Pub\Controller\Album->actionWatch(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(266): XF\Mvc\Dispatcher->dispatchClass('XFMG:Album', 'Watch', Object(XF\Mvc\RouteMatch), Object(***\***\XFMG\Pub\Controller\Album), NULL)
#10 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(***\***\XFMG\Pub\Controller\Album), NULL)
#11 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2830): XF\Mvc\Dispatcher->run()
#13 src/XF.php(850): XF\App->run()
#14 index.php(23): XF::runApp('XF\\Pub\\App')
#15 {main}
Request state
array(4) {
  ["url"] => string(40) "/media/albums/***.508458/watch"
  ["referrer"] => string(61) "https://www.forum.tld/media/albums/***.508458/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(6) {
    ["_xfToken"] => string(8) "********"
    ["notify_on"] => string(13) "media_comment"
    ["send_alert"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
    ["_xfWithData"] => string(1) "1"
    ["_xfRequestUri"] => string(35) "/media/albums/***.508458/"
  }
}