Informix - Problem description
Problem IT13846 | Status: Closed |
IDS CRASHES IN EVALCOLS() SELECTING FROM A VIEW AND A TEMP TABLE IF PDQPRIORITY IS SET | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
following select: SELECT t.camp_key, s.mailhouse_store_no, h.store_brand, s.cust_key, s.addr_c_rec_key, s.lifetime_spend FROM c_status s, store_history h, temp_anns t WHERE s.anny_ext_key = t.camp_key AND s.anny_rules_passed = "Y" AND s.anny_criteria[1] = "M" AND s.mailable_flag = "Y" AND s.mailhouse_store_no != 129 AND s.mailhouse_store_no = h.store_no INTO TEMP ap_temp WITH NO LOG; generates following crash: 13:55:11 Assert Failed: No Exception Handler 13:55:11 IBM Informix Dynamic Server Version 12.10.FC6 13:55:11 Who: Session(86384, informix@server, 5247, 0x5903b970) Thread(87985, insert_1.0, 59000568, 1) File: mtex.c Line: 508 13:55:11 Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:55:11 Action: Please notify IBM Informix Techical Support. 13:55:11 See Also: /opt/informix/12.10.FC6/tmp/af.5b99bf2e 13:55:12 Logical Log 19008 Complete, timestamp: 0x7d156ca9. 13:55:13 Thread ID 87985 will now be suspended. 13:55:13 Assert Failed: Condition Failed (Ignoring free of pool '86384' (0x70c8d040) in use by blkpool), In (mt_shm_free_pool) 13:55:13 IBM Informix Dynamic Server Version 12.10.FC6 13:55:13 Who: Session(86384, markush@?O?o, 5247, 0x5903b970) Thread(87978, sqlexec, 59001fa8, 8) File: mtshpool.c Line: 4853 13:55:13 Action: Please notify IBM Informix Techical Support. 13:55:13 stack trace for pid 21871 written to /opt/informix/12.10.FC6/tmp/af.5b92bf31 13:55:13 See Also: /opt/informix/12.10.FC6/tmp/af.5b92bf31 13:55:15 Condition Failed (Ignoring free of pool '86384' (0x70c8d040) in use by blkpool), In (mt_shm_free_pool) (oninit) afstack (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) (/lib64/libc-2.11.1.so) __GI_memmove (oninit) evalcols (oninit) insertla_next (oninit) producer_thread (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.02.2016 28.06.2016 28.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |