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

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 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:

  

                                          -----------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