Assert Failed: Rowid 0x2101 not found for delete

The system shutdown after reporting an assert failed as follow: 17:30:26 Event alarms enabled. ALARMPROG = '/usr/informix/etc/no_log.sh' 17:30:32 DR: DRAUTO is 0 (Off) 17:30:32 Informix Dynamic Server Version 7.31.UC2A Software Serial Number ACN#J349410 17:30:35 Informix Dynamic Server Initialized -- Shared Memory Initialized. 17:30:35 Physical Recovery Started. 17:30:39 Physical Recovery Complete: 5616 Pages Restored. 17:30:39 Logical Recovery Started. 17:30:42 Assert Failed: Rowid 0x2101 not found for delete in partnum 300013, key 1 17:30:42 Informix Dynamic Server Version 7.31.UC2A 17:30:42 Who: Session(7, root@x2canada, 0, 235359208) Thread(35, fast_rec, e04e28c, 1) File: rsnode.c Line: 2202 17:30:42 Results: Delete failed 17:30:42 Action: Run 'oncheck -cI exp2:"informix".sysprocplan#procplan' 17:30:50 See Also: /tmp/af.40b9981, shmem.40b9981.0 17:30:50 Error writing '/tmp/shmem.40b9981.0' errno = 28 17:30:50 Assert Failed: No Exception Handler 17:30:50 Informix Dynamic Server Version 7.31.UC2A 17:30:50 Who: Session(7, root@x2canada, 0, 235359208) Thread(35, fast_rec, e04e28c, 1) File: mtex.c Line: 446 17:30:50 Results: Exception Caught. Type: MT_EX_OS, Context: mem 17:30:50 Action: Please notify Informix Technical Support. 17:30:50 See Also: /tmp/af.40b9981, shmem.40b9981.1 17:30:50 Error writing '/tmp/shmem.40b9981.1' errno = 28 17:30:50 mtex.c, line 446, thread 35, proc id 2879, No Exception Handler. 17:30:50 Error 12 occurred executing /bin/sh /bin/sh -c /usr/informix/etc/no_log.sh 4 2 "Index failure: 'exp2:"informix".sysprocplan#procplan'." "Rowid 0x2101 not fou 17:30:50 PANIC: Attempting to bring system down We can't run oncheck because we were unable to bring the system in quiescent mode. I would like to know if there is any way how to force bring the instance up even there is inconsistencies. Regards, Rachid Nafidi rachid.nafidi@itsys-consulting.com Tel:((514)9477948 Fax:(450)9677806 www.itsys-consulting.com

Hi, it looks like there's some corruption that prevents logical recovery from working. I think 7.31.UC2A is not a regular IDS version (a bit old as well). Can you get help from the IBM Informix Tech Support in your region ? I think they are in the best position to analyse the problem and help to get it up and running again. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions forum.subscriber@iiug.org wrote on 11.07.2004 04:38:32: > The system shutdown after reporting an assert failed as follow: > > > 17:30:26 Event alarms enabled. ALARMPROG = '/usr/informix/etc/no_log.sh' > 17:30:32 DR: DRAUTO is 0 (Off) > 17:30:32 Informix Dynamic Server Version 7.31.UC2A Software Serial Number > ACN#J349410 > 17:30:35 Informix Dynamic Server Initialized -- Shared Memory Initialized. > 17:30:35 Physical Recovery Started. > 17:30:39 Physical Recovery Complete: 5616 Pages Restored. > 17:30:39 Logical Recovery Started. > 17:30:42 Assert Failed: Rowid 0x2101 not found for delete in partnum > 300013, key 1 > 17:30:42 Informix Dynamic Server Version 7.31.UC2A > 17:30:42 Who: Session(7, root@x2canada, 0, 235359208) > Thread(35, fast_rec, e04e28c, 1) > File: rsnode.c Line: 2202 > 17:30:42 Results: Delete failed > 17:30:42 Action: Run 'oncheck -cI exp2:"informix".sysprocplan#procplan' > 17:30:50 See Also: /tmp/af.40b9981, shmem.40b9981.0 > 17:30:50 Error writing '/tmp/shmem.40b9981.0' errno = 28 17:30:50 Assert > Failed: No Exception Handler 17:30:50 Informix Dynamic Server Version > 7.31.UC2A > 17:30:50 Who: Session(7, root@x2canada, 0, 235359208) > Thread(35, fast_rec, e04e28c, 1) > File: mtex.c Line: 446 > 17:30:50 Results: Exception Caught. Type: MT_EX_OS, Context: mem > 17:30:50 Action: Please notify Informix Technical Support. > 17:30:50 See Also: /tmp/af.40b9981, shmem.40b9981.1 > 17:30:50 Error writing '/tmp/shmem.40b9981.1' errno = 28 17:30:50 mtex.c, > line 446, thread 35, proc id 2879, No Exception Handler. > 17:30:50 Error 12 occurred executing /bin/sh /bin/sh -c > /usr/informix/etc/no_log.sh 4 2 "Index failure: > 'exp2:"informix".sysprocplan#procplan'." "Rowid 0x2101 not fou 17:30:50 > PANIC: Attempting to bring system down > > > > We can't run oncheck because we were unable to bring the system in quiescent mode. I would like to know if there is any way how to force bring the instance up even there is inconsistencies. > > > Regards, > > Rachid Nafidi > rachid.nafidi@itsys-consulting.com > Tel:((514)9477948 > Fax:(450)9677806 > www.itsys-consulting.com > >