AW: AW: Data lost in MaxDB 7.5.0.23

> -----Ursprüngliche Nachricht-----
> Von: Dmitry [mailto:orbb@xxxxxxxxxxxx] 
> Gesendet: Freitag, 28. Januar 2005 04:02
> An: Brunzema, Martin
> Betreff: Re: AW: Data lost in MaxDB 7.5.0.23
> 
> 
> Hello.
> There is no one error in knldiag.err.
> I attach this log.
> But there is some messages in knldiag.old
> Take a look:
> +++++++++++++++++++++++++++++++++++++++ Kernel Exit 
> ++++++++++++++++++++
> ++++++++2005-01-27 10:45:59     0     11987 dump_rte rtedump 
> written to
> file 'rtedump'
> 2005-01-27 10:46:00     0     12847 DBSTATE  Kernel exited 
> without core
> and exit status 0x9
> 2005-01-27 10:46:00     0     12850 DBSTATE  Kernel exited 
> due to signal
> 9(SIGKILL)
> 2005-01-27 10:46:01     0     12808 DBSTATE  Flushing knltrace pages
> 2005-01-27 10:46:01     0 WNG 11824 COMMUNIC Releasing  T76 
> kernel abort
> 2005-01-27 10:46:02     0 WNG 11824 COMMUNIC Releasing  T77 
> kernel abort
> 2005-01-27 10:46:02     0 WNG 11824 COMMUNIC Releasing  T78 
> kernel abort
> 2005-01-27 10:46:02     0     12696 DBSTATE  Change DbState 
> to 'OFFLINE
> '(29)
> --------------------------------------- current write position
> -----------------
> 'rtedump' was attached in last letter.
> 
> >Did the script executed a commit of it's transaction?
> Yes, script work in autocommit mode. 
> During work of a script i have executed simple query (select * from
> MyTable where ...) in other session and can see added records.
> Other event (The first attempt of use MaxDB 7.5.0.23):
> Week ago, i have created database and one table in it.
> After this in other session (!!!) i began to add records into table by
> script. 
> (I saw the added records by SQL Studio)
> In next day db connection was broken. Created table and data in it was
> lost. 
> Database was empty.
> 
> 
> > Hi Dmitry,
> > 
> > > Hello.
> > > I have installed on the computer MaxDB 7.5.0.23. OS is linux FC2.
> > > I have created a database and one table in it.
> > > Set Log Writing parameter to OFF.
> > > I began to add records into table by my perl script (to connect a
> > > database i use unixODBC).
> > > It takes 3 days. After this script call disconnect and terminate
> > > successfully.
> > > Result: Data area Used space = 36% (3.6 Gb)
> > > I have tried to execute query "select count(*) from MyTable" and 
> > > start the perl script to add a new portion of the data. After 
> > > 10 minutes
> > > db connection was broken.
> > > Execution of query and script was terminated. 
> > > I have started Database Manager: database status is 
> offline!...why?
> > 
> > Please have a look into the file knldiag.err, which is located in
> > the rundirectory of the database. If an error occured, it should
> > be noted there.
> > 
> > > I have set it status to online.
> > > Result: Data area Used space = 6% (0.6 Gb)
> > > Data was lost! Those records have escaped which were added in 
> > > first day.
> > > (in second day i have set db status to offline and set it 
> to online
> > > again)
> > > How this can be?
> > 
> > Did the script executed a commit of it's transaction? If a 
> transaction
> > is open while the database is set to offline, this transaction will
> > be rollbacked at the next restart.
> > 
> > 
> > Kind regards, Martin
> -- 
> Dmitry <orbb@xxxxxxxxxxxx>
> 



Hi Dmitry,

please send your mails to the distribution list so that all
readers of the list can participate.

The kernel terminated at 2005-01-27 10:46:00 due to a SIGKILL.
My Assumption ist, that at this time no savepoint has been written
so that all changed data were not made persistent on disk.
Because you switched logwriting off, no redo could take place
at the next restart, so that your data is lost.
Please do not switch off logging unless you are sure that a
loss of data will not have impact to your businness.

regards, Martin





--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx