From: | pasquini(dot)matteo(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14522: plpythonu, missed filenode |
Date: | 2017-02-01 16:58:46 |
Message-ID: | 20170201165846.1411.19551@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: 14522
Logged by: Matteo Pasquini
Email address: pasquini(dot)matteo(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-02-01 18:56:55 | Re: BUG #14522: plpythonu, missed filenode |
Previous Message | Fujii Masao | 2017-02-01 16:26:03 | Re: Bug in Physical Replication Slots (at least 9.5)? |