Project

General

Profile

Actions
Copy link

Bug #88487

closed

Upgrade step SeparateSysHistoryFromSysLogUpdate has problems with large amounts of data

Added by Stefan Berger almost 5 years ago. Updated about 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:
9
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

Also available in: Atom PDF