Hi
On Tue, Jun 28, 2016 at 12:01 AM, rmikeuk <r...@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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
