Re: pgAdmin4 - Query Tool stuck "Initializing the query execution!" on localhost

Hi Dave,

On Tue, Oct 4, 2016 at 2:37 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Thanks.
>
> I don't even see a query being executed in there. Ashesh, am I missing
> something? Any ideas?
>
It seems the logfile was sent you privately.
I won't be able to comment on it.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com/>

*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>

>
> On Mon, Oct 3, 2016 at 1:53 PM, Jan Rössler <jan(dot)rossler1(at)gmail(dot)com>
> wrote:
> > Done, see attached.
> >
> > 2016-10-03 14:08 GMT+02:00 Dave Page <dpage(at)pgadmin(dot)org>:
> >>
> >> On Mon, Oct 3, 2016 at 12:59 PM, Jan Rössler <jan(dot)rossler1(at)gmail(dot)com>
> >> wrote:
> >> > Sure, I'm attaching the logfile here (reproduced all the way until
> >> > pgAdmin
> >> > crashes).
> >>
> >> Thanks. Unfortunately I don't see anything much in there. Can you
> please:
> >>
> >> - Go to File -> Preferences, and set the refresh rates for all the
> >> dashboards to 60 seconds.
> >>
> >> - Exit pgAdmin
> >>
> >> - Edit C:\Program Files\pgAdmin 4\v1\web\config_local.py (assuming you
> >> installed in the standard location) and add:
> >>
> >> DEBUG = True
> >> FILE_LOG_LEVEL = 10
> >>
> >> - Remove the old logfile, and rerun the test.
> >>
> >> Thanks.
> >>
> >> > 2016-10-03 13:28 GMT+02:00 Dave Page <dpage(at)pgadmin(dot)org>:
> >> >>
> >> >> Hi
> >> >>
> >> >> On Mon, Oct 3, 2016 at 10:57 AM, Jan Rössler <jan(dot)rossler1(at)gmail(dot)com
> >
> >> >> wrote:
> >> >> > I'm on the 1.0 GA release. I tried browsing through existing issues
> >> >> > in
> >> >> > redmine and haven't found anything similar reported.
> >> >>
> >> >> See https://redmine.postgresql.org/issues/1732
> >> >>
> >> >> Can you please remove any existing logfile (by default,
> >> >> %AppData%\pgAdmin\pgadmin.log), the start pgAdmin, reproduce the
> >> >> problem, then send the logfile?
> >> >>
> >> >> Thanks.
> >> >>
> >> >> > 2016-10-03 9:58 GMT+02:00 Dave Page <dpage(at)pgadmin(dot)org>:
> >> >> >>
> >> >> >> On Sun, Oct 2, 2016 at 12:54 PM, Jan Rössler
> >> >> >> <jan(dot)rossler1(at)gmail(dot)com>
> >> >> >> wrote:
> >> >> >> > Hello,
> >> >> >> >
> >> >> >> > I seem to have a problem using the Query Tool on a local
> database.
> >> >> >> > When
> >> >> >> > I
> >> >> >> > try to execute any query (for example SELECT 1), the tool just
> >> >> >> > hangs
> >> >> >> > on
> >> >> >> > initializing it for a few minutes, after which pgAdmin outright
> >> >> >> > crashes.
> >> >> >> > Interestingly enough, when I download the result as CSV, I get
> the
> >> >> >> > correct
> >> >> >> > data. Also, on a remote server, the Query Tool works just fine
> for
> >> >> >> > me.
> >> >> >> >
> >> >> >> > Any ideas what might be causing this issue on localhost?
> >> >> >> >
> >> >> >> > I'm running the desktop version on Windows 8.1 and my local db
> >> >> >> > version
> >> >> >> > is:
> >> >> >> > PostgreSQL 9.3.5, compiled by Visual C++ build 1600, 32-bit
> >> >> >>
> >> >> >> What version of pgAdmin exactly? That sounds awfully like a bug
> that
> >> >> >> was fixed before GA.
> >> >> >>
> >> >> >> --
> >> >> >> Dave Page
> >> >> >> Blog: http://pgsnake.blogspot.com
> >> >> >> Twitter: @pgsnake
> >> >> >>
> >> >> >> EnterpriseDB UK: http://www.enterprisedb.com
> >> >> >> The Enterprise PostgreSQL Company
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >> Dave Page
> >> >> Blog: http://pgsnake.blogspot.com
> >> >> Twitter: @pgsnake
> >> >>
> >> >> EnterpriseDB UK: http://www.enterprisedb.com
> >> >> The Enterprise PostgreSQL Company
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> Dave Page
> >> Blog: http://pgsnake.blogspot.com
> >> Twitter: @pgsnake
> >>
> >> EnterpriseDB UK: http://www.enterprisedb.com
> >> The Enterprise PostgreSQL Company
> >
> >
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>