[Pgpool-hackers] problem with pgpool 3.1.1 and \d

[Devrim GUNDUZ]

Hello,

I was testing VACUUM behaviors of pgpool. During the test, I experienced
this problem:

pgpooltest=# \d siparis_bilgisi
ERROR:  column i.indisvalid does not exist
pgpooltest=# \d siparis_bilgisi
HATA:  i.indisvalid sütunu mevcut değil
pgpooltest=# \d siparis_bilgisi
Did not find any relation with OID 24846.
pgpooltest=# \d siparis_bilgisi
HATA:  i.indisvalid sütunu mevcut değil
pgpooltest=# \d siparis_bilgisi
ERROR:  column i.indisvalid does not exist
pgpooltest=# \d siparis_bilgisi
Did not find any relation with OID 24846.
pgpooltest=# \d siparis_bilgisi
Did not find any relation with OID 24846.
pgpooltest=# \d siparis_bilgisi
Did not find any relation with OID 24846.
pgpooltest=# \d siparis_bilgisi
Did not find any relation with OID 16402.
pgpooltest=# \d siparis_bilgisi
ERROR:  column i.indisvalid does not exist

... and it goes on.

Below are the pgpool debug logs:


2006-11-27 00:55:10 DEBUG: pid 13885: read kind from frontend Q(51)
2006-11-27 00:55:10 DEBUG: pid 13885: statement: SELECT c.oid,
  n.nspname,
  c.relname
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relname ~ '^(siparis_bilgisi)$'
  AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 2, 3;
2006-11-27 00:55:10 DEBUG: pid 13885: start_load_balance: selected master is 0
2006-11-27 00:55:10 DEBUG: pid 13885: read kind from backend T
2006-11-27 00:55:10 DEBUG: pid 13885: pool_process_query: kind from backend: T
2006-11-27 00:55:10 DEBUG: pid 13885: read kind from backend pending data D len: 62 po: 81
2006-11-27 00:55:10 DEBUG: pid 13885: pool_process_query: kind from backend: D
2006-11-27 00:55:10 DEBUG: pid 13885: read kind from backend pending data C len: 17 po: 126
2006-11-27 00:55:10 DEBUG: pid 13885: pool_process_query: kind from backend: C
2006-11-27 00:55:10 DEBUG: pid 13885: read kind from backend pending data Z len: 5 po: 138
2006-11-27 00:55:10 DEBUG: pid 13885: pool_process_query: kind from backend: Z
2006-11-27 00:55:10 DEBUG: pid 13885: pool_read_message_length: lenghth: 5
2006-11-27 00:55:10 DEBUG: pid 13885: ReadyForQuery: message length: 5
2006-11-27 00:55:10 DEBUG: pid 13885: ReadyForQuery: transaction state: I
2006-11-27 00:55:10 DEBUG: pid 13885: end_load_balance: end load balance mode
2006-11-27 00:55:10 DEBUG: pid 13885: read kind from frontend Q(51)
2006-11-27 00:55:10 DEBUG: pid 13885: statement: SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules, 
relhasoids , reltablespace 
FROM pg_catalog.pg_class WHERE oid = '24846'
2006-11-27 00:55:10 DEBUG: pid 13885: start_load_balance: selected master is 1
2006-11-27 00:55:10 DEBUG: pid 13885: read kind from backend T
2006-11-27 00:55:10 DEBUG: pid 13885: pool_process_query: kind from backend: T
2006-11-27 00:55:10 DEBUG: pid 13885: read kind from backend pending data C len: 17 po: 212
2006-11-27 00:55:10 DEBUG: pid 13885: pool_process_query: kind from backend: C
2006-11-27 00:55:10 DEBUG: pid 13885: read kind from backend pending data Z len: 5 po: 224
2006-11-27 00:55:10 DEBUG: pid 13885: pool_process_query: kind from backend: Z
2006-11-27 00:55:10 DEBUG: pid 13885: pool_read_message_length: lenghth: 5
2006-11-27 00:55:10 DEBUG: pid 13885: ReadyForQuery: message length: 5
2006-11-27 00:55:10 DEBUG: pid 13885: ReadyForQuery: transaction state: I
2006-11-27 00:55:10 DEBUG: pid 13885: end_load_balance: end load balance mode
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from frontend Q(51)
2006-11-27 00:55:27 DEBUG: pid 13885: statement: SELECT c.oid,
  n.nspname,
  c.relname
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relname ~ '^(siparis_bilgisi)$'
  AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 2, 3;
2006-11-27 00:55:27 DEBUG: pid 13885: start_load_balance: selected master is 0
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend T
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: T
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data D len: 62 po: 81
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: D
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data C len: 17 po: 126
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: C
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data Z len: 5 po: 138
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: Z
2006-11-27 00:55:27 DEBUG: pid 13885: pool_read_message_length: lenghth: 5
2006-11-27 00:55:27 DEBUG: pid 13885: ReadyForQuery: message length: 5
2006-11-27 00:55:27 DEBUG: pid 13885: ReadyForQuery: transaction state: I
2006-11-27 00:55:27 DEBUG: pid 13885: end_load_balance: end load balance mode
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from frontend Q(51)
2006-11-27 00:55:27 DEBUG: pid 13885: statement: SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules, 
relhasoids , reltablespace 
FROM pg_catalog.pg_class WHERE oid = '24846'
2006-11-27 00:55:27 DEBUG: pid 13885: start_load_balance: selected master is 0
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend T
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: T
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data D len: 59 po: 212
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: D
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data C len: 17 po: 254
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: C
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data Z len: 5 po: 266
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: Z
2006-11-27 00:55:27 DEBUG: pid 13885: pool_read_message_length: lenghth: 5
2006-11-27 00:55:27 DEBUG: pid 13885: ReadyForQuery: message length: 5
2006-11-27 00:55:27 DEBUG: pid 13885: ReadyForQuery: transaction state: I
2006-11-27 00:55:27 DEBUG: pid 13885: end_load_balance: end load balance mode
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from frontend Q(51)
2006-11-27 00:55:27 DEBUG: pid 13885: statement: SELECT a.attname,
  pg_catalog.format_type(a.atttypid, a.atttypmod),
  (SELECT substring(pg_catalog.pg_get_expr(d.adbin, d.adrelid) for 128)
   FROM pg_catalog.pg_attrdef d
   WHERE d.adrelid = a.attrelid AND d.adnum = a.attnum AND a.atthasdef),
  a.attnotnull, a.attnum
FROM pg_catalog.pg_attribute a
WHERE a.attrelid = '24846' AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
2006-11-27 00:55:27 DEBUG: pid 13885: start_load_balance: selected master is 0
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend T
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: T
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data D len: 312 po: 144
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: D
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data D len: 199 po: 257
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: D
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data D len: 153 po: 303
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: D
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data D len: 108 po: 348
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: D
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data D len: 63 po: 393
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: D
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data C len: 17 po: 439
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: C
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend pending data Z len: 5 po: 451
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: Z
2006-11-27 00:55:27 DEBUG: pid 13885: pool_read_message_length: lenghth: 5
2006-11-27 00:55:27 DEBUG: pid 13885: ReadyForQuery: message length: 5
2006-11-27 00:55:27 DEBUG: pid 13885: ReadyForQuery: transaction state: I
2006-11-27 00:55:27 DEBUG: pid 13885: end_load_balance: end load balance mode
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from frontend Q(51)
2006-11-27 00:55:27 DEBUG: pid 13885: statement: SELECT c2.relname, i.indisprimary, i.indisunique, i.indisclustered, i.indisvalid, pg_catalog.pg_get_indexdef(i.indexrelid, 0, true), c2.reltablespace
FROM pg_catalog.pg_class c, pg_catalog.pg_class c2, pg_catalog.pg_index i
WHERE c.oid = '24846' AND c.oid = i.indrelid AND i.indexrelid = c2.oid
ORDER BY i.indisprimary DESC, i.indisunique DESC, c2.relname
2006-11-27 00:55:27 DEBUG: pid 13885: start_load_balance: selected master is 1
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend E
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: E
2006-11-27 00:55:27 DEBUG: pid 13885: read kind from backend Z
2006-11-27 00:55:27 DEBUG: pid 13885: pool_process_query: kind from backend: Z
2006-11-27 00:55:27 DEBUG: pid 13885: pool_read_message_length: lenghth: 5
2006-11-27 00:55:27 DEBUG: pid 13885: ReadyForQuery: message length: 5
2006-11-27 00:55:27 DEBUG: pid 13885: ReadyForQuery: transaction state: I
2006-11-27 00:55:27 DEBUG: pid 13885: end_load_balance: end load balance mode



Any idea?

Regards,
-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://pgfoundry.org/pipermail/pgpool-hackers/attachments/20061126/689d0937/attachment.bin