PgDog version
v0.1.34
Description
we have this query:
-- name: CountRetryableTransactions :one
WITH retries_available AS (SELECT 1
FROM retries
WHERE next_retry_at <= NOW()
AND deleted_at IS NULL
FOR UPDATE SKIP LOCKED
)
SELECT COUNT(*)
FROM retries_availableThe query should have been routed to the write replica. If the query needs to be wrapped in an explicit transaction, the documentation at https://docs.pgdog.dev/features/load-balancer/#select-for-update could be a little more explicit about it.
Logs
pq: cannot execute SELECT FOR UPDATE in a read-only transaction (25006)
PgDog version
v0.1.34Description
we have this query:
The query should have been routed to the write replica. If the query needs to be wrapped in an explicit transaction, the documentation at https://docs.pgdog.dev/features/load-balancer/#select-for-update could be a little more explicit about it.
Logs
pq: cannot execute SELECT FOR UPDATE in a read-only transaction (25006)