[Building Sakai] Deadlock Detected in Melete on Oracle
mizematr at notes.udayton.edu
mizematr at notes.udayton.edu
Tue Mar 2 11:15:00 PST 2010
About a month ago, our DBA found a deadlock had occurred when attempting
to delete some melete resources. The exact error is:
=====
DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
The following deadlock is not an ORACLE error. It is a deadlock due to
user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following information may aid in
determining the deadlock:
delete from melete_resource where RESOURCE_ID=:1
delete from melete_module where MODULE_ID in (6553634 , 6553636 , 6553638
, 6553639 , 6553640);
=====
He also said this is not the first time he has seen this deadlock and
asked me to find out if anyone else is seeing these errors. So, has
anyone else seen these errors?
---------------------------------------------------------------------------
Matt Mize, Systems Administrator
- Pay no attention to the man in the back office....
Matt.Mize at notes.udayton.edu
(937) 229-1024
UDit Department, University of Dayton
300 College Park, Dayton, OH, 45469-1302
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100302/47cfd114/attachment.html
More information about the sakai-dev
mailing list