Hi
CLOUDSTACK-8212 might become your help. https://issues.apache.org/jira/browse/CLOUDSTACK-8212 1. This is resolved by commenting out: --- [root@acs ~]# vi /usr/share/cloudstack-management/setup/db/schema-421to430.sql : #realhostip changes, before changing table and adding default value # UPDATE `cloud`.`configuration` SET value = CONCAT("*.",(SELECT `temptable`.`value` FROM (SELECT * FROM `cloud`.`configuration` WHERE `name`="consoleproxy.u rl.domain") AS `temptable` WHERE `temptable`.`name`="consoleproxy.url.domain")) WHERE `name`="consoleproxy.url.domain"; # UPDATE `cloud`.`configuration` SET `value` = CONCAT("*.",(SELECT `temptable`.`value` FROM (SELECT * FROM `cloud`.`configuration` WHERE `name`="secstorage.ssl.cert.domain") AS `temptable` WHERE `temptable`.`name`="secstorage.ssl.cert.domain")) WHERE `name`="secstorage.ssl.cert.domain"; --- and, 2. stop cloudsack-management & cloudsack-usage & mariadb 3. initialize database 4. cloudstack-setup-databases 5. cloudstack-setup-management I also the same problem has occurred. My environment: CloudStack 4.5.2 ( http://packages.shapeblue.com/cloudstack/upstream/centos7/4.5) CentOS 7.1.1503 mariadb-5.5.44-1 --- Satoru Nakaya Japan CloudStack User Group http://cloudstack.jp/ 2015-09-11 23:11 GMT+09:00 Keerthiraja SJ <sjkeer...@gmail.com>: > I really face this issue when I install on MariaDB. If I do the same on > MySQL this pass it. > > On Fri, Sep 11, 2015 at 7:09 PM, Keerthiraja SJ <sjkeer...@gmail.com> > wrote: > > > Hi All, > > > > Today I tried to install the CS 4.5.2 on fresh box where I could able to > > successfully deploy > > the cloudstack-setup-databases. > > > > After I tried number of times the fresh installation I could see the same > > issue been reproducing it. > > > > While stating the cloudstack servers I could see below error constantly. > > > > > > > > > > *ERROR*ERROR [c.c.u.d.ScriptRunner] (main: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] (main:null) > > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications > > link failure > > > > The last packet successfully received from the server was 25 milliseconds > > ago. The last packet sent successfully to the server was 25 milliseconds > > ago. > > ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to execute > upgrade > > script: /usr/share/cloudstack-management/setup/db/schema-421to430.sql > > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications > > link failure > > > > > > Caused by: java.net.SocketException: Broken pipe > > ... 61 more > > ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to upgrade the > > database > > com.cloud.utils.exception.CloudRuntimeException: Unable to execute > upgrade > > script: /usr/share/cloudstack-management/setup/db/schema-421to430.sql > > at > > > com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:311) > > > > ERROR [c.c.u.d.DbUtil] (main:null) RELEASE_LOCK() throws exception > > com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications > > link failure > > > > > > I did this test number of times by allocating fresh box. > > > > Thanks, > > Keerthi > > >
