Обсуждение: [pgadmin-support] pgAdmin 4 v1.3 fails to load

Peter,

Have you heard of any solution to this problem.  I have found pgAdmin 4 v1.3 is completely unusable on Windows 7 64 bit.  I have found that pgAdmin 4 v1.1 is stable.  I am currently using that version.  Do you think they are not testing at all on Windows 7 64 bit?  There website says it is available for Windows 7 (desktop).  I wonder if they have been testing it against Windows 10 but have not updated their web site.

 

Lance Campbell

University of Illinois

 

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Peter Johnson
Sent: Tuesday, March 21, 2017 9:57 PM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] pgAdmin 4 v1.3 fails to load

 

Hello,

 

At start up the program window opens & displays “Loading pgAdmin 4 v1.3”.

 

Case 1:

Sometimes displays error msg:

  error loading script /browser/role/module.js    Error msg: undefined

  or

  error loading script /debugger/js/direct    Error msg: undefined

and never completes loading

 

Case 2:

Sometimes does not display any error msg but never completes loading.

 

Case 3:

If I start the program with ‘Run as Administrator’, sometimes it completes loading OK & works fine,

other times I get Case 2 behaviour.

 

The debug log has repeated msgs:

[0322/131833:WARNING:resource_bundle.cc(311)] locale_file_path.empty() for locale

 

OS = Win 7   SP1 64 bit

desktop mode??  I’m running the downloaded executable

Steps required to reproduce the problem: run the pgAdmin 4 v1.3 executable.

 

I would appreciate any guidance on how to fix this issue.

 

Kind regards,

Peter Johnson

Dave,
I did exactly what you said.  I totally delete the application.  Deleted all directories from the file system.  Then I
reinstalledit.  It hung on startup.  I then had to stop it via task manager.  Then I loaded it the second time.  It
thenran.  The next time I tried to start it the application hung.  
 

I have never ever had any issue with pgAdmin 3.  I don't have any of these issues with pgAdmin4 v1.1 .  

Lance

-----Original Message-----
From: Dave Page [mailto:dpage@pgadmin.org] 
Sent: Thursday, March 23, 2017 9:22 AM
To: Campbell, Lance <lance@illinois.edu>
Cc: Peter Johnson <pj@acslink.net.au>; pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

On Thu, Mar 23, 2017 at 2:12 PM, Campbell, Lance <lance@illinois.edu> wrote:
> Peter,
>
> Have you heard of any solution to this problem.  I have found pgAdmin 
> 4 v1.3 is completely unusable on Windows 7 64 bit.  I have found that 
> pgAdmin 4
> v1.1 is stable.  I am currently using that version.  Do you think they 
> are not testing at all on Windows 7 64 bit?  There website says it is 
> available for Windows 7 (desktop).  I wonder if they have been testing 
> it against Windows 10 but have not updated their web site.

I test against both Windows 10 and 7, and occasionally 2012. As you can see from the attached screenshot, 1.3 works for
me.

I would suggest trying a complete uninstall of the application, ensure the installation directory is removed, then
re-install.

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

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

On Thu, Mar 23, 2017 at 6:08 PM, Campbell, Lance <lance@illinois.edu> wrote:
> Dave,
> I did exactly what you said.  I totally delete the application.  Deleted all directories from the file system.  Then
Ireinstalled it.  It hung on startup.  I then had to stop it via task manager.  Then I loaded it the second time.  It
thenran.  The next time I tried to start it the application hung. 
>
> I have never ever had any issue with pgAdmin 3.  I don't have any of these issues with pgAdmin4 v1.1 .

I'm still struggling to reproduce the issues myself, but all the
evidence suggests it was the move from QtWekKit to QtWebEngine that
caused it (that happened in 1.2). We did that because of numerous
other bugs in QtWebKit, and because QtWebKit has been deprecated and
removed from current versions of Qt. Unfortunately it seems that
whilst QtWebEngine solves the original problems, it has it's own set.

We're currently trying a PoC with another option, as well as thinking
through some other ideas...

Apologies for the inconvenience in the meantime.

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

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

Dave,

Just to follow up your previous advice: I have done a complete uninstall of 
the application, ensured
the installation directory is removed, then re-installed. I tried starting & 
stopping pgAdmin 4 a few
times before re-booting & then again after re-booting my system.

In both cases, before & after re-booting, pgAdmin 4 loaded successfully 
about 50% of the time &
didn't load in the other cases. In the unsuccessful load cases, most, but 
not all, times there was an error msg.
"Error loading script". But the nominated script varied each time.

Thanks for your continuing investigations.

Kind regards,
Peter Johnson


-----Original Message----- 
From: Dave Page
Sent: Friday, March 24, 2017 9:29 PM
To: Campbell, Lance
Cc: Peter Johnson ; pgadmin-support@postgresql.org
Subject: [in] Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

On Thu, Mar 23, 2017 at 6:08 PM, Campbell, Lance <lance@illinois.edu> wrote:
> Dave,
> I did exactly what you said.  I totally delete the application.  Deleted 
> all directories from the file system.  Then I reinstalled it.  It hung on 
> startup.  I then had to stop it via task manager.  Then I loaded it the 
> second time.  It then ran.  The next time I tried to start it the 
> application hung.
>
> I have never ever had any issue with pgAdmin 3.  I don't have any of these 
> issues with pgAdmin4 v1.1 .

I'm still struggling to reproduce the issues myself, but all the
evidence suggests it was the move from QtWekKit to QtWebEngine that
caused it (that happened in 1.2). We did that because of numerous
other bugs in QtWebKit, and because QtWebKit has been deprecated and
removed from current versions of Qt. Unfortunately it seems that
whilst QtWebEngine solves the original problems, it has it's own set.

We're currently trying a PoC with another option, as well as thinking
through some other ideas...

Apologies for the inconvenience in the meantime.

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

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

I just upgraded to 4.1.3 and am having the same issues. Windows 7 pro,
x64, Postgres 9.6.2. Prior version of pgadmin 4 worked OK. (I skipped
the 4.1.2 upgrade, using pgadmin 3 instead to do what I needed.)

Same error; various scripts fail to load. It seems to fail more often if
the system is busy with cpu or disk activity already going on.

Bruce Peret

On 3/26/2017 7:12 PM, Peter Johnson wrote:
> Dave,
>
> Just to follow up your previous advice: I have done a complete
> uninstall of the application, ensured
> the installation directory is removed, then re-installed. I tried
> starting & stopping pgAdmin 4 a few
> times before re-booting & then again after re-booting my system.
>
> In both cases, before & after re-booting, pgAdmin 4 loaded
> successfully about 50% of the time &
> didn't load in the other cases. In the unsuccessful load cases, most,
> but not all, times there was an error msg.
> "Error loading script". But the nominated script varied each time.
>
> Thanks for your continuing investigations.
>
> Kind regards,
> Peter Johnson
>
>
> -----Original Message----- From: Dave Page
> Sent: Friday, March 24, 2017 9:29 PM
> To: Campbell, Lance
> Cc: Peter Johnson ; pgadmin-support@postgresql.org
> Subject: [in] Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load
>
> On Thu, Mar 23, 2017 at 6:08 PM, Campbell, Lance <lance@illinois.edu>
> wrote:
>> Dave,
>> I did exactly what you said.  I totally delete the application.
>> Deleted all directories from the file system.  Then I reinstalled
>> it.  It hung on startup.  I then had to stop it via task manager.
>> Then I loaded it the second time.  It then ran.  The next time I
>> tried to start it the application hung.
>>
>> I have never ever had any issue with pgAdmin 3.  I don't have any of
>> these issues with pgAdmin4 v1.1 .
>
> I'm still struggling to reproduce the issues myself, but all the
> evidence suggests it was the move from QtWekKit to QtWebEngine that
> caused it (that happened in 1.2). We did that because of numerous
> other bugs in QtWebKit, and because QtWebKit has been deprecated and
> removed from current versions of Qt. Unfortunately it seems that
> whilst QtWebEngine solves the original problems, it has it's own set.
>
> We're currently trying a PoC with another option, as well as thinking
> through some other ideas...
>
> Apologies for the inconvenience in the meantime.
>

All,

Please try one of the Mac/Windows test builds at
https://developer.pgadmin.org/~dpage/. I would strongly advise doing a
complete uninstall before installing, to ensure no old, unused files
are left behind.

Thanks.

On Mon, Mar 27, 2017 at 6:40 PM, Bruce Peret <bperet@pobox.com> wrote:
> I just upgraded to 4.1.3 and am having the same issues. Windows 7 pro,
> x64, Postgres 9.6.2. Prior version of pgadmin 4 worked OK. (I skipped
> the 4.1.2 upgrade, using pgadmin 3 instead to do what I needed.)
>
> Same error; various scripts fail to load. It seems to fail more often if
> the system is busy with cpu or disk activity already going on.
>
> Bruce Peret
>
> On 3/26/2017 7:12 PM, Peter Johnson wrote:
>> Dave,
>>
>> Just to follow up your previous advice: I have done a complete
>> uninstall of the application, ensured
>> the installation directory is removed, then re-installed. I tried
>> starting & stopping pgAdmin 4 a few
>> times before re-booting & then again after re-booting my system.
>>
>> In both cases, before & after re-booting, pgAdmin 4 loaded
>> successfully about 50% of the time &
>> didn't load in the other cases. In the unsuccessful load cases, most,
>> but not all, times there was an error msg.
>> "Error loading script". But the nominated script varied each time.
>>
>> Thanks for your continuing investigations.
>>
>> Kind regards,
>> Peter Johnson
>>
>>
>> -----Original Message----- From: Dave Page
>> Sent: Friday, March 24, 2017 9:29 PM
>> To: Campbell, Lance
>> Cc: Peter Johnson ; pgadmin-support@postgresql.org
>> Subject: [in] Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load
>>
>> On Thu, Mar 23, 2017 at 6:08 PM, Campbell, Lance <lance@illinois.edu>
>> wrote:
>>> Dave,
>>> I did exactly what you said.  I totally delete the application.
>>> Deleted all directories from the file system.  Then I reinstalled
>>> it.  It hung on startup.  I then had to stop it via task manager.
>>> Then I loaded it the second time.  It then ran.  The next time I
>>> tried to start it the application hung.
>>>
>>> I have never ever had any issue with pgAdmin 3.  I don't have any of
>>> these issues with pgAdmin4 v1.1 .
>>
>> I'm still struggling to reproduce the issues myself, but all the
>> evidence suggests it was the move from QtWekKit to QtWebEngine that
>> caused it (that happened in 1.2). We did that because of numerous
>> other bugs in QtWebKit, and because QtWebKit has been deprecated and
>> removed from current versions of Qt. Unfortunately it seems that
>> whilst QtWebEngine solves the original problems, it has it's own set.
>>
>> We're currently trying a PoC with another option, as well as thinking
>> through some other ideas...
>>
>> Apologies for the inconvenience in the meantime.
>>
>
>
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support



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

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

Hi Dave,

So far, so good. I uninstalled & removed everything from previous pgAdmin 4 
and installed your new executable.
Have started & stoped it 3 or 4 times, & loaded OK each time.

(BTW, in my removal, I found a pgAdmin log file that was big, over 1.3GB. 
Not sure if that's relevant in any way to the to the load issue. There is 
still space on the disk.)

Thanks for your support on this issue. I'll advise if anything changes.


Regards,
Peter Johnson


-----Original Message----- 
From: Dave Page
Sent: Tuesday, April 04, 2017 6:31 AM
To: Bruce Peret ; Campbell, Lance ; Peter Johnson
Cc: pgAdmin Support
Subject: [in] Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load

All,

Please try one of the Mac/Windows test builds at
https://developer.pgadmin.org/~dpage/. I would strongly advise doing a
complete uninstall before installing, to ensure no old, unused files
are left behind.

Thanks.

On Mon, Mar 27, 2017 at 6:40 PM, Bruce Peret <bperet@pobox.com> wrote:
> I just upgraded to 4.1.3 and am having the same issues. Windows 7 pro,
> x64, Postgres 9.6.2. Prior version of pgadmin 4 worked OK. (I skipped
> the 4.1.2 upgrade, using pgadmin 3 instead to do what I needed.)
>
> Same error; various scripts fail to load. It seems to fail more often if
> the system is busy with cpu or disk activity already going on.
>
> Bruce Peret
>
> On 3/26/2017 7:12 PM, Peter Johnson wrote:
>> Dave,
>>
>> Just to follow up your previous advice: I have done a complete
>> uninstall of the application, ensured
>> the installation directory is removed, then re-installed. I tried
>> starting & stopping pgAdmin 4 a few
>> times before re-booting & then again after re-booting my system.
>>
>> In both cases, before & after re-booting, pgAdmin 4 loaded
>> successfully about 50% of the time &
>> didn't load in the other cases. In the unsuccessful load cases, most,
>> but not all, times there was an error msg.
>> "Error loading script". But the nominated script varied each time.
>>
>> Thanks for your continuing investigations.
>>
>> Kind regards,
>> Peter Johnson
>>
>>
>> -----Original Message----- From: Dave Page
>> Sent: Friday, March 24, 2017 9:29 PM
>> To: Campbell, Lance
>> Cc: Peter Johnson ; pgadmin-support@postgresql.org
>> Subject: [in] Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load
>>
>> On Thu, Mar 23, 2017 at 6:08 PM, Campbell, Lance <lance@illinois.edu>
>> wrote:
>>> Dave,
>>> I did exactly what you said.  I totally delete the application.
>>> Deleted all directories from the file system.  Then I reinstalled
>>> it.  It hung on startup.  I then had to stop it via task manager.
>>> Then I loaded it the second time.  It then ran.  The next time I
>>> tried to start it the application hung.
>>>
>>> I have never ever had any issue with pgAdmin 3.  I don't have any of
>>> these issues with pgAdmin4 v1.1 .
>>
>> I'm still struggling to reproduce the issues myself, but all the
>> evidence suggests it was the move from QtWekKit to QtWebEngine that
>> caused it (that happened in 1.2). We did that because of numerous
>> other bugs in QtWebKit, and because QtWebKit has been deprecated and
>> removed from current versions of Qt. Unfortunately it seems that
>> whilst QtWebEngine solves the original problems, it has it's own set.
>>
>> We're currently trying a PoC with another option, as well as thinking
>> through some other ideas...
>>
>> Apologies for the inconvenience in the meantime.
>>
>
>
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support



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

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


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support 

Thanks Peter. You can adjust the log level by creating a
config_local.py file alongside config.py in your installation. Add the
lines in-between the === marks to the file:

======
from config import *
import logging

CONSOLE_LOG_LEVEL = logging.WARNING
FILE_LOG_LEVEL = logging.WARNING
======

Those are the default settings in current releases though - it's
possible much of your log file is from a much earlier release, before
we dialled down the defaults. You might want to check that in
config.py.

On Tue, Apr 4, 2017 at 9:45 AM, Peter Johnson <pj@acslink.net.au> wrote:
> Hi Dave,
>
> So far, so good. I uninstalled & removed everything from previous pgAdmin 4
> and installed your new executable.
> Have started & stoped it 3 or 4 times, & loaded OK each time.
>
> (BTW, in my removal, I found a pgAdmin log file that was big, over 1.3GB.
> Not sure if that's relevant in any way to the to the load issue. There is
> still space on the disk.)
>
> Thanks for your support on this issue. I'll advise if anything changes.
>
>
> Regards,
> Peter Johnson
>
>
> -----Original Message----- From: Dave Page
> Sent: Tuesday, April 04, 2017 6:31 AM
> To: Bruce Peret ; Campbell, Lance ; Peter Johnson
> Cc: pgAdmin Support
>
> Subject: [in] Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load
>
> All,
>
> Please try one of the Mac/Windows test builds at
> https://developer.pgadmin.org/~dpage/. I would strongly advise doing a
> complete uninstall before installing, to ensure no old, unused files
> are left behind.
>
> Thanks.
>
> On Mon, Mar 27, 2017 at 6:40 PM, Bruce Peret <bperet@pobox.com> wrote:
>>
>> I just upgraded to 4.1.3 and am having the same issues. Windows 7 pro,
>> x64, Postgres 9.6.2. Prior version of pgadmin 4 worked OK. (I skipped
>> the 4.1.2 upgrade, using pgadmin 3 instead to do what I needed.)
>>
>> Same error; various scripts fail to load. It seems to fail more often if
>> the system is busy with cpu or disk activity already going on.
>>
>> Bruce Peret
>>
>> On 3/26/2017 7:12 PM, Peter Johnson wrote:
>>>
>>> Dave,
>>>
>>> Just to follow up your previous advice: I have done a complete
>>> uninstall of the application, ensured
>>> the installation directory is removed, then re-installed. I tried
>>> starting & stopping pgAdmin 4 a few
>>> times before re-booting & then again after re-booting my system.
>>>
>>> In both cases, before & after re-booting, pgAdmin 4 loaded
>>> successfully about 50% of the time &
>>> didn't load in the other cases. In the unsuccessful load cases, most,
>>> but not all, times there was an error msg.
>>> "Error loading script". But the nominated script varied each time.
>>>
>>> Thanks for your continuing investigations.
>>>
>>> Kind regards,
>>> Peter Johnson
>>>
>>>
>>> -----Original Message----- From: Dave Page
>>> Sent: Friday, March 24, 2017 9:29 PM
>>> To: Campbell, Lance
>>> Cc: Peter Johnson ; pgadmin-support@postgresql.org
>>> Subject: [in] Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load
>>>
>>> On Thu, Mar 23, 2017 at 6:08 PM, Campbell, Lance <lance@illinois.edu>
>>> wrote:
>>>>
>>>> Dave,
>>>> I did exactly what you said.  I totally delete the application.
>>>> Deleted all directories from the file system.  Then I reinstalled
>>>> it.  It hung on startup.  I then had to stop it via task manager.
>>>> Then I loaded it the second time.  It then ran.  The next time I
>>>> tried to start it the application hung.
>>>>
>>>> I have never ever had any issue with pgAdmin 3.  I don't have any of
>>>> these issues with pgAdmin4 v1.1 .
>>>
>>>
>>> I'm still struggling to reproduce the issues myself, but all the
>>> evidence suggests it was the move from QtWekKit to QtWebEngine that
>>> caused it (that happened in 1.2). We did that because of numerous
>>> other bugs in QtWebKit, and because QtWebKit has been deprecated and
>>> removed from current versions of Qt. Unfortunately it seems that
>>> whilst QtWebEngine solves the original problems, it has it's own set.
>>>
>>> We're currently trying a PoC with another option, as well as thinking
>>> through some other ideas...
>>>
>>> Apologies for the inconvenience in the meantime.
>>>
>>
>>
>>
>>
>> --
>> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support



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

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

Hello,

I had pretty much the same problem as Peter and this version solved it.

Thanks.



--
View this message in context: http://www.postgresql-archive.org/pgAdmin-4-v1-3-fails-to-load-tp5951102p5965367.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

I just loaded pgAdmin 4 v1.6 and I'm running into the same issue reported
here with pgAdmin opening, then sitting at the "Loading pgAdmin 4 v1.6"
spinning wheel.  I'm running it on Windows 7 64-bit OS.  I've already
changed the following config.py setting as I'm not running it on a
webserver:

SERVER_MODE = True

I changed it to False and saved.

Other than that, is there anything else that I need to do to get it working?

Thanks in advance for your help!

Dennis



--
View this message in context: http://www.postgresql-archive.org/pgAdmin-4-v1-3-fails-to-load-tp5951102p5975786.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Ok, I found the problem.  I had to right click on the shortcut, go to the
Security tab and give my user full control permissions.  Once I did that, it
runs just fine.

Thanks!

Dennis



--
View this message in context: http://www.postgresql-archive.org/pgAdmin-4-v1-3-fails-to-load-tp5951102p5975792.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.