[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