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 |
