http://forge.typo3.org/http://forge.typo3.org/themes/typo3_forge/favicon/favicon.png?17058661692017-04-18T13:02:44ZTYPO3 ForgeTYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3297492017-04-18T13:02:44ZSascha Egerer
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/journals/329749/diff?detail_id=278052">diff</a>)</li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3297592017-04-18T13:53:35ZThomas Hohnthomas@hohn.dk
<ul></ul><p>We actually ended up using <a class="external" href="https://github.com/NamelessCoder/asynchronous_reference_indexing">https://github.com/NamelessCoder/asynchronous_reference_indexing</a> instead since we faced issues like this too.</p> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3320392017-05-04T17:47:37ZBenni Mackbenni@typo3.org
<ul><li><strong>Target version</strong> changed from <i>8 LTS</i> to <i>next-patchlevel</i></li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3328512017-05-16T17:39:13ZSascha Egerer
<ul></ul><p>Thomas Hohn wrote:</p>
<blockquote>
<p>We actually ended up using <a class="external" href="https://github.com/NamelessCoder/asynchronous_reference_indexing">https://github.com/NamelessCoder/asynchronous_reference_indexing</a> instead since we faced issues like this too.</p>
</blockquote>
<p>This extension is not production ready. Looks like file references are not updated correctly.</p>
<p>The error does also occur if i try to update the reference index via the CLI tasks or in the backend db tools.</p> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3331732017-05-19T13:48:33ZOliver Haderoliver.hader@typo3.org
<ul></ul><p>Thx for the report! Sascha, could you please give a stack-track for both steps mentioned above? Thx in advance!</p> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3331872017-05-19T14:35:48ZSascha Egerer
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Accepted</i></li><li><strong>Assignee</strong> set to <i>Sascha Egerer</i></li></ul><p>I'll take care and post an update</p> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3349632017-06-12T12:55:05ZSascha Egerer
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-3 priority-lowest closed" href="/issues/80800">Bug #80800</a>: Too many records on sys_file_reference table breaks TYPO3 when saving IRRE records</i> added</li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3373962017-07-28T07:47:15ZAnu Bhuvanendran Nairanu93nair@gmail.com
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-3 priority-lowest closed" href="/issues/81993">Bug #81993</a>: 'Uncaught TYPO3 Exception' pops up when news records are localized</i> added</li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3388722017-08-29T08:53:59ZRicky Mathewricky.mk@pitsolutions.com
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-3 priority-lowest closed" href="/issues/82233">Bug #82233</a>: File Abstraction Layer: Update storage index (scheduler) failure due to query constraints.</i> added</li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3670232018-06-13T17:16:47ZThomas Rawielt.rawiel@lingner.com
<ul></ul><p>Sascha, here is the requested stack trace, <br />when running <br /><pre>./typo3cms cleanup:orphanrecords -vvv</pre> via CLI<br />(TYPO3 8.7.16)</p>
<pre>
[ Doctrine\DBAL\Exception\DriverException ]
An exception occurred while executing 'SELECT `uid` FROM `tx_dmdeveloperlog_domain_model_logentry` WHERE `uid` NOT IN (?, ###ABOUT 140000 Placeholders###, ?) ORDER BY `uid` ASC' with params [###LIST-OF-IDs###]:
Prepared statement contains too many placeholders
Exception trace:
#0 ()
/var/www/src/typo3_src-8.7.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
#1 Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
/var/www/src/typo3_src-8.7.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#2 Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
/var/www/src/typo3_src-8.7.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:855
#3 Doctrine\DBAL\Connection->executeQuery()
/var/www/src/typo3_src-8.7.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:206
#4 Doctrine\DBAL\Query\QueryBuilder->execute()
typo3/sysext/core/Classes/Database/Query/QueryBuilder.php:187
#5 TYPO3\CMS\Core\Database\Query\QueryBuilder->execute()
typo3/sysext/lowlevel/Classes/Command/OrphanRecordsCommand.php:109
#6 TYPO3\CMS\Lowlevel\Command\OrphanRecordsCommand->execute()
typo3conf/ext/typo3_console/Libraries/symfony-process.phar/vendor/symfony/console/Command/Command.php:252
#7 Symfony\Component\Console\Command\Command->run()
typo3conf/ext/typo3_console/Libraries/symfony-process.phar/vendor/symfony/console/Application.php:946
#8 Symfony\Component\Console\Application->doRunCommand()
typo3conf/ext/typo3_console/Libraries/symfony-process.phar/vendor/symfony/console/Application.php:248
#9 Symfony\Component\Console\Application->doRun()
typo3conf/ext/typo3_console/Libraries/symfony-process.phar/vendor/symfony/console/Application.php:148
#10 Symfony\Component\Console\Application->run()
typo3conf/ext/typo3_console/Classes/Console/Core/Kernel.php:162
#11 Helhum\Typo3Console\Core\Kernel->handle()
typo3conf/ext/typo3_console/Scripts/typo3-console.php:19
#12 {closure}()
typo3conf/ext/typo3_console/Scripts/typo3-console.php:21
#13 require()
typo3cms:18
Caused by:
[ Doctrine\DBAL\Driver\Mysqli\MysqliException ]
Prepared statement contains too many placeholders
Exception trace:
#0 ()
/var/www/src/typo3_src-8.7.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94
#1 Doctrine\DBAL\Driver\Mysqli\MysqliStatement->__construct()
/var/www/src/typo3_src-8.7.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliConnection.php:120
#2 Doctrine\DBAL\Driver\Mysqli\MysqliConnection->prepare()
/var/www/src/typo3_src-8.7.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:844
#3 Doctrine\DBAL\Connection->executeQuery()
/var/www/src/typo3_src-8.7.16/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:206
#4 Doctrine\DBAL\Query\QueryBuilder->execute()
typo3/sysext/core/Classes/Database/Query/QueryBuilder.php:187
#5 TYPO3\CMS\Core\Database\Query\QueryBuilder->execute()
typo3/sysext/lowlevel/Classes/Command/OrphanRecordsCommand.php:109
#6 TYPO3\CMS\Lowlevel\Command\OrphanRecordsCommand->execute()
typo3conf/ext/typo3_console/Libraries/symfony-process.phar/vendor/symfony/console/Command/Command.php:252
#7 Symfony\Component\Console\Command\Command->run()
typo3conf/ext/typo3_console/Libraries/symfony-process.phar/vendor/symfony/console/Application.php:946
#8 Symfony\Component\Console\Application->doRunCommand()
typo3conf/ext/typo3_console/Libraries/symfony-process.phar/vendor/symfony/console/Application.php:248
#9 Symfony\Component\Console\Application->doRun()
typo3conf/ext/typo3_console/Libraries/symfony-process.phar/vendor/symfony/console/Application.php:148
#10 Symfony\Component\Console\Application->run()
typo3conf/ext/typo3_console/Classes/Console/Core/Kernel.php:162
#11 Helhum\Typo3Console\Core\Kernel->handle()
typo3conf/ext/typo3_console/Scripts/typo3-console.php:19
#12 {closure}()
typo3conf/ext/typo3_console/Scripts/typo3-console.php:21
#13 require()
typo3cms:18
cleanup:orphanrecords [--dry-run]
</pre> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3670412018-06-13T21:05:23ZSascha Egerer
<ul></ul><p>Thomas Rawiel wrote:</p>
<blockquote>
<p>Sascha, here is the requested stack trace, <br />when running <br />[...] via CLI<br />(TYPO3 8.7.16)</p>
<p>[...]</p>
</blockquote>
<p>Will be handled in <a class="issue tracker-1 status-5 priority-4 priority-default closed child" title="Bug: OrphanRecordsCommand fails if list of ids is too long (Closed)" href="http://forge.typo3.org/issues/85257">#85257</a></p> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3704012018-08-09T17:00:59ZGleb Levitingleb.levitin@dkd.de
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-3 priority-lowest closed child" href="/issues/85795">Bug #85795</a>: Too many records on reference index updating break TYPO3</i> added</li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3704052018-08-09T17:01:38ZGleb Levitingleb.levitin@dkd.de
<ul><li><strong>Related to</strong> deleted (<i><a class="issue tracker-1 status-5 priority-3 priority-lowest closed child" href="/issues/85795">Bug #85795</a>: Too many records on reference index updating break TYPO3</i>)</li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3704202018-08-09T18:07:39ZGleb Levitingleb.levitin@dkd.de
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-5 priority-3 priority-lowest closed child" href="/issues/85795">Bug #85795</a>: Too many records on reference index updating break TYPO3</i> added</li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3704242018-08-09T18:19:30ZGleb Levitingleb.levitin@dkd.de
<ul><li><strong>Related to</strong> deleted (<i><a class="issue tracker-1 status-5 priority-3 priority-lowest closed child" href="/issues/85795">Bug #85795</a>: Too many records on reference index updating break TYPO3</i>)</li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3912962018-11-29T10:52:53ZDMK E-BUSINESS GmbHdev@dmk-ebusiness.de
<ul></ul><p>It would be great to see some progress. It's not a good sign that an enterprise CMS is not able to edit a category with several thousand referenced elements in the backend.</p> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=3983972019-04-17T23:41:03ZBenni Mackbenni@typo3.org
<ul><li><strong>Target version</strong> changed from <i>next-patchlevel</i> to <i>Candidate for patchlevel</i></li></ul> TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a pagehttp://forge.typo3.org/issues/80875?journal_id=4334412020-10-19T16:26:17ZAlexander Schnitzler
<ul><li><strong>Related to</strong> <i><a class="issue tracker-1 status-3 priority-4 priority-default closed" href="/issues/86859">Bug #86859</a>: Search with indexed_search plugin throws exception: Prepared statement contains too many placeholders </i> added</li></ul>