Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied

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
> <aditya(dot)toshniwal(at)enterprisedb(dot)com> 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
> <bwakkie(at)gmail(dot)com> 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
> <bwakkie(at)gmail(dot)com> 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"