After upgrading to pgadmin4 3.0 I am frequently greeted with this fatal
error when trying to load pgadmin4:
[wsgi:error] mod_wsgi (pid=22889): Exception occurred processing WSGI
script
'/home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi'.
[wsgi:error] Traceback (most recent call last):
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line
1997, in __call__
[wsgi:error] return self.wsgi_app(environ, start_response)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line
1985, in wsgi_app
[wsgi:error] response = self.handle_exception(e)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line
1540, in handle_exception
[wsgi:error] reraise(exc_type, exc_value, tb)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line
1982, in wsgi_app
[wsgi:error] response = self.full_dispatch_request()
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line
1615, in full_dispatch_request
[wsgi:error] return self.finalize_request(rv)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line
1632, in finalize_request
[wsgi:error] response = self.process_response(response)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/flask/app.py", line
1856, in process_response
[wsgi:error] response = handler(response)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/flask_htmlmin.py",
line 35, in response_minify
[wsgi:error] self.html_minify.minify(response.get_data(as_text=True))
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/main.py",
line 162, in minify
[wsgi:error] self.input(*input)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/main.py",
line 174, in input
[wsgi:error] self._parser.feed(i)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/python3html/parser.py",
line 125, in feed
[wsgi:error] self.goahead(0)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/python3html/parser.py",
line 185, in goahead
[wsgi:error] k = self.parse_starttag(i)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/python3html/parser.py",
line 359, in parse_starttag
[wsgi:error] self.handle_starttag(tag, attrs)
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/parser.py",
line 278, in handle_starttag
[wsgi:error] self._in_pre_tag -= self._close_tags_up_to(t[0])
[wsgi:error] File
"/home/pgadmin/venv/local/lib/python2.7/site-packages/htmlmin/parser.py",
line 261, in _close_tags_up_to
[wsgi:error] raise OpenTagNotFoundError()
[wsgi:error] OpenTagNotFoundError
The error is intermittent, it seems that by restart apache you can
sometimes make it work but right now I seem to be in a situation where I
can't get pgadmin4 to start at all.
System details:
root@dgilman:/# cat /etc/debian_version
9.4
mod_wsgi for python 2.7 configuration:
WSGIDaemonProcess pgadmin processes=1 threads=10 user=pgadmin group=pgadmin
python-home=/home/pgadmin/venv
WSGIScriptAlias /pgadmin
/home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4/pgAdmin4.wsgi
<Directory /home/pgadmin/venv/lib/python2.7/site-packages/pgadmin4>
AuthType Basic
AuthName pgadmin4
AuthUserFile /etc/apache2/htpasswds
Require user asdfjkl
WSGIProcessGroup pgadmin
WSGIApplicationGroup %{GLOBAL}
</Directory>
pip freeze output:
alembic==0.9.5
attrs==16.3.0
Babel==2.3.4
backports.csv==1.0.5
bcrypt==3.1.2
beautifulsoup4==4.4.1
blinker==1.4
chardet==2.3.0
click==6.6
colorama==0.3.7
constantly==15.1.0
cryptography==1.7.1
defusedxml==0.4.1
enum34==1.1.6
extras==1.0.0
feedparser==5.1.3
fixtures==3.0.0
Flask==0.12.2
Flask-Babel==0.11.1
Flask-BabelEx==0.9.3
Flask-Gravatar==0.5.0
Flask-HTMLmin==1.3.2
Flask-Login==0.3.2
Flask-Mail==0.9.1
Flask-Migrate==2.1.1
Flask-Paranoid==0.2.0
Flask-Principal==0.4.0
Flask-Script==2.0.6
Flask-Security==3.0.0
Flask-SQLAlchemy==2.3.2
Flask-WTF==0.14.2
fpconst==0.7.2
html5lib==1.0.1
htmlmin==0.1.11
icalendar==3.6.1
idna==2.2
importlib==1.0.4
incremental==16.10.1
ipaddress==1.0.17
isodate==0.5.4
itsdangerous==0.24
Jinja2==2.7.3
keyring==10.1
keyrings.alt==1.3
linecache2==1.0.0
lxml==3.7.1
Mako==1.0.7
MarkupSafe==0.23
mysqlclient==1.3.7
passlib==1.7.1
pbr==3.1.1
pgadmin4==3.0
pkg-resources==0.0.0
psycopg2==2.7.3.2
pyasn1==0.1.9
pyasn1-modules==0.0.7
pycrypto==2.6.1
Pygments==2.2.0
pygobject==3.22.0
pylibacl==0.5.3
pyOpenSSL==16.2.0
pyparsing==2.1.10
pyrsistent==0.14.2
pyspatialite==3.0.1
python-dateutil==2.7.3
python-editor==1.0.3
python-mimeparse==1.6.0
pytz==2018.3
pyxattr==0.6.0
pyxdg==0.25
rdflib==4.2.1
rdiff-backup==1.2.8
SecretStorage==2.3.1
service-identity==16.0.0
simplejson==3.13.2
six==1.11.0
SOAPpy==0.12.22
SPARQLWrapper==1.7.6
speaklater==1.3
SQLAlchemy==1.2.7
sqlparse==0.2.4
testtools==2.3.0
traceback2==1.4.0
Twisted==16.6.0
unittest2==1.1.0
virtualenv==15.1.0
webencodings==0.5
Werkzeug==0.9.6
wokkel==0.7.1
wstools==0.4.3
WTForms==2.1
zope.interface==4.3.2
--
David Gilman
:DG<
