Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERD Tool: Save Image: does not save anything... #8424

Open
pms967 opened this issue Feb 6, 2025 · 7 comments
Open

ERD Tool: Save Image: does not save anything... #8424

pms967 opened this issue Feb 6, 2025 · 7 comments
Assignees
Labels

Comments

@pms967
Copy link

pms967 commented Feb 6, 2025

Describe the bug

The title say it all: with a project imported (or loaded) into the ERD Tool, I've tried to save the ERD scheme as an image (too: saving as .pgerd and .sql file seems to work fine) .

After clicking on the icon (or pressing the shortcut), the screen greys out with the message: “Preparing the image”. Then after a while it goes back to normal, and that's it.

Unfortunately, nothing else happen. No file selector to choose folder and file name appears, and apparently no image file has been created anywhere.

That must be some kind of regression: several months ago, on the same system and with (almost) the same DB, an earlier version did work just fine.

Error message

None. I found these in the log, but I am not sure whether they are related / relevant:

`
Application Server URL: http://127.0.0.1:46695/?key=********
2025-02-06 17:36:31,258: ERROR pgadmin: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/flask/app.py", line 917, in full_dispatch_request
rv = self.dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/flask/app.py", line 891, in dispatch_request
self.raise_routing_exception(req)
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/flask/app.py", line 500, in raise_routing_exception
raise request.routing_exception # type: ignore[misc]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/flask/ctx.py", line 362, in match_request
result = self.url_adapter.match(return_rule=True) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/werkzeug/routing/map.py", line 629, in match
raise NotFound() from None
werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.

2025-02-06 17:36:31,279: ERROR pgadmin: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/flask/app.py", line 917, in full_dispatch_request
rv = self.dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/flask/app.py", line 891, in dispatch_request
self.raise_routing_exception(req)
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/flask/app.py", line 500, in raise_routing_exception
raise request.routing_exception # type: ignore[misc]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/flask/ctx.py", line 362, in match_request
result = self.url_adapter.match(return_rule=True) # type: ignore
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/venv/lib/python3.11/site-packages/werkzeug/routing/map.py", line 629, in match
raise NotFound() from None
werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
`

Desktop (please complete the following information):

  • OS: Debian Linux 12
  • Version: both 8.9 and 9.0
  • Mode: Desktop
  • Package type: DEB

Additional context

All tested packages are from the official repository:
ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/

@pms967 pms967 added the Bug label Feb 6, 2025
@adityatoshniwal
Copy link
Contributor

Hi @pms967,

Before saving the image - Go to View -> Toggle Developer Tools -> Console and then try to save image. Share the errors if any from the console.

@pms967
Copy link
Author

pms967 commented Feb 7, 2025

Here it is:

pgadmin4.log

Image

N.B.: these messages appears as soon as I open the ERD Tool:

Image

BTW: worse yet, while I was able to open an older project (actually, an older version of the same one, saved some times ago) , now it can not even open a .pgerd which I have saved yesterday.

As soon as I try to open that file, pgAdmin4 freezes and I have to manually kill the processes. In that case, no new message whatsoever appears on the console.

@adityatoshniwal
Copy link
Contributor

As soon as I try to open that file, pgAdmin4 freezes and I have to manually kill the processes. In that case, no new message whatsoever appears on the console.

There is a similar freezing related bug open for ERD - #8389. May be related to that.
Need to check console error of 404. I don't get such error on my installed pgAdmin.

@pms967
Copy link
Author

pms967 commented Feb 7, 2025

May be related to that. Need to check console error of 404. I don't get such error on my installed pgAdmin.

Could be some missing library which is not listed as dependency in the .deb package?

Or maybe some other misconfiguration and/or missing file in the package?

@adityatoshniwal
Copy link
Contributor

May be related to that. Need to check console error of 404. I don't get such error on my installed pgAdmin.

Could be some missing library which is not listed as dependency in the .deb package?

Or maybe some other misconfiguration and/or missing file in the package?

In that case, pgAdmin itself won't have opened.

@pravesh-sharma
Copy link
Contributor

Hi @pms967,

I am not able to reproduce the issue. Can you please provide the pgerd file?

@pms967
Copy link
Author

pms967 commented Feb 25, 2025

Hi @pms967,

I am not able to reproduce the issue. Can you please provide the pgerd file?

It looks like it happens to me with any project. Anyway, here's one example.

ems.zip

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: No status
Development

No branches or pull requests

3 participants