Hi,

hmm. If you think that this is a bug in the archiving, then
I'm not really contradicting. The version of IDS that you
are using is really old. I will not go and try to find out
whether such a problem was known in this old version.
And I hope you do not expect this bug to be fixed
in that version of IDS.

You will have to upgrade.

Sorry,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland GmbH
Chairman of the Supervisory Board: Hans Ulrich Märki
Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian
Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael
Diemer
Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart,
HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940

informix-list-bounces@iiug.org wrote on 19.06.2007 16:15:10:
> Thanks for replies!
>
> >========================================
> > I would try to first do physical only restore ("ontape -p").
> >
> > Then try to bring the server to on-line mode.
> > You may try this by doing "onmode -m", or "onmode -yuk"
> > followed by "oninit".
> >========================================
>
> Of course, I tried that. Result is the same:
>
> % ontape -p
> Program over.
> %
> online.log: nothing
>
> % onmode -m
> %
> online.log:
> # 18:55:06 Log 27 not found.
> # 18:55:06 Cannot change to On-Line Mode.
>
> >==========================================
> > If there is an open transaction that needs to be rolled back,
> > but there are no log records, then the above will most likely
> > not solve the problem. In that case Tech Support may be able
> > to cut off that transaction so that it will not be rolled back. Then
> > you'd have somewhere a logic inconsistency, but
> > at least you could access most of the data ...
> >===========================================
>
> Lost transaction and some logic inconsistency are the last things
> I'm thinking about now.
>
> The main point is: this defective 0-archive does not contain any
> logical log file at all.
> As a result, after restore (ontape -r) logical log IS EMPTY (see my
> example with "onstat -l").
> And IDS can't begin any work besause there is no starting checkpoint
> (it cannot finish
> restore in 'without logical recovery' mode, cannot start logical
> recovery (see my 1st posting), etc.)
>
> Is any special way to "put down" missing data into the empty logical
> log? (Some special
> utilities?)
> As I see, missing information is the log file and the checkpoint
> with loguniq/logpos
> fixed in the archive (27/0x7ff018 in my example).
>
> ----------------------------------- appendix
> -----------------------------------
> I cleared up circumstances, in wich defective 0-archive (without log
> file) is creating.
> The 'archive' checkpoint is THE LAST RECORD in the current log file.
> This is obvious bug of IDS/ontape.
> I can stably reproduce this situation (examples above are the results
> of purposeful experiments):
>
> onlog:
> # log number: 27.
> # addr len type xid id link
> # ...
> # 7fc7e4 56 HUPDAT 6 0 7fc7ac 500030 18e0b 0 128 128
> 1
> # 7fd038 56 HUPDAT 6 0 7fc7e4 500030 18e0c 0 128 128
> 1
> # 7fd070 36 COMMIT 6 0 7fd038 06/13/2007 18:34:32
> # 7fe018 32 CKPOINT 1 27 0 0
> # 7ff018 32 CKPOINT 1 27 0 0
> #
> # log number: 28.
> #
> # 18 52 ARCINFO 9 28 0 0 06/13/2007 18:35:03 0x17454d 27
> 0x7ff018
> # 4c 52 ARCINFO 9 0 18 0 06/13/2007 18:35:03 0x17454d 27
> 0x7ff018
> # 80 52 ARCINFO 9 0 4c 0 06/13/2007 18:35:03 0x17454d 27
> 0x7ff018
> # b4 52 ARCINFO 9 0 80 0 06/13/2007 18:35:03 0x17454d 27
> 0x7ff018
> # e8 52 ARCINFO 9 0 b4 0 06/13/2007 18:35:03 0x17454d 27
> 0x7ff018
> # 11c 52 ARCINFO 9 0 e8 0 06/13/2007 18:35:03 0x17454d 27
> 0x7ff018
> # 150 52 ARCINFO 9 0 11c 0 06/13/2007 18:35:03 0x17454d 27
> 0x7ff018
> # 1018 32 CKPOINT 1 28 0 0
> # 2018 52 LOGINFO 6 28 0 26 06/13/2007 20:46:35 0x1745ab
> # 3018 52 LOGINFO 6 0 2018 27 06/13/2007 20:46:36 0x1745ac
>
> log file length = 2048 ( => max.pos is 0x7fffff).
> CKPOINT(7fe018) - the result of "onmode -c".
> CKPOINT(7ff018) - the result of starting "ontape -s".
>
--------------------------------------------------------------------------------------------------------------------------------
>
> Vadim Kubrak,
> DataX/FLORIN
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list