poulpi
01/06/2023, 4:38 PM2 UNKNOWN: unable to find revision: ERROR: prepared statement \"lrupsc_89_0\" does not exist (SQLSTATE 26000)
leonnicolas
03/21/2023, 10:12 AMconnectionPooler:
mode: session
or see https://www.pgbouncer.org/config.html#pool_mode.
Otherwise I believe, the pgbouncer cleans up all prepared statements, causing those errorsvroldanbet
03/21/2023, 1:33 PMsashayakovtseva_46690
10/04/2023, 1:29 PM{
"level": "warn",
"error": "error deleting in gc: unable to encode postgres.xid8{Uint64:0x1, Valid:true} into text format for unknown type (OID 0): cannot find encode plan",
"next-attempt-in": 597.742967,
"time": "2023-10-04T12:41:30Z",
"message": "error attempting to perform garbage collection"
}
I am not sure session pooling is a good idea at all. Are there any recommendations for pgbouncer+spicedb?