INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

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

****************************************************************
* USERS AFFECTED:                                              *
* All users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9                      *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

15.03.2017
10.07.2017
10.07.2017

12.10.xC9