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]