Thread: [BUGS] BUG #14488: Unable to read the block from the table

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

aravindhan.v@ionidea.com writes:
> PostgreSQL version: 9.3.0

If you're actually running 9.3.0 then the *first* thing to do is update to
9.3.latest.  And read the release notes.  There were some nasty data-loss
bugs in the earliest 9.3.x releases.

            regards, tom lane


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