Hello.

Sadly has no one an idea for my latest problems.

Perhaps, you can help me with this question.

ClassicServer 2.01. After I have deleted much data once more, the
gstat-monitor shows me the follow:

Oldest Tr. 16339
Oldest active 16340
Oldest snapshot 4656
Next transaction 198659
Bumped trans. 1
Sequenceno. 0
Next attachmentid 428
Implementation id 16
Shadow count 0
Page puffers 0
Next header page 0
Database dialect 3
Creation date feb 12, 2009 20:29:52
Attributes force write
Sweep interval 20000

The deletion I have made with IB Manager 3. I have committed all steps and
close the program after action.

What does the snapshot counter mean? Can I manually update the counters?
(oldest transaction)

The deleted data are gone, but not the counter - despite I have committed
all erasing steps.

I have my doubts, if I close the network connection to backup the database,
that the database will be corrupted again. Currently the database works fine
and the automatically backup does finish.


My second database works fine since nearly 5 Years. I never had to create a
backup, but since four weeks, (without any changes on my application) the
oldest transaction counter does not go forward, like the next transaction
counter. It doesn't count (oldest transaction) for many days ago. But the
database still work. This database running on firebird 1.5.0

Please, have anyone an idea?

Thank you.


-----Ursprüngliche Nachricht-----
Von: Olaf Kluge [mailto:olaf.kluge@...]
Gesendet: Freitag, 13. Februar 2009 08:28
An: 'firebird-support@yahoogroups.com'
Betreff: damaged database

Hello.

I've a little problem with my firebird database. The classicserver 2.01 is
running on a quad core machine, 4 GB RAM, Windows 2003 Server.

Yesterday, I have deleted much old data on any tables taken with my IB
Manager. After this, the database works fine again. I have made a backup
copy - without any problems.

But the statistics of my database (gbak -h) looks not good. A hour later,
the same problem. The oldest transaction: 4000 and the next transaction:
119000- rising. I have thought that I can clear the problem with
backup-restore. All connections I have closed, and then I have disabled my
network adapter, that no user can connect to my database.

With my EMS-Manager I have access over 127.0.0.1, although it is no active
connection available. But now, the backup-cycle does not end. Gbak does run
and run, but with no result. (With the -g switch manually, it does work)

But, after I have tried a backup, the statistics were fine! The two counters
had nearly no difference! But I could no longer access the database.

Result: After I have disabled my network connection, the database cannot
backup, does not work again after running backup, but the statistics are
good. I had an old backup restored.

Now, I have these questions:

Can any one help me, what's the problem? Thousands records I have deleted,
but the next transactions-counter stopped. Also, when I have closed my
EMS-Manager and commit after every step.

It there a problem with disabled network connection? Does the database
damage? Why does gbak only works with this -g switch after this - so in my
case?

After I restart the firebird-serviced (classic server), I have no access to
my database. What can it be?

Thanks for your help. In this way, also many thanks to mr Streicher for your
friendly help.

With best regards

Olaf Kluge