Alert under performance warehouse in incidents dashboard

Question

Question by Anusha K. · Aug 31, 2014 at 12:40 AM ·

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

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2014-09-01T21:01:19Z

Answer by Markus B. · Sep 01, 2014 at 09:01 PM

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

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Alert under performance warehouse in incidents dashboard

1 Reply

Join the conversation!

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Forum Tags