View Single Post
Old 08-29-2021, 05:24 PM   #18
capink
Wizard
capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.capink ought to be getting tired of karma fortunes by now.
 
Posts: 1,203
Karma: 1995558
Join Date: Aug 2015
Device: Kindle
Quote:
Originally Posted by chaley View Post
A threading violation or any other error while writing the database could cause a transaction to be rolled back. How big is a transaction? My guess: changes to a column for all affected books.
It never happened when you changed column for multiple books, as that only fires a single event with multiple book_ids. During my testing it happened only when multiple db events where happening in succession. (e.g. adding books)

Edit: Theoretically it can happen if you bulk change multiple columns using the bulk metadata edit dialog as that fire multiple events (one event per column). But I tested this multiple times and it did not happen, but the error was random so maybe with more testing it would happen. But it was more easily replicated when adding books.

Last edited by capink; 08-29-2021 at 05:35 PM.
capink is offline   Reply With Quote