IT05109: ALTER TABLE ADD CRCOLS WITH BLOB DATA IN SBSPACE GIVES ERROR -959 -172 WITH ASSERT FAILURE

APAR status

• Closed as program error.

Error description

• alter table add CRCOLS with no data does not produce errors.
  
  alter table add CRCOLS with blob data in sbspace gives error
  -959 -172 with Assert Failure.
  
     959: The current transaction has been rolled back due to an
  internal error.
     172: ISAM error:  Unexpected internal error
  
  
  11:41:06  Assert Failed: No Exception Handler
  11:41:06  IBM Informix Dynamic Server Version 12.10.FC4W1
  11:41:06   Who: Session(55, informix@server, 17301810,
  700000020489c58)
                  Thread(87, sqlexec, 700000020447188, 1)
                  File: mtex.c Line: 516
  11:41:06   Results: Exception Caught. Type: MT_EX_USR, Context:
  IX000
  11:41:06   Action: Please notify IBM Informix Technical Support.
  11:41:06   See Also: /usr/products/12.10.FC4/tmp/af.43fa3a2
  
  
  9:01  Raw hex dump of stack located in
  /usrproducts/12.10.FC4W4/tm
  p/af.421fc35.rawstk
  17:59:01  Stack for thread: 57 sqlexec
  
   base: 0x07000000500f5000
    len:   69632
     pc: 0x00000001000ae3d0
    tos: 0x0700000050102ae0
  state: running
     vp: 1
  
  
  
  oninit)afstack
        (oninit)mt_ex_throw_sig@AF11_4
        (oninit)sqapi_error_dispatch
        (oninit)sqapi_online_error
        (oninit)allocate_udr_state
        (oninit)sapicon_create
        (oninit)mi_open@AF20_2
        (oninit)sblob_checksum
        (oninit)cdrCalculateInitialReplcheckVer
        (oninit)copydata
        (oninit)ddalter
        (oninit)aud_ddalter
        (oninit)excommand
        (oninit)sq_execute
        (oninit)sqmain
        (oninit)listen_verify
        (oninit)spawn_thread
        (oninit)th_init_initgls
        (oninit)startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of tables with a BLOB or CLOB column and CRCOLS        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-12.10.xC5                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-12.10.xC5
  

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 PSY

     UP