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 |
