RE: [firebird-support] Re: Another Error When Backup

[intelru...@yahoo.com [firebird-support]]

Hi Christine, dd is not really a proper way to test RAM (since if it fails, 
chances are you had a hard time booting in the first place). There are a lot of 
memtest tools out there. I've had success with prime95 as well. Whatever you 
pick, give it some time. Not really sure what is considered 'enough' but more 
*is* better in such matters :)

RE: [firebird-support] Re: Another Error When Backup

['Christine S' christine.sanj...@melawai.com [firebird-support]]

Dear Vlad, 

 

Did you mean gfix –validate ? Yes I tried it, and there is no errors. 

Here is my memory test with dd command – the result of md5 is all same and no 
errors found : 

memtest2.jpg

 

About running DDL,  yes.. I actively alter table as is needed. Is this 
forbidden on live database ? 

 

Do you have a complete guide for database maintenance? and what shouldn’t and 
should do ? 

 

Regards, 

Christine Sanjaya - MIS 

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Tuesday, April 26, 2016 5:58 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Another Error When Backup

 

  

> ---In firebird-support@yahoogroups.com, <whitebuble@...> wrote :


Christine 

> 

> Did anyone ever face this error when gbak ? 

> 

> gbak: ERROR:internal Firebird consistency check (decompression overran buffer 
> (179), file: sqz.cpp line: 239)

> gbak: ERROR:gds_$receive failed

> gbak:Exiting before completion due to errors

 

  Your database still get corrupted. gbak reads whole db therefore it detect 
corruption. But gbak is nor a reason of corruption, nor 
a correct tool for diagnosis (gfix is). I ask you again to check RAM on server 
machine. One more question - does you run DDL 
statements such as ALTER TABLE on live database ?

Regards,
Vlad





[Non-text portions of this message have been removed]

[firebird-support] Re: Another Error When Backup

[hv...@users.sourceforge.net [firebird-support]]

> ---In firebird-support@yahoogroups.com,  wrote :
 
Christine 

 > 
 > Did anyone ever face this error when gbak ? 
 > 
 > gbak: ERROR:internal Firebird consistency check (decompression overran 
 > buffer (179), file: sqz.cpp line: 239)
 > gbak: ERROR:gds_$receive failed
 > gbak:Exiting before completion due to errors
  


  Your database still get corrupted. gbak reads whole db therefore it detect 
corruption. But gbak is nor a reason of corruption, nor 
a correct tool for diagnosis (gfix is). I ask you again to check RAM on server 
machine. One more question - does you run DDL 
statements such as ALTER TABLE on live database ?

Regards,
Vlad