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

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.toshniwal@enterprisedb.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@gmail.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@gmail.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

"Don't Complain about Heat, Plant a TREE"

--

Thanks,

Aditya Toshniwal

pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com

"Don't Complain about Heat, Plant a TREE"