Bug #86491
Updated by Sybille Peters about 6 years ago
Occasionally running into this error on an installation with indexed_search. After reloading the page, the error disappeared. The error code in the frontend was shown instead of the indexed_search plugin.
<pre>
Mon, 01 Oct 2018 09:37:38 +0200 [ALERT] request="0f377e1561597" component="TYPO3.CMS.Frontend.ContentObject.Exception.ProductionExceptionHandler": Oops, an error occurred! Code: 20181001093733ffa01a02 - {"exception":"Doctrine\\DBAL\\Driver\\Mysqli\\MysqliException: Duplicate entry 'aa45edde44b23b3e236fb700c43dab76' for key 'PRIMARY' in \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/Mysqli\/MysqliStatement.php:165
Stack trace:
#0 \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/Mysqli\/MysqliStatement.php:165\nStack trace:\n#0 \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(1008): Doctrine\\DBAL\\Driver\\Mysqli\\MysqliStatement->execute(Array)
#1 Doctrine\\DBAL\\Driver\\Mysqli\\MysqliStatement->execute(Array)\n#1 \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(714): Doctrine\\DBAL\\Connection->executeUpdate('INSERT INTO `ca...', Array, Array)
#2 Array)\n#2 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/core\/Classes\/Database\/Connection.php(208): Doctrine\\DBAL\\Connection->insert('`cache_treelist...', Array, Array)
#3 Array)\n#3 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/ContentObjectRenderer.php(6984): TYPO3\\CMS\\Core\\Database\\Connection->insert('cache_treelist', Array)
#4 Array)\n#4 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/indexed_search\/Classes\/Domain\/Repository\/IndexSearchRepository.php(1064): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->getTreeList(10, 9999)
#5 9999)\n#5 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/indexed_search\/Classes\/Domain\/Repository\/IndexSearchRepository.php(322): TYPO3\\CMS\\IndexedSearch\\Domain\\Repository\\IndexSearchRepository->execFinalQuery('4109082,1060002...', -1)
#6 -1)\n#6 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/indexed_search\/Classes\/Domain\/Repository\/IndexSearchRepository.php(227): TYPO3\\CMS\\IndexedSearch\\Domain\\Repository\\IndexSearchRepository->getResultRows_SQLpointer(Array, -1)
#7 -1)\n#7 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/indexed_search\/Classes\/Controller\/SearchController.php(276): TYPO3\\CMS\\IndexedSearch\\Domain\\Repository\\IndexSearchRepository->doSearch(Array, -1)
#8 -1)\n#8 [internal function]: TYPO3\\CMS\\IndexedSearch\\Controller\\SearchController->searchAction(Array)
...
Next TYPO3\\CMS\\IndexedSearch\\Controller\\SearchController->searchAction(Array)\n#9 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Mvc\/Controller\/ActionController.php(316): call_user_func_array(Array, Array)\n#10 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Mvc\/Controller\/ActionController.php(176): TYPO3\\CMS\\Extbase\\Mvc\\Controller\\ActionController->callActionMethod()\n#11 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Mvc\/Dispatcher.php(85): TYPO3\\CMS\\Extbase\\Mvc\\Controller\\ActionController->processRequest(Object(TYPO3\\CMS\\Extbase\\Mvc\\Web\\Request), Object(TYPO3\\CMS\\Extbase\\Mvc\\Web\\Response))\n#12 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Mvc\/Web\/FrontendRequestHandler.php(91): TYPO3\\CMS\\Extbase\\Mvc\\Dispatcher->dispatch(Object(TYPO3\\CMS\\Extbase\\Mvc\\Web\\Request), Object(TYPO3\\CMS\\Extbase\\Mvc\\Web\\Response))\n#13 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Core\/Bootstrap.php(199): TYPO3\\CMS\\Extbase\\Mvc\\Web\\FrontendRequestHandler->handleRequest()\n#14 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Core\/Bootstrap.php(186): TYPO3\\CMS\\Extbase\\Core\\Bootstrap->handleRequest()\n#15 [internal function]: TYPO3\\CMS\\Extbase\\Core\\Bootstrap->run('', Array)\n#16 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/ContentObjectRenderer.php(6341): call_user_func_array(Array, Array)\n#17 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/UserContentObject.php(41): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->callUserFunction('TYPO3\\\\CMS\\\\Extba...', Array, '')\n#18 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/ContentObjectRenderer.php(820): TYPO3\\CMS\\Frontend\\ContentObject\\UserContentObject->render(Array)\n#19 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/ContentObjectRenderer.php(736): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->render(Object(TYPO3\\CMS\\Frontend\\ContentObject\\UserContentObject), Array)\n#20 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Controller\/TypoScriptFrontendController.php(3528): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->cObjGetSingle('USER', Array)\n#21 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Controller\/TypoScriptFrontendController.php(3490): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->INTincScript_process(Array)\n#22 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Controller\/TypoScriptFrontendController.php(3457): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent()\n#23 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Http\/RequestHandler.php(226): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->INTincScript()\n#24 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/core\/Classes\/Core\/Bootstrap.php(316): TYPO3\\CMS\\Frontend\\Http\\RequestHandler->handleRequest(Object(TYPO3\\CMS\\Core\\Http\\ServerRequest))\n#25 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Http\/Application.php(79): TYPO3\\CMS\\Core\\Core\\Bootstrap->handleRequest(Object(TYPO3\\CMS\\Core\\Http\\ServerRequest))\n#26 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Resources\/Private\/Php\/frontend.php(23): TYPO3\\CMS\\Frontend\\Http\\Application->run()\n#27 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Resources\/Private\/Php\/frontend.php(24): {closure}()\n#28 \/home\/public_html\/_sources\/typo3_src-8.7.19\/index.php(3): require('\/home\/p...')\n#29 {main}\n\nNext Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO `cache_treelist` (`md5hash`, `pid`, `treelist`, `tstamp`) VALUES (?, ?, ?, ?)' with params [\"aa45edde44b23b3e236fb700c43dab76\", 10, \"39,38,37,36,35,34,33,32,31,30,13,48,49,50,4159,4160,47,63,134,135,54,56,57,59,61,62,136,137,138,139,141,68,65,64,67,66,4161,96,107,124,108,53,109,110,116,117,123,118,119,120,4164,126,4163,17,125,4162,127,4135,4137,82,83,85,90,88,87,86,89,4153,4168,3962,3961,3960,3959,3958,4147,4148,4149,4140,4141,4144,4143,4142,3969,3966,3965,3964,4138,3978,3977,3976,3975,3974,3990,3989,3982,3981,3997,3995,3994,4003,4002,4001,4004,3999,3991,3979,3970,3963,4139,4145,3956,3955,3954,4167,4029,4028,4027,4026,4025,4024,4023,4022,4021,4020,4019,4018,4017,4016,4015,4014,4013,4012,4011,4033,4032,4036,4038,4042,4041,4044,4046,4045,4043,4040,4039,4037,4035,4049,4051,4056,4055,4054,4053,4052,4050,4048,4061,4060,4059,4069,4068,4067,4066,4065,4064,4063,4072,4071,4070,4062,4058,4078,4077,4076,4075,4083,4082,4081,4080,4087,4086,4096,4095,4094,4093,4092,4091,4090,4089,4088,4085,4104,4103,4102,4101,4100,4099,4098,4109,4108,4107,4111,4114,4113,4116,4125,4124,4123,4122,4121,4120,4119,4118,4117,4115,4112,4110,4106,4105,4097,4084,4079,4074,4073,4057,4047,4034,4030,4010,4009,4008,4007,3953,114,112,115,111,4136,4129,128,129,130,131,132,2373,4134,4170,24,25,26,27,28,74,75,121,93,4128,80,94,95,72,73,81,76,79,92,15,4,18,5,6,7,8,9,20,19,16,21,22,23,42,43,45,46,60,4157,4158,14,29,51,4130,4150,4131,4132,4133,40,41,12,11,10\", 1538379453]:
Duplicate 1538379453]:\n\nDuplicate entry 'aa45edde44b23b3e236fb700c43dab76' for key 'PRIMARY' in \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php:66
Stack \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php:66\nStack trace:\n#0 \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(128): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\Mysqli\\MysqliException))
#1 Object(Doctrine\\DBAL\\Driver\\Mysqli\\MysqliException))\n#1 \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(1015): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\Mysqli\\Driver), Object(Doctrine\\DBAL\\Driver\\Mysqli\\MysqliException), 'INSERT INTO `ca...', Array)
#2 Array)\n#2 \/home\/public_html\/_sources\/typo3_src-8.7.19\/vendor\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php(714): Doctrine\\DBAL\\Connection->executeUpdate('INSERT INTO `ca...', Array, Array)
#3 Array)\n#3 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/core\/Classes\/Database\/Connection.php(208): Doctrine\\DBAL\\Connection->insert('`cache_treelist...', Array, Array)
#4 Array)\n#4 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/ContentObjectRenderer.php(6984): TYPO3\\CMS\\Core\\Database\\Connection->insert('cache_treelist', Array)
#5 Array)\n#5 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/indexed_search\/Classes\/Domain\/Repository\/IndexSearchRepository.php(1064): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->getTreeList(10, 9999)
#6 9999)\n#6 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/indexed_search\/Classes\/Domain\/Repository\/IndexSearchRepository.php(322): TYPO3\\CMS\\IndexedSearch\\Domain\\Repository\\IndexSearchRepository->execFinalQuery('4109082,1060002...', -1)
#7 -1)\n#7 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/indexed_search\/Classes\/Domain\/Repository\/IndexSearchRepository.php(227): TYPO3\\CMS\\IndexedSearch\\Domain\\Repository\\IndexSearchRepository->getResultRows_SQLpointer(Array, -1)
#8 -1)\n#8 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/indexed_search\/Classes\/Controller\/SearchController.php(276): TYPO3\\CMS\\IndexedSearch\\Domain\\Repository\\IndexSearchRepository->doSearch(Array, -1)
#9 -1)\n#9 [internal function]: TYPO3\\CMS\\IndexedSearch\\Controller\\SearchController->searchAction(Array)
... TYPO3\\CMS\\IndexedSearch\\Controller\\SearchController->searchAction(Array)\n#10 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Mvc\/Controller\/ActionController.php(316): call_user_func_array(Array, Array)\n#11 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Mvc\/Controller\/ActionController.php(176): TYPO3\\CMS\\Extbase\\Mvc\\Controller\\ActionController->callActionMethod()\n#12 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Mvc\/Dispatcher.php(85): TYPO3\\CMS\\Extbase\\Mvc\\Controller\\ActionController->processRequest(Object(TYPO3\\CMS\\Extbase\\Mvc\\Web\\Request), Object(TYPO3\\CMS\\Extbase\\Mvc\\Web\\Response))\n#13 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Mvc\/Web\/FrontendRequestHandler.php(91): TYPO3\\CMS\\Extbase\\Mvc\\Dispatcher->dispatch(Object(TYPO3\\CMS\\Extbase\\Mvc\\Web\\Request), Object(TYPO3\\CMS\\Extbase\\Mvc\\Web\\Response))\n#14 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Core\/Bootstrap.php(199): TYPO3\\CMS\\Extbase\\Mvc\\Web\\FrontendRequestHandler->handleRequest()\n#15 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/extbase\/Classes\/Core\/Bootstrap.php(186): TYPO3\\CMS\\Extbase\\Core\\Bootstrap->handleRequest()\n#16 [internal function]: TYPO3\\CMS\\Extbase\\Core\\Bootstrap->run('', Array)\n#17 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/ContentObjectRenderer.php(6341): call_user_func_array(Array, Array)\n#18 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/UserContentObject.php(41): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->callUserFunction('TYPO3\\\\CMS\\\\Extba...', Array, '')\n#19 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/ContentObjectRenderer.php(820): TYPO3\\CMS\\Frontend\\ContentObject\\UserContentObject->render(Array)\n#20 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/ContentObject\/ContentObjectRenderer.php(736): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->render(Object(TYPO3\\CMS\\Frontend\\ContentObject\\UserContentObject), Array)\n#21 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Controller\/TypoScriptFrontendController.php(3528): TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer->cObjGetSingle('USER', Array)\n#22 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Controller\/TypoScriptFrontendController.php(3490): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->INTincScript_process(Array)\n#23 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Controller\/TypoScriptFrontendController.php(3457): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent()\n#24 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Http\/RequestHandler.php(226): TYPO3\\CMS\\Frontend\\Controller\\TypoScriptFrontendController->INTincScript()\n#25 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/core\/Classes\/Core\/Bootstrap.php(316): TYPO3\\CMS\\Frontend\\Http\\RequestHandler->handleRequest(Object(TYPO3\\CMS\\Core\\Http\\ServerRequest))\n#26 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Classes\/Http\/Application.php(79): TYPO3\\CMS\\Core\\Core\\Bootstrap->handleRequest(Object(TYPO3\\CMS\\Core\\Http\\ServerRequest))\n#27 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Resources\/Private\/Php\/frontend.php(23): TYPO3\\CMS\\Frontend\\Http\\Application->run()\n#28 \/home\/public_html\/_sources\/typo3_src-8.7.19\/typo3\/sysext\/frontend\/Resources\/Private\/Php\/frontend.php(24): {closure}()\n#29 \/home\/public_html\/_sources\/typo3_src-8.7.19\/index.php(3): require('\/home\/p...')\n#30 {main}"}
</pre>