Skip to content

Instantly share code, notes, and snippets.

@ibuildthecloud

ibuildthecloud/fix.sql

Last active March 15, 2016 03:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ibuildthecloud/2d819cc2cc1c68b1d22f to your computer and use it in GitHub Desktop.
Save ibuildthecloud/2d819cc2cc1c68b1d22f to your computer and use it in GitHub Desktop.
Download ZIP
Fix failed upgrade to v0.63.0
Raw
fix.sql
TRUNCATE `process_execution`;
ALTER TABLE `process_execution` DROP `created`;
@ibuildthecloud
Copy link
Author

If you attempted to upgrade to v0.63.0 and it failed and now you are trying to upgrade to v0.63.1 and get then following error

Migration failed for change set db/core-076.xml::dump1::wizardofmath (generated):
    Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE rancher.process_execution ADD created datetime NULL: Duplicate column name 'created'

Run the above SQL in your MySQL database. If you are running the embedded database in the rancher/server you can log into MySQL by running

docker exec -it $RANCHER_CONTAINER_ID mysql -u root cattle

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment