[cas-user] Re: Deadlocks and Uncommited Transaction

2019-08-14 Thread saritha v
Thanks a lot Tim. We came across this in our load test and we were missing indexes for foreign keys in ticketregistryticket and serviceticket table. Adding this has solved issue in load test but we are seeing same in production and deadlocks with indexes on. We have cleaner running on one of th

[cas-user] Re: Deadlocks and Uncommited Transaction

2019-07-31 Thread 'Tim Evdokimov' via CAS Community
We have faced the very same issue (deadlocks on delete from TGT table) during our load tests, and resorted to re-write the ticket registry using pure JDBC (with Spring JdbcTemplate), taking Cassandra ticket registry as a reference/example. It yields more than 2x lower overall request latency, a

[cas-user] Re: Deadlocks and Uncommited Transaction

2019-07-30 Thread saritha v
Hi, We are facing same issue. Were you able to resolve the problem. Any pointers of how you resolved it will help me. Thank you On Monday, October 8, 2018 at 11:57:53 AM UTC-4, Trevor Fong wrote: > > > > Anyone have any ideas why we're getting deadlocks against the tables > LOCKS, SERVICETIC

[cas-user] Re: Deadlocks and Uncommited Transaction

2018-10-08 Thread Trevor Fong
Anyone have any ideas why we're getting deadlocks against the tables LOCKS, SERVICETICKET, TICKETGRANTINGTICKET? Thanks a lot Trev On Friday, October 5, 2018 at 4:50:40 PM UTC-7, Trevor Fong wrote: > Hi There,  > > > We've trying out CAS 5.2.4 in a clustered environment with the ticket > r