#Ora 00060 deadlock detected while waiting for resource full#
If you could get full trace with DebugLevel 4 it might be useful. I don't have any logs currently from the DB side. I didn't see anything else really relevant but if the full trace is useful let me know. I'm seeing this as well on 2.0.5 (although I haven't tested against earlier versions) when batch updates to the items table are made, I've attached a snippet of the log. Is it possible to attach the original log (or create a new one with DebugLevel 4 if possible). For Z3005 errors the failed sql statement should be printed after error message in. I don't think setting prefetch buffer would cause deadlocks (unless you have tested 2.05 version with removed ZBX-5920 fix and it worked fine).Īctually after looking more at the quoted errors the messages seem to be truncated. Seems to work, but I think in this fix is modification which causes above errors.Ĭan you attach the oracle trace file? There should be more information about resources/transactions involved. When I run environment with zabbix_server 2.0.4 it is OK, but with 2.0.5 - it dies.įix ZBX-5920 added prefetching of 2 MB of data for Oracle SQL selects I made many tests and it remains the same. Which causes to grow usage of cache write buffer and eventually to crash zabbix_server after a while (1-4h). *Action: Look at the trace file to see the transactions and resources *Cause: Transactions deadlocked one another while waiting for resources. 00000 - "deadlock detected while waiting for resource" ORA-00060: deadlock detected while waiting for resource Insert into faculty values (category,id) Įxecuting the above procedure sometimes gives me the following error. Insert into patron values (fname,lname,id,status,country_name)
Status in varchar2,country_name in varchar2,category in varchar2) return integer CREATE or replace FUNCTION insert_faculty (fname in varchar2,lname in varchar2,id in number, I use the following function call to insert data into these tables. CREATE TABLE Patron(ĬONSTRAINT fk_patron_nationality FOREIGN KEY (country_name) REFERENCES Nationality (country_name),ĬONSTRAINT chk_status CHECK(status IN ('GOOD','BAD'))ĬONSTRAINT fk_faculty FOREIGN KEY (id) REFERENCES Patron (id),ĬONSTRAINT fk_faculty_category FOREIGN KEY (category) REFERENCES Faculty_Category (category) Patron is the parent class of Faculty and these are their definitions. I tried to model inheritance relationship in SQL.
0 kommentar(er)
