<div dir="ltr"><div><div>Hi, we use two AG unified push servers with Oracle DB in cluster, but we have some problem with deadlock (probably caused by clean up by both servers at the same time).</div><div>We used DB owner PUSHSRVAG and application DB account APUSHSRVAG.</div><div><br></div><div>(version ... my fork (with small change in dev) ... <a href="https://github.com/IvanGurtler/aerogear-unifiedpush-server/tree/MyBranch">https://github.com/IvanGurtler/aerogear-unifiedpush-server/tree/MyBranch</a>)</div><div><br></div><div>Is possible change some settings to prevent deadlock ? or some different solution ?</div><div><br></div><div>-----------------------------------------------------------------------------------------</div><div><br></div><div>*** 2015-04-10 00:00:04.506</div><div>*** SESSION ID:(84.48937) 2015-04-10 00:00:04.506</div><div>*** CLIENT ID:() 2015-04-10 00:00:04.506</div><div>*** SERVICE NAME:(SYS$USERS) 2015-04-10 00:00:04.506</div><div>*** MODULE NAME:(JDBC Thin Client) 2015-04-10 00:00:04.506</div><div>*** CLIENT DRIVER:(jdbcthin) 2015-04-10 00:00:04.506</div><div>*** ACTION NAME:() 2015-04-10 00:00:04.506</div><div> </div><div> </div><div><br></div><div>*** 2015-04-10 00:00:04.506</div><div>DEADLOCK DETECTED ( ORA-00060 )</div><div>See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors</div><div>[Transaction Deadlock]</div><div> </div><div>The following deadlock is not an ORACLE error. It is a</div><div>deadlock due to user error in the design of an application</div><div>or from issuing incorrect ad-hoc SQL. The following</div><div>information may aid in determining the deadlock:</div><div> </div><div>Deadlock graph:</div><div> ---------Blocker(s)-------- ---------Waiter(s)---------</div><div>Resource Name process session holds waits process session holds waits</div><div>TM-00013891-00000000-00000000-00000000 142 84 SX SSX 144 162 SX SSX</div><div>TM-00013891-00000000-00000000-00000000 144 162 SX SSX 142 84 SX SSX</div><div> </div><div> <br></div><div>Rows waited on:</div><div> Session 84: no row</div><div> Session 162: no row</div><div> </div><div>----- Information for the OTHER waiting sessions -----</div><div>Session 162:</div><div> sid: 162 ser: 54036 audsid: 10790094 user: 115/APUSHSRVAG</div><div> flags: (0x41) USR/- flags_idl: (0x1) BSY/-/-/-/-/-</div><div> flags2: (0x40009) -/-/INC</div><div> pid: 144 O/S info: user: oracle, term: UNKNOWN, ospid: 11534420</div><div> image: oracle@s16000ks</div><div> client details:</div><div> O/S info: user: jbotp, term: unknown, ospid: 1234</div><div> machine: s1.sk.srv.acc.sys program: JDBC Thin Client</div><div> application name: JDBC Thin Client, hash value=2546894660</div><div> current SQL:</div><div> delete from PUSHSRVAG.PushMessageInformation where submitDate<:1 </div><div> </div><div>----- End of information for the OTHER waiting sessions -----</div><div> </div><div>Information for THIS session:</div><div> </div><div>----- Current SQL Statement for this session (sql_id=bsk109wpq55yg) -----</div><div>delete from PUSHSRVAG.PushMessageInformation where submitDate<:1 </div></div><div><br></div><div>-----------------------------------------------------------------------------------------<br></div><div><br></div><div><br></div><div><br></div><div><br></div><div>Thanks </div><div><br></div><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><span style="color:rgb(7,55,99)"><b>Mgr. Ivan Gürtler</b></span><br></div><span style="color:rgb(102,102,102)">Mobile software developer</span><br><br>AHEAD iTec, s.r.o., Botanická 554/68a,<br>602 00 Brno (Czech Republic)<br><br><a href="http://www.ahead-itec.com/" style="color:rgb(17,85,204)" target="_blank">www.ahead-itec.com</a> | <a href="https://www.twitter.com/AHEADiTec" style="color:rgb(17,85,204)" target="_blank">twitter</a> | mobile security solutions<br></div></div></div>
</div>