| Latest versions | fixlist |
| 14.10.xC12 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
Informix - Problem description
| Problem IT07039 | Status: Closed |
INDEX CORRUPTION IN TEMP OVERFLOW PARTITION FOR DEFERRED CONSTRAINT CHECKING | |
| product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
| Problem description: | |
'SET CONSTRAINTS ... IMMEDIATE' (or COMMIT WORK) at the end of a
large transaction using 'SET CONSTRAINTS ... DEFERRED' can fail
with
680: Cannot write constraint violation data for constraint
(andreasl.n106_45).
105: ISAM error: bad isam file format.
An assertion failure would be created stating, in the af file:
Rowid 0x213 not found for delete in partnum
<partnum_in_tempdbs>, key 1
Assertion and stack would look like this:
10:51:49 Assert Failed: ... some garbage ...
10:51:49 Who: Session(37612, user@host, 40108060,
7000000204a3768)
Thread(37641, sqlexec, 700000020468568, 1)
File: rsnode.c Line: 2849
10:51:49 Results: Delete failed
10:51:49 Action: Run 'oncheck -cI db:"owner"._temptable#'
10:51:49 Raw hex dump of stack located in
/opt/informix/tmp/af.96f18eb5.rawstk
10:51:49 Stack for thread: 37641 sqlexec
base: 0x07000000f063d000
len: 69632
pc: 0x00000001000ad4d4
tos: 0x07000000f0649920
state: running
vp: 1
afstack
afhandler
affail_interface
btdelitem
delrecord
rsdelrec
isdelrec
fmdelrec
sqisdelrec
recheckcon
chkdefcon
chkdeflist
setcons
aud_setcons
excommand
sq_execute
sqmain
listen_verify | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL DB Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10 * **************************************************************** | |
| Local Fix: | |
| Solution | |
Problem Fixed In IBM Informix Server 12.10 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.02.2015 16.10.2015 16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) | |
12.10.0 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 12.10.xC5 |
|
| 12.10.xC5.W1 |
|