[CLOUDSTACK-8212] database upgrade failed for fresh install of 4.5.0-SNAPSHOT

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.5.0
• Component/s: Management Server
• Security Level: Public (Anyone can view this level - this is the default.)
• Environment: RedHat 7, external MariaDB on custom port.
• Assignee: Unassigned
• Reporter: Andreas Stenius
• Created: 04/Feb/15 13:59
• Updated: 07/Jul/15 20:33

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