OK I create issue ... https://issues.jboss.org/browse/AGPUSH-1362Mgr. Ivan GürtlerMobile software developer
AHEAD iTec, s.r.o., Botanická 554/68a,
602 00 Brno (Czech Republic)
www.ahead-itec.com | twitter | mobile security solutions2015-04-10 13:19 GMT+02:00 Matthias Wessendorf <matzew@apache.org>:On Fri, Apr 10, 2015 at 12:32 PM, Ivan Gürtler <ivan.gurtler@ahead-itec.com> wrote:And is it possible in current version to set up time for scheduler not to run at midnight?unfortunately not - we discussed that option, but I am overasked if we actually have a JIRA for that :-)But I agree, it should be done, for 1.1.x - for now you would have to tweak your fork :)Mgr. Ivan GürtlerMobile software developer
AHEAD iTec, s.r.o., Botanická 554/68a,
602 00 Brno (Czech Republic)
www.ahead-itec.com | twitter | mobile security solutions2015-04-10 11:20 GMT+02:00 Matthias Wessendorf <matzew@apache.org>:Oh, that's this guy, triggered at midnight:It's a singleton, but per node :-/Can you create a JIRA ticket for that ?On Fri, Apr 10, 2015 at 10:33 AM, Ivan Gürtler <ivan.gurtler@ahead-itec.com> wrote:_______________________________________________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).We used DB owner PUSHSRVAG and application DB account APUSHSRVAG.(version ... my fork (with small change in dev) ... https://github.com/IvanGurtler/aerogear-unifiedpush-server/tree/MyBranch)Is possible change some settings to prevent deadlock ? or some different solution ?-----------------------------------------------------------------------------------------*** 2015-04-10 00:00:04.506*** SESSION ID:(84.48937) 2015-04-10 00:00:04.506*** CLIENT ID:() 2015-04-10 00:00:04.506*** SERVICE NAME:(SYS$USERS) 2015-04-10 00:00:04.506*** MODULE NAME:(JDBC Thin Client) 2015-04-10 00:00:04.506*** CLIENT DRIVER:(jdbcthin) 2015-04-10 00:00:04.506*** ACTION NAME:() 2015-04-10 00:00:04.506*** 2015-04-10 00:00:04.506DEADLOCK DETECTED ( ORA-00060 )See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors[Transaction Deadlock]The following deadlock is not an ORACLE error. It is adeadlock due to user error in the design of an applicationor from issuing incorrect ad-hoc SQL. The followinginformation may aid in determining the deadlock:Deadlock graph:---------Blocker(s)-------- ---------Waiter(s)---------Resource Name process session holds waits process session holds waitsTM-00013891-00000000-00000000-00000000 142 84 SX SSX 144 162 SX SSXTM-00013891-00000000-00000000-00000000 144 162 SX SSX 142 84 SX SSXRows waited on:Session 84: no rowSession 162: no row----- Information for the OTHER waiting sessions -----Session 162:sid: 162 ser: 54036 audsid: 10790094 user: 115/APUSHSRVAGflags: (0x41) USR/- flags_idl: (0x1) BSY/-/-/-/-/-flags2: (0x40009) -/-/INCpid: 144 O/S info: user: oracle, term: UNKNOWN, ospid: 11534420image: oracle@s16000ksclient details:O/S info: user: jbotp, term: unknown, ospid: 1234machine: s1.sk.srv.acc.sys program: JDBC Thin Clientapplication name: JDBC Thin Client, hash value=2546894660current SQL:delete from PUSHSRVAG.PushMessageInformation where submitDate<:1----- End of information for the OTHER waiting sessions -----Information for THIS session:----- Current SQL Statement for this session (sql_id=bsk109wpq55yg) -----delete from PUSHSRVAG.PushMessageInformation where submitDate<:1-----------------------------------------------------------------------------------------ThanksMgr. Ivan GürtlerMobile software developer
AHEAD iTec, s.r.o., Botanická 554/68a,
602 00 Brno (Czech Republic)
www.ahead-itec.com | twitter | mobile security solutions
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev--Matthias Wessendorf
blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf
_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev
_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev--Matthias Wessendorf
blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf
_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev