Re: Assert Failed: Page Check Error in bfput

Hi, I recommend you open a case with IBM Technical Support to have them look into it. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management owner-informix-list@iiug.org wrote on 14.09.2005 17:20:33: > I could use some help on the below message: > > Informix Dynamic Server Version 7.31.UC6 on Solaris 7 > > 09:24:21 Assert Failed: Page Check Error in bfput > 09:24:21 Informix Dynamic Server Version 7.31.UC6 > 09:24:21 Who: Session(1577425, ac758200@emco11, 4732, 2137802408) > Thread(2569850, sqlexec, 79c2db10, 3) > File: rsdebug.c Line: 1036 > 09:24:21 Results: Possible inconsistencies in 'cdi:"informix".auth_l' > 09:24:21 Action: Run 'oncheck -cDI cdi:"informix".auth_l' > 09:24:31 Logical Log 444272 Complete. > 09:24:41 See Also: /tmp/af.3a622485 > 09:24:41 Assert Failed: Rollback error 172 > 09:24:41 Informix Dynamic Server Version 7.31.UC6 > 09:24:41 Who: Session(1577425, ac758200@emco11, 4732, 2137802408) > Thread(2569850, sqlexec, 79c2db10, 3) > File: rsextlog.c Line: 1450 > 09:24:41 Results: Log record (OLDRSAM:DELITEM) in log 444271, offset0x3e85d0 > was not rolled back > 09:24:41 Action: Use 'onlog' to view the transaction and repair manually. > 09:25:00 See Also: /tmp/af.3a622485 > 09:25:00 Checkpoint Completed: duration was 16 seconds.> > I ran oncheck -cDI cdi:"informix".auth_l and got the following error: > BAD PAGE 30fcaa1: pg_addr 0 != bp->bf_pagenum 30fcaa1 > > > I exported the table, no issues. Dropped the indexes. Renamed the table to > auth_l_bad. Created the new table and imported the data and indexed. > > Do I need to address this beyond this point? Can I delete the renamed table or > is there something wrong with the space it's on? > > Thanks > Gary Quiring sending to informix-list