search

BlackbitDigitalCommerce / pimcore-data-director

Import Bundle for Pimcore
16 stars 3 forks source link

DataDirector created records in objects but not in _query and _store table #76

Open betterapp opened 1 year ago

betterapp commented 1 year ago

Hi.

We got a DataPort that import products.

Today I discovered that we got a issue. In objects table there are records without parent_id and other fields also with NULL value.

image

Strange is that there was no data for this objects in _query and _store data.

image

How is it possible ?

BlackbitDevs commented 1 year ago

Were there any errors recently during imports? Have fixed this in 3.3: The write operations are executed as bulk operations like INSERT INTO objects (field1, field2, ...) VALUES (...),(...),(...). This is what makes data director imports much faster than calling save() method for every object. In case of a non-retryable error (deadlock is for example a retryable error but duplicate key is not), the save transaction was not rolled back.

I also created 3.2.36 release because this is really a critical bug. 3.3 will get released tomorrow.