Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[timestampTrade] Database lock protection #310

Open
MikeLund opened this issue May 25, 2024 · 0 comments
Open

[timestampTrade] Database lock protection #310

MikeLund opened this issue May 25, 2024 · 0 comments

Comments

@MikeLund
Copy link

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant