[Pgpool-general] out of sync after listing tables

[Gerd König]

Hello,

I currently installed the latest pgpool-II 2.2.1 with Postgres8.3.7 as backend
on 2 nodes.
Setup and start pgpool worked as expected, but immediately after connecting to
pgpool via psql it got out of sync....?!?!
The steps:
1.) install and startup pgpool-II 2.2.1 on "node1" and "node2" (node1 is the
"master")
2.) call "psql -U dbname -u user -h node1" from a different workstation (psql
version 8.3.5)
3.) inside psql session type "\d"
4.) check pgpool log and detect the following lines:
....
2009-04-30 14:00:10 DEBUG: pid 11979: pool_read_message_length2: master slot: 0
length: 36
2009-04-30 14:00:10 DEBUG: pid 11979: pool_read_message_length2: master slot: 1
length: 36
2009-04-30 14:00:10 DEBUG: pid 11979: 0 th backend: name:
standard_conforming_strings value: off
2009-04-30 14:00:10 DEBUG: pid 11979: 1 th backend: name:
standard_conforming_strings value: off
2009-04-30 14:00:10 DEBUG: pid 11979: pool_read_message_length2: master slot: 0
length: 27
2009-04-30 14:00:10 DEBUG: pid 11979: pool_read_message_length2: master slot: 1
length: 27
2009-04-30 14:00:10 DEBUG: pid 11979: 0 th backend: name: TimeZone value:
Europe/Berlin
2009-04-30 14:00:10 DEBUG: pid 11979: 1 th backend: name: TimeZone value:
Europe/Berlin
2009-04-30 14:00:10 DEBUG: pid 11979: pool_read_message_length: slot: 0 length: 12
2009-04-30 14:00:10 DEBUG: pid 11979: pool_read_message_length: slot: 1 length: 12
2009-04-30 14:00:10 DEBUG: pid 11979: pool_send_auth_ok: send pid 18650 to frontend
2009-04-30 14:00:10 DEBUG: pid 11979: read_kind_from_backend: read kind from 0
th backend Z NUM_BACKENDS: 2
2009-04-30 14:00:10 DEBUG: pid 11979: read_kind_from_backend: read kind from 1
th backend Z NUM_BACKENDS: 2
2009-04-30 14:00:10 DEBUG: pid 11979: pool_process_query: kind from backend: Z
2009-04-30 14:00:10 DEBUG: pid 11979: pool_read_message_length: slot: 0 length: 5
2009-04-30 14:00:10 DEBUG: pid 11979: pool_read_message_length: slot: 1 length: 5
2009-04-30 14:00:10 DEBUG: pid 11979: ReadyForQuery: message length: 5
2009-04-30 14:00:10 DEBUG: pid 11979: ReadyForQuery: transaction state: I
2009-04-30 14:00:18 DEBUG: pid 11979: read kind from frontend Q(51)
2009-04-30 14:00:18 LOG:   pid 11979: statement: SELECT n.nspname as "Schema",
  c.relname as "Name",
  CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'i' THEN
'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' END as "Type",
  r.rolname as "Owner"
FROM pg_catalog.pg_class c
     JOIN pg_catalog.pg_roles r ON r.oid = c.relowner
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','v','S','')
  AND n.nspname <> 'pg_catalog'
  AND n.nspname !~ '^pg_toast'
  AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;
2009-04-30 14:00:18 DEBUG: pid 11979: waiting for backend 0 completing the query
2009-04-30 14:00:18 DEBUG: pid 11979: detect_error: kind: T
2009-04-30 14:00:18 DEBUG: pid 11979: detect_error: kind: T
2009-04-30 14:00:18 DEBUG: pid 11979: read_kind_from_backend: read kind from 0
th backend T NUM_BACKENDS: 1
2009-04-30 14:00:18 DEBUG: pid 11979: pool_process_query: kind from backend: T


Is this a bug, or am I missing something ?

thanks in advance...GERD...