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 | |
12.10.xC5.W1 |