Informix - Problem description
Problem IT19702 | Status: Closed |
TRANSACTION MIX WITH LOGGED TEMP TABS ROLLBACKS AND SQLEXIT CALLS CAN CAUSE RECOVERY ERRORS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Running an application mix where logged temporary tables are created and dropped in the same transaction, rollbacks occurred and sessions are either killed by onmode -z on the backend sid or kill -9 on the front-end side rollback, error -135 or -101 can occur. Online.log looks like this ( for example ) 11:16:28 Assert Failed: Rollback error 101 11:16:28 IBM Informix Dynamic Server Version 12.10.FC5W1XA3AEE 11:16:28 Who: Session(294586, informix@server, 11772, 0x40868a5a8) Thread(663980, sqlexec, 408cfb928, 15) File: rstrans.c Line: 3248 11:16:28 Results: Log record (OLDRSAM:HUPDATE) in log 14346, offset 0xa7434f4 was not rolled back 11:16:28 Action: Use 'onlog' to view the transaction and repair manually. 11:16:28 stack trace for pid 7702 written to /opt/informix/tmp/af.2594c2fc 11:16:28 See Also: /opt/informix/tmp/af.2594c2fc, shmem.2594c2fc.0 11:20:25 Rollback error 101 11:20:25 Assert Failed: Rollback error 101 11:20:25 IBM Informix Dynamic Server Version 12.10.FC5W1XA3AEE 11:20:25 Who: Session(294586, informix@server, 11772, 0x40868a5a8) Thread(663980, sqlexec, 408cfb928, 15) File: rsextlog.c Line: 1740 11:20:25 Results: Log record (OLDRSAM:HUPDATE) in log 14346, offset 0xa7434f4 was not rolled back 11:20:25 Action: Use 'onlog' to view the transaction and repair manually. 11:20:25 stack trace for pid 7702 written to /opt/informix/tmp/af.2594c2fc 11:20:25 See Also: /opt/informix/tmp/af.2594c2fc | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.03.2017 10.07.2017 10.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |