[pgpool-general: 1722] [PgPool-II 3.2.4] pgpool_regclass now mandatory?

[Thomas Martin]

Hello all.

I tried Pgpool-II 3.2.4 and it seems that the pgpool_regclass is now
mandatory?
Indeed pgpool have degenerated a node just after I put the 3.2.4 version in
production; here is the logs:

May 13 09:55:00 node1 pgpool-II[10714]: connection received: host=192.0.0.7
port=36766
May 13 09:55:00 node1 pgpool-II[10714]: do_query: error message from
backend function "pgpool_regclass(cstring)" does not exist
May 13 09:55:00 node1 pgpool-II[10714]: do_query: error message from
backend current transaction is aborted, commands ignored until end of
transaction block
May 13 09:55:00 node1 pgpool-II[10714]: do_query: error message from
backend current transaction is aborted, commands ignored until end of
transaction block
May 13 09:55:00 node1 pgpool-II[10714]: pool_send_and_wait: Error or notice
message from backend: : DB node id: 0 backend pid: 10736 statement: INSERT
INTO blablabla; message: current transaction is aborted, commands ignored
until end of transaction block
May 13 09:55:00 node1 pgpool-II[10714]: read_kind_from_backend: 1 th kind C
does not match with master or majority connection kind E
May 13 09:55:00 node1 pgpool-II[10714]: kind mismatch among backends.
Possible last query was: "INSERT INTO blablabla;" kind details are: 0[E:
current transaction is aborted, commands ignored until end of transaction
block] 1[C]
May 13 09:55:00 node1 pgpool-II[10714]: degenerate_backend_set: 1 fail over
request from pid 10714
May 13 09:55:00 node1 pgpool-II[10169]: starting degeneration. shutdown
host 192.0.0.19(5432)
May 13 09:55:00 node1 pgpool-II[10169]: Restart all children
May 13 09:55:00 node1 pgpool-II[10169]: execute command: sudo
/usr/bin/block_failed_db 1 &
May 13 09:55:00 node1 pgpool-II[10169]: failover: set new primary node: -1
May 13 09:55:00 node1 pgpool-II[10169]: failover: set new master node: 0
May 13 09:55:00 node1 pgpool-II[10169]: failover done. shutdown host
192.0.0.19(5432)
May 13 09:55:00 node1 pgpool-II[10316]: worker process received restart
request
May 13 09:55:00 node1 pgpool-II[10756]: connection received:
host=192.0.0.117 port=54452

I never added the table to my databases before (even I know that it's
"strongly recommended" in the documentation) and I'm using PgPool since
several years now.
According to releases notes I guess this is related to the changes about
pool_has_pgpool_regclass.

So my question is: does I really need to add the pgpool_regclass in my
databases or it's a side effect of the 3.4.8 which could be corrected in
the future?

Thanks.

Regards.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130513/41e7a9be/attachment.html>