Worker failed to lock a job level=error cannot set transaction read-write mode during recovery.

[mcbenjemaa]

I'm getting a lot of logs of this type.

Worker failed to lock a job level=error cannot set transaction read-write mode during recovery.

do you know what is this?

[vgarvardt]

According to https://stackoverflow.com/questions/24384407/cannot-set-transaction-read-write-mode-during-recovery-error

You have connected to a read-replica server in hot standby mode - a streaming replica, or one that's using WAL archiving, it doesn't matter.

These servers are read-only. So you cannot write to them.

[mcbenjemaa]

Oh I'm using postgres-operator I thought this is coming from gue..

[vgarvardt]

gue is using existing DB connection, so the app you're building is connecting to the DB server and this connection (pool actually) is used by the library