Bug #80734
closed
Upgrade Wizard: "Update the hash field of sys_refindex to exclude the sorting field" leads to an error
100%
Description
Hi,
I'm running a quite large installation and try to execute the task "Update the hash field of sys_refindex to exclude the sorting field" via the install tool. Each time it leads to the error shown in screenshot 2.
The "strange" thing is that the message shows a fatal error and afterwards it seems that the check for incompatible extensions is run.
Sorry that I cannot copy the message as text any more, because I tried to update the refindex via the console command "vendor/bin/typo3 referenceindex:update". Then I tried to rerun the upgrade wizard. Now I get a fatal error in the install tool similar to #80347
An exception occurred while executing 'UPDATE `sys_refindex` SET `hash` = ? WHERE `hash` = ?' with params ["1447553260b762fe2ae104b1ea9a08d0", "22a73f6f23fbe5bb5264b81390ca4f52"]: Duplicate entry '1447553260b762fe2ae104b1ea9a08d0' for key 'PRIMARY' Doctrine\DBAL\Exception\UniqueConstraintViolationException thrown in file [...]/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 66.
- TYPO3 version is 8.7.0
- php version is 7.0.17
Files
Updated by Thomas Hohn over 7 years ago
Hi Marcus
Can you check if you have double records in any of the tables that are in the sys_refindex table? Maybe it's the same as the ticket you are "relating" to?
Greetings
Thomas
Updated by Morton Jonuschat over 7 years ago
- Status changed from New to Rejected
This error indicates that the reference index is not healthy. Please make sure you execute all steps of the upgrade guide at https://docs.typo3.org/typo3cms/InstallationGuide/Upgrade/Index.html, in this case it seems to me the step https://docs.typo3.org/typo3cms/InstallationGuide/Upgrade/UpdateReferenceIndex/Index.html was not executed.
Updated by Marcus Schwemer over 7 years ago
Hi,
"partly" ACK ;-)
Yes, maybe the refindex was not clean.
But: Even if so, I find it confusing, if I run a update wizard for the refindex and then get a response about incompatible extensions, which resides at a complete different part of the install ...
IMHO it would be better, that just the php error message should be shown or better leave a hint for the user to update his refindex (with the cli command).
Updated by Morton Jonuschat over 7 years ago
- Status changed from Rejected to Accepted
- Assignee set to Morton Jonuschat
Hi Markus,
the fallback to check for broken extension can not be avoided, this is true for all exceptions in the install tool. But the Updater should not fail with an exception on this error and instead show a custom message of what failed.
I'll work on a fix.
Updated by Gerrit Code Review over 7 years ago
- Status changed from Accepted to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52399
Updated by Gerrit Code Review over 7 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52399
Updated by Gerrit Code Review over 7 years ago
Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/52686
Updated by Morton Jonuschat over 7 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 61bb768be84a061057df419aedd14e04df0f4f56.
Updated by 
