Informix - Problem description
Problem IT27570 | Status: Closed |
USING 'ONMODE -I' TO TRAP ERRORS -206/-111 ALSO CATCHES FALSE -206/-111 ERRORS OF SESSIONS USING 'INTO TEMP' | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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 | |
Problem Summary: | |
**************************************************************** * 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: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.12.2018 07.10.2019 07.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC11 | |
Problem solved according to the fixlist(s) of the following version(s) |