Replacing/updating products errors and failures.

When trying to re-import products (after they’ve successfully been imported and exist fine) I receive:

PHP

consumer.ERROR: Consuming interrupted by exception. "Transaction commit failed because the transaction has been marked for rollback only." consumer.DEBUG: Execution was interrupted and message was rejected.

1 2	consumer.ERROR: Consuming interrupted by exception. "Transaction commit failed because the transaction has been marked for rollback only." consumer.DEBUG: Execution was interrupted and message was rejected.

in both the application and consumer logs, along with highly descriptive debug lines…
Eventually the consumers stop operating and the import never successfully completes, no email is generated to the admin showing successful/error logs either..

To troubleshoot, manual rm -rf var/cache/*, rm /tmp/*.csv, rm var/logs/*, rm /var/log/supervisor/* and a re-import of a single item was attempted… no logs or consumer activity at all, just a copy of the uploaded .csv in /tmp …

All of the attempted products have already successfully imported and validate and exist in both backoffice and storefront.

I’d like to be doing this routinely as to update any gaps or new products that may be added into the initial library.
All searching points towards DBAL/doctrine not handling nested transactions fully…
Any thoughts or similar experience?

• This topic was modified 4 years, 6 months ago by  chris.
• This topic was modified 4 years, 6 months ago by  chris.
• This topic was modified 4 years, 6 months ago by  chris.
• This topic was modified 4 years, 6 months ago by  chris.

Topic

[Andrey YatsenkoModerator]

Hi Chris,

This error usually means that validation rules out of sync with the database constraints, and you are trying to save invalid data.

Please, check the query log for the errors to add validation rules for the exceptional case and fix the imported data or update the database constraints to allow the imported data.

• This reply was modified 4 years, 5 months ago by  Andrey Yatsenko.

[Author]

Replies