[GitHub] cycy9999 opened a new issue #6389: Superset Database is locked

[GitBox <gi...@apache.org>]

cycy9999 opened a new issue #6389: Superset Database is locked
URL: https://github.com/apache/incubator-superset/issues/6389
 
 
   - [yes] I have checked the superset logs for python stacktraces and included it here as text if there are any.
   - [no] I have reproduced the issue with at least the latest released version of superset.
   - [ yes] I have checked the issue tracker for the same issue and I haven't found one similar.
   
   
   ### Superset version: 0.25.5
   
   Hello,
   I use Superset since 6 months with success.
   My problem already happened several times until this morning, when a new time, Superset was locked.
    
   I stopped superset and I tried to restart it with following command:
   "nohup superset runserver -d -p 8088 &"
   
   the product did not start because the Database is locked, here is the error message:
   
   OperationalError:
   
   (sqlite3.OperationalError) database is locked [SQL: u'SELECT ab_user.id AS ab_user_id, ab_user.first_name AS ab_user_first_name, ab_user.last_name AS ab_user_last_name, ab_user.username AS ab_user_username, ab_user.password AS ab_user_password, ab_user.active AS ab_user_active, ab_user.email AS ab_user_email, ab_user.last_login AS ab_user_last_login, ab_user.login_count AS ab_user_login_count, ab_user.fail_login_count AS ab_user_fail_login_count, ab_user.created_on AS ab_user_created_on, ab_user.changed_on AS ab_user_changed_on, ab_user.created_by_fk AS ab_user_created_by_fk, ab_user.changed_by_fk AS ab_user_changed_by_fk \nFROM ab_user \nWHERE ab_user.id = ?'] [parameters: (1,)]
   
   After several kill and attempts (even rebooting the server), it has finally restarted.
   
   As said, this problem already occurred several times.
   
   could you help me to understand better this error, and how to process correctly ?
   
   
   
   
   
   
   ### Expected results
   Avoid to lock the Database.
   Have a command / a solution to unlock the Database.
   
   ### Actual results
   Superset has restarted, but I am afraid the problem occur again.
   
   ### Steps to reproduce
   I don't know
   
   
   Many thanks for your ideas / help
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

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