<div dir="ltr">Hi Yugo,<div><br></div><div>Thanks for your response. Let me prepare a test environment and i will send them to you. I hope I will be able to send them to you by next week.</div><div><br></div><div>Thank you,</div>
<div><br></div><div>Jose Maria.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 26 May 2014 10:59, Yugo Nagata <span dir="ltr"><<a href="mailto:nagata@sraoss.co.jp" target="_blank">nagata@sraoss.co.jp</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<div class=""><br>
<br>
On Mon, 19 May 2014 12:20:35 +0200<br>
Jose Maria Alvarez Fernandez <<a href="mailto:josemaria.alvarez@2020mobile.es">josemaria.alvarez@2020mobile.es</a>> wrote:<br>
<br>
> Hi all,<br>
><br>
> I am writing because I would need some help with a strange behaviour we are<br>
> having with our pgpool2 installation.<br>
><br>
> Our deployment includes two Postgresql 9.3.4 servers in synchronous<br>
> streaming replication, and a pgpool2 cluster with watchdog configured to<br>
> access them, in replication mode and with load balancing.<br>
><br>
> When we deployed the 3.3.2 versión, we saw an unexpected behaviour that<br>
> wasn't there in the 3.3.1 release. Our application started to get deadlocks<br>
> when introducing data from different threads simultaneously. I think I've<br>
> narrowed the problem to this bugfix introduced in 3.3.2:<br>
><br>
> Fix data inconsistency problem with native replication mode + extended<br>
> protocol case<br>
><br>
> Per bug report by Steve Kuekes in [pgpool-general: 2142].<br>
> <a href="http://www.sraoss.jp/pipermail/pgpool-general/2013-September/002171.html" target="_blank">http://www.sraoss.jp/pipermail/pgpool-general/2013-September/002171.html</a><br>
<br>
</div>How did you check the commit is the problem? By usign git bisect?<br>
<br>
For analysis, the exact log messages of pgpool with log_statement=on<br>
and backend log are helpful for me. Could you please send me this?<br>
<div class=""><br>
><br>
> It seems that, as our application is using OpenJPA to manage data, and<br>
> it doesn't ensure the insert order, some of the inserts trying to get<br>
> a lock in a table that other thread as already locked, but this thread<br>
> is also trying to acquire a lock in a table that the other thread has<br>
> already locked, due to the unordered insert statements.<br>
><br>
> Does anyone have an idea of how can we workaround this, to keep pgpool2<br>
> versions up to date? I haven't found an option to force OpenJPA to "order"<br>
> the inserts.<br>
><br>
> Thank you all,<br>
><br>
> Jose Maria.<br>
><br>
</div>> --<br>
><br>
><br>
> Brightstar 20:20 mobile<br>
> C/ Arroyo de los Prados. 5. P.I. Las Arenas. 28320 (MADRID) Spain<br>
><br>
> ------------------------------<br>
><br>
> This e-mail has been sent by Brightstar 20:20 mobile.<br>
><br>
> Telephone number: <a href="tel:%2B34%20911%20032%20160" value="+34911032160">+34 911 032 160</a>.<br>
><br>
> Please see our website for further information, <a href="http://www.brightstar-2020.es/" target="_blank">www.brightstar-2020.es/</a><<a href="http://www.2020mobile.com/confidentiality-notice/" target="_blank">http://www.2020mobile.com/confidentiality-notice/</a>><br>
><br>
> *P please consider the environment and only print this if required*<br>
><br>
> ------------------------------<br>
><br>
><br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
--<br>
Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><span style="font-family:Arial,sans-serif;line-height:13px;font-weight:bold;color:rgb(68,68,68);text-transform:uppercase;font-size:8pt;margin-left:60px">JOSE MARIA ALVAREZ</span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);text-transform:uppercase;margin-left:60px">SYSTEMS ARCHITECT</span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px"><span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);margin-left:60px">Tel: +34 91 103 21 60 (Ext. 316)</span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);margin-left:60px">Móvil: +34 +34 637 792 144 </span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);margin-left:60px">C/ Arroyo de los Prados, 5 - P.I. Las Arenas </span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<span style="font-family:Arial,sans-serif;line-height:13px;font-size:8pt;color:rgb(78,78,86);margin-left:60px">28320 Pinto - Madrid. Spain </span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px"><span style="color:rgb(0,0,0);font-family:Arial,sans-serif;line-height:13px;font-size:8pt;margin-left:60px"><a href="http://www.brightstar-2020.es/" style="text-decoration:none;color:rgb(37,88,126)" target="_blank">www.brightstar-2020.es</a></span><br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px">
<br style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px"><img src="http://www.brightstar-2020.es/logo-email.jpg" style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:medium;line-height:13px"><br>
</div>
</div>
<br>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><span style="font-family:Verdana,sans-serif;color:rgb(153,153,153);font-size:8pt"><font face="Times New Roman">Brightstar 20:20 mobile<font face="Times New Roman"></font><br>C/ Arroyo de los Prados. 5. P.I. Las Arenas. 28320 (MADRID) Spain</font></span></p><span style="background-color:rgb(255,255,255);font-family:Verdana,sans-serif;color:rgb(153,153,153);font-size:8pt"><p></p><hr><p style="margin:0cm 0cm 0pt"><span style="font-size:8pt"><font color="#999999" face="Times New Roman">This e-mail has been sent by Brightstar 20:20 mobile.</font></span></p><p style="margin:0cm 0cm 0pt"><span style="font-family:'Times New Roman';font-size:8pt">Telephone number:</span><span style="font-family:'Times New Roman';font-size:8pt"> </span><a value="+441270412020" style="font-family:'Times New Roman';font-size:8pt;color:rgb(17,85,204)">+34 911 032 160</a><span style="font-family:'Times New Roman';font-size:8pt">.</span></p><p style="margin:0cm 0cm 0pt"><span style="font-size:8pt"><font face="Times New Roman"><font color="#999999">Please see our website for further information,</font> <a href="http://www.2020mobile.com/confidentiality-notice/" style="color:rgb(17,85,204)" target="_blank">www.brightstar-<WBR>2020.es/</a></font></span></p><p><font face="Times New Roman"></font></p><font size="+0"></font><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p><p></p></span><font size="+0" style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><font size="1"><font color="#c0c0c0"><font face="Times New Roman"><font color="#c0c0c0"></font><span style="color:blue"></span></font></font></font></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><strong><font face="Times New Roman"><font size="1"><span style="font-family:Webdings;color:green">P</span><span style="color:green"> please consider the environment and only print this if required</span></font></font></strong></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><font size="+0" style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><font size="+0" style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></p><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255);margin:0cm 0cm 0pt"><span style="font-family:Verdana,sans-serif;color:rgb(153,153,153);font-size:8pt"></span></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><strong><font face="Times New Roman"><font size="3"><span style="color:green"></span></font></font></strong></p><font face="Times New Roman" style="color:rgb(34,34,34);background-color:rgb(255,255,255)"></font><span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"></span><hr style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><p style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><br></p>