Re: RE: [firebird-support] Re: Database Corrupt ?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
 
as was mentioned earlier - successful backup restore did not mean that source 
database was without errors.
To test source database run:
gfix -validate -full 
 
PS. will be good to see that you have most recent version of firebird from some 
part (2.1.X, 2.5.X, 3)
 
regards,
Karol Bieniaszewski
 
W dniu 2016-04-22 09:19:38 użytkownik 'Christine S' 
christine.sanj...@melawai.com [firebird-support] 
<firebird-support@yahoogroups.com> napisał:
 
Dear Intelrullz,
Thanks for your respond.
Yes, I have ever backup, restore and validate it, and its ok, no errors found. 
Still don’t have clue why it could be happen.. and how to avoid it..
Regards,
Christine Sanjaya - MIS
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, April 21, 2016 9:23 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: Database Corrupt ?
Hi Christine,
Successful restore does *not* mean your original database is ok. It just means 
the backup contains consistent data, which (I believe) means it did not touch 
any corrupt pages. I assume it could be 'truncated just the right way' and 
remain valid, but I'd love to see it actually happen. Generally, corruption may 
go unnoticed for months, depending on the workload/data/moon-phase/so-on
If you have the option of downtime - I'd suggest a full validation on the 
files. File copy is possible with some NBackup magic, but it seems risky on a 
DB with an unknown state.
A few hours of RAM testing won't hurt too.
As for the CPU - nothing weird about that. A lot of machines have cpu power 
management on powersave by default, which keeps the freq lower (that 4GHz cpu 
is a descent room heater at full speed). You'll probably want to change that on 
a DB server, though :)
[Non-text portions of this message have been removed]

 

Re: RE: [firebird-support] Re: Database Corrupt ?

[liviuslivius liviusliv...@poczta.onet.pl [firebird-support]]

Hi,
 
Vlad say about RAM not HDD test
you can use for test RAM memory any tool
e.g. you can use Microsoft tool - run START type "mdsched.exe" and enter
 
regards,
Karol Bieniaszewski
 
W dniu 2016-04-22 09:14:17 użytkownik 'Christine S' 
christine.sanj...@melawai.com [firebird-support] 
<firebird-support@yahoogroups.com> napisał:
 
Dear Vlad,
Thank you for the info.
Hardware problem ? Well, few months ago we have tried chkdsk, but there is no 
error on disk.
Regards,
Christine Sanjaya - MIS
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, April 22, 2016 3:56 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Database Corrupt ?
---In firebird-support@yahoogroups.com, <christine.sanjaya@...> wrote :
Your glibc seems ok (a bit outdated, but not critical)
> 4. MemTotal: 7911216 kB (8 GB)
I mean - could you run memory test to ensure your RAM is ok ?
Random corruptions of different databases could be sign of hardware problem 
(not necessary, but
possible)
> 5. Here is a part of my less /proc/cpuinfo - Is it weird that I have 4 GHz 
> but the cpu MHz just 800 Mhz ?
It is OK, while CPU is not 100% buzy
Regards,
Vlad
[Non-text portions of this message have been removed]

 

RE: [firebird-support] Re: Database Corrupt ?

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

Dear Intelrullz, 

 

Thanks for your respond. 

Yes, I have ever backup, restore and validate it, and its ok, no errors found. 
Still don’t have clue why it could be happen.. and how to avoid it.. 

 

Regards, 

Christine Sanjaya - MIS 

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Thursday, April 21, 2016 9:23 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: Database Corrupt ?

 

  

Hi Christine,

Successful restore does *not* mean your original database is ok. It just means 
the backup contains consistent data, which (I believe) means it did not touch 
any corrupt pages. I assume it could be 'truncated just the right way' and 
remain valid, but I'd love to see it actually happen. Generally, corruption may 
go unnoticed for months, depending on the workload/data/moon-phase/so-on

If you have the option of downtime - I'd suggest a full validation on the 
files. File copy is possible with some NBackup magic, but it seems risky on a 
DB with an unknown state.

A few hours of RAM testing won't hurt too.

As for the CPU - nothing weird about that. A lot of machines have cpu power 
management on powersave by default, which keeps the freq lower (that 4GHz cpu 
is a descent room heater at full speed). You'll probably want to change that on 
a DB server, though :)





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

RE: [firebird-support] Re: Database Corrupt ?

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

Dear Vlad, 

 

Thank you for the info. 

Hardware problem ? Well, few months ago we have tried chkdsk, but there is no 
error on disk. 

 

Regards, 

Christine Sanjaya - MIS 

 

From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Friday, April 22, 2016 3:56 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Database Corrupt ?

 

  

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


 Your glibc seems ok (a bit outdated, but not critical)

> 4. MemTotal: 7911216 kB (8 GB)

  I mean - could you run memory test to ensure your RAM is ok ? 
Random corruptions of different databases could be sign of hardware problem 
(not necessary, but
possible)

> 5. Here is a part of my less /proc/cpuinfo - Is it weird that I have 4 GHz 
> but the cpu MHz just 800 Mhz ?

  It is OK, while CPU is not 100% buzy

Regards,
Vlad





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

[firebird-support] Re: Database Corrupt ?

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

---In firebird-support@yahoogroups.com,  wrote :
 
 Your glibc seems ok (a bit outdated, but not critical)

 > 4. MemTotal: 7911216 kB (8 GB)
 
  I mean - could you run memory test to ensure your RAM is ok ? 
Random corruptions of different databases could be sign of hardware problem 
(not necessary, but
possible)

 > 5. Here is a part of my less /proc/cpuinfo - Is it weird that I have 4 GHz 
 > but the cpu MHz just 800 Mhz ?

  It is OK, while CPU is not 100% buzy

Regards,
Vlad

RE: [firebird-support] Re: Database Corrupt ?

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

Hi Christine, Successful restore does *not* mean your original database is ok. 
It just means the backup contains consistent data, which (I believe) means it 
did not touch any corrupt pages. I assume it could be 'truncated just the right 
way' and remain valid, but I'd love to see it actually happen. Generally, 
corruption may go unnoticed for months, depending on the 
workload/data/moon-phase/so-on
 If you have the option of downtime - I'd suggest a full validation on the 
files. File copy is possible with some NBackup magic, but it seems risky on a 
DB with an unknown state.
 A few hours of RAM testing won't hurt too.
 As for the CPU - nothing weird about that. A lot of machines have cpu power 
management on powersave by default, which keeps the freq lower (that 4GHz cpu 
is a descent room heater at full speed). You'll probably want to change that on 
a DB server, though :)

RE: [firebird-support] Re: Database Corrupt ?

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

Dear Vlad,





Thanks for your respond.





1.   Yes I have few different DB. I still wondering if its corrupt or not. 
Because now I can backup restore with no errors. But sometimes my automatic 
backup is not successfully.





2.   I use 64-bit Centos


Linux 2.6.32-573.7.1.el6.x86_64 x86_64


CentOS release 6.7 (Final)


Firebird Classic v2.5.3 (FirebirdCS-2.5.3.26780-0.amd64)





3.   Glibc Version :


ldd (GNU libc) 2.12





4.   MemTotal:7911216 kB (8 GB)





5.   Here is a part of my less /proc/cpuinfo - Is it weird that I have 4 
GHz but the cpu MHz just 800 Mhz ?


vendor_id   : GenuineIntel


cpu family  : 6


model   : 60


model name  : Intel(R) Core(TM) i7-4790K CPU @ 4.00GHz


stepping: 3


microcode   : 28


cpu MHz : 800.000


cache size  : 8192 KB





Regards,


Christine Sanjaya - MIS





From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, April 19, 2016 5:03 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Database Corrupt ?








Christine,


few questions:



- am i correctly understand that you have few different DB's and all of them 
corrupted ?
- does you use 32-bit or 64 bit build of Firebird and CentOS (i686 or x64)?
- what is glibc version ?
- could you check memory on server machine ?


Regards,
Vlad










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

[firebird-support] Re: Database Corrupt ?

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

Christine,

few questions:

- am i correctly understand that you have few different DB's and all of them 
corrupted ?
- does you use 32-bit or 64 bit build of Firebird and CentOS (i686 or x64)?
- what is glibc version ?
- could you check memory on server machine ?

Regards,
Vlad