IT35673: ASSERT IN MT_LOCK_HELPER CALLING JAVA UDR THAT EXECUTES SELECT STATEMENT AND RETURNS JAVA.UTIL.VECTOR AS LIST(VARCHAR NOTNULL)

APAR status

• Closed as program error.

Error 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) <signal frame>
  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
  

Local fix

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).                                  *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC15 and 14.10.xC6.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels