[pgpool-general: 8754] ERROR unable to flush data to frontend
Steeve Boulanger
sboulanger29 at gmail.com
Tue May 9 08:24:33 JST 2023
Greetings,
We are getting this error message "ERROR: unable to flush data to frontend"
sporadically in our environments, across several micro service applications
running under K8s.
~~
2023-05-08 23:15:00.558: console pid 3290292: ERROR: unable to flush data
to frontend
~~
I'm attaching an extract from our logs as an example.
I have found one or two older posts mentioning that this was an issue
with the client disconnecting abruptly, thus pgpool is unable to
communicate with the client and reports this error - is this correct?
Any recommendations on how to diagnose (and hopefully fix) this issue would
be greatly appreciated.
Regards,
Steeve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230508/0d395adb/attachment.htm>
-------------- next part --------------
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:1 name:"application_name" value:"console"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:2 name:"application_name" value:"console"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:1 name:"client_encoding" value:"UTF8"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:2 name:"client_encoding" value:"UTF8"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:0 name:"DateStyle" value:"ISO, MDY"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:1 name:"DateStyle" value:"ISO, MDY"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:2 name:"DateStyle" value:"ISO, MDY"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:1 name:"integer_datetimes" value:"on"
2023-05-08 22:09:16.580: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.580: console pid 3338613: DETAIL: backend:2 name:"integer_datetimes" value:"on"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:1 name:"IntervalStyle" value:"postgres"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:2 name:"IntervalStyle" value:"postgres"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:0 name:"is_superuser" value:"off"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:1 name:"is_superuser" value:"off"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:2 name:"is_superuser" value:"off"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:1 name:"server_encoding" value:"UTF8"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:2 name:"server_encoding" value:"UTF8"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:0 name:"server_version" value:"13.10 (Ubuntu 13.10-1.pgdg20.04+1)"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:1 name:"server_version" value:"13.10 (Ubuntu 13.10-1.pgdg20.04+1)"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:2 name:"server_version" value:"13.10 (Ubuntu 13.10-1.pgdg20.04+1)"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:0 name:"session_authorization" value:"microservice"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:1 name:"session_authorization" value:"microservice"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:2 name:"session_authorization" value:"microservice"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:1 name:"standard_conforming_strings" value:"on"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:2 name:"standard_conforming_strings" value:"on"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:0 name:"TimeZone" value:"Etc/UTC"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:1 name:"TimeZone" value:"Etc/UTC"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: backend:2 name:"TimeZone" value:"Etc/UTC"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: authentication backend
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: cp->info[i]:0x7f3a600bfc08 pid:2497196
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: authentication backend
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: cp->info[i]:0x7f3a600bfca8 pid:3137930
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: authentication backend
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: cp->info[i]:0x7f3a600bfd48 pid:1408237
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: sending backend key data
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: send pid 1408237 to frontend
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: selecting load balance node
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: selected backend id is 0
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:16.581: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:16.581: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:16.581: console pid 3338613: DEBUG: do_query: extended:1 query:"SELECT current_setting('transaction_isolation')"
2023-05-08 22:09:16.581: console pid 3338613: CONTEXT: while getting transaction isolation
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: memcache encode key
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: username: "microservice" database_name: "DB"
2023-05-08 22:09:16.582: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: memcache encode key
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: query: "SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = 'QueueDataPerMessages' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'"
2023-05-08 22:09:16.582: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: memcache encode key
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: `microserviceSELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = 'QueueDataPerMessages' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'DB' -> `41bf0b83026a07fec52d9f5b63d0cd6b'
2023-05-08 22:09:16.582: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: fetching from cache storage
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: search key "41bf0b83026a07fec52d9f5b63d0cd6b"
2023-05-08 22:09:16.582: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: fetching from cache storage
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: query="SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = 'QueueDataPerMessages' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'" len:13
2023-05-08 22:09:16.582: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: hit query cache
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = 'QueueDataPerMessages' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:16.582: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:16.582: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:16.582: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:16.582: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:16.582: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:16.582: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:16.582: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:16.583: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:16.583: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:18.584: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:18.584: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:18.584: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:18.584: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:18.584: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:18.584: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:18.584: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:18.584: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:18.585: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:18.585: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:18.585: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:18.585: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:18.585: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:18.585: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:18.585: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:20.587: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:20.587: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:20.587: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:20.587: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:20.587: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:20.587: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:20.587: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:20.587: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:20.588: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:20.588: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:22.589: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:22.589: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:22.589: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:22.589: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:22.589: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:22.589: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:22.589: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:22.589: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:22.590: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:22.590: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:22.590: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:22.590: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:22.590: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:22.590: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:22.590: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:24.592: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:24.592: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:24.592: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:24.592: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:24.592: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:24.592: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:24.592: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:24.592: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:26.590: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:26.590: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:26.590: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:26.590: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:26.590: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:26.590: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:26.590: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:26.590: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:26.591: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:26.591: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:26.591: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:26.591: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:26.591: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:26.591: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:26.591: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:28.593: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:28.593: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:28.593: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:28.593: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:28.593: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:28.593: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:28.593: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:28.593: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:28.594: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:28.594: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:30.595: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:30.595: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:30.595: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:30.595: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:30.595: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:30.595: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:30.596: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:30.596: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:30.596: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:30.596: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:30.596: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:30.596: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:30.596: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:30.597: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:30.597: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:32.599: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:32.599: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:32.599: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:32.599: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:32.599: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:32.599: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:32.599: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:32.599: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:34.597: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:34.597: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:34.597: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:34.597: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:34.597: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:34.597: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:34.597: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:34.597: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:09:34.598: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: result = 0
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:09:34.598: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:09:34.598: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:09:34.598: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:09:34.598: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:09:34.598: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:09:34.598: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:09:36.589: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:09:36.589: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:09:36.589: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:36.589: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:36.589: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:36.589: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:36.589: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:36.589: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:36.589: console pid 3338613: LOG: Terminate message from frontend.
2023-05-08 22:09:36.589: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:09:36.589: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:09:36.589: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:36.589: console pid 3338613: DETAIL: waiting for backend:0 to complete the query
2023-05-08 22:09:36.590: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:09:36.590: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:09:36.590: console pid 3338613: DETAIL: close time 1683583776
2023-05-08 22:10:18.718: console pid 3338613: DEBUG: LOCKING select()
2023-05-08 22:10:24.682: console pid 3338613: DEBUG: UNLOCKING select()
2023-05-08 22:10:24.682: console pid 3338613: DEBUG: I am 3338613 accept fd 7
2023-05-08 22:10:24.682: console pid 3338613: DEBUG: reading startup packet
2023-05-08 22:10:24.682: console pid 3338613: DETAIL: application_name: console
2023-05-08 22:10:24.682: console pid 3338613: DEBUG: reading startup packet
2023-05-08 22:10:24.682: console pid 3338613: DETAIL: guc name: client_encoding value: UTF8
2023-05-08 22:10:24.682: console pid 3338613: DEBUG: reading startup packet
2023-05-08 22:10:24.682: console pid 3338613: DETAIL: Protocol Major: 3 Minor: 0 database: DB user: microservice
2023-05-08 22:10:24.682: console pid 3338613: DEBUG: md5 authentication successful with frontend
2023-05-08 22:10:24.688: console pid 3338613: DEBUG: authentication backend
2023-05-08 22:10:24.688: console pid 3338613: DETAIL: auth kind:5
2023-05-08 22:10:24.688: console pid 3338613: DEBUG: authentication backend: 0
2023-05-08 22:10:24.688: console pid 3338613: DETAIL: trying md5 authentication
2023-05-08 22:10:24.689: console pid 3338613: DEBUG: authentication backend: 1
2023-05-08 22:10:24.689: console pid 3338613: DETAIL: trying md5 authentication
2023-05-08 22:10:24.690: console pid 3338613: DEBUG: authentication backend: 2
2023-05-08 22:10:24.690: console pid 3338613: DETAIL: trying md5 authentication
2023-05-08 22:10:24.691: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:10:24.691: console pid 3338613: DETAIL: backend:0 name:"application_name" value:"console"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"application_name" value:"console"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"application_name" value:"console"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"client_encoding" value:"UTF8"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"client_encoding" value:"UTF8"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"client_encoding" value:"UTF8"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"DateStyle" value:"ISO, MDY"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"DateStyle" value:"ISO, MDY"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"DateStyle" value:"ISO, MDY"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"integer_datetimes" value:"on"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"integer_datetimes" value:"on"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"integer_datetimes" value:"on"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"IntervalStyle" value:"postgres"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"IntervalStyle" value:"postgres"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"is_superuser" value:"off"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"is_superuser" value:"off"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"is_superuser" value:"off"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"server_encoding" value:"UTF8"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"server_encoding" value:"UTF8"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"server_encoding" value:"UTF8"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"server_version" value:"13.10 (Ubuntu 13.10-1.pgdg20.04+1)"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"server_version" value:"13.10 (Ubuntu 13.10-1.pgdg20.04+1)"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"server_version" value:"13.10 (Ubuntu 13.10-1.pgdg20.04+1)"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"session_authorization" value:"microservice"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"session_authorization" value:"microservice"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"session_authorization" value:"microservice"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"standard_conforming_strings" value:"on"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"standard_conforming_strings" value:"on"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:0 name:"TimeZone" value:"Etc/UTC"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:1 name:"TimeZone" value:"Etc/UTC"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: process parameter status
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: backend:2 name:"TimeZone" value:"Etc/UTC"
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: authentication backend
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: cp->info[i]:0x7f3a600b5c08 pid:2499941
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: authentication backend
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: cp->info[i]:0x7f3a600b5ca8 pid:3159945
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: authentication backend
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: cp->info[i]:0x7f3a600b5d48 pid:1411066
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: sending backend key data
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: send pid 1411066 to frontend
2023-05-08 22:31:20.933: console pid 3338613: DEBUG: selecting load balance node
2023-05-08 22:31:20.933: console pid 3338613: DETAIL: selected backend id is 1
2023-05-08 22:31:20.934: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:20.934: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:20.934: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:20.934: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:20.934: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:20.934: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:20.934: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:20.934: console pid 3338613: DEBUG: do_query: extended:1 query:"SELECT current_setting('transaction_isolation')"
2023-05-08 22:31:20.934: console pid 3338613: CONTEXT: while getting transaction isolation
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: memcache encode key
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: username: "microservice" database_name: "DB"
2023-05-08 22:31:20.935: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: memcache encode key
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: query: "SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = 'QueueDataPerMessages' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'"
2023-05-08 22:31:20.935: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: memcache encode key
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: `microserviceSELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = 'QueueDataPerMessages' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'DB' -> `41bf0b83026a07fec52d9f5b63d0cd6b'
2023-05-08 22:31:20.935: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: fetching from cache storage
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: search key "41bf0b83026a07fec52d9f5b63d0cd6b"
2023-05-08 22:31:20.935: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: fetching from cache storage
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: query="SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = 'QueueDataPerMessages' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'" len:13
2023-05-08 22:31:20.935: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: hit query cache
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = 'QueueDataPerMessages' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:20.935: console pid 3338613: CONTEXT: while searching system catalog, When relcache is missed
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:20.935: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:20.935: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:20.935: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:20.935: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:20.935: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:20.935: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:20.936: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:20.936: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:22.937: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:22.937: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:22.937: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:22.937: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:22.937: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:22.937: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:22.938: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:22.938: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:22.938: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:22.938: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:22.938: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:22.938: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:22.938: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:24.938: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:24.938: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:24.938: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:24.938: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:24.938: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:24.938: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:24.938: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:24.938: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:24.938: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:24.938: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:24.938: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:24.938: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:24.938: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:24.938: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:24.938: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:24.938: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:24.938: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:24.938: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:24.939: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:24.939: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:24.939: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:24.939: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:24.939: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:24.939: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:24.939: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:24.939: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:24.939: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:24.939: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:24.939: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:26.941: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:26.941: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:26.941: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:26.941: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:26.941: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:26.941: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:26.941: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:26.941: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:26.942: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:26.942: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:28.943: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:28.943: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:28.943: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:28.943: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:28.943: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:28.943: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:28.943: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:28.943: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:30.945: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:30.945: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:30.945: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:30.945: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:30.945: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:30.945: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:30.945: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:30.945: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:30.946: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:30.946: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:32.946: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:32.946: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:32.946: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:32.946: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:32.946: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:32.946: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:32.946: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:32.946: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:34.945: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:34.945: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:34.945: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:34.945: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:34.945: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:34.945: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:34.946: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:34.946: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:34.946: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:34.946: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:34.946: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:34.946: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:34.946: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:36.946: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:36.946: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:36.946: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:36.946: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:36.946: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:36.947: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:36.947: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:36.947: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:36.947: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:36.947: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:36.947: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:36.947: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:36.947: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:36.947: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:36.947: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:38.946: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:38.946: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:38.946: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:38.946: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:38.946: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:38.946: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: Parse: statement name <>
2023-05-08 22:31:38.947: console pid 3338613: LOG: Parse message from frontend.
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: statement: "", query: "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: checking if query has INSERT INTO, FOR SHARE or FOR UPDATE
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: result = 0
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: checking load balance preconditions. TSTATE:I writing_transaction:0 failed_transaction:0 isolation:2
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: destination = 2 for query= "SELECT q."Id", q."RawMessage", q."Type"
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: system catalog walker, checking relation "QueueDataPerMessages"
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = pg_catalog.to_regclass('"%s"') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: temporary table walker. checking relation "QueueDataPerMessages"
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c, pg_namespace AS n WHERE c.relname = '%s' AND c.relnamespace = n.oid AND n.nspname ~ '^pg_temp_'
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: make table name from rangevar: tablename:""QueueDataPerMessages""
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: unlogged table walker. checking relation ""QueueDataPerMessages""
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: hit local relation cache
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: query:SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('%s') AND c.relpersistence = 'u'
2023-05-08 22:31:38.947: console pid 3338613: LOG: Bind message from frontend.
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: portal: "", statement: ""
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: Bind: waiting for main node completing the query
2023-05-08 22:31:38.947: console pid 3338613: LOG: Describe message from frontend.
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: Describe: waiting for main node completing the query
2023-05-08 22:31:38.947: console pid 3338613: LOG: Execute message from frontend.
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: portal: ""
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: Execute: pool_is_writing_transaction: 0 TSTATE: I
2023-05-08 22:31:38.947: console pid 3338613: LOG: Sync message from frontend.
2023-05-08 22:31:38.947: console pid 3338613: DEBUG: processing command complete
2023-05-08 22:31:38.947: console pid 3338613: DETAIL: set transaction state to T
2023-05-08 22:31:40.932: console pid 3338613: LOG: Query message from frontend.
2023-05-08 22:31:40.933: console pid 3338613: DETAIL: query: "DISCARD ALL"
2023-05-08 22:31:40.933: console pid 3338613: DEBUG: decide where to send the query
2023-05-08 22:31:40.933: console pid 3338613: DETAIL: destination = 3 for query= "DISCARD ALL"
2023-05-08 22:31:40.933: console pid 3338613: DEBUG: waiting for query response
2023-05-08 22:31:40.933: console pid 3338613: DETAIL: waiting for backend:1 to complete the query
2023-05-08 22:31:40.933: console pid 3338613: ERROR: unable to flush data to frontend
2023-05-08 22:32:01.558: console pid 3338613: DEBUG: LOCKING select()
2023-05-08 22:32:01.853: console pid 3338613: DEBUG: UNLOCKING select()
More information about the pgpool-general
mailing list