BUG #14118: ERROR: could not read block 0 in file causes the application goes down

From: yuqiang(dot)liao(at)polycom(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14118: ERROR: could not read block 0 in file causes the application goes down
Date: 2016-04-28 08:41:22
Message-ID: 20160428084122.19112.65187@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: 14118
Logged by: Yuqiang
Email address: yuqiang(dot)liao(at)polycom(dot)com
PostgreSQL version: 9.3.6
Operating system: CentOS 6.6
Description:

Hi,

Our system encountered the error twice with the same exception as below --

<179>1 2015-10-31T19:52:19.989+01:00 E11VRPRM01.pharma.xxxxxx.com RPRM 15898
Jserver - ERROR|||main|com.xxxxxx.rm.db.AbstractDomainDao| Unable to add
instance of SystemAlert to database.
<179>1 2015-10-31T19:52:19.989+01:00 E11VRPRM01.pharma.xxxxxx.com RPRM 15898
Jserver - org.springframework.jdbc.UncategorizedSQLException:
PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO
SystemAlerts (alerttype, note, createdate, updatedate, updateby) values
(?,?,?,?,?)]; SQL state [XX001]; error code [0]; ERROR: could not read block
0 in file "pg_tblspc/16403/PG_9.3_201306121/16405/20189": read only 0 of
8192 bytes;

I see there is a bug tracking the similar issue but I'd like to know the
clear workaround instruction.

http://www.postgresql.org/message-id/87tx0dc80x.fsf@news-spur.riddles.org.uk

Thanks!

Browse pgsql-bugs by date

  From Date Subject
Next Message Francisco Olarte 2016-04-28 09:24:34 Re: BUG #14116: Character with value 0x0a must be escaped. using COPY FROM
Previous Message Кирковский Александр 2016-04-28 07:17:16 Bug report