From: Hahn, Uwe (uwe.hahnsap.com)
Date: Sun Apr 25 2004 - 10:18:06 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Could you please send me the dbm.knl, dbm.utl and dbm.prt,
so that I can have a look at it directly ?
Thanks
Uwe

-----Original Message-----
From: Ilker Uyanik [mailto:ieuyanikhotmail.com]
Sent: Sonntag, 25. April 2004 17:08
To: Hahn, Uwe; maxdblists.mysql.com
Subject: Re: -126,Databackup missing (Backuphistory lost)

I checked the dbm.utl and none of them is mentioned. I was able to run
interactive log save before, I cannot do that either...

So basically I cannot turn on auto log and I cannot interactively save the
logs. Whne I try to do that in addition the -126 message I also observe the
folowing message in knldiag.err:
2004-04-24 13:24:07 86 ERR 26 Log Backup of Log not allowed. Devicestate is
HistoryLost.

I do not have any inside knowledge, but there should be a table where this
flag is set and I have no idea where it is. It is clearly not docuemnted.

We have another Livecache system with exact same settings and I do not have
this problem there...

Regards,

Ilker

----- Original Message -----
From: "Hahn, Uwe" <uwe.hahnsap.com>
To: "'Ilker Uyanik'" <ieuyanikhotmail.com>; <maxdblists.mysql.com>
Sent: Sunday, April 25, 2004 4:24 AM
Subject: RE: -126,Databackup missing (Backuphistory lost)

> I assume that you enabled AUTOMATIC LOG OVERWRITE or set LOG WRITER OFF.
> Please check this. It should be mentioned in dbm.utl.
> Disable automatic log overwrite and enable log writing.
> After that you have to do the complete data backup again.
> Then you should be able to backup log or enable the autosave_log.
> Kind regards,
> UWe
>
> -----Original Message-----
> From: Ilker Uyanik [mailto:ieuyanikhotmail.com]
> Sent: Sonntag, 25. April 2004 02:39
> To: maxdblists.mysql.com
> Subject: -126,Databackup missing (Backuphistory lost)
>
>
> Clear DayMaxDB documentation clearly says this message means that there is
no
> complete data backup to enable to autosave, but even after creating a
> complete data backup I do get the same message.
>
> So I cannot turn autosave on!!! The system info is :
> SERVERDB: DLC
> The database state is ONLINE
> Kernel Version 'Kernel 7.4.3 Build 031-123-063-122'
> RTE Version 'X64/AIX 7.4.3 Build 031-123-063-122'
>
> The following screen info shows that situation:
> vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
> degu1ds011:dlcadm> dbmcli -d DLC -u control,control -uUTL
> dbmcli on DLC>backup_start DUMMYDATA DATA
> OK
> Returncode 0
> Date 20040424
> Time 00140850
> Server degu1ds011
> Database DLC
> Kernel Version Kernel 7.4.3 Build 031-123-063-122
> Pages Transferred 9520
> Pages Left 0
> Volumes 1
> Medianame DUMMYDATA
> Location /DLC/backup/DUMMYDATA
> Errortext
> Label DAT_00030
> Is Consistent true
> First LOG Page 23454
> Last LOG Page
> DB Stamp 1 Date 20040424
> DB Stamp 1 Time 00140723
> DB Stamp 2 Date
> DB Stamp 2 Time
> Page Count 9484
> Devices Used 1
> Database ID degu1ds011:DLC_20031008_150143
> Max Used Data Page 0
>
> ---
> dbmcli on DLC>autolog_on autosave
> ERR
> -24988,ERR_SQL: sql error
> -126,Databackup missing (Backuphistory lost)
>
> ---
> dbmcli on DLC>
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> Best Regards,
>
> Ilker
>
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/maxdb?unsub=matt.woodsadsdish.com
>
>

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]