sql tx errors during bulk import #2

New Issue

dave · 2020-11-15T13:15:07-08:00

dave commented

2020-11-15 13:15:07 -08:00

Progress: total: 430  completed: 430   errors: 8

files         status    uuid
------------  --------  -------------------------------------------------------------------------------------------------------
IMG_7320.JPG  error     (pymysql.err.InternalError) (3101, 'Plugin instructed the server to rollback the current transaction.')
                        (Background on this error at: http://sqlalche.me/e/2j85)

The import endpoint should retry transactions as this is somewhat expected on a bulk function.

A longer term TODO could be some import batch system where photos can be added to the batch async and you can edit/tag before they are seen in the library.

``` Progress: total: 430 completed: 430 errors: 8 files status uuid ------------ -------- ------------------------------------------------------------------------------------------------------- IMG_7320.JPG error (pymysql.err.InternalError) (3101, 'Plugin instructed the server to rollback the current transaction.') (Background on this error at: http://sqlalche.me/e/2j85) ``` The import endpoint should retry transactions as this is somewhat expected on a bulk function. A longer term TODO could be some import batch system where photos can be added to the batch async and you can edit/tag before they are seen in the library.

dave commented

2022-12-23 13:44:01 -08:00

Perhaps see https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html#sysvar_group_replication_consistency ?