Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-67169

MySQL Bug cause Upgrade tasks to fail

    XMLWordPrintable

Details

    Description

      Summary

      Upgrading from Jira 7.6.X or below to 7.7 or above with a MySQL 5.7.9 - 5.7.17 version encounters failed upgrade tasks caused by MySql BUG:

      MySQL 5.7.18 and Later do not encounter this issue

      Expected Results

      MySQL 5.7 is listed as Supported Platform and should not conflict

      Actual Results

      The below exception is thrown in the logs:

      <UpgradeTaskHistory id="10300" upgradeTaskFactoryKey="host" buildNumber="77001" status="FAILED" upgradeType="SERVER" />

    <UpgradeTaskHistoryAuditLog id="10400" upgradeTaskFactoryKey="host" buildNumber="77001" status="FAILED" upgradeType="SERVER" timeperformed="2018-03-15 15:02:16.0" action="upgrade" />
    <UpgradeTaskHistoryAuditLog id="10500" upgradeTaskFactoryKey="host" buildNumber="77001" status="FAILED" upgradeType="SERVER" timeperformed="2018-03-15 15:08:19.0" action="upgrade" />
    <UpgradeTaskHistoryAuditLog id="10600" upgradeTaskFactoryKey="host" buildNumber="77001" status="FAILED" upgradeType="SERVER" timeperformed="2018-03-15 15:12:59.0" action="upgrade" />
    <UpgradeTaskHistoryAuditLog id="10700" upgradeTaskFactoryKey="host" buildNumber="77001" status="FAILED" upgradeType="SERVER" timeperformed="2018-03-15 15:19:49.0" action="upgrade" />
    <UpgradeTaskHistoryAuditLog id="10800" upgradeTaskFactoryKey="host" buildNumber="77001" status="FAILED" upgradeType="SERVER" timeperformed="2018-03-19 19:38:05.0" action="upgrade" />
    <UpgradeTaskHistoryAuditLog id="10900" upgradeTaskFactoryKey="host" buildNumber="77001" status="FAILED" upgradeType="SERVER" timeperformed="2018-03-23 20:00:24.0" action="upgrade" />
    <UpgradeTaskHistoryAuditLog id="11000" upgradeTaskFactoryKey="host" buildNumber="77001" status="FAILED" upgradeType="SERVER" timeperformed="2018-03-25 17:11:00.0" action="upgrade" />

      Workaround

      Upgrade MySQL to version 5.7.18 or later

      Suggested Follow Up:

      As this is specific to a MySQL bug there is really not a fix Jira Side so we should Update the Documentation to note the conflicting MySQL versions:

      Attachments

        Issue Links

          mentioned in

          Page Loading...

          Activity

            People

              tbartyzel Tomasz Bartyzel
              emccutcheon Earl McCutcheon
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: