Thread: pgAdmin4 - Query Tool stuck "Initializing the query execution!" on localhost
Hi Dave,
On Tue, Oct 4, 2016 at 2:37 PM, Dave Page <dpage@pgadmin.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.
On Mon, Oct 3, 2016 at 1:53 PM, Jan Rössler <jan.rossler1@gmail.com> wrote:
> Done, see attached.>
> 2016-10-03 14:08 GMT+02:00 Dave Page <dpage@pgadmin.org>:
>>
>> On Mon, Oct 3, 2016 at 12:59 PM, Jan Rössler <jan.rossler1@gmail.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@pgadmin.org>:
>> >>
>> >> Hi
>> >>
>> >> On Mon, Oct 3, 2016 at 10:57 AM, Jan Rössler <jan.rossler1@gmail.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@pgadmin.org>:
>> >> >>
>> >> >> On Sun, Oct 2, 2016 at 12:54 PM, Jan Rössler
>> >> >> <jan.rossler1@gmail.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
On Tue, Oct 4, 2016 at 10:10 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Hi Dave,
On Tue, Oct 4, 2016 at 2:37 PM, Dave Page <dpage@pgadmin.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.
On Mon, Oct 3, 2016 at 1:53 PM, Jan Rössler <jan.rossler1@gmail.com> wrote:
> Done, see attached.>
> 2016-10-03 14:08 GMT+02:00 Dave Page <dpage@pgadmin.org>:
>>
>> On Mon, Oct 3, 2016 at 12:59 PM, Jan Rössler <jan.rossler1@gmail.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@pgadmin.org>:
>> >>
>> >> Hi
>> >>
>> >> On Mon, Oct 3, 2016 at 10:57 AM, Jan Rössler <jan.rossler1@gmail.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@pgadmin.org>:
>> >> >>
>> >> >> On Sun, Oct 2, 2016 at 12:54 PM, Jan Rössler
>> >> >> <jan.rossler1@gmail.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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company