Bug #81993

'Uncaught TYPO3 Exception' pops up when news records are localized

Added by Anu Bhuvanendran Nair about 2 years ago. Updated over 1 year ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
-
Target version:
-
Start date:
2017-07-28
Due date:
% Done:

0%

TYPO3 Version:
8
PHP Version:
7.1
Tags:
pdo, placeholders, tx_news, localization
Complexity:
medium
Is Regression:
Sprint Focus:
Remote Sprint

Description

I recently installed tx_news v6.0.0 in my TYPO3 8.7.3 system. When 'Use content element relation' is checked in plugin settings, I tried to localize a news record.
My system contains around 4,50,000 content elements. Suddenly backend breaks with an exception

Uncaught TYPO3 Exception: An exception occurred while executing 'SELECT uid FROM tt_content WHERE (pid= ?) AND (uid IN (?, ?, ?, ?, ### HERE ARE AROUND 4,50,000 PLACEHOLDERS!### , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ASC' with params [-1, 6877, ... ###HERE ARE AROUND 4,50,000 IDS!###, 0] Too many placeholders

When I unchecked the option, every thing works perfectly. What if I want to use inline content elements in news record with this much of content elements in the system.

Way to reproduce :-

1. Make sure TYPO3 system has a huge number of content elements like mentioned.
2. Install tx_news v6.0.0
3. Create a news record. Check whether the entry has a tab 'Content elements' in it when selected.
4. Try to localize this record.

Bug #81555 is similar and patch explained in it solves this issue. It manages the solution by breaking up total placeholders in the prepared statement into chunks of placeholders (around 65,000) and processes it. Unfortunately in a system with a huge number of content elements, it takes too much time to process a single localization.


Related issues

Related to TYPO3 Core - Bug #81555: Do not use prepared statements for reference index queries Closed 2017-06-12
Related to TYPO3 Core - Bug #80875: Multiple problems with relation handler if too many records exist on a page Accepted 2017-06-12

History

#1 Updated by Anu Bhuvanendran Nair about 2 years ago

  • Related to Bug #81555: Do not use prepared statements for reference index queries added

#2 Updated by Anu Bhuvanendran Nair about 2 years ago

  • Related to Bug #80875: Multiple problems with relation handler if too many records exist on a page added

#3 Updated by Morton Jonuschat almost 2 years ago

  • Category deleted (Database API (Doctrine DBAL))
  • Status changed from New to Needs Feedback
  • Target version deleted (next-patchlevel)

Can you provide a full stack trace when this error occurs, tracking down the source of this problem is much easier with detailed information.

#4 Updated by Riccardo De Contardi over 1 year ago

  • Status changed from Needs Feedback to Closed
  • Assignee deleted (Anu Bhuvanendran Nair)

90 days without feedback -> closing it.

If you think that this is the wrong decision or experience the issue again or have more information about how to reproduce it, please reopen it or open a new issue with a reference to this one. Thank you.

Also available in: Atom PDF