Bug #88487: Upgrade step SeparateSysHistoryFromSysLogUpdate has problems with large amounts of data - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #88487

closed

Upgrade step SeparateSysHistoryFromSysLogUpdate has problems with large amounts of data

Added by Stefan Berger over 5 years ago. Updated over 4 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Category:

Install Tool

Target version:

next-patchlevel

Start date:

2019-06-04

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

7.2

Tags:

Complexity:

Is Regression:

Sprint Focus:

Description

Hi,

in some cases when the sys_history or sys_log tables contain large amounts of data, in our case about 600 MB and 250 MB, the SeparateSysHistoryFromSysLogUpdate update step silently exits.

Deeper debuggings lead us to the point in \Doctrine\DBAL\Driver\Mysqli\MysqliStatement::execute, where will be called the $this->_stmt->store_result(); method.

So our fix to handle this is to do the jobs in smaller blocks. @see attached patch file.

Thanks for fixing.

Files

bugfix-SeparateSysHistoryFromSysLogUpdate.patch (4.19 KB) bugfix-SeparateSysHistoryFromSysLogUpdate.patch

Stefan Berger, 2019-06-04 14:58

Actions

Copy link

Updated by Gerrit Code Review about 5 years ago

Status changed from New 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/c/Packages/TYPO3.CMS/+/61654

Actions

Copy link

Updated by Gerrit Code Review about 5 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/c/Packages/TYPO3.CMS/+/61654

Actions

Copy link

Updated by Gerrit Code Review about 5 years 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/c/Packages/TYPO3.CMS/+/61654

Actions

Copy link

Updated by Gerrit Code Review about 5 years ago

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

Actions

Copy link

Updated by Gerrit Code Review about 5 years ago

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

Actions

Copy link

Updated by Gerrit Code Review over 4 years ago

Patch set 1 for branch 9.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/63577

Actions

Copy link