<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="">Yeah or if you build your own Deb package or something.<div class="">You can see in the patch-file which src-file will be patched.<br 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 18:00, 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="">When you say compile it yourself you mean run make and make install again ?</div></div><div class="gmail_extra"><br class=""><div class="gmail_quote"><div dir="ltr" class="">2018-02-28 18:39 GMT+02:00 Mathias Buresch <span dir="ltr" class=""><<a href="mailto:mathias.buresch@de.clara.net" target="_blank" class="">mathias.buresch@de.clara.net</a>></span>:</div><blockquote class="gmail_quote" style="margin:0 .8ex;border-left:1px #ccc solid;border-right:1px #ccc solid;padding-left:1ex;padding-right:1ex"><div style="word-wrap:break-word;line-break:after-white-space" class="">Hi,<div class=""><br class=""></div><div class="">at the top of the link I posted there is a link called “patch”</div><div class=""><br class=""></div><div class=""><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04" target="_blank" class=""><font face="ArialMT" class="">https://git.postgresql.org/</font><font face="ArialMT" class="">git<wbr class="">web/?p=pgpool2.git;a=commit;h=<wbr class="">e8baa3f0ee1a24f833cfa6cc5d0104<wbr class="">b5cefe7b04</font></a></div><div class=""><br class=""></div><div class="">But here is the direct-link -> <a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04" target="_blank" class="">https://git.postgresql.org/<wbr class="">gitweb/?p=pgpool2.git;a=patch;<wbr class="">h=<wbr class="">e8baa3f0ee1a24f833cfa6cc5d0104<wbr class="">b5cefe7b04</a></div><div class=""><br class=""></div><div class="">As I mentioned only if you compile it by yourself because this will patch the sources.</div><div class=""><span 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" target="_blank" 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=""><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g" class="">Hanauer Landstraße 196</a><br class=""><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g" class="">60314 Frankfurt</a><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=""><a href="http://www.claranet.de/" target="_blank" class="">http://www.claranet.de</a><br class=""><br class=""><br class=""><br class="">
</div>
</span><div class=""><div class="h5"><div class=""><br class=""><blockquote type="cite" class=""><div class="">On 28. Feb 2018, at 17:36, Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" target="_blank" class="">mariel.cherkassky@gmail.com</a>> wrote:</div><br class="m_3974173618883497140Apple-interchange-newline"><div class=""><div dir="rtl" class=""><div dir="ltr" class="">Hi,</div><div dir="ltr" class="">first of all thanks !</div><div dir="ltr" class="">Can you attach the patch you mentioned ? or a link to the patch ?</div></div><div class="gmail_extra"><br class=""><div class="gmail_quote"><div dir="ltr" class="">2018-02-28 18:15 GMT+02:00 Mathias Buresch <span dir="ltr" class=""><<a href="mailto:mathias.buresch@de.clara.net" target="_blank" class="">mathias.buresch@de.clara.net</a>></span><wbr class="">:</div><blockquote class="gmail_quote" style="margin:0 .8ex;border-left:1px #ccc solid;border-right:1px #ccc solid;padding-left:1ex;padding-right:1ex"><div style="word-wrap:break-word;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="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="font-family:"Helvetica Neue"" class="">.. But here is the explanation in short:</span></div><div class=""><span style="font-family:"Helvetica Neue"" class=""><br class=""></span></div><div class=""><span style="font-family:"Helvetica Neue";font-size:14px" class=""><b class="">Problem: (posted by Tatsuo Ishii)</b></span></div><div class=""><span style="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" target="_blank" class="">https://git.postgresql.org/git<wbr class="">web/?p=pgpool2.git;a=commit;h=<wbr class="">36517db60a829422d382debb7aa325<wbr class="">6fac5da26d</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" target="_blank" class="">https://git.postgresql.org/git<wbr class="">web/?p=pgpool2.git;a=commit;h=<wbr class="">e8baa3f0ee1a24f833cfa6cc5d0104<wbr class="">b5cefe7b04</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/" target="_blank" class="">http://atalia.postgresql.or<wbr class="">g/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" target="_blank" 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=""><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g" target="_blank" class="">Hanauer Landstraße 196</a><br class=""><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g" target="_blank" class="">60314 Frankfurt</a><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=""><a href="http://www.claranet.de/" target="_blank" class="">http://www.claranet.de</a><br class=""><br class=""><br class=""><br class="">
</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class=""><div class="m_3974173618883497140h5"><div class="">On 28. Feb 2018, at 17:05, Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" target="_blank" class="">mariel.cherkassky@gmail.com</a>> wrote:</div><br class="m_3974173618883497140m_5719806315459832255Apple-interchange-newline"></div></div><div class=""><div class=""><div class="m_3974173618883497140h5"><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></div></div>
______________________________<wbr class="">_________________<br class="">pgpool-general mailing list<br class=""><a href="mailto:pgpool-general@pgpool.net" target="_blank" class="">pgpool-general@pgpool.net</a><br class=""><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank" class="">http://www.pgpool.net/mailman/<wbr class="">listinfo/pgpool-general</a><br class=""></div></blockquote></div><br class=""></div></div></blockquote></div><br class=""></div>
</div></blockquote></div><br class=""></div></div></div></div></blockquote></div><br class=""></div>
</div></blockquote></div><br class=""></div></body></html>