The following bug has been logged on the website:
Bug reference: 14118
Logged by: Yuqiang
Email address: yuqiang.liao@polycom.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!