Teamsite 7.3.2/Oracle 11gr2
We've been getting some LSCS deployment errors, and our DBA pointed out some transient deadlocks in the LSCS database.
Our clients were doing some large deployments of livesite pages at the time (100+). Seems if they throttle that back a little, to say 5-10 at a time, deploys are successful.
----- Current SQL Statement for this session (sql_id=8ztu3gw4pj7zc) -----
insert into asset (asset_id, mutable, marked_for_delete, deleted, mod_time_internal, context, project, id) values (:1, :2, 
, :4, :5, :6, :7, :8)
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:
Search for "deadlock" on these forums returns no results...are we the only ones running into this issue?
Anywhere else i should be looking for more descriptive errors? Some configs perhaps that could be tweaked?
