[GitHub] [superset] StormingBullet commented on issue #23622: Failed run with 'superset db upgrade'

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

StormingBullet commented on issue #23622:
URL: https://github.com/apache/superset/issues/23622#issuecomment-1506333949

   > @StormingBullet I had same issue. After multiple tries, I got solution.
   > 
   > it was Sqlite version issue. Actually centos7 comes with very old version of Sqlite. I have replaced Sqlite with postgres 15 `SQLALCHEMY_DATABASE_URI = 'postgresql://postgres:postgres@localhost/postgres' ` and it worked fine.
   
   Thank you for your answer.
   However, it seems that it is not just a problem with the old version of sqlite3.
   I compiled and installed sqlite3 to the latest version and tried again, but the result was the same.
   (Of course, the symbolic link has been changed accordingly.)
   
   ```
   $ sqlite3 --version
   3.41.2 2023-03-22 11:56:21 0d1fc92f94cb6b76bffe3ec34d69cffde2924203304e8ffc4155597af0c191da
   ```
   
   But there was no difference.
   
   Anyway, as you said, this problem was solved when using postgres. (But another error related to the certificate appeared during the sample data generation process. maybe it's not related to postgres.)


-- 
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