Oninit cdi / Archive
Talk to an expert →

Error when initializing

Posted in 2007

Summary

A user's IDS 10.00 server hung during startup, stuck in Fast Recovery showing "Blocked:CKPT". Respondents asked for onstat -m/-l output and suspected full logical logs. The message log confirmed it: "Logical Log Files are Full -- Backup is Needed" (plus an alarmprogram.sh failing with return code 126). Advice was to back up the logs or add more logs; since the user had no tape device, the suggested workaround was onmode -ky, set LTAPEDEV to /dev/null, and restart. No confirmation from the poster that it worked is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

juanc — — source: Usenet: comp.databases.informix

On IDS 10.00 when I trying to startup it remains eternally. In another screen (onstat -) appears IBM Informix Dynamic Server Version 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 Kbytes Blocked:CKPT. That I must do?

↪ replying to juanc
TBP — — source: Usenet: comp.databases.informix

juanc wrote: > On IDS 10.00 when I trying to startup it remains eternally. In > another screen (onstat -) appears IBM Informix Dynamic Server Version > 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 > Kbytes Blocked:CKPT. > > That I must do? > Post the output from onstat -m and onstat -l.

↪ replying to juanc
Jonathan Leffler — — source: Usenet: comp.databases.informix

juanc wrote: > On IDS 10.00 when I trying to startup it remains eternally. In > another screen (onstat -) appears IBM Informix Dynamic Server Version > 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 > Kbytes Blocked:CKPT. > > That I must do? I suspect that you have your logical logs full and needing backup, or something along those lines. Either add some more logs or do the archive. If that isn't the problem, send the onstat outputs suggested by The Spud (aka The Big Potato). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2007.0226 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler
juanc — — source: Usenet: comp.databases.informix

On May 19, 1:43 pm, Jonathan Leffler <jleff...@earthlink.net> wrote: > juanc wrote: > > On IDS 10.00 when I trying to startup it remains eternally. In > > another screen (onstat -) appears IBM Informix Dynamic Server Version > > 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 > > Kbytes Blocked:CKPT. > > > That I must do? > > I suspect that you have your logical logs full and needing backup, or > something along those lines. Either add some more logs or do the > archive. If that isn't the problem, send the onstat outputs suggested > by The Spud (aka The Big Potato). > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleff...@earthlink.net, jleff...@us.ibm.com > Guardian of DBD::Informix v2007.0226 --http://dbi.perl.org/ Yor are righ, onstat -m show: but, in this moment i don't have tape backup. 06:36:20 Warning: shared-memory connection file '/INFORMIXTMP/.inf.omega' is overwritten. This file might belong to another instance of IDS server. If the service name of the IDS database server is not unique in the environment of the host computer where the database server resides, rename the service. 06:36:20 IBM Informix Dynamic Server Version 10.00.UC6TL SoftwareSerial Number AAA#B000000 06:36:20 Your evaluation license will expire on 2007-08-04 00:00:00 06:36:21 IBM Informix Dynamic Server Initialized -- Shared MemoryInitialized. 06:36:21 Physical Recovery Started at Page (1:587). 06:36:21 Physical Recovery Complete: 428 Pages Examined, 428 Pages Restored. 06:36:21 Logical Recovery Started. 06:36:21 10 recovery worker threads will be started. 06:36:22 Fast Recovery Switching to Log 5 06:36:23 Fast Recovery Switching to Log 6 06:36:26 Logical Recovery has reached the transaction cleanup phase. 06:36:26 Logical Log Files are Full -- Backup is Needed 06:36:26 Process exited with return code 126: /bin/sh /bin/sh -c /informix/ids10/etc/alarmprogram.sh 3 20 "Logical Logs are Full -- Backup is Needed." "Logical Log Fil

↪ replying to juanc
TBP — — source: Usenet: comp.databases.informix

juanc wrote: > On May 19, 1:43 pm, Jonathan Leffler <jleff...@earthlink.net> wrote: >> juanc wrote: >>> On IDS 10.00 when I trying to startup it remains eternally. In >>> another screen (onstat -) appears IBM Informix Dynamic Server Version >>> 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 >>> Kbytes Blocked:CKPT. >>> That I must do? >> I suspect that you have your logical logs full and needing backup, or >> something along those lines. Either add some more logs or do the >> archive. If that isn't the problem, send the onstat outputs suggested >> by The Spud (aka The Big Potato). >> >> -- >> Jonathan Leffler #include <disclaimer.h> >> Email: jleff...@earthlink.net, jleff...@us.ibm.com >> Guardian of DBD::Informix v2007.0226 --http://dbi.perl.org/ > > > > Yor are righ, onstat -m show: > > but, in this moment i don't have tape backup. > > 06:36:20 Warning: shared-memory connection file '/> INFORMIXTMP/.inf.omega' is overwritten. This file might > belong to another instance of IDS server. If the service name of the > IDS > database server is not unique in the environment of the host computer > where > the database server resides, rename the service. > 06:36:20 IBM Informix Dynamic Server Version 10.00.UC6TL Software> Serial Number AAA#B000000 > 06:36:20 Your evaluation license will expire on 2007-08-04 00:00:00 > > 06:36:21 IBM Informix Dynamic Server Initialized -- Shared Memory> Initialized. > > 06:36:21 Physical Recovery Started at Page (1:587). > 06:36:21 Physical Recovery Complete: 428 Pages Examined, 428 Pages > Restored. > 06:36:21 Logical Recovery Started. > 06:36:21 10 recovery worker threads will be started. > 06:36:22 Fast Recovery Switching to Log 5 > 06:36:23 Fast Recovery Switching to Log 6 > 06:36:26 Logical Recovery has reached the transaction cleanup phase. > 06:36:26 Logical Log Files are Full -- Backup is Needed > > 06:36:26 Process exited with return code 126: /bin/sh /bin/sh -c /> informix/ids10/etc/alarmprogram.sh 3 20 "Logical Logs are Full -- > Backup is Needed." "Logical Log Fil > Well, you could try setting LTAPEDEV to /dev/null, as you do not have a backup you will be in no worse position throwing your log backups down /dev/null. And this is a fairly new instance (switching to Log 5 then log 6). Run onmode -ky and then set LTAPEDEV to /dev/null and then try starting up. Where did this instance come from (i.e. is this a fairly recent new instance? or a "copy" from another machine?)

↪ replying to TBP
scottishpoet — — source: Usenet: comp.databases.informix

06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software

↪ replying to juanc
Art S. Kagel — — source: Usenet: comp.databases.informix

juanc wrote: > On IDS 10.00 when I trying to startup it remains eternally. In > another screen (onstat -) appears IBM Informix Dynamic Server Version > 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 > Kbytes Blocked:CKPT. > > That I must do? Post the output from onstat -l, I suspect that your logical logs are full and need to be archived. Art S. Kagel

Related threads

Glossary