The following bug has been logged on the website:
Bug reference: 14522
Logged by: Matteo Pasquini
Email address: pasquini.matteo@gmail.com
PostgreSQL version: 9.6.1
Operating system: linux x64, debian8
Description:
got: [...] "base/23417/2659":no such file or directory
sqlcode : 58P01
while using plpython functions, usually after 2nd call of a plpython
function.
I've this big python app that cannot be translated entirely in plpython, so
i've managed to
- give to postgres execution of python app (/var/lib/postgresql/pyapp)
- with plpythonu add the path of the app to be able to make import in all
pther functions.
$$
from sys import path
pyapp = '/var/lib/postgresql/pyapp'
if not pyapp in path:
path.append(pyapp)
path = set(path)
$$
- Then, call another plpython function that produce data.
that function convert a file from filesystem and give back a list of values,
it works as expected.
The file "base/23417/2659" is there
-rw------ 1 postgres postgres 80K Feb 1 17:25 base/23417/2659
and both
select * from pg_dabase where oid = 23417;
select * from pg_class where relfilenode = 2659;
returns as expected.
haven't find similar issues around for version 9.6.x
After some tries the error becomes permanent.
Thanks.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs