<div dir="rtl"><div dir="ltr">Hi,</div><div dir="ltr">I did the changes you mentioned, the pool.h code : </div><div dir="ltr"><img src="cid:ii_161dd703b36ea117" alt="תמונה מוטבעת 1" width="471" height="174"><br></div><div dir="ltr"><br></div><div dir="ltr">But I'm still getting the same error</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div dir="ltr">2018-02-28 19:03 GMT+02:00 Mathias Buresch <span dir="ltr"><<a href="mailto:mathias.buresch@de.clara.net" target="_blank">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">Yeah or if you build your own Deb package or something.<div>You can see in the patch-file which src-file will be patched.<span class=""><br><div>
<br>Mit herzlichen Grüßen<br><br>Mathias Buresch<br>Systems Engineer<br>-- <br><a href="mailto:mathias.buresch@de.clara.net" target="_blank">mathias.buresch@de.clara.net</a><br>Tel: +49 (69) 40 80 18 - 265<br>Fax: +49 (69) 40 80 18 - 129<br><br>Claranet GmbH<br><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g">Hanauer Landstraße 196</a><br><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g">60314 Frankfurt</a><br><br>Geschäftsführung Olaf Fischer<br>Hrb 50381 AG Frankfurt am Main<br>Vat-ID de 812918694<br><br><a href="http://www.claranet.de" target="_blank">http://www.claranet.de</a><br><br><br><br>
</div>
</span><div><div class="h5"><div><br><blockquote type="cite"><div>On 28. Feb 2018, at 18:00, Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" target="_blank">mariel.cherkassky@gmail.com</a>> wrote:</div><br class="m_4345492838635014367Apple-interchange-newline"><div><div dir="rtl"><div dir="ltr">When you say compile it yourself you mean run make and make install again ?</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div dir="ltr">2018-02-28 18:39 GMT+02:00 Mathias Buresch <span dir="ltr"><<a href="mailto:mathias.buresch@de.clara.net" target="_blank">mathias.buresch@de.clara.net</a>></span><wbr>:</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">Hi,<div><br></div><div>at the top of the link I posted there is a link called “patch”</div><div><br></div><div><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04" target="_blank"><font face="ArialMT">https://git.postgresql.org/</font><font face="ArialMT">git<wbr>web/?p=pgpool2.git;a=commit;h=<wbr>e8baa3f0ee1a24f833cfa6cc5d0104<wbr>b5cefe7b04</font></a></div><div><br></div><div>But here is the direct-link -> <a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04" target="_blank">https://git.postgresql.org/<wbr>gitweb/?p=pgpool2.git;a=patch;<wbr>h=e8baa3f0ee1a24f833cfa6cc5d01<wbr>04b5cefe7b04</a></div><div><br></div><div>As I mentioned only if you compile it by yourself because this will patch the sources.</div><div><span><div>
<br>Mit herzlichen Grüßen<br><br>Mathias Buresch<br>Systems Engineer<br>-- <br><a href="mailto:mathias.buresch@de.clara.net" target="_blank">mathias.buresch@de.clara.net</a><br>Tel: +49 (69) 40 80 18 - 265<br>Fax: +49 (69) 40 80 18 - 129<br><br>Claranet GmbH<br><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g" target="_blank">Hanauer Landstraße 196</a><br><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g" target="_blank">60314 Frankfurt</a><br><br>Geschäftsführung Olaf Fischer<br>Hrb 50381 AG Frankfurt am Main<br>Vat-ID de 812918694<br><br><a href="http://www.claranet.de/" target="_blank">http://www.claranet.de</a><br><br><br><br>
</div>
</span><div><div class="m_4345492838635014367h5"><div><br><blockquote type="cite"><div>On 28. Feb 2018, at 17:36, Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" target="_blank">mariel.cherkassky@gmail.com</a>> wrote:</div><br class="m_4345492838635014367m_3974173618883497140Apple-interchange-newline"><div><div dir="rtl"><div dir="ltr">Hi,</div><div dir="ltr">first of all thanks !</div><div dir="ltr">Can you attach the patch you mentioned ? or a link to the patch ?</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div dir="ltr">2018-02-28 18:15 GMT+02:00 Mathias Buresch <span dir="ltr"><<a href="mailto:mathias.buresch@de.clara.net" target="_blank">mathias.buresch@de.clara.net</a>></span><wbr>:</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">Hi,<div><br></div><div>I reported that problem yesterday too. Maybe someone did it already before me..</div><div><br></div><div>I don’t know if you can access this -> <span style="font-family:"Helvetica Neue"">Re: [pgpool-general: 5939] Re: PgPool 3.7.2 forwards write statements to Standby</span></div><div><span style="font-family:"Helvetica Neue"">.. But here is the explanation in short:</span></div><div><span style="font-family:"Helvetica Neue""><br></span></div><div><span style="font-family:"Helvetica Neue";font-size:14px"><b>Problem: (posted by Tatsuo Ishii)</b></span></div><div><span style="font-family:"Helvetica Neue""><br></span></div><div><span style="font-family:ArialMT">Today I have just found a serious regression in 3.7.2: it does not</span><br style="font-family:ArialMT"><span style="font-family:ArialMT">work if the primary is other than node 0, sending write queries to</span><br style="font-family:ArialMT"><span style="font-family:ArialMT">node 0, which is the standby (In my testing, 3.7.2 does work if the</span><br style="font-family:ArialMT"><span style="font-family:ArialMT">primary is node 0). I guess your primary is not node 0, right?</span><br style="font-family:ArialMT"><br style="font-family:ArialMT"><span style="font-family:ArialMT">The cause was this commit [1]:</span><br style="font-family:ArialMT"><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d" style="font-family:ArialMT" target="_blank">https://git.postgresql.org/git<wbr>web/?p=pgpool2.git;a=commit;h=<wbr>36517db60a829422d382debb7aa325<wbr>6fac5da26d</a><br style="font-family:ArialMT"><br style="font-family:ArialMT"><span style="font-family:ArialMT">So I today reverted the commit [2]:</span><br style="font-family:ArialMT"><a href="https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04" style="font-family:ArialMT" target="_blank">https://git.postgresql.org/git<wbr>web/?p=pgpool2.git;a=commit;h=<wbr>e8baa3f0ee1a24f833cfa6cc5d0104<wbr>b5cefe7b04</a><br style="font-family:ArialMT"><br style="font-family:ArialMT"><span style="font-family:ArialMT">Until 3.7.3 is released, you could:</span><br style="font-family:ArialMT"><br style="font-family:ArialMT"><span style="font-family:ArialMT">1) Let node 0 to be the primary</span><br style="font-family:ArialMT"><br style="font-family:ArialMT"><span style="font-family:ArialMT">2) down grade to 3.7.1</span><br style="font-family:ArialMT"><br style="font-family:ArialMT"><span style="font-family:ArialMT">3) Apply the patch [2] to 3.7.2.</span><br style="font-family:ArialMT"><br style="font-family:ArialMT"><span style="font-family:ArialMT">Sorry for the inconvenience.</span></div><div><span style="font-family:ArialMT"><br></span></div><div><span style="font-family:ArialMT"><br></span></div><div><font face="ArialMT"><b style="font-size:14px">Solution:</b></font></div><div><font face="ArialMT"><br></font></div><div><font face="ArialMT">If you compile the software by yourself you could enable the patch provided by him.</font></div><div><font face="ArialMT">Or install the 3.7.1 for RedHat.</font></div><div><font face="ArialMT">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><font face="ArialMT">-> <a href="http://atalia.postgresql.org/morgue/p/pgpool2/" target="_blank">http://atalia.postgresql.or<wbr>g/morgue/p/pgpool2/</a></font> (don’t forget to set packages on “hold”)</div><div><span style="font-family:ArialMT"><br></span></div><div><span style="font-family:ArialMT"><br></span></div><div><br></div><div><div>
<br>Mit herzlichen Grüßen<br><br>Mathias Buresch<br>Systems Engineer<br>-- <br><a href="mailto:mathias.buresch@de.clara.net" target="_blank">mathias.buresch@de.clara.net</a><br>Tel: +49 (69) 40 80 18 - 265<br>Fax: +49 (69) 40 80 18 - 129<br><br>Claranet GmbH<br><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g" target="_blank">Hanauer Landstraße 196</a><br><a href="https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g" target="_blank">60314 Frankfurt</a><br><br>Geschäftsführung Olaf Fischer<br>Hrb 50381 AG Frankfurt am Main<br>Vat-ID de 812918694<br><br><a href="http://www.claranet.de/" target="_blank">http://www.claranet.de</a><br><br><br><br>
</div>
<div><br><blockquote type="cite"><div><div class="m_4345492838635014367m_3974173618883497140h5"><div>On 28. Feb 2018, at 17:05, Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" target="_blank">mariel.cherkassky@gmail.com</a>> wrote:</div><br class="m_4345492838635014367m_3974173618883497140m_5719806315459832255Apple-interchange-newline"></div></div><div><div><div class="m_4345492838635014367m_3974173618883497140h5"><div dir="rtl"><div dir="ltr">Hi,</div><div dir="ltr">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"><br></div><div dir="ltr"><div dir="ltr">ERROR: cannot execute CREATE TABLE in a read-only transaction</div><div dir="ltr">SQL state: 25006</div><div dir="ltr"><br></div><div>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>_________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br></div></blockquote></div><br></div></div></blockquote></div><br></div>
</div></blockquote></div><br></div></div></div></div></blockquote></div><br></div>
</div></blockquote></div><br></div></div></div></div></blockquote></div><br></div>