Assert Fail / 7.31 FC2

Posted in 1999

beach_bummer@my-deja.com — Tue, 28 Dec 1999 19:39:30 GMT — source: Informix-list mailing list archive (1991-1998)

Assert Fail messages during deletions,always the same index, Running on TruUnix64 4.0D: 06:48:17 Assert Failed: Error during recovery left index inconsistent. 06:48:17 Informix Dynamic Server Version 7.31.FC2 06:48:17 Who: Session(713, info@blue, 0, 285820304) Thread(68, xchg_1.10, 211067048, 1) File: rskey.c Line: 1366 06:48:17 Results: Index 'mcommsg:"info".isidextid#idextid_pk' is nowunusable 06:48:17 Action: Run 'oncheck -cI mcommsg:"info".isidextid#idextid_pk' 06:48:17 See Also: /user/info/tmp/af.42c7710 06:48:17 Rollforward of log record failed. iserrno = 105 06:48:17 Log Record: log = 49721, pos = 13710d4, type = OLDRSAM:DELITEM(29), trans = 949 Or 22:51:47 Assert Failed: Dead Lock 22:51:47 Info Dynamic Server Version 7.31.FC2 22:51:47 Who: Session(96665, luke@green, 8164, 571531792) Thread(96531, sqlexec, 243d80638, 1) File: exfmlukep.c Line: 821 22:51:47 Results: Delete failed 22:51:47 Action: Run 'oncheck -cI mcommsg:"info".isidextid#idextid_pk' 22:51:47 See Also: /user/info/tmp/af.7cfb9ee3 Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to beach_bummer@my-deja.com

Art S. Kagel — Tue, 28 Dec 1999 14:58:09 -0500 — source: Informix-list mailing list archive (1991-1998)

Drop the index and recreate it. Does your database have logging turned on? If not you will have corrupt indexes turning up all the time caused by machine and/or engine crashes, improper shutdowns, etc. If you are not using logging now start, immediately. Art S. Kagel beach_bummer@my-deja.com wrote: > > Assert Fail messages during deletions,always the same index, Running on > TruUnix64 4.0D: > 06:48:17 Assert Failed: Error during recovery left index inconsistent. > 06:48:17 Informix Dynamic Server Version 7.31.FC2 > 06:48:17 Who: Session(713, info@blue, 0, 285820304) > Thread(68, xchg_1.10, 211067048, 1) > File: rskey.c Line: 1366 > 06:48:17 Results: Index 'mcommsg:"info".isidextid#idextid_pk' is now> unusable > 06:48:17 Action: Run 'oncheck -cI mcommsg:"info".isidextid#idextid_pk' > 06:48:17 See Also: /user/info/tmp/af.42c7710 > 06:48:17 Rollforward of log record failed. iserrno = 105 > 06:48:17 Log Record: log = 49721, pos = 13710d4, type = > OLDRSAM:DELITEM(29), trans = 949> > Or > > 22:51:47 Assert Failed: Dead Lock > 22:51:47 Info Dynamic Server Version 7.31.FC2 > 22:51:47 Who: Session(96665, luke@green, 8164, 571531792) > Thread(96531, sqlexec, 243d80638, 1) > File: exfmlukep.c Line: 821 > 22:51:47 Results: Delete failed > 22:51:47 Action: Run 'oncheck -cI mcommsg:"info".isidextid#idextid_pk' > 22:51:47 See Also: /user/info/tmp/af.7cfb9ee3> > Sent via Deja.com http://www.deja.com/ > Before you buy.