[Pgpool-general] out of sync after listing tables

[Tatsuo Ishii]

Did not reproduce here.

Do you have anything special with your setting?
Do you have same result with a trivial query such as "SELECT 1"?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> 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...
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general