0
(click on this box to dismiss)
Error: Your transaction has been unilaterally aborted by the system.
When I insert records into CUBRID DB(2008 R3.0), the following error was popped up.
"ERROR CA001CUBRIDCUBRID ODBC Driver Transaction(index1, dba@localhost|20383) has been unilaterally aborted by the system"
What does it mean and what can I do?
![[레벨:2]](http://www.cubrid.org/modules/point/icons/default/2.gif "Rank: 2/30, reputation score 41 (70% completed for the next level)"){kind=icon}
cottonspan
1
0
The specified transaction was terminated by the engine and the message mostly appears when deadlock occurs. You can check your SQL logs under CUBRID/log/broker/sql_log and find a CAS process which holds a lock. Then kill a lockholder by using "cubrid killtran" utility if necessary.
In general, using index, short transaction, and lower isolation level is a good way to reduce deadlock problem.
질문시간 6달 전
viewed 1039 times