Cannot Rollforward from Checkpoint

hello All, I am facing following problem while starting up the informix instance. when i run the oninit command, the following error appears in message log file. ---------------------------------------------------------- 18:30:04 Loading Module <CNULL> 18:30:04 Booting Language <builtin> from module <> 18:30:04 Loading Module <BUILTINNULL> 18:30:08 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:30:09 DR: DRAUTO is 0 (Off) 18:30:09 Dynamically allocated new message shared memory segment (size 56KB) 18:30:09 IBM Informix Dynamic Server Version 10.00.UC1 Software Serial Number AAA#B000000 18:30:09 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 18:30:09 Physical Recovery Started at Page (1:821). 18:30:09 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 18:30:09 Logical Recovery Started. 18:30:09 10 recovery worker threads will be started. 18:30:09 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:30:09 Fast Recovery Switching to Log 1364 18:30:18 I/O read chunk 1, pagenum 114583, pagecnt 32 --> errno = 5 18:30:18 Cannot Rollforward from Checkpoint. 18:30:19 IBM Informix Dynamic Server Stopped. 18:30:19 mt_shm_remove: WARNING: may not have removed all/correct segments ------------------------------------------------------------- can anybody suggest the solution, what should i do. i dont have any backup, no dbexport and all data is stored in only one dbspace named rootdbspace

Well, then you have a serious problem. One of your chunks is corrupted in some way. Errno 5 is a generic read error, your system or disk array logs may have more information and may be able to tell you if this is recoverable. Sounds like a typical RAID5 *&%^ up, to me. If you had mirrors or an archive or even a replicant server you'd be OK. With none of those ways to recover, you are probably hosed. Art S. Kagel ----- Original Message ----- From: Ahmed Bilal <ids@iiug.org> At: 3/09 8:33:55 hello All, I am facing following problem while starting up the informix instance. when i run the oninit command, the following error appears in message log file. ---------------------------------------------------------- 18:30:04 Loading Module <CNULL> 18:30:04 Booting Language <builtin> from module <> 18:30:04 Loading Module <BUILTINNULL> 18:30:08 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:30:09 DR: DRAUTO is 0 (Off) 18:30:09 Dynamically allocated new message shared memory segment (size 56KB) 18:30:09 IBM Informix Dynamic Server Version 10.00.UC1 Software Serial Number AAA#B000000 18:30:09 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 18:30:09 Physical Recovery Started at Page (1:821). 18:30:09 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 18:30:09 Logical Recovery Started. 18:30:09 10 recovery worker threads will be started. 18:30:09 Dynamically allocated new virtual shared memory segment (size 8192KB) 18:30:09 Fast Recovery Switching to Log 1364 18:30:18 I/O read chunk 1, pagenum 114583, pagecnt 32 --> errno = 5 18:30:18 Cannot Rollforward from Checkpoint. 18:30:19 IBM Informix Dynamic Server Stopped. 18:30:19 mt_shm_remove: WARNING: may not have removed all/correct segments ------------------------------------------------------------- can anybody suggest the solution, what should i do. i dont have any backup, no dbexport and all data is stored in only one dbspace named rootdbspace ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

On 09/03/07, AHMED BILAL <billaall@gmail.com> wrote: > hello All, > > I am facing following problem while starting up the informix instance. when i > run the oninit command, the following error appears in message log file. > > ---------------------------------------------------------- > 18:30:04 Loading Module <CNULL> > 18:30:04 Booting Language <builtin> from module <> > 18:30:04 Loading Module <BUILTINNULL> > 18:30:08 Dynamically allocated new virtual shared memory segment (size 8192KB) > 18:30:09 DR: DRAUTO is 0 (Off) > 18:30:09 Dynamically allocated new message shared memory segment (size 56KB) > 18:30:09 IBM Informix Dynamic Server Version 10.00.UC1 Software Serial Number > AAA#B000000 > 18:30:09 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. > > 18:30:09 Physical Recovery Started at Page (1:821). > 18:30:09 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. > 18:30:09 Logical Recovery Started. > 18:30:09 10 recovery worker threads will be started. > 18:30:09 Dynamically allocated new virtual shared memory segment (size 8192KB) > 18:30:09 Fast Recovery Switching to Log 1364 > 18:30:18 I/O read chunk 1, pagenum 114583, pagecnt 32 --> errno = 5 > 18:30:18 Cannot Rollforward from Checkpoint. > 18:30:19 IBM Informix Dynamic Server Stopped. > > 18:30:19 mt_shm_remove: WARNING: may not have removed all/correct segments > > ------------------------------------------------------------- > > can anybody suggest the solution, what should i do. i dont have any backup, no > dbexport and all data is stored in only one dbspace named rootdbspace > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > Oh dear !! Throwing yourself on the nearest pointed, sharp object is rather messy and probably painful. If you have support now might be a good time to call in. It may be possible to bring the engine up and skip the fast recovery step (just enough access to pull your data off) or you may be able fool the engine into believing no work was done after the checkpoint. What caused the engine to go down in the first place? Keith

First have a look if all the chunks are accessable. Error 5 points to problems writing to a chunk. You can check using dd if all chunks can be read. If so, contact support. If not, look for messages in the operating system. Good luck ! > On 09/03/07, AHMED BILAL <billaall@gmail.com> wrote: > > hello All, > > > > I am facing following problem while starting up the informix instance. when > i > > run the oninit command, the following error appears in message log file. > > > > ---------------------------------------------------------- > > 18:30:04 Loading Module <CNULL> > > 18:30:04 Booting Language <builtin> from module <> > > 18:30:04 Loading Module <BUILTINNULL> > > 18:30:08 Dynamically allocated new virtual shared memory segment (size > 8192KB) > > 18:30:09 DR: DRAUTO is 0 (Off) > > 18:30:09 Dynamically allocated new message shared memory segment (size 56KB) > > 18:30:09 IBM Informix Dynamic Server Version 10.00.UC1 Software Serial > Number > > AAA#B000000 > > 18:30:09 IBM Informix Dynamic Server Initialized -- Shared Memory > Initialized. > > > > 18:30:09 Physical Recovery Started at Page (1:821). > > 18:30:09 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. > > 18:30:09 Logical Recovery Started. > > 18:30:09 10 recovery worker threads will be started. > > 18:30:09 Dynamically allocated new virtual shared memory segment (size > 8192KB) > > 18:30:09 Fast Recovery Switching to Log 1364 > > 18:30:18 I/O read chunk 1, pagenum 114583, pagecnt 32 --> errno = 5 > > 18:30:18 Cannot Rollforward from Checkpoint. > > 18:30:19 IBM Informix Dynamic Server Stopped. > > > > 18:30:19 mt_shm_remove: WARNING: may not have removed all/correct segments > > > > ------------------------------------------------------------- > > > > can anybody suggest the solution, what should i do. i dont have any backup, > no > > dbexport and all data is stored in only one dbspace named rootdbspace > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > Oh dear !! > > Throwing yourself on the nearest pointed, sharp object is rather messy > and probably painful. > If you have support now might be a good time to call in. It may be > possible to bring the engine up and skip the fast recovery step (just > enough access to pull your data off) or you may be able fool the > engine into believing no work was done after the checkpoint. > What caused the engine to go down in the first place? > > Keith > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > _________________________________________________________________________ In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten! Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114