Informix - Problem description
Problem IT31226 | Status: Closed |
USING DETACHABLE SMARTTRIGGER ACCESSED BY MULTIPLE SESSIONS IN PARALLEL MAY CAUSE ASSERTION IN CDRPUSH_DEREGISTERSESSION_INT | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When using a Smarttrigger within a mutlithreaded Java application, othe database side this lead to the situation where multiple sessions were linked sequentially to the same smart trigger structure. During the cleanup of the sessions, the first session was fine with the cleanup. Subsequent session cleanups lead to exception in: 11/25/19 13:20:13 Assert Failed: Invalid Mutex Type 11/25/19 13:20:13 IBM Informix Dynamic Server Version 12.10.FC12W1WE 11/25/19 13:20:13 Who: Session(28833, login@host, 2128, 0x72005e68) Thread(116054, sqlexec, 4d0f0a28, 9) File: mt_fn.c Line: 9179 11/25/19 13:20:13 stack trace for pid 3224 written to DUMPDIR/af.c93ec6fd 11/25/19 13:20:13 See Also: DUMPDIR/af.c93ec6fd, shmem.c93ec6fd.0 11/25/19 13:20:22 Logical Log 165287 Complete, timestamp: 0xd062fd71. afstack mt_ex_throw_sig afsig_handler mt_slock cdrpush_deregisterSession_int cdrpush_deregisterSession cdrScbClean sqscb_cleanup destroy_session sqsetconerr _iread _igetint sqmain spawn_thread th_init_initgls startup or a exception in: afstack afhandler afcrash_interface mt_slock cdrPush_readdata sq_lodata sqmain spawn_thread th_init_initgls startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when * * available). * **************************************************************** | |
Comment | |
Update to Informix Server 12.10.xC14 or 14.10.xC4 (when available). | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.12.2019 28.02.2020 28.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC4 | |
Problem solved according to the fixlist(s) of the following version(s) |