MigrateAuditFieldQuery failure on large datasets

Hey,

when I try to update ORO I ran into the problem that the migration MigrateAuditFieldQuery in https://github.com/orocrm/platform/blob/master/src/Oro/Bundle/DataAuditBundle/Migrations/Schema/v1_3/MigrateAuditFieldQuery.php fails on large datasets.

The problem seems to be that there is a kind of memory leak somewhere, because I assigned 4 GB RAM to my Vagrant Box and set the php-fpm memory-limit to -1, so this shouldn’t be a problem, but still the MigrateAuditFieldQuery dies after ~100k rows.

Any suggestions about that problem ?

Greetings from Germany!

Topic

[Dima SorokaKeymaster]

Hi Kevin

What is you data audit table size?

[Kevin MauelParticipant]

Hey Dima,

it’s about 1,5 million rows, which results at the moment in 859.7 MiB according to MySQL Workbench.

[Dima SorokaKeymaster]

Thanks, let us try to reproduce this issue.

[Kevin MauelParticipant]

I’m looking forward to your results according this, because it actually blocks our ORO Update :)

[Author]

Replies