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

On Tue, Oct 4, 2016 at 10:10 AM, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com
> wrote:

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

No, it was sent to the list - I even approved it as it was over the size
limit. However, it doesn't seem to be in the archives.

In any case, I've forwarded you a copy.

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

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company