Re: pgAdmin4 10-beta2 for Mac - error/freeze on start

Hi

On Tue, Jun 28, 2016 at 12:01 AM, rmikeuk <roy(at)tmtch(dot)demon(dot)co(dot)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(at)postgresql(dot)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