Informix - Problem description
Problem IT27956 | Status: Closed |
SYSSESSIONS OCCASIONALLY NOT RETURNING CURRENT SESSION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Customers are facing again the problem of missing sessions in sysmaster:syssessions (as reported in defect idsdb00096417) in IDS 12.10.FC12W1. The defect idsdb00096417 should be fixed in IDS 12.10.FC11. However I am able to reproduce the issue in 12.10.FC10, 12.10.FC11, 12.10.FC12 and 12.10.FC12W1 using the following reproducing scenario (provided by the customer). ============== test_ec.ec ============== #include $int c, sid; main() { $database stores_demo; $select DBINFO('sessionid') INTO :sid FROM sysmaster:sysdual; $select COUNT(*) INTO :c FROM sysmaster:syssessions s WHERE s.sid = :sid; if ( c == 0 ) printf("SID: %d Count: %d ",sid,c); sleep(1); } =================================== ============== test_ec_connections.sh ====== #!/bin/bash LOOP_MAX=$1 while true do LOOP=1 while [ $LOOP -le $LOOP_MAX ] do ./test_ec.exe & LOOP=`expr $LOOP + 1` done sleep 2 date done =================================== $ esql -o test_ec.exe test_ec.ec Execute: [informix@localhost ~]$ onstat - IBM Informix Dynamic Server Version 12.10.FC10 -- On-Line -- Up 00:03:19 -- 219400 Kbytes [informix@localhost ~]$ ./test_ec_connections.sh 10 Fri Jan 18 11:56:49 CET 2019 Fri Jan 18 11:56:51 CET 2019 Fri Jan 18 11:56:54 CET 2019 SID: 72 Count: 0 Fri Jan 18 11:56:56 CET 2019 Fri Jan 18 11:56:58 CET 2019 SID: 92 Count: 0 Fri Jan 18 11:57:00 CET 2019 SID: 103 Count: 0 Fri Jan 18 11:57:03 CET 2019 Fri Jan 18 11:57:05 CET 2019 SID: 123 Count: 0 Fri Jan 18 11:57:07 CET 2019 SID: 132 Count: 0 ^C [informix@localhost ~]$ =================================== [informix@localhost ~]$ onstat - IBM Informix Dynamic Server Version 12.10.FC11 -- On-Line -- Up 00:01:37 -- 219400 Kbytes [informix@localhost ~]$ ./test_ec_connections.sh 25 Fri Jan 18 13:56:32 CET 2019 Fri Jan 18 13:56:34 CET 2019 Fri Jan 18 13:56:36 CET 2019 Fri Jan 18 13:56:39 CET 2019 Fri Jan 18 13:56:41 CET 2019 SID: 160 Count: 0 Fri Jan 18 13:56:44 CET 2019 Fri Jan 18 13:56:46 CET 2019 SID: 210 Count: 0 Fri Jan 18 13:56:49 CET 2019 Fri Jan 18 13:56:51 CET 2019 SID: 260 Count: 0 SID: 261 Count: 0 Fri Jan 18 13:56:54 CET 2019 Fri Jan 18 13:56:56 CET 2019 Fri Jan 18 13:56:59 CET 2019 Fri Jan 18 13:57:01 CET 2019 Fri Jan 18 13:57:04 CET 2019 Fri Jan 18 13:57:06 CET 2019 Fri Jan 18 13:57:09 CET 2019 Fri Jan 18 13:57:11 CET 2019 Fri Jan 18 13:57:14 CET 2019 Fri Jan 18 13:57:16 CET 2019 SID: 510 Count: 0 Fri Jan 18 13:57:19 CET 2019 Fri Jan 18 13:57:21 CET 2019 Fri Jan 18 13:57:23 CET 2019 Fri Jan 18 13:57:26 CET 2019 ^C [informix@localhost ~]$ =================================== [informix@localhost ~]$ onstat - IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up 00:03:52 -- 219400 Kbytes [informix@localhost ~]$ ./test_ec_connections.sh 25 Fri Jan 18 13:47:18 CET 2019 SID: 62 Count: 0 SID: 65 Count: 0 Fri Jan 18 13:47:21 CET 2019 Fri Jan 18 13:47:23 CET 2019 Fri Jan 18 13:47:26 CET 2019 Fri Jan 18 13:47:28 CET 2019 SID: 164 Count: 0 Fri Jan 18 13:47:31 CET 2019 Fri Jan 18 13:47:33 CET 2019 SID: 214 Count: 0 Fri Jan 18 13:47:36 CET 2019 Fri Jan 18 13:47:38 CET 2019 Fri Jan 18 13:47:41 CET 2019 Fri Jan 18 13:47:43 CET 2019 Fri Jan 18 13:47:46 CET 2019 Fri Jan 18 13:47:48 CET 2019 Fri Jan 18 13:47:51 CET 2019 Fri Jan 18 13:47:53 CET 2019 SID: 416 Count: 0 Fri Jan 18 13:47:56 CET 2019 Fri Jan 18 13:47:58 CET 2019 Fri Jan 18 13:48:01 CET 2019 Fri Jan 18 13:48:03 CET 2019 Fri Jan 18 13:48:05 CET 2019 Fri Jan 18 13:48:08 CET 2019 Fri Jan 18 13:48:10 CET 2019 Fri Jan 18 13:48:13 CET 2019 Fri Jan 18 13:48:15 CET 2019 ^C [informix@localhost ~]$ =================================== [informix@localhost ~]$ onstat - IBM Informix Dynamic Server Version 12.10.FC12W1 -- On-Line -- Up 00:04:00 -- 219400 Kbytes [informix@localhost ~]$ ./test_ec_connections.sh 25 Fri Jan 18 13:38:44 CET 2019 Fri Jan 18 13:38:46 CET 2019 Fri Jan 18 13:38:49 CET 2019 Fri Jan 18 13:38:51 CET 2019 Fri Jan 18 13:38:54 CET 2019 Fri Jan 18 13:38:56 CET 2019 Fri Jan 18 13:38:59 CET 2019 Fri Jan 18 13:39:01 CET 2019 Fri Jan 18 13:39:03 CET 2019 Fri Jan 18 13:39:06 CET 2019 Fri Jan 18 13:39:08 CET 2019 Fri Jan 18 13:39:11 CET 2019 Fri Jan 18 13:39:13 CET 2019 Fri Jan 18 13:39:16 CET 2019 Fri Jan 18 13:39:18 CET 2019 Fri Jan 18 13:39:21 CET 2019 Fri Jan 18 13:39:23 CET 2019 SID: 2187 Count: 0 Fri Jan 18 13:39:25 CET 2019 Fri Jan 18 13:39:28 CET 2019 Fri Jan 18 13:39:30 CET 2019 Fri Jan 18 13:39:33 CET 2019 SID: 2289 Count: 0 Fri Jan 18 13:39:35 CET 2019 Fri Jan 18 13:39:38 CET 2019 SID: 2338 Count: 0 Fri Jan 18 13:39:40 CET 2019 Fri Jan 18 13:39:43 CET 2019 SID: 2387 Count: 0 Fri Jan 18 13:39:45 CET 2019 ^C [informix@localhost ~]$ | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Syssessions occasionally not returning current session. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.02.2019 24.09.2019 24.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |