[Triage] Ongoing Crashes since v2025.3.17

[marcus-at-localhost]

The app crashes all the time or isn't available. In the logs I see a lot of attempts to update ytdl and I opened the DB and saw the oban_jobs table filled with jobs incomplete jobs Pinchflat.YtDlp.UpdateWorker

07:00:15.312 [info] User scripts lifecyle file either not present or is empty. Skipping.

07:00:15.315 [info] {"message":"notifier only receiving messages from its own node, functionality may be degraded","source":"oban","event":"notifier:switch","connectivity_status":"solitary"}

07:00:15.318 [info] Running PinchflatWeb.Endpoint with cowboy 2.12.0 at 0.0.0.0:8945 (http)

07:00:15.320 [info] Access PinchflatWeb.Endpoint at http://localhost:8945

07:00:15.329 [info] {"args":{},"id":50747,"meta":{},"system_time":1742450415329190919,"max_attempts":20,"queue":"local_data","worker":"Pinchflat.YtDlp.UpdateWorker","source":"oban","event":"job:start","attempt":20,"tags":["local_data"]}

07:00:15.329 [info] Updating yt-dlp

07:00:15.329 [info] [command_wrapper]: /usr/local/bin/yt-dlp called with: --update

07:00:15.329 [info] {"args":{},"id":50749,"meta":{},"system_time":1742450415329550325,"max_attempts":20,"queue":"local_data","worker":"Pinchflat.YtDlp.UpdateWorker","source":"oban","event":"job:start","attempt":20,"tags":["local_data"]}

07:00:15.329 [info] {"args":{},"id":50748,"meta":{},"system_time":1742450415329272648,"max_attempts":20,"queue":"local_data","worker":"Pinchflat.YtDlp.UpdateWorker","source":"oban","event":"job:start","attempt":20,"tags":["local_data"]}

07:00:15.330 [info] Updating yt-dlp

07:00:15.330 [info] Updating yt-dlp

07:00:15.330 [info] {"args":{},"id":50750,"meta":{},"system_time":1742450415329889455,"max_attempts":20,"queue":"local_data","worker":"Pinchflat.YtDlp.UpdateWorker","source":"oban","event":"job:start","attempt":19,"tags":["local_data"]}

07:00:15.330 [info] [command_wrapper]: /usr/local/bin/yt-dlp called with: --update

07:00:15.330 [info] Updating yt-dlp

07:00:15.330 [info] [command_wrapper]: /usr/local/bin/yt-dlp called with: --update

07:00:15.330 [info] [command_wrapper]: /usr/local/bin/yt-dlp called with: --update

07:00:15.330 [info] {"args":{},"id":50751,"meta":{},"system_time":1742450415330180648,"max_attempts":20,"queue":"local_data","worker":"Pinchflat.YtDlp.UpdateWorker","source":"oban","event":"job:start","attempt":19,"tags":["local_data"]}

07:00:15.330 [info] Updating yt-dlp

07:00:15.331 [info] [command_wrapper]: /usr/local/bin/yt-dlp called with: --update

07:00:15.331 [info] {"args":{},"id":50753,"meta":{},"system_time":1742450415330849456,"max_attempts":20,"queue":"local_data","worker":"Pinchflat.YtDlp.UpdateWorker","source":"oban","event":"job:start","attempt":18,"tags":["local_data"]}

07:00:15.331 [info] {"args":{},"id":50762,"meta":{},"system_time":1742450415330988692,"max_attempts":20,"queue":"local_data","worker":"Pinchflat.YtDlp.UpdateWorker","source":"oban","event":"job:start","attempt":4,"tags":["local_data"]}

07:00:15.331 [info] Updating yt-dlp

07:00:15.331 [info] Updating yt-dlp

07:00:15.331 [info] [command_wrapper]: /usr/local/bin/yt-dlp called with: --update

07:00:15.331 [info] [command_wrapper]: /usr/local/bin/yt-dlp called with: --update

07:00:15.331 [info] {"args":{},"id":50752,"meta":{},"system_time":1742450415330764758,"max_attempts":20,"queue":"local_data","worker":"Pinchflat.YtDlp.UpdateWorker","source":"oban","event":"job:start","attempt":18,"tags":["local_data"]}

07:00:15.331 [info] Updating yt-dlp

07:00:15.332 [info] [command_wrapper]: /usr/local/bin/yt-dlp called with: --update

Early January I manually updated ytdl as described here in the forum and I think I read that can cause issues.

[marcus-at-localhost]

I ran DELETE FROM oban_jobs WHERE worker = 'Pinchflat.YtDlp.UpdateWorker'; that restored access to the app, and it looks like it's working now.

[marcus-at-localhost]

Still a thing, unfortunately. Hope it's ok to reopen it.