#106579"Prepared statement contains too many placeholders" on reference index update
Description
I ran into a Doctrine\DBAL\Exception\DriverException “An exception occurred while executing a query: Prepared statement contains too many placeholders” while updating an existing project. It happened on saving a new data set leaving the system unmaintainable.
The cause was that the reference index was not up-to-date and an attempt was made to update it when the data record was saved. However, as > 3000 entries were to be added for a single record, the method TYPO3\CMS\Core\Database\Connection::bulkInsert() failed.
This type of error occurs relatively frequently, as a search shows: https://forge.typo3.org/projects/typo3cms-core/search?utf8=%E2%9C%93&scope=subprojects&issues=1&q=Prepared+statement+contains+too+many+placeholders
Since the number of permitted prepared statements differs depending on the database used, I believe that the request should be split centrally and not be handled by each individual call itself.
Reviews 2
Related issues 2
History 49
-
Gerrit Code Review pushed patch set 1 for main to change 89144 status
NewUnder Review <span data-processor="relativetime" data-value="2025-04-16T12:47:48+00:00" > 04/16/25, 12:47 </span> -
Gerrit Code Review pushed patch set 2 for main to change 89144 <span data-processor="relativetime" data-value="2025-04-16T17:07:28+00:00" > 04/16/25, 17:07 </span>
-
Gerrit Code Review pushed patch set 3 for main to change 89144 <span data-processor="relativetime" data-value="2025-04-16T17:43:16+00:00" > 04/16/25, 17:43 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 89144 <span data-processor="relativetime" data-value="2025-04-16T18:07:15+00:00" > 04/16/25, 18:07 </span>
-
Garvin Hicking changed Related to #106566 <span data-processor="relativetime" data-value="2025-04-16T18:08:23+00:00" > 04/16/25, 18:08 </span>
-
Gerrit Code Review pushed patch set 1 for 13.4 to change 89147 <span data-processor="relativetime" data-value="2025-04-16T19:40:21+00:00" > 04/16/25, 19:40 </span>
-
Oliver Heins commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2025-04-16T20:05:10+00:00" > 04/16/25, 20:05 </span> -
Stefan Bürk changed Related to #106591 <span data-processor="relativetime" data-value="2025-04-21T12:40:57+00:00" > 04/21/25, 12:40 </span>
-
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2025-12-02T14:21:16+00:00" > 12/02/25, 14:21 </span>
Applied in changeset commit:23d2006be0ef3fe4f770bcedb336db65eeafc90d.