[GitHub] mprior10 commented on issue #6307: db upgrade reverts database to a previous version

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

mprior10 commented on issue #6307: db upgrade reverts database to a previous version
URL: https://github.com/apache/incubator-superset/issues/6307#issuecomment-437927401
 
 
   I’ve reproduced this on a new installation. Here are the steps
   
   -Install 0.24.0 keeping the default sqlite db for superset.db
   -pip install psycopg2
   -Add a database in Sources (in our case Postgresql)
   -Add a table referencing a table in the database.
   -Edit the table, and change the table name (new name won’t reflect an actual table), and now put some sql to create a (Superset) View.
   -Save the table
   -Shutdown the 0.24.0 instance and copy the superset.db to a non running 0.28.1 instance
   -Do a superset db upgrade
   -Start the Superset 0.28.1 instance and navigate to Sources/Databases, and you will see the database you added previously
   -Go to Sources==>Tables, and you will not see the table added in the previous step.
   
   Mike
   
   
   
   From: Maxime Beauchemin [mailto:notifications@github.com]
   Sent: Thursday, November 08, 2018 4:29 PM
   To: apache/incubator-superset
   Cc: Prior, Mike; Author
   Subject: Re: [apache/incubator-superset] db upgrade reverts database to a previous version (#6307)
   
   
   This could be difficult to reproduce, as we have made several edits to the tables
   What kind of edits? DDL? DML? Could that be the source of the issue?
   
   tables that have been modified, go back to their previous configuration
   What does that mean? How have they been modified?
   
   Also what database engine do you use?
   
   —
   You are receiving this because you authored the thread.
   Reply to this email directly, view it on GitHub<https://github.com/apache/incubator-superset/issues/6307#issuecomment-437059525>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AqyiX1CCl_H2wtWEXv8SG4yTwnsOoq8hks5utFuzgaJpZM4YUkdP>.
   
   This e-mail, including attachments, may include confidential and/or
   proprietary information, and may be used only by the person or entity
   to which it is addressed. If the reader of this e-mail is not the intended
   recipient or his or her authorized agent, the reader is hereby notified
   that any dissemination, distribution or copying of this e-mail is
   prohibited. If you have received this e-mail in error, please notify the
   sender by replying to this message and delete this e-mail immediately.
   

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