IT11138: WINDOWS: RUNNING TS_INIT CRASHES THE INSTANCE

APAR status

• Closed as program error.

Error description

• Using 12.10.FC5W1 and TS 6.00.FC6
  a simple TS_INIT will crash the server with the following stack:
  
  
  Call Stack for thread #47 - sqlexec
   (*nosymtab*)0x00000001800F0536
   (*nosymtab*)0x00000001800F217F
   (*nosymtab*)0x00000001800F2A49
   (*nosymtab*)0x00000001800F4B92
   (*nosymtab*)0x0000000180101D55
   (*nosymtab*)0x0000000180102E62
  (oninit)udrlm_clang_execute_internal
   (oninit)udrlm_clang_execute
   (oninit)udrlm_exec_routine
   (oninit)udr_execute
  ...
  
  the online.log shows:
  
  IBM Informix Dynamic Server Version 12.10.FC5 -- On-Line -- Up
  00:00:28 -- 185088 Kbytes
  
  Message Log File: C:\sqldists\1210~1.FC5\ol_informix1210FC6.log
  
  16:59:39   Action: To enable automatic checkpoints, increase the
  physical log to at least 737280 KB.
  16:59:40  Defragmenter cleaner thread now running
  16:59:40  Defragmenter cleaner thread cleaned:0 partitions
  16:59:49  Loading Module
  <$INFORMIXDIR/extend/TimeSeries.6.00.FC6/TimeSeries.bld>
  16:59:50  The C Language Module
  <C:\sqldists\1210~1.FC5/extend/TimeSeries.6.00.FC6/TimeSeries.bl
  d> loaded
  16:59:50  Assert Failed: NT Exception!
  16:59:50   See Also: C:\sqldists\1210~1.FC5\tmp\af.417a666
  16:59:50  Assert Failed: Exception Caught. Type: MT_EX_OS,
  Context: mem
  16:59:50  IBM Informix Dynamic Server Version 12.10.FC5
  16:59:50   Who: Session(6, Administ@Cokmah, 2488,
  0000000000000000)
  		Thread(47, sqlexec, 0, 1)
  		File: mtex.c Line: 1174
  16:59:50   Action: Please notify IBM Informix Techical Support.
  16:59:50  stack trace for pid 3548 written to
  C:\sqldists\1210~1.FC6\tmp\af.417a666
  16:59:53   See Also: C:\sqldists\1210~1.FC6\tmp\af.417a666,
  shmem.417a666.0
  
  this is the statement:
  Current SQL statement (2) :
    execute function tsl_init
  ('ts_data','raw_reads','%Y-%m-%d|%H:%M:%S')
  
  Stored procedure stack :
  
     context            proc-counter       opcode name
  
  ----------------------------------------------------------------
  --
     0x0000000082af5860 0x00000000+0x0000 ***UDR
  testdb:tsl_init
  
  Last parsed SQL statement :
    execute function tsl_init
  ('ts_data','raw_reads','%Y-%m-%d|%H:%M:%S')
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of TimeSeries on Windows Server 2008 and 2012          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  * Fixed with idsdb00507872 - On windows Server 2008/2012,      *
  * Routine execution trap on tsl_inscontainercache when calling *
  * TSContainerCreate                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC6                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.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

• RC10 PSN

     UP