search

BlackbitDigitalCommerce / pimcore-data-director

Import Bundle for Pimcore
16 stars 3 forks source link

Cancel import does not work. #33

Open betterapp opened 2 years ago

betterapp commented 2 years ago

I have many errors like this in log:

Next Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO objects (o_key, o_path) VALUES (?, ?)' with params ["-Produktkatalog-Serier-Other suppliers-1000082 - SINDRE", "\/"]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '/--Produktkatalog-Serier-Other suppliers-1000082 - SINDRE' for key 'objects.fullpath' in /mnt/bohus-pimcore-live-volume/www/pim.bohus.no/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:74 Stack trace:

When I want cancel this import (with admin interface) - it is not working.

How can I force cancelation for running import ?

BlackbitDevs commented 2 years ago

As the import is executed in a separate PHP process, clicking the Cancel icon only sets a flag in the database. This flag gets checked after a batch of raw data items if processed. It could be that because of the exceptions we do not get to this point. Do you see the string Unable to import data: in your log?

betterapp commented 2 years ago

Yes

[ERROR] Unable to import data: PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction