Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | 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?

 

 

link comment (0)
asked 2 years ago
cottonspan
61
1 Answer
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.

link comment (0)
answered 2 years ago
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: