Informix - Problem description
Problem IT29860 | Status: Closed |
SMARTTRIGGER: PUSH DATA STOPPED WHEN A CERTAIN TRANSACTION SET HAPPENED | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Testenvironment contains a Java based client investigating the data from the pushdata. On the producer side we have several tables where we want to catch the changes from. When in this scenario a certain transaction mix happened , the client cannot get any data from the push, the pending event conditions growth. onstat -g pd IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up 2 days 19:03:16 -- 566908 Kbytes push-data subsystem structure at 0x4642c028 push-data session structure at 0x47182028 push-data sql session id: 1466 0x5ba Marked as detachable session, session unique id: 1 Smartblob file descriptor: 39 Number of event conditions: 12 Number of pending event operations: 198 Number of discarded event operations: 0 Total event operations returned to client: 80194 Frist tx(0x4724ad28) begin work logpos: 67:0xb744f0, commit work pos: 67:0xb772ac Last txn(0x47f7cfa0) begin work logpos: 67:0xc400d8, commit work pos: 67:0xc402e4 IBM Informix Dynamic Server Version 12.10.FC12 -- On-Line -- Up 2 days 19:04:30 -- 566908 Kbytes Stack for thread: 2020 sqlexec base: 0x000000004878b000 len: 69632 pc: 0x0000000001437627 tos: 0x000000004879a420 state: sleeping vp: 1 0x0000000001437627 (oninit) yield_processor_svp 0x0000000001440917 (oninit) mt_yield 0x00000000010c1d79 (oninit) cdrPush_readdata 0x0000000000a22c54 (oninit) sq_lodata 0x0000000000b0b011 (oninit) sqmain 0x000000000154ca1b (oninit) spawn_thread 0x0000000001411450 (oninit) th_init_initgls 0x0000000001456d88 (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS versions prior to 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * When a scenario contains a certain transaction mix the * * client cannot get any data from the push and the pending * * event conditions grow. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.07.2019 20.09.2019 20.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
Problem solved according to the fixlist(s) of the following version(s) |