<div dir="ltr">Hi all,<div><br></div><div>I am writing because I would need some help with a strange behaviour we are having with our pgpool2 installation.</div><div><br></div><div>Our deployment includes two Postgresql 9.3.4 servers in synchronous streaming replication, and a pgpool2 cluster with watchdog configured to access them, in replication mode and with load balancing.</div>
<div><br></div><div>When we deployed the 3.3.2 versión, we saw an unexpected behaviour that wasn't there in the 3.3.1 release. Our application started to get deadlocks when introducing data from different threads simultaneously. I think I've narrowed the problem to this bugfix introduced in 3.3.2:</div>
<div><br></div><div><pre style="color:rgb(0,0,0);word-wrap:break-word;white-space:pre-wrap">Fix data inconsistency problem with native replication mode + extended
protocol case</pre><div><pre style="color:rgb(0,0,0);word-wrap:break-word;white-space:pre-wrap">Per bug report by Steve Kuekes in [pgpool-general: 2142].
<a href="http://www.sraoss.jp/pipermail/pgpool-general/2013-September/002171.html">http://www.sraoss.jp/pipermail/pgpool-general/2013-September/002171.html</a></pre><pre style="color:rgb(0,0,0);word-wrap:break-word;white-space:pre-wrap">
<span style="font-family:arial;color:rgb(34,34,34)">It seems that, as our application is using OpenJPA to manage data, and it doesn't ensure the insert order, some of the inserts trying to get a lock in a table that other thread as already locked, but this thread is also trying to acquire a lock in a table that the other thread has already locked, due to the unordered insert statements. </span><br>
</pre>Does anyone have an idea of how can we workaround this, to keep pgpool2 versions up to date? I haven't found an option to force OpenJPA to "order" the inserts.</div><div><br></div><div>Thank you all,</div>
<div><br></div><div>Jose Maria.</div><div dir="ltr"><br></div>
</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>