| Neueste Versionen | FixList |
| 14.10.xC11 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
Informix - Problembeschreibung
| Problem IT07039 | Status: Geschlossen |
INDEX CORRUPTION IN TEMP OVERFLOW PARTITION FOR DEFERRED CONSTRAINT CHECKING | |
| Produkt: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
| Problembeschreibung: | |
'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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL DB Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10 * **************************************************************** | |
| Local-Fix: | |
| Lösung | |
Problem Fixed In IBM Informix Server 12.10 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 09.02.2015 16.10.2015 16.10.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.0 | |
| Problem behoben lt. FixList in der Version | |
| 12.10.xC5 |
|
| 12.10.xC5.W1 |
|