Upgrade from 3.x version Failed


#1

Issue Summary
A summary of the issue and the browser/OS environment in which it occurs.

Steps to Reproduce

Requirement Python package:
alembic==0.9.9
amqp==1.4.9
aniso8601==1.1.0
anyjson==0.3.3
asn1crypto==0.24.0
backports.ssl-match-hostname==3.5.0.1
billiard==3.3.0.23
blinker==1.3
botocore==1.5.72
cachetools==2.1.0
celery==3.1.25
cffi==1.11.5
click==6.6
configobj==4.7.2
contextlib2==0.5.5
cryptography==2.0.2
cx-Oracle==6.3.1
decorator==3.4.0
defusedxml==0.5.0
docutils==0.14
dynamo3==0.4.7
enum34==1.1.6
Flask==0.11.1
Flask-Admin==1.4.2
Flask-Limiter==0.9.3
Flask-Login==0.4.0
Flask-Mail==0.9.1
Flask-Migrate==2.0.1
Flask-OAuthlib==0.9.3
Flask-RESTful==0.3.5
Flask-Script==2.0.6
Flask-SQLAlchemy==2.1
Flask-SSLify==0.1.5
funcy==1.7.1
future==0.16.0
google-api-python-client==1.5.1
google-auth==1.5.0
google-auth-httplib2==0.0.3
gspread==0.6.2
gunicorn==19.7.1
honcho==0.5.0
httplib2==0.10.3
idna==2.7
impyla==0.10.0
influxdb==2.7.1
iniparse==0.4
ipaddress==1.0.16
itsdangerous==0.24
Jinja2==2.8
jmespath==0.9.3
jsonschema==2.4.0
kombu==3.0.37
limits==1.3
Mako==1.0.7
MarkupSafe==0.23
meld3==0.6.10
msgpack-python==0.4.8
MySQL-python==1.2.5
oauth2client==3.0.0
oauthlib==2.1.0
parsedatetime==2.1
passlib==1.6.2
Paste==2.0.3
perf==0.1
psycopg2==2.7.3.2
pyasn1==0.4.3
pyasn1-modules==0.2.1
pycparser==2.18
pycrypto==2.6.1
pycurl==7.19.0
pygobject==3.22.0
pygpgme==0.3
PyHive==0.3.0
pyliblzma==0.5.3
pymongo==3.2.1
pymssql==2.1.3
pyOpenSSL==16.2.0
pyparsing==2.2.0
pysaml2==4.5.0
pystache==0.5.4
python-dateutil==2.4.2
python-editor==1.0.3
python-geoip==1.2
python-geoip-geolite2==2015.303
python-linux-procfs==0.4.9
pytz==2016.7
pyudev==0.15
pyxattr==0.5.1
raven==6.0.0
redis==2.10.5
repoze.who==2.3
requests==2.11.1
requests-oauthlib==1.0.0
RestrictedPython==3.6.0
rsa==3.4.2
schedutils==0.4
semver==2.2.1
setproctitle==1.1.10
simplejson==3.10.0
six==1.10.0
slip==0.4.0
slip.dbus==0.4.0
SQLAlchemy==1.1.4
SQLAlchemy-Searchable==0.10.6
SQLAlchemy-Utils==0.33.3
sqlparse==0.2.4
statsd==2.1.2
supervisor==3.1.4
td-client==0.8.0
thrift==0.11.0
ua-parser==0.7.3
uritemplate==0.6
urlgrabber==3.10
urllib3==1.23
user-agents==1.1.0
validators==0.12.2
vertica-python==0.5.1
WebOb==1.8.2
Werkzeug==0.11.11
WTForms==2.2.1
XlsxWriter==0.9.3
yum-metadata-parser==1.1.4
zope.interface==4.5.0

[root@opertool-9-201 bin]# ./upgrade
Starting Redash upgrade:
Found version: 4.0.1
Current version: 3.0.0+b3134

Before doing an upgrade, please make sure you have a backup.
If you have any issues, please refer to the troubleshooting section in the upgrade guide:
If the upgrade guide doesn’t help, you can ask for help on the forum (https://discuss.redash.io).
Continue with upgrade? (y/n): y
Downloading release tarball…
Unpacking to: redash.4.0.1.b4038…
Changing ownership to redash…
Linking .env file…
Installing new Python packages (if needed)…
Running migrations (if needed)…
Failed running: sudo -u redash bin/run ./manage.py db upgrade
Exit status: 1
Output:
/usr/lib/python2.7/site-packages/sqlalchemy_searchable/parser.py:107: SyntaxWarning: Cannot combine element of type <type ‘NoneType’> with ParserElement
).setResultsName(‘and’) |
/usr/lib/python2.7/site-packages/sqlalchemy_searchable/parser.py:108: SyntaxWarning: Cannot combine element of type <type ‘NoneType’> with ParserElement
not_
Traceback (most recent call last):
File “/opt/redash/redash.4.0.1.b4038/manage.py”, line 6, in
from redash.cli import manager
File “/opt/redash/redash.4.0.1.b4038/redash/init.py”, line 72, in
import_query_runners(settings.QUERY_RUNNERS)
File “/opt/redash/redash.4.0.1.b4038/redash/query_runner/init.py”, line 179, in import_query_runners
import(runner_import)
File “/opt/redash/redash.4.0.1.b4038/redash/query_runner/query_results.py”, line 9, in
from redash import models
File “/opt/redash/redash.4.0.1.b4038/redash/models.py”, line 38, in
from sqlalchemy_searchable import SearchQueryMixin, make_searchable, vectorizer
File “/usr/lib/python2.7/site-packages/sqlalchemy_searchable/init.py”, line 17, in
parser = SearchQueryParser()
File “/usr/lib/python2.7/site-packages/sqlalchemy_searchable/parser.py”, line 49, in init
self.parser = self.parser()
File “/usr/lib/python2.7/site-packages/sqlalchemy_searchable/parser.py”, line 108, in parser
not
File “/usr/lib/python2.7/site-packages/pyparsing.py”, line 2927, in lshift
self.mayReturnEmpty = other.mayReturnEmpty
AttributeError: ‘NoneType’ object has no attribute ‘mayReturnEmpty’

Technical details:
Redash Version: redash.3.0.0.b3134
Browser/OS: CentOS 7 x64
How did you install Redash: use bootstrap.sh
I can’t upgrade to version 3.0 by using CLI.