[BUGS] BUG #14488: Unable to read the block from the table - Mailing list pgsql-bugs

From aravindhan.v@ionidea.com
Subject [BUGS] BUG #14488: Unable to read the block from the table
Date
Msg-id 20170106074749.10135.40497@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14488: Unable to read the block from the table
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14488
Logged by:          Aravindhan Vellaichamy
Email address:      aravindhan.v@ionidea.com
PostgreSQL version: 9.3.0
Operating system:   Windows
Description:

Hi Team,

We are using the postgresql database for processing the data in one of our
application monitoring tool. Thus we are unable to read the block and throws
continuous exception in the logs.Which resulted in the failure of data
purging as well the data discontinuity. 

We are getting the below error even though we have the block is available.

2016-12-30 10:56:14 WARNING [DefaultStatementExecutor] Exception occured
during PWH data processing. Exception:
com.dynatrace.diagnostics.server.shared.exceptions.repository.UncategorizedRepositoryException:
ERROR: could not read block 160169 in file "base/12029/2985813.1": read only
0 of 8192 bytes Cause: org.postgresql.util.PSQLException: ERROR: could not
read block 160169 in file "base/12029/2985813.1": read only 0 of 8192 bytes
[log message will be suppressed for 15 minutes]:
com.dynatrace.diagnostics.sdk.logging.ThrottlingLogger a:150

Please help us to identify the issue asap since it affects our production
environment.

Thanks,
Aravindhan.V


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Vitaly Burovoy
Date:
Subject: Re: [HACKERS] Re: [BUGS][PATCH] BUG #14486: Inserting and selectinginterval have different constraints
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14488: Unable to read the block from the table