Hello,
Thank you for getting back to me so quickly. One of our network gurus star=
ted digging into the issue last night and found that there was a problem wi=
th our Pacemaker syncing. Essentially it failed to sync properly and promo=
ted a slave node to Master and gave two different nodes the =93master=94 IP=
address. Also, the table we were accessing was an unlogged table. We bel=
ieve these issues caused our problem. Once the syncing issue was resolved =
and the IP addresses were corrected, the issue cleared itself up.
Going forward we are going to monitor the situation and see if the syncing =
issue repeats.
Thank you again,
Michael Buccetti
On Mar 17, 2014, at 7:21 PM, Venkata Balaji Nagothi <vbnpgc@gmail.com<mailt=
o:vbnpgc@gmail.com>> wrote:
On Tue, Mar 18, 2014 at 4:38 AM, <Michael.buccetti@airgas.com<mailto:Michae=
l.buccetti@airgas.com>> wrote:
The following bug has been logged on the website:
Bug reference: 9604
Logged by: Michael Buccetti
Email address: Michael.buccetti@airgas.com<mailto:Michael.buccetti@air=
gas.com>
PostgreSQL version: 9.1.0
Operating system: OpenSuse
Description:
We have a java web app running on Tomcat 7 that accesses data on a Postgres
database. For some reason, we get the following error unexpectedly, causin=
g
a crucial database query to fail:
ERROR: could not open file "base/16397/106156081": No such file or
directory.
Could you please help us know if the above file is missing from the locatio=
n ( data-directory/base/16397 ) on the host where the database is hosted ?
You might be knowing this : The file "106156081" belongs to a particular ta=
ble in the database with OID 16397.
If you have audit logs - did you notice if the file was accidentally delete=
d or may be file system permissions/ownership has changed ?
Or any activity has happened which would not let the database user access t=
he file from the OS level ?
Regards,
Venkata Balaji N
Sr. Database Administrator
Fujitsu Australia