Skip to content

Instantly share code, notes, and snippets.

@ibuildthecloud

ibuildthecloud/fix.sql

Last active March 15, 2016 03:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ibuildthecloud/2d819cc2cc1c68b1d22f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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
Copy Markdown
Author

ibuildthecloud commented Mar 15, 2016

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