Technote (troubleshooting)
Problem(Abstract)
You run an sql but receive a message like this:
Database Exception Catched, Message is : Serialization failure. Origin: State:40001,Native:-11037,Origin:[Informix][Informix ODBC Driver]
-11037 Serialization failure.
This IBM Informix CLI error code is the same as SQLSTATE value 40001. The following functions can return this error code: SQLExecDirect(), SQLExecute(), SQLExtendedFetch(), and SQLFetch().
IBM Informix CLI terminated the transaction to prevent deadlock. If you consistently receive this error, a problem exists with the logic in your application.
Cause
The potential for a deadlock was realized so database server terminated the transaction.
Resolving the problem
- Change the table locking from page level locking to row level locking. Alter table syntax
- Determine which table columns are being used as filters in your queries and add indexes to the tables involved.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.