-
Incident report
-
Resolution: Unsupported version
-
Trivial
-
None
-
None
-
None
-
None
I'm with this error below.
syddba said that this error, it is bursting filesystem /oracle.
is there any configuration that can be done?
I do not know if these errors were caused by a massive update
sorry for my English.
20011:20180803:142410.675 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource [select null from hosts where hostid=10812 for update] 20011:20180803:142410.676 slow query: 22.848106 sec, "select null from hosts where hostid=10812 for update" 20016:20180803:142410.903 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource [select null from hosts where hostid=10822 for update] 20016:20180803:142410.903 slow query: 6.856941 sec, "select null from hosts where hostid=10822 for update" 19979:20180803:142410.948 [Z3005] query failed: [-1] ORA-00060: deadlock detected while waiting for resource [update ids set nextid=nextid+1 where table_name='items' and field_name='itemid']
[oracle@MZ-CL-BD-071:/oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace [CDBBRA] $ df -hP /oracle Filesystem Size Used Avail Use% Mounted on /dev/mapper/oracle_vg-oracle_lv 99G 40G 55G 43% /oracle
alert.log
ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25740.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25926.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25780.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25792.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25682.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25796.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25922.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25624.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25776.trc. ZBCORP(4):ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /oracle/app/oracle/diag/rdbms/cdbbra/CDBBRA/trace/CDBBRA_ora_25948.trc.
deadlock:
DEADLOCK DETECTED ( ORA-00060 ) See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors [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:
Deadlock graph:
-----------Blocker(s)--------- ------------Waiter(s)----------- Resource Name process session holds waits serial process session holds waits serial TM-000059BE-00000000-2F87D304-00000000 342 597 SX 34886 584 806 SX SSX 6707 TX-00300001-00004B70-2F87D304-00000000 584 806 X 6707 342 597 X 34886 2018-08-03T08:22:37.193245-03:00 (ZBCORP(4)) dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0) ----- Error Stack Dump ----- Current SQL Statement for this session (sql_id=akmjxxu866qa5) -----* select null from hosts where hostid=10672 for update