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

[Tatsuo Ishii]

I seems your servers' OIDs are out of sync.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> 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/