[Pgpool-general] pgadmin and pgpool-II problem

[Gary Fu]

Hi,

I tried to connect a db in PgAdmin III through pgpool-II (2.0.1) and got 
a mismatch error log on
table pg_namespace and the PgAdmin failed connecting to that db.  First, 
I'm not sure why PgAdmin
wants to get info from that table to make the connection, second, I 
don't know why that system table has
different rows in the backend hosts.  Is there a way to let PgAdmin make 
connection without checking
that system table, or a simple way to sync just that system table 
between the backend hosts ?

Thanks,
Gary

---------------- pgpool log

2008-06-03 14:29:52 LOG:   pid 14001: statement: select localtimestamp;
2008-06-03 14:30:11 LOG:   pid 14002: statement: select localtimestamp;
2008-06-03 14:30:12 LOG:   pid 14000: statement: SET 
DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding, 
datlastsysoid
 FROM pg_database WHERE datname='nppsd3'
2008-06-03 14:30:12 LOG:   pid 14000: statement: set client_encoding to 
'UNICODE'
2008-06-03 14:30:12 LOG:   pid 14000: statement: SELECT version();
2008-06-03 14:30:12 LOG:   pid 14000: statement: SELECT usecreatedb, 
usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL 
END as upsince
 FROM pg_user WHERE usename=current_user
2008-06-03 14:30:12 LOG:   pid 14000: statement: SELECT rolcreaterole, 
rolcreatedb FROM pg_roles WHERE rolname = current_user;
2008-06-03 14:30:12 LOG:   pid 14000: statement: SELECT db.oid, datname, 
db.dattablespace AS spcoid, spcname, datallowconn, datconfig, datacl, 
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) 
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
current_setting('default_tablespace') AS default_tablespace
 FROM pg_database db
 LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
2008-06-03 14:30:12 LOG:   pid 14000: statement: SELECT description FROM 
pg_shdescription WHERE objoid=9985117::oid
2008-06-03 14:30:12 LOG:   pid 14000: statement: SHOW search_path
2008-06-03 14:30:12 LOG:   pid 14000: statement: SELECT nspname, 
session_user=nspname AS isuser FROM pg_namespace
2008-06-03 14:30:12 ERROR: pid 14000: pool_process_query: 1 th kind C 
does not match with master connection kind D
2008-06-03 14:30:12 LOG:   pid 14000: do_child: exits with status 1 due 
to error
2008-06-03 14:30:18 LOG:   pid 14001: statement:  RESET ALL
2008-06-03 14:30:18 LOG:   pid 14001: statement:  SET SESSION 
AUTHORIZATION DEFAULT
2008-06-03 14:30:53 LOG:   pid 14002: statement: ;
2008-06-03 14:30:55 LOG:   pid 14002: statement: SELECT oid, 
pg_encoding_to_char(encoding) AS encoding, datlastsysoid
 FROM pg_database WHERE datname='nppsd3'
;
2008-06-03 14:31:10 LOG:   pid 14002: statement: SELECT version();
2008-06-03 14:31:24 LOG:   pid 14002: statement: SELECT usecreatedb, 
usesuper, CASE WHEN usesuper THEN pg_postmaster_start_time() ELSE NULL 
END as upsince
 FROM pg_user WHERE usename=current_user
;
2008-06-03 14:31:30 LOG:   pid 14002: statement: SELECT rolcreaterole, 
rolcreatedb FROM pg_roles WHERE rolname = current_user;
2008-06-03 14:31:44 LOG:   pid 14002: statement: SELECT db.oid, datname, 
db.dattablespace AS spcoid, spcname, datallowconn, datconfig, datacl, 
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) 
AS datowner,has_database_privilege(db.oid, 'CREATE') as cancreate,
current_setting('default_tablespace') AS default_tablespace
 FROM pg_database db
 LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
ORDER BY datname
;
2008-06-03 14:31:56 LOG:   pid 14002: statement: SELECT description FROM 
pg_shdescription WHERE objoid=9985117::oid
;
2008-06-03 14:32:05 LOG:   pid 14002: statement: SHOW search_path
;
2008-06-03 14:32:14 LOG:   pid 14002: statement: SELECT nspname, 
session_user=nspname AS isuser FROM pg_namespace
;
2008-06-03 14:32:14 ERROR: pid 14002: pool_process_query: 1 th kind C 
does not match with master connection kind D
2008-06-03 14:32:14 LOG:   pid 14002: do_child: exits with status 1 due 
to error

---------------- select sql from backend host 0

[nppdist.gfu].nppsd3> select * from pg_namespace;
      nspname       | nspowner |               nspacl               
--------------------+----------+-------------------------------------
 pg_toast           |       10 |
 pg_temp_1          |       10 |
 pg_catalog         |       10 | {postgres=UC/postgres,=U/postgres}
 information_schema |       10 | {postgres=UC/postgres,=U/postgres}
 public             |       10 | {postgres=UC/postgres,=UC/postgres}
 pg_temp_4          |       10 |
 pg_temp_13         |       10 |
 pg_temp_15         |       10 |
 pg_temp_23         |       10 |
 pg_temp_3          |       10 |
 pg_temp_6          |       10 |
 pg_temp_2          |       10 |
 pg_temp_5          |       10 |
 pg_temp_7          |       10 |
 pg_temp_10         |       10 |
 pg_temp_8          |       10 |
 pg_temp_32         |       10 |
 pg_temp_17         |       10 |
 pg_temp_12         |       10 |
 pg_temp_48         |       10 |
 pg_temp_25         |       10 |
 pg_temp_11         |       10 |
 pg_temp_26         |       10 |
 pg_temp_45         |       10 |
 pg_temp_24         |       10 |
 pg_temp_9          |       10 |
 pg_temp_16         |       10 |
 pg_temp_14         |       10 |
(28 rows)

-------------------- select sql from backend host 1
[nppsds1.gfu].nppsd3>  select * from pg_namespace;
      nspname       | nspowner |               nspacl
--------------------+----------+-------------------------------------
 pg_toast           |       10 |
 pg_temp_1          |       10 |
 pg_catalog         |       10 | {postgres=UC/postgres,=U/postgres}
 information_schema |       10 | {postgres=UC/postgres,=U/postgres}
 public             |       10 | {postgres=UC/postgres,=UC/postgres}
 pg_temp_5          |       10 |