IT29144: ASSERT SEGV IN PROPENDB RUNNING SELECT AGAINST SYSMASTER:SYSOPENDB WHILE OTHER SESSIONS OPENING DATABASE

APAR status

• Closed as program error.

Error description

• The query that is running for the asserting thread has been:
  
   SELECT odb_sessionid, odb_dbname, odb_iscurrent FROM
      sysmaster:'informix'.sysopendb t2 WHERE odb_iscurrent='Y'
  
  The assert is typically like this with the following stack:
  08:09:24  IBM Informix Dynamic Server Version 12.10.FC10
  08:09:24   Who: Session(4957, informix@rocklaubster, 17150,
  0x46b1d618)
                  Thread(4974, sqlexec, 46add6a8, 1)
                  File: mtex.c Line: 508
  08:09:24   Results: Exception Caught. Type: MT_EX_OS, Context:
  mem
  08:09:24   Action: Please notify IBM Informix Technical Support.
  08:09:24   See Also:
  /work4/laube/pmrs/CHCLS00115214/tmp/af.1756de03
  08:09:29  Thread ID 4974 will NOT be suspended because
  
  08:09:23  Stack for thread: 4974 sqlexec
  
   base: 0x0000000048b12000
    len:   266240
     pc: 0x00000000013f01a9
    tos: 0x000000004644a310
  state: running
     vp: 1
  
  0x00000000013f01a9 (oninit) afstack
  0x00000000013f3bd1 (oninit) mt_ex_throw_sig
  0x00000000014048e3 (oninit) afsig_handler
  0x0000003ddfa0e4c0 (Linux) <signal frame>
  0x00000000015a83c5 (oninit) stchar
  0x0000000000916128 (oninit) propendb
  0x0000000000e354e0 (oninit) pstread
  0x0000000000cffbf0 (oninit) pst_rsread
  0x0000000000d026ac (oninit) rsread
  0x00000000014cf447 (oninit) fmread
  0x00000000007f05ae (oninit) readseq_single
  0x00000000007f19ee (oninit) gettupl
  0x00000000007f4be4 (oninit) scan_next
  0x00000000007fb4d1 (oninit) getrow
  0x00000000007fc1e8 (oninit) fetchrow
  0x00000000005cf628 (oninit) exfetch
  0x0000000000a17450 (oninit) sql_nfetch
  0x0000000000a17a3b (oninit) sq_nfetch
  0x0000000000adfb43 (oninit) sqmain
  0x000000000151c2fb (oninit) spawn_thread
  0x00000000013e1d00 (oninit) th_init_initgls
  0x000000000144aa98 (oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS prior to 12.10.xC13.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Assert segv (segmentation violation) in propendb running     *
  * select against sysmaster:sysopendb while other sessions      *
  * opening database.                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 12.10.xC13.
  

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