cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andreas Stenius (JIRA)" <>
Subject [jira] [Created] (CLOUDSTACK-8212) database upgrade failed for fresh install of 4.5.0-SNAPSHOT
Date Wed, 04 Feb 2015 13:59:34 GMT
Andreas Stenius created CLOUDSTACK-8212:

             Summary: database upgrade failed for fresh install of 4.5.0-SNAPSHOT
                 Key: CLOUDSTACK-8212
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Management Server
    Affects Versions: 4.5.0
         Environment: RedHat 7, external MariaDB on custom port.
            Reporter: Andreas Stenius

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

This message was sent by Atlassian JIRA

View raw message