<div dir="ltr"><div><div><div><div><div><div><div>Hello all.<br><br></div>I tried Pgpool-II 3.2.4 and it seems that the pgpool_regclass is now mandatory?<br></div>Indeed pgpool have degenerated a node just after I put the 3.2.4 version in production; here is the logs:<br>
<br>May 13 09:55:00 node1 pgpool-II[10714]: connection received: host=192.0.0.7 port=36766<br>May 13 09:55:00 node1 pgpool-II[10714]: do_query: error message from backend function "pgpool_regclass(cstring)" does not exist<br>
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<br>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<br>
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<br>
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<br>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]<br>
May 13 09:55:00 node1 pgpool-II[10714]: degenerate_backend_set: 1 fail over request from pid 10714<br>May 13 09:55:00 node1 pgpool-II[10169]: starting degeneration. shutdown host 192.0.0.19(5432)<br>May 13 09:55:00 node1 pgpool-II[10169]: Restart all children<br>
May 13 09:55:00 node1 pgpool-II[10169]: execute command: sudo /usr/bin/block_failed_db 1 &<br>May 13 09:55:00 node1 pgpool-II[10169]: failover: set new primary node: -1<br>May 13 09:55:00 node1 pgpool-II[10169]: failover: set new master node: 0<br>
May 13 09:55:00 node1 pgpool-II[10169]: failover done. shutdown host 192.0.0.19(5432)<br>May 13 09:55:00 node1 pgpool-II[10316]: worker process received restart request<br>May 13 09:55:00 node1 pgpool-II[10756]: connection received: host=192.0.0.117 port=54452<br>
<br></div>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.<br>According to releases notes I guess this is related to the changes about pool_has_pgpool_regclass.<br>
<br>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?<br></div></div><br></div>Thanks.<br><br></div>Regards.<br>
</div>