[
https://issues.apache.org/jira/browse/CLOUDSTACK-8212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617337#comment-14617337
]
Tom Wood commented on CLOUDSTACK-8212:
--------------------------------------
I was able to reproduce this problem using CentOS 7 and CloudStack 4.5.1 using
the following databases all on one VM:
MariaDB 5.5.44 (pulled from MariaDB repo)
MariaDB 10.0.20 (pulled from MariaDB repo)
I was able to resolve this problem using the recommendation above. Or at least
everything seemed to work. Not sure if commenting out those two lines is a
"fix".
Also when I used the default CentOS repo for the database "MariaDB 5.5.41"
would installed instead of the latest from MariaDB which worked fine with no
problems. This may be why some people are running into the problem and some
people are not.
> database upgrade failed for fresh install of 4.5.0-SNAPSHOT
> -----------------------------------------------------------
>
> Key: CLOUDSTACK-8212
> URL: https://issues.apache.org/jira/browse/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
> Attachments: cloudstack-4.5.0-SNAPSHOT-logs.tar.gz
>
>
> 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
(v6.3.4#6332)
