Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


1
(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?

 

 

링크 댓글 쓰기 (0)
질문시간 2년 전
cottonspan
61
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.

링크 댓글 쓰기 (0)
답변시간 2년 전
cottonspan
61
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: