Re: v4 3.0 connection issues, notices is readonly - Mailing list pgadmin-support
From | Cherio |
---|---|
Subject | Re: v4 3.0 connection issues, notices is readonly |
Date | |
Msg-id | CAKHqFk+DvXBVPtcAtYS0MO1gXgKOM3dqWw_teW8mmyvGJOaR=Q@mail.gmail.com Whole thread Raw |
In response to | Re: v4 3.0 connection issues, notices is readonly (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>) |
List | pgadmin-support |
I may not have time to do that this week. One possible extra clue my team member reports this happens as a result of upgrade from v4 2.1 (which was previously upgraded from v4 2.0) to v4 3.0 and using the same config directory ~/.pgadmin. Cleaning up configuration directory resolves the issue but creates another issue forcing us to recreate connection profiles for over 20 servers which is a big hassle. For this reason we will be sticking to v4 2.1 for now.
While on this subject I want to briefly mention another overlooked aspect of configuration. It is a hassle to run pgadmin 3 and pgadmin 4 in the same environment. To mitigate that we need to crete system wide (vs per user) "/usr/share/pgadmin4/web/config_local.py" as root and tweak DATA_DIR in there to e.g. /home/<user>/.pgadmin4. Tweaking configuration requires system-wide changes within the installed package. This is less of an issue when running from virtualenv because it can be installed within user environment but still it requires re-applying configuration for every new build. The simplest way to solve this is to either initialize DATA_DIR via environment variable or allow passing it via command line. This should be quite easy to implement.
On Wed, Apr 18, 2018 at 1:27 AM Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com> wrote:
Hi,Please create a bug for the same HERE,Also provide us steps to reproduce the issue in the bug ticket and attach`pgAdmin4.log` log filein the ticket, It will help us to pinpoint the issue quickely.- Enable debug logging (https://www.pgadmin.org/faq/#8)- Disable the dashboard graphs temporarily to avoid unwanted logging from dashboard calls (https://www.pgadmin.org/faq/#5)- Delete/Rename existing `pgAdmin4.log` file- Restart pgAdmin4 and try to re-produce the issue- Zip the log file andupload it on bug ticket.--Regards,On Tue, Apr 17, 2018 at 10:03 PM, Cherio <cherio@gmail.com> wrote:Hello,PgAdmin 4 v3.0 didn't work out of the box on my ubuntu 16.04.4. Both DEB install and python wheel generate errors. I researched the DEB install and determined that the error occurs in "/usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py" on line 313 which readspg_conn.notices = deque([], self.ASYNC_NOTICE_MAXLENGTH)and complains that the property is readonly. I am not a python guy but after some research I made the following tweak to make it work:if self.async == 1:pg_conn.notices = deque([], self.ASYNC_NOTICE_MAXLENGTH)The same file has similar code on line ~1250 though I didn't see errors on that line.Another error which completely prevents from continuing on a web page is the "INTERNAL SERVER ERROR" which locks the screen with an alert popup (the title reads "AlertifyJS") that can't be closed, but I believe this was already reported and claimed to be fixed the next day.Regards,Yuri
pgadmin-support by date: