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

[Tatsuo Ishii]

The bug has been already fixed in V3_3_STABLE head.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

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