BUG #14488: Unable to read the block from the table

From: aravindhan(dot)v(at)ionidea(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14488: Unable to read the block from the table
Date: 2017-01-06 07:47:49
Message-ID: 20170106074749.10135.40497@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14488
Logged by: Aravindhan Vellaichamy
Email address: aravindhan(dot)v(at)ionidea(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-01-06 15:08:41 Re: BUG #14488: Unable to read the block from the table
Previous Message Vitaly Burovoy 2017-01-06 02:39:09 Re: Re: [BUGS][PATCH] BUG #14486: Inserting and selecting interval have different constraints