Assert error last night :-(

Posted in 2010

BRETT SIMPSON — Fri, 19 Nov 2010 04:59:07 — source: IIUG Forums & Mailing Lists

HI I got this error on our live database last night 17:54:41 Assert Failed: Page Check Error in phposition:isposition:bad page 17:54:41 IBM Informix Dynamic Server Version 9.40.UC7 17:54:41 Who: Session(35462, cs3@suze, 10771, 0x96e058f8) Thread(35871, sqlexec, 8f9823d8, 1) File: rsdebug.c Line: 1081 17:54:41 Results: Possible inconsistencies in 'actrol:"cs3".podetm' 17:54:41 Action: Run 'oncheck -cDI actrol:"cs3".podetm' 17:54:41 stack trace for pid 1913 written to /work/data/informix/dump/af.9007cdb0 17:54:41 See Also: /work/data/informix/dump/af.9007cdb0, shmem.9007cdb0.0 17:55:12 Page Check Error in phposition:isposition:bad page 17:55:18 Assert Failed: Page Check Error in phposition:isposition:bad page The oncheck wouldnt fix it. The error was corrupt. I dropped the index and ran oncheck -cD but that errored as well. I had to drop and load the table from backup. The disk array the database is on had no errors (all lights green) could this error be leaning more towards a hardware issue ?