[firebird-support] FB 1.5 server sluggish after been up for awhile

[halim1...@hotmail.com [firebird-support]]

Hello All,
 we are still on FB 1.5 release, our live Database is about 50 GB. While using 
the freshly restored database, things are very fast in the beginning but they 
get slower and slower as weeks go by. We are always forced to do a 
backup/restore after 4 weeks or so.
 In the beginning we were thinking about the database itself. a Backup and 
restore would fix any speed issue but in recent days, I decided to stop and 
restart FB service without DB backup and restore. After doing so, everything 
was extremely fast as if we did a backup/restore.
 Do you think this is normal, every now and then a Firebird restart is needed?
 We are using Windows 2008 Server. Raid 0 HD 
 

 Thank you all,
 -Halim
 

 

Re: [firebird-support] GBAK - validation error for column X, value *** null ***

['Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]]

If you only have a backup and the backup is corrupted then  very bad
news.

The best politic is always to do a backup/restore cycle inmediatly. So, if
an error is detected when the backup is being restored you can take actions
at that right moment.

If your operating system is Windows, you can open a command window and
write:

*GBAK -b -user SYSDBA -password masterkey MyDataBase.FDB stdout | GBAK
-user SYSDBA -password masterkey -r stdin MyRestoredDatabase.FDB*

Any error will be inmediatly detected.

And, if you can read Spanish, the following page has more info about this
subject:

https://firebird21.wordpress.com/2013/03/05/backup-y-restauracion-al-mismo-tiempo/

Greetings.

Walter.


On Fri, May 15, 2015 at 4:41 AM, Josef Kokeš j.ko...@apatykaservis.cz
[firebird-support] firebird-support@yahoogroups.com wrote:



 Hi!

 Thanks for the answer. Luckily, I still have the FDB file, so I can get
 rid of the bad records easily. What has me concerned is, what if I only
 had the backup? Your trick with pumping seems plausible, I will have to
 give it a try. IBBackupSurgeon looks promising, too.

 Josef

 On 15.5.2015 9:14, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote:
 
  Hi Josef,
 
  Such error is the consequence of the corruption - in the original
  database there was a NULL in the field (most likely, all fields in
  that record are NULL).
  gbak does not check constraints when reading.
 
  The best way to fix it is to find record with NULLs in the original
  database and delete it, then repeat backup/restore.
  If you don't have original records, it can be a problem.
  Try to restore database till the privileges error and then pump data
  from partially restored database to the new empty database with the
  same structure - you can use free tool IBDataPump for it.
  If problems continue, you can export data using our proprietary
  IBBackupSurgeon tool (http://ib-aid.com/en/ibbackupsurgeon/), which
  can export data on low-level.
 
  Regards,
  Alexey Kovyazin
  IBSurgeon