Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vBpzj-005oHl-39 for pgadmin-support@arkaria.postgresql.org; Thu, 23 Oct 2025 07:44:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vBpzh-006p5V-HO for pgadmin-support@arkaria.postgresql.org; Thu, 23 Oct 2025 07:44:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vBpzh-006p5N-70 for pgadmin-support@lists.postgresql.org; Thu, 23 Oct 2025 07:44:20 +0000 Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vBpzb-003lNL-2m for pgadmin-support@lists.postgresql.org; Thu, 23 Oct 2025 07:44:19 +0000 Received: by mail-ej1-x62b.google.com with SMTP id a640c23a62f3a-b3e234fcd4bso89507166b.3 for ; Thu, 23 Oct 2025 00:44:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761205454; x=1761810254; darn=lists.postgresql.org; h=in-reply-to:content-language:from:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=SYwlQymJ9XUFJFFer4/vrJREWmtX5rawk9QqeCSEPps=; b=ixdwdlvz/RAgxN+DsbqwMYRvTgILt+8FCiDCnYeERFBBbtAjn2eaANRNXOAVJD0phf AmLtHXNSosGPlM+jWKbUVf1oahBqpCnzpOTNTfdL/qGsQjpvn/mamyXJF365MxM89H13 InKUQsQ6XTMUnrSyCAcohF0tdK+1MSuZWFkm5F0wQM6vUBQkwe+qZEuYf9ra99ibAK7F TP4/w3vhZalYhCMSScHj4WYI4ke9PCXXvjopT7lERUtRwFTPKeZdL2KFNtGNbmfccXpk B+fsn9CJ/8ahA4dIz6k7srFGXSmZUsj6aRNHTC6ZbyhtIvhWyyYycNelHTmIQgIO84QK aPFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761205454; x=1761810254; h=in-reply-to:content-language:from:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=SYwlQymJ9XUFJFFer4/vrJREWmtX5rawk9QqeCSEPps=; b=ar147oufWSuEecms4Dr/teGQ9DoGdZkx7CDyxYBZbbnX0NKF3Vs+9soZYBSM7q27FG +EeSKlDCAu/4qU/p5MJKpi49SkgWk0C6vr/Y8alBeq/iq2jDFzzC7oUfBFui4YTCSpWz W7FoXuDGqZQL1GYd7cvOzaBeMVbw5E5qdYintj57StAM4Z2JseWe7BIB9ofdAIRC0k1B 1O99ydOhs3y2s7hInCb9tUi0c/aWqWSxsAVs3SWhCGif01A1K3MRqjRJOhsNuuih1Qr/ mZZi0pnHgHG1vRUlDXitLa1KCO5hUGfQR2DteBjSQ18i4jeYKx1H3UXWAcdyHstH6WVJ J+hw== X-Gm-Message-State: AOJu0Yx9NitFkMqeHB6LWG5j5657uDFtq6PqwBNSpbgAb/t1qC3Np0Js 3D9wCmU51bFanxIbmLf2kGFQ1oA12xlMCYVLfbgAXaZz2YvTJWCrjdv8xEbGxA== X-Gm-Gg: ASbGncv6yRoF0NuH5x/XGhz9mrR5+liPFDWVYjszDd2CFYEKqcraZI2Xb16XHRYNgOl oN1In0HQG0sSpGOD7w0XntyWWgyq0A8z1OzthjCad7IMF2Gt5w+fyGDi1xx29Enr2QQFEDyXWMq 4nfWJn3wNvzdgZvorPDyAXXWB3K5ayaDrAIiKfwVWq/48Aab3DsHM7vP4ZtrLdB9+u9rydHvaG8 o1O3BqQgSlbUZwv5RC9XNagyCVYph9QExMDkcZbz1/83xxjr676viRBmPu/FxSPJyOTakb0l1nO GOEeYFTX4DV5maimfrL9UpOXdKwJ3ah8s4CW0mg2P05IM+nb4aJ92smSwQDY0fzrqf5xt6gFk17 VdtYm/d+WNxEmpApVH6cnI5anC6X1zAc66Pj7OsNiJ7Qd0nF+0eGSmgLREipRfp/AYnREmHbLu4 OuPK8FmmrE77ES7cOlNmZ0QjJ2xL7SQBicIiTT0KxtUzMlsr5XJtlUcQ9I X-Google-Smtp-Source: AGHT+IHe4QRETXsARr09NN26rMrk6VjhJq2zlWXywML/I9YoaC0MxeVNQ8LGX39kOVkUqXv4gXdXkQ== X-Received: by 2002:a17:907:6d02:b0:b63:2000:72c8 with SMTP id a640c23a62f3a-b6474543490mr2750208266b.62.1761205454225; Thu, 23 Oct 2025 00:44:14 -0700 (PDT) Received: from [192.168.129.20] (146.8-129-109.adsl-dyn.isp.belgacom.be. [109.129.8.146]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b6d511d00e0sm144311366b.2.2025.10.23.00.44.13 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 23 Oct 2025 00:44:13 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------r61KiFcDYVJtFl3wvx7vS0CN" Message-ID: <5d9badc0-a454-454c-9f77-de9a122b991c@gmail.com> Date: Thu, 23 Oct 2025 09:44:13 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied To: Aditya Toshniwal Cc: "pgadmin-support@lists.postgresql.org" References: <72B3573D-7E61-4D20-AE8B-8EB6DA2672F8@gmail.com> From: Bastiaan Wakkie Content-Language: en-US, nl In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------r61KiFcDYVJtFl3wvx7vS0CN Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 > 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 > 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 > 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" --------------r61KiFcDYVJtFl3wvx7vS0CN Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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"
--------------r61KiFcDYVJtFl3wvx7vS0CN--