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

Hi Bastiaan,

Glad to hear that you're able to proceed with the workaround.
We need to fix the root cause.

On Thu, Oct 23, 2025 at 1:14 PM Bastiaan Wakkie <bwakkie(at)gmail(dot)com> wrote:

> 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"
>
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"