Plex doesn’t recover when Postgres restarts

[sjdaws]

If Postgres restarts the shim detects and recovers from this according to the logs, however Plex doesn’t work correctly until it is restarted.

I am running Plex as a standalone docker container using the Dockerfile.standalone in this repo. It is connected to a Postgres container via tcp. When Postgres restarts I only have the “to watch” option available, all libraries show a “something went wrong error”

The only way to bring the libraries back is to restart Plex. I am unable to use the socket to connect so I haven’t tested whether this recovers correctly.

[sjdaws]

This also seems to happen when the initial connection times out and has to be reestablished.

[cgnl]

Thanks a lot for using this project and reporting this. Fixing this now.

[cgnl]

Should go better now. Let me know.

[sjdaws]

Thanks for fixing this, I can confirm it's now fixed after waiting for PLEX_PG_IDLE_TIMEOUT. Not sure if it's possible to force close these connections when a break in connectivity has been detected?

[cgnl]

Good point. That was actually what I wanted it to do. PLEX_PG_IDLE_TIMEOUT was meant for cleaning up unused connections, not for the recovery after a restart. But I only implemented the retries for sqlite3_step yesterday.
I just pushed a fix that adds the same pre-flight connection check and retry logic to sqlite3_exec. Dead connections are now detected immediately (via PQstatus), reconnected inline (PQreset, then fresh connection if needed), and retried with the same backoff schedule from PLEX_PG_RETRY_DELAYS.

Edit: Some other fixes needed.
6348d8b
Done

[sjdaws]

Thanks for this, 0.9.40 seems much more responsive to disconnects.

v1 doesn't seem to start up, but this is another issue unrelated to this one:

plex-test plex-test-0 plex-test [SHIM_INIT] Original SQLite functions loaded
plex-test plex-test-0 plex-test [SHIM_INIT] Not Plex Server/Scanner ('uname'), skipping entirely (PID 2519)
plex-test plex-test-0 plex-test Error relocating /usr/lib/x86_64-linux-gnu/libgcc_s.so.1: _dl_find_object: symbol not found

[cgnl]

I was planning a major refactor in develop branch but since a week ago I'm all day visiting in the hospital for something very critical. This project is not abandoned but paused in the meantime.