Well, this information is not sufficient for diagnosing problem. Could you provide stacktraces of blocked sql queries?
You can do it this way: - make some traffic until block happens - reduce traffic - do kill -3 on PID or attach debugger - provide us queries along with stacktraces of blocked threads 2009/12/18 Pratik Bhatt <[email protected]>: > Hi, > > As i mentioned in my earlier query, We have deployed ode on jboss 5 with MS > SQL Server 2005 using hibernate as the persistence manger. The deadlock > issues seem to have resolved by creating various indices on the tables, but > a new issue has turned up. > > The processes seem to be stalling completely at random. i.e. many processes > are progressing simultanously and then suddenly everything comes to a halt. > We dont loose data, but time as the system does seem to began reprocessing > after 15 mins. > > Looking throught sql server, we observe that some of the sessions are unable > to commit for a very long about of time, which blocks up every thing else. > The last query that is run on that session is as follows. > > (@P0 bigint)select properties0_.MEX as MEX0_, properties0_.VALUE as VALUE0_, > properties0_.NAME as NAME0_ from BPEL_MEX_PROPS properties0_ where > properties0_.MEX= @P0 > > Which seems to indicate that the processing for some process is over and its > trying to clear off but is unable to commit. > > Also one thing we noticed was that ODE is having database level locks? > > Thanks for everyones help in advance. > > Regards > - Pratik Bhatt > Regards, -- Rafał Rusin http://rrusin.blogspot.com http://www.touk.pl http://top.touk.pl
