Error - Task 4943 crashed with unknown code 1 on restore

[Matth33]

Yo

Had a stroke when failing to resto Doli with this error : Error - Task 4943 crashed with unknown code 1

It's a SQL constraint that fail. If you search for it in SQL logs in the server you'll probably find this :

ERROR 6125 (HY000): Failed to add the foreign key constraint.
Missing unique key for constraint 'fk_b4d_bank_reconciliation'
in the referenced table 'dolibarr_c_banking4dolibarr_bank_account'

Had to go SSH my cloudron then :

# shell
sudo docker exec -it mysql /bin/bash -c 'MYSQL_PWD="$CLOUDRON_MYSQL_ROOT_PASSWORD" mysql -u root'

# then once connected in mysql :
SELECT CURRENT_USER();
SET GLOBAL restrict_fk_on_non_standard_key = OFF;
SHOW GLOBAL VARIABLES LIKE 'restrict_fk_on_non_standard_key';
# should return OFF

go back to cloudron UI and restore, then everything go smoothly.

After that go back to your mysql then put constraint on again :

SET GLOBAL restrict_fk_on_non_standard_key = ON;
SHOW GLOBAL VARIABLES LIKE 'restrict_fk_on_non_standard_key';
# should return ON

maybe it'll help someone one day...!

@staff could probably do something during the restore process ? It's common to have those error in dolibarr.

PS : note that the error comes from the external module Banking4Dolibarr, not dolibarr himself.

[nebulon]

That seems a bit rough to disable those checks just to import the dump. Doesn't this hint at a data inconsistency? But I am not familiar with what non standard keys are in mysql