🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.opensource
Article #198

Re: Disaperaed data

#198
From: Magnus Flysj�
Date: Wed, 16 Nov 2005 12:55
29 lines
2204 bytes
I have the same problem.
But this is on a 6.0.2.0 version.

We have an application that never commited as often as it should.
When the application is close and commit was called, we lost all data and I 
have no idea why.

Also, the GDB file grown very fast.. but if I use gbak and gfix, the file is 
shrinken from 32MB to only 2MB.

Can anyone smart confirm if there will be a problem if data isn't commited 
often?


"Kr�lik" <jaroslaw.smyczynski@arisco.pl> skrev i meddelandet 
news:42a975c4$1@newsgroups.borland.com...
> We have IB server version LI-V6.0.1.0 on Debian Linux 3.0
> About month ago database file was copy to the server,
> and have been used intensivly up to yesterday by up to
> ten users. All introduced data was visible. IB server worked
> all the time.
> Yesterday the core of Linux was changed from 2.4.30 to 2.4.31,
> so IB server was shutdown. After restart all data inroduced
> during last month disapeared.
> We have backup copy of database file made everyday, but
> all file proved to be identical with the initial file.
> What can be a reason of such strange behaviour?
> May it be that all data was cached (forced write is off)
> during this month ? 
Technical Details
Message-ID: <437b2c01@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <42a975c4$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,2b7ab1a9c8c0694
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII
Reply-To: "Magnus Flysj�" <magnus@flysjo.com>
From: "Magnus Flysj�" <magnus@flysjo.com>
Newsgroups: borland.public.interbase.opensource
References: <42a975c4$1@newsgroups.borland.com>
Subject: Re: Disaperaed data
Date: Wed, 16 Nov 2005 13:55:05 +0100
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 213.112.41.159
Message-ID: <437b2c01@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1132145665 213.112.41.159 (16 Nov 2005 04:54:25 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail