[pgpool-general: 2092] problem with psql \d command

[Gary Fu]

Hi,

I'm running pgpool 3.3 with postgres 9.2.4 with the following configuration:

replication_mode = on
replicate_select = off
replication_stop_on_mismatch = off
failover_if_affected_tuples_mismatch = on
load_balance_mode = off

I got the following error when I tried to use '\d gfu' command on psql 
(gfu is a table)

[sd3dev1.dev1_admin].sd3dev1> show pool_nodes;
  node_id | hostname | port | status | lb_weight |  role
---------+----------+------+--------+-----------+--------
  0       | sd3db5   | 5432 | 2      | 0.500000  | master
  1       | sd3db6   | 5432 | 2      | 0.500000  | slave

[sd3dev1.dev1_admin].sd3dev1> \d gfu
ERROR:  kind mismatch among backends. Possible last query was: "SELECT 
c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, 
c.relhasoids, '', c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' 
ELSE c.reloftype::pg_catalog.regtype::pg_catalog.t
ERROR:  kind mismatch among backends. Possible last query was: "SELECT 
c.relchecks, c.relkind, c.relhasindex, c.relhasrules, c.relhastriggers, 
c.relhasoids, '', c.reltablespace, CASE WHEN c.reloftype = 0 THEN '' 
ELSE c.reloftype::pg_catalog.regtype::pg_catalog.t
The connection to the server was lost. Attempting reset: Succeeded.

The pgpool log has the following information:

2013-08-29 19:46:37 ERROR: pid 15910: read_kind_from_backend: 1 th kind 
C does not match with master or majority connection kind D
2013-08-29 19:46:37 ERROR: pid 15910: kind mismatch among backends. 
Possible last query was: "SELECT c.relchecks, c.relkind, c.relhasindex, 
c.relhasrules, c.relhastriggers, c.relhasoids, '', c.reltablespace, CASE 
WHEN c.reloftype = 0 THEN '' ELSE 
c.reloftype::pg_catalog.regtype::pg_catalog.text END, c.relpersistence
FROM pg_catalog.pg_class c
  LEFT JOIN pg_catalog.pg_class tc ON (c.reltoastrelid = tc.oid)
WHERE c.oid = '919011';" kind details are: 0[D] 1[C]
2013-08-29 19:46:37 LOG:   pid 15910: do_child: exits with status 1 due 
to error

-----------------------------------------------------------------------------
There is no problem with the '\dt gfu' command as below

[sd3dev1.dev1_admin].sd3dev1> \dt gfu
          List of relations
  Schema | Name | Type  |   Owner
--------+------+-------+------------
  public | gfu  | table | dev1_admin


And there is no problem, if the psql connect to the db server directly

7:42pm 306 gfu at sd3dev1:~$ psql -h sd3db5
psql (9.2.4)
Type "help" for help.

[sd3db5.dev1_admin].sd3dev1> \d gfu
       Table "public.gfu"
  Column |  Type   | Modifiers
--------+---------+-----------
  id     | integer |


Any explanation and how to resolve the problem ?

Thanks,
Gary