[GitHub] [superset] alanorth commented on issue #23483: upgrade from 2.0.1 to 2.1.0.rc3 fails

["alanorth (via GitHub)" <gi...@apache.org>]

alanorth commented on issue #23483:
URL: https://github.com/apache/superset/issues/23483#issuecomment-1498723868

   Upgrading from 2.0.1 to 2.1.0 failed for me as well:
   
   ```console
   # systemctl stop superset
   # su - superset
   $ mv venv venv-2.0.1
   $ python3.8 -m venv venv
   $ source ./venv/bin/activate
   $ pip install --upgrade setuptools pip wheel
   # Make sure we install the EXACT dependencies listed in Superset 2.1.0's requirements.txt
   $ curl -sS https://raw.githubusercontent.com/apache/superset/2.1.0/requirements/base.txt | tail -n +10 | awk -v ORS=" " '/^[A-z]/{print}' | xargs pip install apache-superset==2.1.0
   $ pip install pillow mysqlclient gevent
   $ export PYTHONPATH=/home/superset
   $ export FLASK_APP=superset
   $ superset
   $ superset db upgrade
   $ superset init
   ...
   (MySQLdb.ProgrammingError) (1146, "Table 'superset.ab_permission_view_role_id_seq' doesn't exist")
   [SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) VALUES (nextval(ab_permission_view_role_id_seq), %s, %s)]
   [parameters: ((460, 6), (462, 6), (148, 6), (186, 6), (228, 6), (463, 6), (457, 6), (458, 6)  ... displaying 10 of 14 total bound parameter sets ...  (585, 6), (805, 6))]
   (Background on this error at: https://sqlalche.me/e/14/f405)
   ```
   
   Log: [superset-init.log](https://github.com/apache/superset/files/11168300/superset-init.log)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org