superset db upgrade not working when upgrading from v 0.35.2 to 1.0.1

[asdi744]

I am trying to upgrade superset from version 0.35.2 to 1.0.1

Expected results

superset db upgrade command should migrate my default db compatible to v 1.0.1

Actual results

superset db upgrade failed with the following error

sqlalchemy.exc.IntegrityError: (psycopg2.errors.NotNullViolation) column "table_name" contains null values

[SQL: ALTER TABLE tables ALTER COLUMN table_name SET NOT NULL]

Screenshots

How to reproduce the bug

1. pip install apache-superset
2. superset db upgrade

Environment

(please complete the following information):

• superset version: 1.0.1
• python version: 3.7.3
• flask version: 1.1.2
• Werkzeug version 1.0.1

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are any.
• I have reproduced the issue with at least the latest released version of superset.
• I have checked the issue tracker for the same issue and I haven't found one similar.

[asdi744]

Dear community, please help.