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

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