Gelbooru

Notice: Visit your account options to access your Patreon rewards for April. Come join our Discord!

Now Viewing: "Deadlock found when trying to get lock; try restarting transaction"

Keep it civil, do not flame or bait other users. If you notice anything illegal or inappropriate being discussed, contact an administrator or moderator.

Domestic_Importer Group: Member - Total Posts: 151
user_avatar
"Deadlock found when trying to get lock; try restarting transaction"
Posted on: 05/10/17 05:39PM
What's the reason to why this happens at random times when trying to upload something? Than it'll say the file exist even though its nowhere to be found.

lozertuser Group: Administrator - Total Posts: 1433
user_avatar
Posted on: 05/11/17 01:37AM
Hmm... during a deadlock it shouldn't commit, it should rollback, buuuut... it could be it is not inserted in to the searcher index, but actually is on the database server. If you know the source file md5, let me know and I'll try to debug.

Domestic_Importer Group: Member - Total Posts: 151
user_avatar
Posted on: 05/11/17 01:56AM
256297b63e6c165e5bac28aabfd18336 and 9f2afd9b238facdffc8509ba56ba9d82

lozertuser Group: Administrator - Total Posts: 1433
user_avatar
Posted on: 05/11/17 02:13AM
I'll look into it further tomorrow. Database shows no trace of those files, so if they aren't adding even now, there is something being done wrong in our image processing script.

lozertuser Group: Administrator - Total Posts: 1433
user_avatar
Posted on: 05/11/17 02:15AM
gelbooru.com/images/25/62...165e5bac28aabfd18336.jpeg

It is adding an image, just no db entry. I'll have it narrowed down hopefully tomorrow.

lozertuser Group: Administrator - Total Posts: 1433
user_avatar
Posted on: 05/12/17 01:01AM
I believe this to be fixed now, if not, open a tracker ticket.

add_replyAdd Reply

1