<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">I reported that problem yesterday too. Maybe someone did it already before me..</div><div class=""><br class=""></div><div class="">I don’t know if you can access this -> <span style="color: rgba(0, 0, 0, 0.85098); font-family: "Helvetica Neue";" class="">Re: [pgpool-general: 5939] Re: PgPool 3.7.2 forwards write statements to Standby</span></div><div class=""><span style="color: rgba(0, 0, 0, 0.85098); font-family: "Helvetica Neue";" class="">.. But here is the explanation in short:</span></div><div class=""><span style="color: rgba(0, 0, 0, 0.85098); font-family: "Helvetica Neue";" class=""><br class=""></span></div><div class=""><span style="color: rgba(0, 0, 0, 0.85098); font-family: "Helvetica Neue"; font-size: 14px;" class=""><b class="">Problem: (posted by Tatsuo Ishii)</b></span></div><div class=""><span style="color: rgba(0, 0, 0, 0.85098); font-family: "Helvetica Neue";" class=""><br class=""></span></div><div class=""><span style="font-family: ArialMT;" class="">Today I have just found a serious regression in 3.7.2: it does not</span><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">work if the primary is other than node 0, sending write queries to</span><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">node 0, which is the standby (In my testing, 3.7.2 does work if the</span><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">primary is node 0). I guess your primary is not node 0, right?</span><br style="font-family: ArialMT;" class=""><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">The cause was this commit [1]:</span><br style="font-family: ArialMT;" class=""><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d" style="font-family: ArialMT;" class="">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d</a><br style="font-family: ArialMT;" class=""><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">So I today reverted the commit [2]:</span><br style="font-family: ArialMT;" class=""><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04" style="font-family: ArialMT;" class="">https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04</a><br style="font-family: ArialMT;" class=""><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">Until 3.7.3 is released, you could:</span><br style="font-family: ArialMT;" class=""><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">1) Let node 0 to be the primary</span><br style="font-family: ArialMT;" class=""><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">2) down grade to 3.7.1</span><br style="font-family: ArialMT;" class=""><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">3) Apply the patch [2] to 3.7.2.</span><br style="font-family: ArialMT;" class=""><br style="font-family: ArialMT;" class=""><span style="font-family: ArialMT;" class="">Sorry for the inconvenience.</span></div><div class=""><span style="font-family: ArialMT;" class=""><br class=""></span></div><div class=""><span style="font-family: ArialMT;" class=""><br class=""></span></div><div class=""><font face="ArialMT" class=""><b style="font-size: 14px;" class="">Solution:</b></font></div><div class=""><font face="ArialMT" class=""><br class=""></font></div><div class=""><font face="ArialMT" class="">If you compile the software by yourself you could enable the patch provided by him.</font></div><div class=""><font face="ArialMT" class="">Or install the 3.7.1 for RedHat.</font></div><div class=""><font face="ArialMT" class="">If you run Ubuntu (like me) then you can download old Deb and install the old packages (libpgpool0, pgpool2, postgresql-xx.pgpool2).</font></div><div class=""><font face="ArialMT" class="">-> <a href="http://atalia.postgresql.org/morgue/p/pgpool2/" class="">http://atalia.postgresql.org/morgue/p/pgpool2/</a></font> (don’t forget to set packages on “hold”)</div><div class=""><span style="font-family: ArialMT;" class=""><br class=""></span></div><div class=""><span style="font-family: ArialMT;" class=""><br class=""></span></div><div class=""><br class=""></div><div class=""><div class="">
<br class="">Mit herzlichen Grüßen<br class=""><br class="">Mathias Buresch<br class="">Systems Engineer<br class="">-- <br class=""><a href="mailto:mathias.buresch@de.clara.net" class="">mathias.buresch@de.clara.net</a><br class="">Tel: +49 (69) 40 80 18 - 265<br class="">Fax: +49 (69) 40 80 18 - 129<br class=""><br class="">Claranet GmbH<br class="">Hanauer Landstraße 196<br class="">60314 Frankfurt<br class=""><br class="">Geschäftsführung Olaf Fischer<br class="">Hrb 50381 AG Frankfurt am Main<br class="">Vat-ID de 812918694<br class=""><br class="">http://www.claranet.de<br class=""><br class=""><br class=""><br class="">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 28. Feb 2018, at 17:05, Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" class="">mariel.cherkassky@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div dir="rtl" class=""><div dir="ltr" class="">Hi,</div><div dir="ltr" class="">I found a problem that had a big impact on our servers. I'm using pgpool as a load balancer and pool connections manager. When a user tries to run a select query it redirects the query to the slave. If the user tries after that to run dml or ddl command he get error : </div><div dir="ltr" class=""><br class=""></div><div dir="ltr" class=""><div dir="ltr" class="">ERROR: cannot execute CREATE TABLE in a read-only transaction</div><div dir="ltr" class="">SQL state: 25006</div><div dir="ltr" class=""><br class=""></div><div class="">Is there any way to solve this issue ? It means that once the pool redirected your session to the slaves you cant run any ddl/dml actions ..</div></div></div>
_______________________________________________<br class="">pgpool-general mailing list<br class=""><a href="mailto:pgpool-general@pgpool.net" class="">pgpool-general@pgpool.net</a><br class="">http://www.pgpool.net/mailman/listinfo/pgpool-general<br class=""></div></blockquote></div><br class=""></div></body></html>