Thread: Unable to open query tool

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

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
>>
>>

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
>> >>
>> >>

As a follow up, could this be related? My log file is growing like
crazy /w these errors: https://pastebin.com/V0sAH5NC


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
> >> >>
> >> >>