Thread: pgadmin4 3.0: OpenTagNotFoundError
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
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<
:DG<
Hi,
I can see there are many extra python modules are present in your virtual environment, It seems like there must be some python module conflicting with pgAdmin4 modules.
This is what I've in my fresh pgAdmin4 virtual environment,
(venv_pg4) murtuza@b0x:~/Documents/prj/pgadmin4$ pip freeze
alembic==0.9.9
asn1crypto==0.24.0
Babel==2.5.3
bcrypt==3.1.4
blinker==1.4
cffi==1.11.5
chromedriver-installer==0.0.6
click==6.7
cryptography==2.2.2
extras==1.0.0
fixtures==3.0.0
Flask==0.12.2
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-Security==3.0.0
Flask-SQLAlchemy==2.3.2
Flask-WTF==0.14.2
html5lib==1.0.1
htmlmin==0.1.12
idna==2.6
itsdangerous==0.24
Jinja2==2.10
linecache2==1.0.0
Mako==1.0.7
MarkupSafe==1.0
paramiko==2.4.1
passlib==1.7.1
pbr==3.1.1
psycopg2==2.7.4
pyasn1==0.4.2
pycodestyle==2.3.1
pycparser==2.18
pycrypto==2.6.1
PyNaCl==1.2.1
pyperclip==1.6.0
pyrsistent==0.14.2
pytest-runner==4.2
python-dateutil==2.7.2
python-editor==1.0.3
python-mimeparse==1.6.0
pytz==2018.3
selenium==3.11.0
setuptools-scm==2.0.0
simplejson==3.13.2
six==1.11.0
speaklater==1.3
SQLAlchemy==1.2.7
sqlparse==0.2.4
sshtunnel==0.1.3
testscenarios==0.5.0
testtools==2.3.0
traceback2==1.4.0
unittest2==1.1.0
webencodings==0.5.1
Werkzeug==0.14.1
WTForms==2.1
Could you please check again with the clean virtual environment where you do not have any unwanted modules included in it?
--
Regards,
On Sun, May 27, 2018 at 9:02 PM, David Gilman <davidgilman1@gmail.com> wrote:
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] OpenTagNotFoundErrorThe 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_version9.4mod_wsgi for python 2.7 configuration:WSGIDaemonProcess pgadmin processes=1 threads=10 user=pgadmin group=pgadmin python-home=/home/pgadmin/venvWSGIScriptAlias /pgadmin /home/pgadmin/venv/lib/python2.7/site-packages/ pgadmin4/pgAdmin4.wsgi <Directory /home/pgadmin/venv/lib/python2.7/site-packages/ pgadmin4> AuthType BasicAuthName pgadmin4AuthUserFile /etc/apache2/htpasswdsRequire user asdfjklWSGIProcessGroup pgadminWSGIApplicationGroup %{GLOBAL}</Directory>pip freeze output:alembic==0.9.5attrs==16.3.0Babel==2.3.4backports.csv==1.0.5bcrypt==3.1.2beautifulsoup4==4.4.1blinker==1.4chardet==2.3.0click==6.6colorama==0.3.7constantly==15.1.0cryptography==1.7.1defusedxml==0.4.1enum34==1.1.6extras==1.0.0feedparser==5.1.3fixtures==3.0.0Flask==0.12.2Flask-Babel==0.11.1Flask-BabelEx==0.9.3Flask-Gravatar==0.5.0Flask-HTMLmin==1.3.2Flask-Login==0.3.2Flask-Mail==0.9.1Flask-Migrate==2.1.1Flask-Paranoid==0.2.0Flask-Principal==0.4.0Flask-Script==2.0.6Flask-Security==3.0.0Flask-SQLAlchemy==2.3.2Flask-WTF==0.14.2fpconst==0.7.2html5lib==1.0.1htmlmin==0.1.11icalendar==3.6.1idna==2.2importlib==1.0.4incremental==16.10.1ipaddress==1.0.17isodate==0.5.4itsdangerous==0.24Jinja2==2.7.3keyring==10.1keyrings.alt==1.3linecache2==1.0.0lxml==3.7.1Mako==1.0.7MarkupSafe==0.23mysqlclient==1.3.7passlib==1.7.1pbr==3.1.1pgadmin4==3.0pkg-resources==0.0.0psycopg2==2.7.3.2pyasn1==0.1.9pyasn1-modules==0.0.7pycrypto==2.6.1Pygments==2.2.0pygobject==3.22.0pylibacl==0.5.3pyOpenSSL==16.2.0pyparsing==2.1.10pyrsistent==0.14.2pyspatialite==3.0.1python-dateutil==2.7.3python-editor==1.0.3python-mimeparse==1.6.0pytz==2018.3pyxattr==0.6.0pyxdg==0.25rdflib==4.2.1rdiff-backup==1.2.8SecretStorage==2.3.1service-identity==16.0.0simplejson==3.13.2six==1.11.0SOAPpy==0.12.22SPARQLWrapper==1.7.6speaklater==1.3SQLAlchemy==1.2.7sqlparse==0.2.4testtools==2.3.0traceback2==1.4.0Twisted==16.6.0unittest2==1.1.0virtualenv==15.1.0webencodings==0.5Werkzeug==0.9.6wokkel==0.7.1wstools==0.4.3WTForms==2.1zope.interface==4.3.2--David Gilman
:DG<
Re: David Gilman 2018-05-27 <CALBH9DBoagWc9m4JsVjz3bo-XfX9PUwRjwsRX=tCs8zL7ff4oQ@mail.gmail.com> > 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. > Flask-HTMLmin==1.3.2 > htmlmin==0.1.11 You need htmlmin 0.1.12: https://github.com/mankyd/htmlmin/issues/46 https://github.com/mankyd/htmlmin/commit/220b1d16442eb4b6fafed338ee3b61f698a01e63 The old version sometimes fails subsequent requests to minify some object, the internal state was not cleared properly. Btw, any reason you aren't using the pgadmin4 Debian packages from apt.postgresql.org? Christoph