Informix - Problem description
Problem IT34887 | Status: Closed |
ASSERT CALLING MT_LOCK_HELPER FROM SAPI_DRAIN_MEM AFTER CALLING JAVA UDR THAT 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 returns a Vector type (java.util.Vector) into a LIST(LVARCHAR NOT NULL) as this function definition shows: CREATE FUNCTION satoriaddress(CHAR(64), CHAR(64), CHAR(64), CHAR(64), CHAR(10), CHAR(10), CHAR(100), CHAR(100)) RETURNS LIST(LVARCHAR NOT NULL) with (class="jvp") EXTERNAL NAME 'informix.getlist_jar:getlist.getlist()' LANGUAGE java; After the session completes and the database1 is closed, 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 0x0000000001413431 (oninit) afhandler 0x0000000001413c12 (oninit) affail_interface 0x00000000014141a1 (oninit) mt_ex_throw_sig 0x000000000141de13 (oninit) afsig_handler 0x0000003ddfa0e4c0 (Linux) 0x000000000142ab11 (oninit) mt_lock_helper 0x0000000000594977 (oninit) sapi_drain_mem 0x00000000006a4ffd (oninit) crd2current 0x000000000068fb15 (oninit) drpcurlist 0x00000000006cf8f1 (oninit) rmstproc 0x00000000006cfb79 (oninit) freecache 0x0000000000753f6b (oninit) sqdbclose 0x00000000006ca66b (oninit) aud_sqdbclose 0x00000000005d4a11 (oninit) excommand 0x0000000000a27753 (oninit) sq_execute_workhorse 0x0000000000a27d6e (oninit) sq_execute 0x0000000000ae7b71 (oninit) sqmain 0x000000000154290b (oninit) spawn_thread | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * This problem reproduces running 12.10.FC14 on linux x86-64 * * but * * it's suspected not to be platform specfic. * * * * The key pieces to this reproduction 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 returns a Vector type * * (java.util.Vector) into a LIST(LVARCHAR NOT NULL) * * as this function definition shows: * * * * CREATE FUNCTION test(CHAR(64), CHAR(64), CHAR(64), * * CHAR(64), CHAR(10), CHAR(10), CHAR(100), CHAR(100)) * * RETURNS LIST(LVARCHAR NOT NULL) * * with (class="jvp") * * EXTERNAL NAME * * 'informix.getlist_jar:getlist.getlist()' * * LANGUAGE java; * * * * After the session completes and the database1 is closed, 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 * * 0x0000000001413431 (oninit) afhandler * * 0x0000000001413c12 (oninit) affail_interface * * 0x00000000014141a1 (oninit) mt_ex_throw_sig * * 0x000000000141de13 (oninit) afsig_handler * * 0x0000003ddfa0e4c0 (Linux) * * 0x000000000142ab11 (oninit) mt_lock_helper * * 0x0000000000594977 (oninit) sapi_drain_mem * * 0x00000000006a4ffd (oninit) crd2current * * 0x000000000068fb15 (oninit) drpcurlist * * 0x00000000006cf8f1 (oninit) rmstproc * * 0x00000000006cfb79 (oninit) freecache * * 0x0000000000753f6b (oninit) sqdbclose * * 0x00000000006ca66b (oninit) aud_sqdbclose * * 0x00000000005d4a11 (oninit) excommand * * 0x0000000000a27753 (oninit) sq_execute_workhorse * * 0x0000000000a27d6e (oninit) sq_execute * * 0x0000000000ae7b71 (oninit) sqmain * * 0x000000000154290b (oninit) spawn_thread * **************************************************************** * 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: * * This problem reproduces running 12.10.FC14 on linux x86-64 * * but * * it's suspected not to be platform specfic. * * * * The key pieces to this reproduction 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 returns a Vector type * * (java.util.Vector) into a LIST(LVARCHAR NOT NULL) * * as this function definition shows: * * * * CREATE FUNCTION test(CHAR(64), CHAR(64), CHAR(64), * * CHAR(64), CHAR(10), CHAR(10), CHAR(100), CHAR(100)) * * RETURNS LIST(LVARCHAR NOT NULL) * * with (class="jvp") * * EXTERNAL NAME * * 'informix.getlist_jar:getlist.getlist()' * * LANGUAGE java; * * * * After the session completes and the database1 is closed, 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 * * 0x0000000001413431 (oninit) afhandler * * 0x0000000001413c12 (oninit) affail_interface * * 0x00000000014141a1 (oninit) mt_ex_throw_sig * * 0x000000000141de13 (oninit) afsig_handler * * 0x0000003ddfa0e4c0 (Linux) * * 0x000000000142ab11 (oninit) mt_lock_helper * * 0x0000000000594977 (oninit) sapi_drain_mem * * 0x00000000006a4ffd (oninit) crd2current * * 0x000000000068fb15 (oninit) drpcurlist * * 0x00000000006cf8f1 (oninit) rmstproc * * 0x00000000006cfb79 (oninit) freecache * * 0x0000000000753f6b (oninit) sqdbclose * * 0x00000000006ca66b (oninit) aud_sqdbclose * * 0x00000000005d4a11 (oninit) excommand * * 0x0000000000a27753 (oninit) sq_execute_workhorse * * 0x0000000000a27d6e (oninit) sq_execute * * 0x0000000000ae7b71 (oninit) sqmain * * 0x000000000154290b (oninit) spawn_thread * **************************************************************** * 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 : | 11.11.2020 06.01.2021 06.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |