Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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



link comment (0)
asked 5 years ago
1 Answer

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.

link comment (0)
answered 5 years ago

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

Internet Explorer: Mozilla Firefox: Google Chrome: