Bug #85795

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

Too many records on reference index updating break TYPO3

Added by Gleb Levitin about 1 year ago. Updated 3 months ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Start date:
2018-08-09
Due date:
% Done:

100%

TYPO3 Version:
9
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Do not use prepared statements for updating reference index

Associated revisions

Revision ca2f7c3e (diff)
Added by Gleb Levitin 10 months ago

[BUGFIX] Process large list of hashes in chunks updating reference index

The list of old hashes by cleaning up the reference index can
be very long. To avoid exceeding query limits like maximum number
of placeholder per query or the max allowed statement length these
large lists are split into chunks of safe length before processing.

Resolves: #85795
Releases: master, 8.7
Change-Id: Iaebc555fe791f9e41f336bcd30d5b6eb149ad4e9
Reviewed-on: https://review.typo3.org/57846
Reviewed-by: Markus Klein <>
Tested-by: TYPO3com <>
Reviewed-by: Guido Schmechel <>
Reviewed-by: Susanne Moog <>
Tested-by: Susanne Moog <>
Reviewed-by: Benni Mack <>
Tested-by: Benni Mack <>

Revision 82689e2d (diff)
Added by Benni Mack 10 months ago

[BUGFIX] Process large list of hashes in chunks updating reference index

The list of old hashes by cleaning up the reference index can
be very long. To avoid exceeding query limits like maximum number
of placeholder per query or the max allowed statement length these
large lists are split into chunks of safe length before processing.

Resolves: #85795
Releases: master, 8.7
Change-Id: Iaebc555fe791f9e41f336bcd30d5b6eb149ad4e9
Reviewed-on: https://review.typo3.org/58756
Tested-by: TYPO3com <>
Reviewed-by: Susanne Moog <>
Reviewed-by: Benni Mack <>
Tested-by: Benni Mack <>

History

#1 Updated by Gleb Levitin about 1 year ago

  • Parent task deleted (#80875)

#2 Updated by Gleb Levitin about 1 year ago

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

#3 Updated by Gleb Levitin about 1 year ago

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

#4 Updated by Gleb Levitin about 1 year ago

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

#5 Updated by Stephan GroƟberndt about 1 year ago

  • Status changed from In Progress to Needs Feedback

Could you please provide more information on how to reproduce the issue? Thanks!

#6 Updated by Gerrit Code Review about 1 year ago

  • Status changed from Needs Feedback 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/57846

#7 Updated by Gerrit Code Review about 1 year 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/57846

#8 Updated by Gerrit Code Review about 1 year ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/57846

#9 Updated by Gleb Levitin about 1 year ago

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

#10 Updated by Gleb Levitin about 1 year ago

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

#11 Updated by Gleb Levitin about 1 year ago

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

#12 Updated by Gleb Levitin about 1 year ago

  • Parent task set to #80875

#13 Updated by Gleb Levitin about 1 year ago

  • Assignee deleted (Gleb Levitin)

#14 Updated by Gleb Levitin about 1 year ago

  • Subject changed from Too many records on reference index updating breaks TYPO3 to Too many records on reference index updating break TYPO3

#15 Updated by Gleb Levitin about 1 year ago

  • Target version changed from next-patchlevel to 8.7.19

#16 Updated by Susanne Moog 12 months ago

  • Target version changed from 8.7.19 to Candidate for patchlevel

#17 Updated by Gerrit Code Review 10 months 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/58756

#18 Updated by Gleb Levitin 10 months ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100

#19 Updated by Benni Mack 3 months ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF