Performance warehouse issues

Question

Question by Ashwin -. · Aug 28, 2014 at 01:53 AM ·

Performance warehouse issues

Hi ,

We have PostgreSQL 9.3 DB with dynaTrace 5.6.0.

During daily batch process that is triggered at 2:00 GMT by dynaTrace server self monitoring -> Performance warehouse to purge data in DB, we got below mentioned errors:

Error: invalid page in block 1325 of relation base/16394/16469 - count:376

FATAL: database "XX" does not exist - Count:14

We logged into DB and we are able to veiw XX database with 39 tables.

Could you please suggest ?

Thanks and Regards,

Ashwin

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-08-28T02:19:03Z

Answer by Andreas G. · Aug 28, 2014 at 02:19 AM

Please open a support ticket for this problem

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.

Answer 2 · 2014-08-28T10:26:12Z

Answer by Markus B. · Aug 28, 2014 at 10:26 AM

This seems a database issue that must be fixed by the DBA. As an alternative to opening a ticket with dynaTrace support, I suggest to follow the instructions that can be found at the following pages:

http://raghavt.blogspot.co.at/2013/05/disk-page-checksums-to-detect.html

http://stackoverflow.com/questions/5220344/postgresql-invalid-page-header-in-block

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.

Performance warehouse issues

2 Replies

How to get started

NAM 2019 SP5 is available

LIVE WEBINAR

Follow this Question

Forum Tags