Uploaded image for project: 'CloudStack'
  1. CloudStack
  2. CLOUDSTACK-8212

database upgrade failed for fresh install of 4.5.0-SNAPSHOT

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.5.0
    • Fix Version/s: None
    • Component/s: Management Server
    • Security Level: Public (Anyone can view this level - this is the default.)
    • Labels:
      None
    • Environment:
      RedHat 7, external MariaDB on custom port.

      Description

      During installation of a new system, when first starting the MS, it logs that the db needs upgrading from 4.0.0, but fails to do so (see attached logs).

      The culprit would seem to be due to these error messages (my guess from screening the logs...):

      ERROR [c.c.u.d.ScriptRunner] (localhost-startStop-1:null) Error executing: UPDATE `cloud`.`configuration` SET value = CONCAT("*.",(SELECT `temptable`.`value` FROM (SELECT * FROM `cloud`.`configuration` WHERE `name`="consoleproxy.url.domain") AS `temptable` WHERE `temptable`.`name`="consoleproxy.url.domain")) WHERE `name`="consoleproxy.url.domain"
      ERROR [c.c.u.d.ScriptRunner] (localhost-startStop-1:null) java.sql.SQLException: You can't specify target table 'configuration' for update in FROM clause
      ERROR [c.c.u.DatabaseUpgradeChecker] (localhost-startStop-1:null) Unable to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-421to430.sql

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              kaos Andreas Stenius
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: