OpenMRS Core
  1. OpenMRS Core
  2. TRUNK-3909

Liquibase fails to change column with foreign key in MySQL 5.6

    Details

    • Complexity:
      Medium

      Description

      Tried to install a clean installation on a new database using the advanced installation option. I'm installing in MySQL 5.6.10.1 on Windows 7 x64. The installation works fine with MySQL 5.5

      Attached is the error stacktrace

        Gliffy Diagrams

        1. stacktrace.txt
          4 kB
          Saptarshi Purkayastha

          Issue Links

            Activity

            Hide
            Wyclif Luyima added a comment -

            Daniel Kayiwa, Rafal Korytkowski, [~djazayeri] i think there is a problem with the fix to this ticket , i see that it removes a column with id 1-fix which exists in a released openmrs 1.9.7, i think we need to add back that changeset and possibly just add a new one to reverse what it does instead.

            Show
            Wyclif Luyima added a comment - Daniel Kayiwa , Rafal Korytkowski , [~djazayeri] i think there is a problem with the fix to this ticket , i see that it removes a column with id 1-fix which exists in a released openmrs 1.9.7, i think we need to add back that changeset and possibly just add a new one to reverse what it does instead.
            Hide
            Wyclif Luyima added a comment - - edited

            And for changesets with ids 3-increase-privilege-col-size-person_attribute_type and 20121016-1504, i see no point in why we add valid check sums if they are in unreleased versions, seeing checksums, gives an immediate illusion that it is already in production.

            Show
            Wyclif Luyima added a comment - - edited And for changesets with ids 3-increase-privilege-col-size-person_attribute_type and 20121016-1504, i see no point in why we add valid check sums if they are in unreleased versions, seeing checksums, gives an immediate illusion that it is already in production.
            Hide
            Kaweesi Joseph added a comment -

            Was this back-ported to 1.10/ released in 1.10 Wyclif Luyima?

            Show
            Kaweesi Joseph added a comment - Was this back-ported to 1.10/ released in 1.10 Wyclif Luyima ?
            Hide
            Daniel Kayiwa added a comment -
            Show
            Daniel Kayiwa added a comment - This was merged into 1.10. You can see the changes in here: https://github.com/openmrs/openmrs-core/blob/1.10.x/api/src/main/resources/liquibase-update-to-latest.xml
            Hide
            Kaweesi Joseph added a comment -

            thanks Daniel Kayiwa for that information, i have excluded it from the list of our tickets for 1.11 release

            Show
            Kaweesi Joseph added a comment - thanks Daniel Kayiwa for that information, i have excluded it from the list of our tickets for 1.11 release

              People

              • Assignee:
                Saptarshi Purkayastha
                Reporter:
                Saptarshi Purkayastha
              • Votes:
                0 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 day
                  1d
                  Remaining:
                  Remaining Estimate - 1 day
                  1d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                    Development