CommunityScripts icon indicating copy to clipboard operation
CommunityScripts copied to clipboard

[timestampTrade] Database lock protection

Open MikeLund opened this issue 1 year ago • 0 comments

If the stash database gets locked for some reason, it aborts the entire "Sync" task.

ERRO[2024-05-25 16:17:24] movieCreate: input: movieCreate inserting into movies: executing `INSERT INTO `movies` (`aliases`, `back_image_blob`, `created_at`, `date`, `director`, `duration`, `front_image_blob`, `name`, `rating`, `studio_id`, `synopsis`, `updated_at`, `url`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)` [[<nil> <nil> 2024-05-25T16:17:24+02:00 2019-12-04 <nil> <nil> <nil> Babysitter Diaries 21 <nil> <nil> Naughty babysitter Winter Jade is hungry for Alex Jetts thick cock. Sometimes you just need to let loose and misbehave while on the job! Robby Echo has had a hard day at work so his sexy babysitter Liv Wild gives him a nice massage . . . starting with his big cock! Liv always gives it her all while on the job! Blonde hottie Megan Holly is bound to get the job as a babysitter, once she shows Jon Rogue her sweet tits . . . and lets him fuck her tight pussy! Tiny cutie Kiara Cole is a sexy live-in babysitter with benefits, and lucky for Robby, he gets to fuck her tight little pussy whenever he wants to! 2024-05-25T16:17:24+02:00 https://www.adultdvdempire.com/2755362/babysitter-diaries-21-porn-videos.html]]: database is locked
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade] DATABASE_LOCKED: inserting into movies: executing `INSERT INTO `movies` (`aliases`, `back_image_blob`, `created_at`, `date`, `director`, `duration`, `front_image_blob`, `name`, `rating`, `studio_id`, `synopsis`, `updated_at`, `url`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)` [[<nil> <nil> 2024-05-25T16:17:24+02:00 2019-12-04 <nil> <nil> <nil> Babysitter Diaries 21 <nil> <nil> Naughty babysitter Winter Jade is hungry for Alex Jetts thick cock. Sometimes you just need to let loose and misbehave while on the job! Robby Echo has had a hard day at work so his sexy babysitter Liv Wild gives him a nice massage . . . starting with his big cock! Liv always gives it her all while on the job! Blonde hottie Megan Holly is bound to get the job as a babysitter, once she shows Jon Rogue her sweet tits . . . and lets him fuck her tight pussy! Tiny cutie Kiara Cole is a sexy live-in babysitter with benefits, and lucky for Robby, he gets to fuck her tight little pussy whenever he wants to! 2024-05-25T16:17:24+02:00 https://www.adultdvdempire.com/2755362/babysitter-diaries-21-porn-videos.html]]: database is locked ['movieCreate']
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade] Database is temporarily locked.
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade] 200 OK query failed. v0.25.1-0
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade] Traceback (most recent call last):
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]   File "/home/mmm/.stash/plugins/timestampTrade/timestampTrade.py", line 862, in <module>
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]     processAll(query)
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]   File "/home/mmm/.stash/plugins/timestampTrade/timestampTrade.py", line 334, in processAll
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]     processScene(s)
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]   File "/home/mmm/.stash/plugins/timestampTrade/timestampTrade.py", line 23, in processScene
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]     processSceneTimestamTrade(s)
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]   File "/home/mmm/.stash/plugins/timestampTrade/timestampTrade.py", line 246, in processSceneTimestamTrade
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]     nm = stash.create_movie(new_movie)
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]   File "/home/mmm/.local/lib/python3.10/site-packages/stashapi/stashapp.py", line 1031, in create_movie
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]     result = self._callGraphQL(query, variables)
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]   File "/home/mmm/.local/lib/python3.10/site-packages/stashapi/classes.py", line 233, in _callGraphQL
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]     return self._handleGQLResponse(response)
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]   File "/home/mmm/.local/lib/python3.10/site-packages/stashapi/classes.py", line 279, in _handleGQLResponse
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade]     raise Exception(error_msg)
ERRO[2024-05-25 16:17:24] [Plugin / Timestamp Trade] Exception: 200 OK query failed. v0.25.1-0
ERRO[2024-05-25 16:17:24] Plugin returned error: exit status 1

Ideally it'd catch such an exception, wait a short while, and retry?

MikeLund avatar May 25 '24 14:05 MikeLund