INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

If 'onmode -I 206' is enable to trap errors -206, it also traps
false errors -206/-111 of sessions running queries with clause
'INTO TEMP;.

For example :

$ onmode -I 206
$ onstat -m

IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line --
Up 00:56:02 -- 165016 Kbytes

Message Log File: /media/informix/usr2/work/online.1210fc10.log
....
03:59:45  Maximum server connections 0
03:59:45  Checkpoint Statistics - Avg. Txn Block Time 0.000, #
Txns blocked 0, Plog used 7, Llog used 2

04:10:03  Verbose error trapping set, errno = 206, session_id =
-1

$
$ dbaccess testdb  !

Database selected.

1 row(s) retrieved into temp table.

Database closed.

$ onstat -m

IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line --
Up 00:58:21 -- 165016 Kbytes

Message Log File: /media/informix/usr2/work/online.1210fc10.log

.....
04:10:03  Verbose error trapping set, errno = 206, session_id =
-1
04:12:20  Assert Failed: found errno 206 in session 41
04:12:20  IBM Informix Dynamic Server Version 12.10.FC10AEE
04:12:20   Who: Session(41, informix@server, 4779, 0x44d50748)
                Thread(161, sqlexec, 44d0ff98, 1)
                File: rsdebug.c Line: 3398
04:12:20   Action: Use onmode -I to stop verbose error trapping.
04:12:20  stack trace for pid 4561 written to
/media/informix/usr2/prods/12.10/FC10/tmp/af.489a4f3
04:12:20   See Also:
/media/informix/usr2/prods/12.10/FC10/tmp/af.489a4f3,
shmem.489a4f3.0
04:12:22  found errno 206 in session 41

and the information of the session 41 shows :

Sess       SQL            Current            Iso Lock       SQL
ISAM F.E.
Id         Stmt type      Database           Lvl Mode       ERR
ERR  Vers  Explain
41         SELECT         testdb             CR  Not Wait   -206
-111 9.24  Off

Current SQL statement (1) :
  SELECT * FROM systables WHERE tabid = 1 INTO TEMP mytmp

Last parsed SQL statement :
  SELECT * FROM systables WHERE tabid = 1 INTO TEMP mytmp

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS 12.10.xC10 and older versions.                  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Using 'onmode -I' to trap errors -206/-111 also catches      *
* false -206/-111 errors of sessions using 'INTO TEMP'.        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

26.12.2018
07.10.2019
07.10.2019

12.10.xC11