Обсуждение: pgAdmin4 10-beta2 for Mac - error/freeze on start
Hi, I installed pgAdmin4 1.0 beta2 onto Mac running OS X Yosemite 10.10.2 with python 2.7.11 Running the app i get a partial app start up as shown below and then it freezes: <http://postgresql.nabble.com/file/n5909658/Screenshot_2016-06-27_23.png> Also get the following console messages: which then continue to loop on the final "OperationalError: database is locked: Full Python path: "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload:/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python" User Python path: "" Webapp path: "/Applications/pgAdmin 4.app/Contents/Resources/web/pgAdmin4.py" QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) QObject::connect: Cannot connect (null)::stateChanged(QNetworkSession::State) to QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) 2016-06-27 23:41:54,509: ERROR pgadmin: Exception on /static/css/font-mfizz.css [GET] Traceback (most recent call last): File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1817, in wsgi_app response = self.full_dispatch_request() File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1477, in full_dispatch_request rv = self.handle_user_exception(e) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1381, in handle_user_exception reraise(exc_type, exc_value, tb) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1473, in full_dispatch_request rv = self.preprocess_request() File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1666, in preprocess_request rv = func() File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/__init__.py", line 244, in before_request login_user(user) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask_security/utils.py", line 61, in login_user if not _login_user(user, remember): # pragma: no cover File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask_login.py", line 679, in login_user session['user_id'] = user_id File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/local.py", line 341, in __setitem__ self._get_current_object()[key] = value File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/session.py", line 88, in __setitem__ conn.execute(self._set_sql, (key, sqlite3.Binary(value))) OperationalError: database is locked 2016-06-27 23:42:03,981: ERROR pgadmin: Exception on /static/css/backgrid/backgrid-select-all.min.css [GET] Traceback (most recent call last): File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1817, in wsgi_app response = self.full_dispatch_request() File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1477, in full_dispatch_request rv = self.handle_user_exception(e) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1381, in handle_user_exception reraise(exc_type, exc_value, tb) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1473, in full_dispatch_request rv = self.preprocess_request() File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line 1666, in preprocess_request rv = func() File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/__init__.py", line 244, in before_request login_user(user) File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask_security/utils.py", line 61, in login_user if not _login_user(user, remember): # pragma: no cover File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/flask_login.py", line 680, in login_user session['_fresh'] = True File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/local.py", line 341, in __setitem__ self._get_current_object()[key] = value File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/session.py", line 88, in __setitem__ conn.execute(self._set_sql, (key, sqlite3.Binary(value))) OperationalError: database is locked Any help greatly appreciated. -- View this message in context: http://postgresql.nabble.com/pgAdmin4-10-beta2-for-Mac-error-freeze-on-start-tp5909658.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
Hi On Tue, Jun 28, 2016 at 12:01 AM, rmikeuk <roy@tmtch.demon.co.uk> wrote: > Hi, > > I installed pgAdmin4 1.0 beta2 onto Mac running OS X Yosemite 10.10.2 with > python 2.7.11 > > Running the app i get a partial app start up as shown below and then it > freezes: > <http://postgresql.nabble.com/file/n5909658/Screenshot_2016-06-27_23.png> > > Also get the following console messages: which then continue to loop on the > final "OperationalError: database is locked: We've seen that on Macs before, but only in fairly resource limited virtual machines. What are you running on exactly? Ashesh recently added a parameter to allow control of the timeout on the database to avoid this issue - you could try increasing that. Try adding something like this to config_local.py: # SQLITE_TIMEOUT will define how long to wait before throwing the error - # OperationError due to database lock. On slower system, you may need to change # this to some higher value. # (Default: 500 milliseconds) SQLITE_TIMEOUT = 1000 > Full Python path: "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages:/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/lib-dynload:/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python" > User Python path: "" > Webapp path: "/Applications/pgAdmin > 4.app/Contents/Resources/web/pgAdmin4.py" > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > QObject::connect: Cannot connect > (null)::stateChanged(QNetworkSession::State) to > QNetworkReplyHttpImpl::_q_networkSessionStateChanged(QNetworkSession::State) > 2016-06-27 23:41:54,509: ERROR pgadmin: Exception on > /static/css/font-mfizz.css [GET] > Traceback (most recent call last): > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1817, in wsgi_app > response = self.full_dispatch_request() > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1477, in full_dispatch_request > rv = self.handle_user_exception(e) > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1381, in handle_user_exception > reraise(exc_type, exc_value, tb) > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1473, in full_dispatch_request > rv = self.preprocess_request() > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1666, in preprocess_request > rv = func() > File "/Applications/pgAdmin > 4.app/Contents/Resources/web/pgadmin/__init__.py", line 244, in > before_request > login_user(user) > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask_security/utils.py", > line 61, in login_user > if not _login_user(user, remember): # pragma: no cover > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask_login.py", line > 679, in login_user > session['user_id'] = user_id > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/local.py", > line 341, in __setitem__ > self._get_current_object()[key] = value > File "/Applications/pgAdmin > 4.app/Contents/Resources/web/pgadmin/utils/session.py", line 88, in > __setitem__ > conn.execute(self._set_sql, (key, sqlite3.Binary(value))) > OperationalError: database is locked > 2016-06-27 23:42:03,981: ERROR pgadmin: Exception on > /static/css/backgrid/backgrid-select-all.min.css [GET] > Traceback (most recent call last): > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1817, in wsgi_app > response = self.full_dispatch_request() > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1477, in full_dispatch_request > rv = self.handle_user_exception(e) > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1381, in handle_user_exception > reraise(exc_type, exc_value, tb) > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1473, in full_dispatch_request > rv = self.preprocess_request() > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask/app.py", line > 1666, in preprocess_request > rv = func() > File "/Applications/pgAdmin > 4.app/Contents/Resources/web/pgadmin/__init__.py", line 244, in > before_request > login_user(user) > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask_security/utils.py", > line 61, in login_user > if not _login_user(user, remember): # pragma: no cover > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/flask_login.py", line > 680, in login_user > session['_fresh'] = True > File "/Applications/pgAdmin > 4.app/Contents/Resources/venv/lib/python/site-packages/werkzeug/local.py", > line 341, in __setitem__ > self._get_current_object()[key] = value > File "/Applications/pgAdmin > 4.app/Contents/Resources/web/pgadmin/utils/session.py", line 88, in > __setitem__ > conn.execute(self._set_sql, (key, sqlite3.Binary(value))) > OperationalError: database is locked > > > Any help greatly appreciated. > > > > -- > View this message in context: http://postgresql.nabble.com/pgAdmin4-10-beta2-for-Mac-error-freeze-on-start-tp5909658.html > Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. > > > -- > 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, Many thanks for the reply. Sorry - should have added details about the Mac. I don't think it should be hardware issue as its a new-ish (year old) Mac Book Pro 2.5Ghz Intel I7 16 Gb. However, again, i should have included in first post - i did actually wonder if was a resource issue as i do often run a fair few things concurrently. So had also tried shutting everything down and then trying again with nothing else running - same result. Also as an aside, I have also got VMWare Fusion so i did also spin up a Win 7 VM and downloaded the Windows pgAdmin4 version ...that starts fine in VM. But obviously I would much prefer to use Mac! Given all that I have still just tried SQLITE_TIMEOUT = 1000 addition. Afraid the result is still exactly the same - but obviously a slower occurrence and repetition of the "database is locked" result. I was wondering if the error / lock could be due to an earlier issue or error or problem with my environment. I just read the instructions here about desktop deployment: https://www.pgadmin.org/docs4/dev/desktop_deployment.html#configuration Although have obviously downloaded the .app i did just check these. The config_local.py file is fine. There is no pgadmin4.db Not sure if its a red herring or if i should have done so , but i just tried : > pwd /Applications/pgAdmin 4.app/Contents/Resources/web > python setup.py Traceback (most recent call last): File "setup.py", line 20, in <module> from flask import Flask ImportError: No module named flask However, i can see flask and all the other dependecies are in the app in the directory: /Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages So not sure whether that is pointing to an issue with my setup or something I'm doing incorrectly or thats just not a suitable thing to try. I've tried removing the app and then re-installing to the Applications folder. But same problem. Any further thoughts? Really appreciate the time and help. Many thanks. -- View this message in context: http://postgresql.nabble.com/pgAdmin4-10-beta2-for-Mac-error-freeze-on-start-tp5909658p5909703.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
On Tue, Jun 28, 2016 at 4:09 PM, rmikeuk <roy@tmtch.demon.co.uk> wrote:
Hi,
Many thanks for the reply.
Sorry - should have added details about the Mac. I don't think it should be
hardware issue as its a new-ish (year old) Mac Book Pro 2.5Ghz Intel I7 16
Gb.
However, again, i should have included in first post - i did actually wonder
if was a resource issue as i do often run a fair few things concurrently. So
had also tried shutting everything down and then trying again with nothing
else running - same result.
Also as an aside, I have also got VMWare Fusion so i did also spin up a Win
7 VM and downloaded the Windows pgAdmin4 version ...that starts fine in VM.
But obviously I would much prefer to use Mac!
Given all that I have still just tried SQLITE_TIMEOUT = 1000 addition.
Afraid the result is still exactly the same - but obviously a slower
occurrence and repetition of the "database is locked" result.
I was wondering if the error / lock could be due to an earlier issue or
error or problem with my environment.
I've seen the same issue one of my colleague's MacBook, sqlite is not coping up with the read, and write of the session on OSX.
Or, the way, the code has been written, is not optimised enough to work with Sqlite.
I am currently working on the caching mechanism in the session handling for the same issue, and hopefully will be able to share the patch to resolve the issue.
I just read the instructions here about desktop deployment:
https://www.pgadmin.org/docs4/dev/desktop_deployment.html#configuration
Although have obviously downloaded the .app i did just check these.
The config_local.py file is fine.
There is no pgadmin4.db
Not sure if its a red herring or if i should have done so , but i just tried
:
> pwd
/Applications/pgAdmin 4.app/Contents/Resources/web
> python setup.py
Traceback (most recent call last):
File "setup.py", line 20, in <module>
from flask import Flask
ImportError: No module named flask
However, i can see flask and all the other dependecies are in the app in the
directory:
/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python/site-packages
So not sure whether that is pointing to an issue with my setup or something
I'm doing incorrectly or thats just not a suitable thing to try.
You need to set PYTHONPATH for the same to make it from the virtual environment.
I've tried removing the app and then re-installing to the Applications
folder. But same problem.
Any further thoughts? Really appreciate the time and help.
Many thanks.
In order to make pgAdmin 4 (beta 2) to work on your OSX, you can comment out the line #124 in file -
'/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/__init__.py'.
i.e.
# app.session_interface = ServerSideSessionInterface(config.SESSION_DB_PATH)
Hope - this will help to make it work on your system.
--
Thanks & Regards,
Ashesh Vashi
Hi Ashesh, Ashesh Vashi wrote > On Tue, Jun 28, 2016 at 4:09 PM, rmikeuk < > roy@.co > > wrote: > > > In order to make pgAdmin 4 (beta 2) to work on your OSX, you can comment > out the line #124 in file - > '/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/__init__.py'. > i.e. > *# app.session_interface = > ServerSideSessionInterface(config.SESSION_DB_PATH)* > > Hope - this will help to make it work on your system. Commenting that line out did the trick! The beta2 version now running up ok on my Mac Many thanks. -- View this message in context: http://postgresql.nabble.com/pgAdmin4-10-beta2-for-Mac-error-freeze-on-start-tp5909658p5909707.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.