[pgpool-general: 5956] Re: pgpool load balancing problem

Thu Mar 1 02:03:36 JST 2018

Yeah or if you build your own Deb package or something.
You can see in the patch-file which src-file will be patched.

Mit herzlichen Grüßen

Mathias Buresch
Systems Engineer
-- 
mathias.buresch at de.clara.net
Tel: +49 (69) 40 80 18 - 265
Fax: +49 (69) 40 80 18 - 129

Claranet GmbH
Hanauer Landstraße 196
60314 Frankfurt

Geschäftsführung Olaf Fischer
Hrb 50381 AG Frankfurt am Main
Vat-ID de 812918694

http://www.claranet.de

> On 28. Feb 2018, at 18:00, Mariel Cherkassky <mariel.cherkassky at gmail.com> wrote:
> 
> When you say compile it yourself you mean run make and make install again ?
> 
> 2018-02-28 18:39 GMT+02:00 Mathias Buresch <mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>>:
> Hi,
> 
> at the top of the link I posted there is a link called “patch”
> 
> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04 <https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04>
> 
> But here is the direct-link -> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04 <https://git.postgresql.org/gitweb/?p=pgpool2.git;a=patch;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04>
> 
> As I mentioned only if you compile it by yourself because this will patch the sources.
> 
> Mit herzlichen Grüßen
> 
> Mathias Buresch
> Systems Engineer
> -- 
> mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>
> Tel: +49 (69) 40 80 18 - 265
> Fax: +49 (69) 40 80 18 - 129
> 
> Claranet GmbH
> Hanauer Landstraße 196 <https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g>
> 60314 Frankfurt <https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g>
> 
> Geschäftsführung Olaf Fischer
> Hrb 50381 AG Frankfurt am Main
> Vat-ID de 812918694
> 
> http://www.claranet.de <http://www.claranet.de/>
> 
> 
> 
> 
>> On 28. Feb 2018, at 17:36, Mariel Cherkassky <mariel.cherkassky at gmail.com <mailto:mariel.cherkassky at gmail.com>> wrote:
>> 
>> Hi,
>> first of all thanks !
>> Can you attach the patch you mentioned ? or a link to the patch ?
>> 
>> 2018-02-28 18:15 GMT+02:00 Mathias Buresch <mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>>:
>> Hi,
>> 
>> I reported that problem yesterday too. Maybe someone did it already before me..
>> 
>> I don’t know if you can access this -> Re: [pgpool-general: 5939] Re: PgPool 3.7.2 forwards write statements to Standby
>> .. But here is the explanation in short:
>> 
>> Problem: (posted by Tatsuo Ishii)
>> 
>> Today I have just found a serious regression in 3.7.2: it does not
>> work if the primary is other than node 0, sending write queries to
>> node 0, which is the standby (In my testing, 3.7.2 does work if the
>> primary is node 0). I guess your primary is not node 0, right?
>> 
>> The cause was this commit [1]:
>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d <https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=36517db60a829422d382debb7aa3256fac5da26d>
>> 
>> So I today reverted the commit [2]:
>> https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04 <https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=e8baa3f0ee1a24f833cfa6cc5d0104b5cefe7b04>
>> 
>> Until 3.7.3 is released, you could:
>> 
>> 1) Let node 0 to be the primary
>> 
>> 2) down grade to 3.7.1
>> 
>> 3) Apply the patch [2] to 3.7.2.
>> 
>> Sorry for the inconvenience.
>> 
>> 
>> Solution:
>> 
>> If you compile the software by yourself you could enable the patch provided by him.
>> Or install the 3.7.1 for RedHat.
>> If you run Ubuntu (like me) then you can download old Deb and install the old packages (libpgpool0, pgpool2, postgresql-xx.pgpool2).
>> -> http://atalia.postgresql.org/morgue/p/pgpool2/ <http://atalia.postgresql.org/morgue/p/pgpool2/> (don’t forget to set packages on “hold”)
>> 
>> 
>> 
>> 
>> Mit herzlichen Grüßen
>> 
>> Mathias Buresch
>> Systems Engineer
>> -- 
>> mathias.buresch at de.clara.net <mailto:mathias.buresch at de.clara.net>
>> Tel: +49 (69) 40 80 18 - 265
>> Fax: +49 (69) 40 80 18 - 129
>> 
>> Claranet GmbH
>> Hanauer Landstraße 196 <https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g>
>> 60314 Frankfurt <https://maps.google.com/?q=Hanauer+Landstra%C3%9Fe+196+60314+Frankfurt&entry=gmail&source=g>
>> 
>> Geschäftsführung Olaf Fischer
>> Hrb 50381 AG Frankfurt am Main
>> Vat-ID de 812918694
>> 
>> http://www.claranet.de <http://www.claranet.de/>
>> 
>> 
>> 
>> 
>>> On 28. Feb 2018, at 17:05, Mariel Cherkassky <mariel.cherkassky at gmail.com <mailto:mariel.cherkassky at gmail.com>> wrote:
>>> 
>>> Hi,
>>> 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 : 
>>> 
>>> ERROR: cannot execute CREATE TABLE in a read-only transaction
>>> SQL state: 25006
>>> 
>>> 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 ..
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net <mailto:pgpool-general at pgpool.net>
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general <http://www.pgpool.net/mailman/listinfo/pgpool-general>
>> 
>> 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180228/8fe42c28/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3815 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180228/8fe42c28/attachment-0001.p7s>