Re: Unable to open query tool - Mailing list pgadmin-support

From Khushboo Vashi
Subject Re: Unable to open query tool
Date
Msg-id CAFOhELc+DS6c9zxCESYxe_JycX1NKVCeFe4i3KqpxFHuwwEdPg@mail.gmail.com
Whole thread Raw
In response to Re: Unable to open query tool  (Brian Hansen <dulanic@gmail.com>)
List pgadmin-support
Hi,

On Fri, May 15, 2020 at 6:14 PM Brian Hansen <dulanic@gmail.com> wrote:
As a follow up, could this be related? My log file is growing like
crazy /w these errors: https://pastebin.com/V0sAH5NC

You can set the log level to logging.WARNING, which would prevent the log file from growing to some extent.
Unfortunately the logs are not much useful to identify your original issue.

Thanks,
Khushboo


On Fri, May 15, 2020 at 7:28 AM Brian Hansen <dulanic@gmail.com> wrote:
>
> Thank you, so I had rebuilt the container multiple times and cleared
> browser cache including trying multiple browsers and none of it
> worked. However, once I enabled logging... it started working again.
> Not sure why that would have happened because I had tried it again
> just 5 minutes before and it wasn't working. Strange why adding the
> config_local.py /w the logging options would fix the query tool....
>
> On Thu, May 14, 2020 at 10:40 PM Khushboo Vashi
> <khushboo.vashi@enterprisedb.com> wrote:
> >
> > Hi,
> >
> > Please clear the browser cache, restart the server and try again.
> > If you still encounter the issue, please enable logging and share the logs. To enable logging please refer: https://www.pgadmin.org/faq/#8
> > Also, share the browser console error logs, if you get any errors.
> >
> > Thanks,
> > Khushboo
> >
> > On Thu, May 14, 2020 at 5:56 PM Brian Hansen <dulanic@gmail.com> wrote:
> >>
> >> Hello,
> >>
> >> No change.
> >>
> >> On Wed, May 13, 2020 at 10:36 PM Khushboo Vashi
> >> <khushboo.vashi@enterprisedb.com> wrote:
> >> >
> >> > Hi,
> >> >
> >> > Please try File > Reset Layout.
> >> >
> >> > Thanks,
> >> > Khushboo
> >> >
> >> > On Thu, May 14, 2020 at 12:31 AM Brian Hansen <dulanic@gmail.com> wrote:
> >> >>
> >> >> Hello,
> >> >>
> >> >> I have been using pgadmin for a while and just recently it stopped
> >> >> working to query anything. I can use other query tools to run SQL, but
> >> >> now pgadmin4 just shows as it is stuck loading. This happens across
> >> >> all databases. I run it from docker and have purged all files and
> >> >> relaunched my container and that had 0 impact. I can run maintenance
> >> >> tools etc...
> >> >>
> >> >> I am superuser and granted all permissions for the user. No
> >> >> permissions changed between when it used to work and when it stopped
> >> >> working.
> >> >>
> >> >> https://snipboard.io/6sA8BH.jpg
> >> >>
> >> >> This is my docker config:
> >> >>
> >> >>   pgadmin:
> >> >>     image: dpage/pgadmin4:latest
> >> >>     container_name: pgadmin
> >> >>     environment:
> >> >>       TZ: America/Chicago
> >> >>       PGADMIN_DEFAULT_EMAIL: someone@somewhere.com
> >> >>       PGADMIN_DEFAULT_PASSWORD: notachance
> >> >>       PGADMIN_LISTEN_PORT: 5050
> >> >>     volumes:
> >> >>       - pgadmin:/var/lib/pgadmin
> >> >>     ports:
> >> >>       - 5050:5050
> >> >>     restart: unless-stopped
> >> >>
> >> >>

pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: pgAdmin 4.21: Edge version not correctly recognized
Next
From: Dave Page
Date:
Subject: Re: pgadmin4 container install: volume mapping