<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Apr 10, 2015 at 12:32 PM, Ivan Gürtler <span dir="ltr"><<a href="mailto:ivan.gurtler@ahead-itec.com" target="_blank">ivan.gurtler@ahead-itec.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">And is it possible in current version to set up time for scheduler not to run at midnight?</div></blockquote><div><br></div><div>unfortunately not - we discussed that option, but I am overasked if we actually have a JIRA for that :-)</div><div>But I agree, it should be done, for 1.1.x - for now you would have to tweak your fork :)</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="gmail_extra"><span class=""><br clear="all"><div><div><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>
<br></span><div><div class="h5"><div class="gmail_quote">2015-04-10 11:20 GMT+02:00 Matthias Wessendorf <span dir="ltr"><<a href="mailto:matzew@apache.org" target="_blank">matzew@apache.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Oh, that's this guy, triggered at midnight:<div><a href="https://github.com/aerogear/aerogear-unifiedpush-server/blob/master/service/src/main/java/org/jboss/aerogear/unifiedpush/service/metrics/DeleteOldPushMessageInformationScheduler.java" target="_blank">https://github.com/aerogear/aerogear-unifiedpush-server/blob/master/service/src/main/java/org/jboss/aerogear/unifiedpush/service/metrics/DeleteOldPushMessageInformationScheduler.java</a><br></div><div><br></div><div>It's a singleton, but per node :-/</div><div><br></div><div>Can you create a JIRA ticket for that ? </div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Fri, Apr 10, 2015 at 10:33 AM, Ivan Gürtler <span dir="ltr"><<a href="mailto:ivan.gurtler@ahead-itec.com" target="_blank">ivan.gurtler@ahead-itec.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><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" target="_blank">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: <a href="tel:54036" value="+4954036" target="_blank">54036</a> 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=<a href="tel:2546894660" value="+12546894660" target="_blank">2546894660</a></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><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>
<br></div></div>_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org" target="_blank">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><span><font color="#888888"><br></font></span></blockquote></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div>Matthias Wessendorf <br><br>blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a></div>
</font></span></div>
<br>_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org" target="_blank">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Matthias Wessendorf <br><br>blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a></div>
</div></div>