Informix - Problem description
Problem IT35673 | Status: Closed |
ASSERT IN MT_LOCK_HELPER CALLING JAVA UDR THAT EXECUTES SELECT STATEMENT AND RETURNS JAVA.UTIL.VECTOR AS LIST(VARCHAR NOTNULL) | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
This problem reproduces running 12.10.FC14 on linux x86-64 but it's suspected not to be platform specfici. The key pieces to this repro seem to be Call a stored procedure from database1. This procedure calls a stored procedure from database2. The stored procedure in database2 calls a java UDR that executes a query from another java udr and then returns a Vector type (java.util.Vector) into a LIST(LVARCHAR NOT NULL) as this function definition shows: CREATE FUNCTION "informix".sp_submit_to_processor(LVARCHAR) RETURNS LIST(LVARCHAR NOT NULL) EXTERNAL NAME 'informix.processor_payment_jar:SubmitPayment.submitToProcessor( java.lang.String)' LANGUAGE java; After the java udr completes, you will first see the following assertion possibly followed by several other varying assertions that may even crash the server, but this is always the first: 0x0000000001410459 (oninit) afstack 0x0000000001413f41 (oninit) mt_ex_throw_sig 0x000000000141de13 (oninit) afsig_handler 0x0000003ddfa0e4c0 (Linux) 0x000000000142ab11 (oninit) mt_lock_helper 0x0000000000594977 (oninit) sapi_drain_mem 0x00000000006a4ffd (oninit) crd2current 0x0000000000695eda (oninit) delcontext 0x000000000069781d (oninit) ip_clscur 0x0000000000698aa4 (oninit) ip_close 0x000000000061e17d (oninit) close_cb_subtree_r 0x000000000061e2a7 (oninit) close_cb_subtree 0x000000000061ec69 (oninit) closesdb 0x0000000000a1f6a1 (oninit) close_cursor 0x0000000000a208d9 (oninit) sq_close 0x0000000000ae7b71 (oninit) sqmain 0x000000000154290b (oninit) spawn_thread 0x0000000001401c70 (oninit) th_init_initgls 0x0000000001448997 (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.01.2021 18.05.2021 18.05.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |