home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT05109 Status: Closed

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

product:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problem 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
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                                      * 
****************************************************************
Local Fix:
Solution
Problem Fixed In IDS-12.10.xC5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.10.2014
16.10.2015
16.10.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC5 FixList
12.10.xC5.W1 FixList