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"
