public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bastiaan Wakkie <[email protected]>
To: Aditya Toshniwal <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
Date: Thu, 23 Oct 2025 09:44:13 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAM9w-_m3Cv9_TTdOE-CuHFXhBr2DoBD47ZyXywghBGuq=vX1sg@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CAM9w-_nAgj6Niue6HAvfFFpw0vsNuOU8Vn+=h=RdbLQC7v8yfQ@mail.gmail.com>
<CAM9w-_m3Cv9_TTdOE-CuHFXhBr2DoBD47ZyXywghBGuq=vX1sg@mail.gmail.com>
Hi Aditya,
Yes!!
I can confirm that it was exactly the same problem. Somehow, the last
storage went into this 'None' state.
I altered the SELECT statement (from issues/9281) to also see the pid
SELECT p.name, up.pid, up.uid, up.value FROM user_preferences AS up JOIN
preferences AS p ON p.id = up.pid order by p.name;
which gave me:
...
> last_storage|220|1|None
... and then...
UPDATE user_preferences SET value='my_storage' WHERE pid=220 AND uid=1;
... Solved it!
All I remember before I went into this 'None' state is that I went
somewhere to the root of the storage (maybe via the storage manager)
where I normally don't go.
Thanks problem solved!
Cheers,
Bastiaan
On 10/22/25 14:47, Aditya Toshniwal wrote:
> Hi Bastiaan,
>
> Check this one - https://github.com/pgadmin-org/pgadmin4/issues/9281
> Are you able to get the same behaviour as mentioned?
>
> On Wed, Oct 22, 2025 at 12:21 PM Aditya Toshniwal
> <[email protected]> wrote:
>
> Hi Bastiaan,
>
> Maybe we'll have to add more logs to debug the issue you're
> facing. If it's an internal server error then it should have
> logged it.
>
> On Sat, Oct 18, 2025 at 8:51 PM Bastiaan Wakkie
> <[email protected]> wrote:
>
> UPDATE:
>
> After upgrading to 9.9 still the same problem.
>
> Im getting...
> When saving: ... and [! Request failed with status code 500]
> error popup and “Access denied (…)” in the Message pane.
> When opening an already stored file: ... an [! Request failed
> with status code 500] error popup.
>
> If Im logged in as pgadmin on the server (the user running the
> app) and I could create a file in the storage directory. I
> even tried to make one file world readable (chmod 777) but
> still I am getting the above errors. I do see any file created
> directly in the storage.
>
> I also started Firefox 144.0 without extensions to see if this
> was causing the problem. But not as I expected as an 500 error
> indicates something server side. But I am ticking off any
> possible way to trace why this problem is happening.
>
> Still nowhere I am able to detect any indication in the log files.
>
> The only thing that works is creating a new folder via the
> storage manager and rename files … weirdly enough.
>
> Could it be that I open the query tool always tool in a new
> tab? I’m have trouble finding the setting to disable this btw
> to test this hypothesis.
> I also note that options/storage/last storage is set to None.
> While the last directory changes when I move around.
>
> Ps running pgadmin4 in a venv with python 3.13.7
>
> Thx,
> Bastiaan
>
> > On 11 Oct 2025, at 12:10, Bastiaan Wakkie
> <[email protected]> wrote:
> >
> >
> >
> > Hi all,
> >
> >
> > Opening and saving files (crtl-o) (in 9.6 and 9.8) results
> in 500 error/Access denied
> >
> > The rest of the pgadmin4 application is working like normal..
> >
> > I can run any sql queries without problems, just cannot load
> or save any files!
> >
> >
> > What did I do/remember:
> >
> > 1) recently updated postgresql to 17.5 on manjaro rolling
> release.
> >
> > 2) I remember that I went to the root of the storage when it
> started to act weird. Not sure this is connected though
> >
> > 3) When I try opening any file stored in the storage, I'm
> getting ...
> > "Request failed with status code 500"
> > ... error in the application but I cannot find *anywhere* in
> the logs an indication of what is happening (Also not in my
> postgresql, supervisor, nginx or journalctl logs).
> >
> > 4) I updated pgadmin4 from 9.6 to 9.8 like I always do (pip
> install -U pgadmin4) to see if this would fix it but the
> problem persists.
> >
> > 5) ...I changed CONSOLE_LOG_LEVEL = 10 in the hope to see
> more but alas...
> >
> > 6) ...I enabled postgresql log to see something comes up
> there, but no postgresql seems quietly doing it's thing..
> >
> > 7) I checked the ...
> > STORAGE_DIR = "/data/databases/pgadmin4/storage"
> > ... and all is owned by the pgadmin user.
> >
> > 8) Via the command line I can add/delete/remove
> files/directories in the storage folder and I will see them in
> the storage (manager) but still unable to open or save any file.
> >
> > 9) BUT when I create a new sql script and try to save it or
> "save as" I am getting an "Access denied" message :
> > "Successfully run. Total query runtime: 311 msec. 14603 rows
> affected. Access denied (/new script.sql)Access denied
> (/new_file.sql)Access denied (/two.new.sql)"
> > (The message keeps appending my last attempts, btw)
> >
> >
> > Did anybody else had this problem before?
> >
> > ... and know how to fix it?
> >
> > ... or knows a way to track down the 500 error of the app.
> >
> >
> > or is this git issue material?
> >
> > Cheers,
> >
> > Bastiaan
> >
> >
> >
>
>
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Staff SDE II |*enterprisedb.com*
> <https://www.enterprisedb.com/;
> "Don't Complain about Heat, Plant a TREE"
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Staff SDE II |*enterprisedb.com*
> <https://www.enterprisedb.com/;
> "Don't Complain about Heat, Plant a TREE"
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox