You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/07/09 16:53:19 UTC

[GitHub] [incubator-superset] Z08JBECH opened a new issue #10272: migration failed new database model

Z08JBECH opened a new issue #10272:
URL: https://github.com/apache/incubator-superset/issues/10272


   Hello everyone.
   
   **I have an issue to migrate from 0.25 to 0.36 superset**
   
   I can run it into a new venv with new installation and without to use my postgresql database, but when i use my database, I have some errors (new columns)
   For example in the dashboard tab
   ![image](https://user-images.githubusercontent.com/46780967/87066830-7ddca200-c213-11ea-87cb-894e40699a0c.png)
   
   I can see that this new version use new column for the new features
   
   I tried "superset db upgrade" to update model database but i have some errors (see databaseèupgrade.txt file)
   
   [database upgrade.txt](https://github.com/apache/incubator-superset/files/4898168/database.upgrade.txt)
   
   Does I need to create a new database and migrate the data manually ?
   
   Thanks in advance for your answer. 
   
   
   
   
   
   
   
   


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

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


[GitHub] [incubator-superset] dpgaspar commented on issue #10272: migration failed new database model

Posted by GitBox <gi...@apache.org>.
dpgaspar commented on issue #10272:
URL: https://github.com/apache/incubator-superset/issues/10272#issuecomment-656766262


   Hi @Z08JBECH,
   
   Looking at your log:
   
   ```
   psycopg2.errors.UniqueViolation: could not create unique index "uq_table_columns_column_name"
   DETAIL:  Key (column_name, table_id)=(<new column>, 101) is duplicated.
   ```
   
   So it seems you have a duplicate column name for a table, remove the duplicate and rerun the migration
   


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

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


[GitHub] [incubator-superset] stale[bot] commented on issue #10272: migration failed new database model

Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10272:
URL: https://github.com/apache/incubator-superset/issues/10272#issuecomment-690864901


   This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
   


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

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


[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10272: migration failed new database model

Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10272:
URL: https://github.com/apache/incubator-superset/issues/10272#issuecomment-656238460


   Issue-Label Bot is automatically applying the label `#question` to this issue, with a confidence of 0.61. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback! 
   
    Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.


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

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


[GitHub] [incubator-superset] stale[bot] commented on issue #10272: migration failed new database model

Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10272:
URL: https://github.com/apache/incubator-superset/issues/10272#issuecomment-690864901






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

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


[GitHub] [incubator-superset] stale[bot] closed issue #10272: migration failed new database model

Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #10272:
URL: https://github.com/apache/incubator-superset/issues/10272


   


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

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


[GitHub] [incubator-superset] stale[bot] commented on issue #10272: migration failed new database model

Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10272:
URL: https://github.com/apache/incubator-superset/issues/10272#issuecomment-690864901






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

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