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 |
|