Alert under performance warehouse in incidents dashboard
Hi,
My incidents dashboard is showing an alert under performance warehouse as "Invalid page in block XXXX of Relation base XXXX/XXXX". We tried to solve the problem by restoring postgre database,but still the alert is coming.
Please help me in finding a solution for this problem.
Thanks,Anusha
Hi
This problem was recently reported already: Re: Performance warehouse issues
Postgres 9.3 has a new feature called disk page checksums. The database will check if a page loaded from the disk has a correct checksum and will print this error message if the check fails.
The root cause is normally a hardware or disk error.
Can you verify with the DBA if the disk and hardware is ok and follow the steps mentioned in the linked article?
If the problem persists, I suggest to open a support case.
Regards,
Markus
