On Tue, Apr 22, 2014 at 9:10 AM, Jason Roscoe <[email protected]> wrote: > How would I go about removing the Java/Quartz job?
Please review the first Spring configuration section of the following wiki page: > > Jason Roscoe | Rite Aid | T: (717) 761-2633 x5581| [email protected] > > > -----Original Message----- > From: Marvin Addison [mailto:[email protected]] > Sent: Tuesday, April 22, 2014 9:09 AM > To: [email protected] > Subject: Re: [cas-user] TGT table not getting cleaned up > >> 2014-04-17 19:51:52,279 ERROR >> [org.hibernate.util.JDBCExceptionReporter] - DB2 SQL Error: >> SQLCODE=-911, SQLSTATE=40001, SQLERRMC=68, DRIVER=3.50.152 >> >> 2014-04-17 19:51:52,279 ERROR >> [org.hibernate.event.def.AbstractFlushingEventListener] - Could not >> synchronize database state with >> sessionorg.hibernate.exception.LockAcquisitionException: could not >> delete: >> [org.jasig.cas.ticket.TicketGrantingTicketImpl#TGT-2284-diTwnt9x0sYdKY >> LoXcQdWBYRb1ZTdumpbjyKK3wnHFnepuVS50-cas_25] > > > That error is a sign of a concurrency/locking situation. Concurrency happens; > deadlocks happen; it's just a matter of usage patterns and database platform > that determines the extent. I have no experience with DB2 but it may simply > not handle concurrency as well as some others. Oracle does well, Microsoft > SQL Server does poorly, PostgreSQL only marginally better; others can speak > up about MySQL/MariaDB/whatever it's called today. > > I'd recommend running a cron job with a query like what I provided earlier in > the thread (straight delete) and remove the Java/Quartz job and be done with > it. > > M > > -- > You are currently subscribed to [email protected] as: > [email protected] To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > > > -- > You are currently subscribed to [email protected] as: > [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
