Re: BUG #9604: Unable to access table remotely

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