Hi, The issue is already solved on 4.6 (which is the same as master now).
The two queries were replaced by this one (https://github.com/apache/cloudstack/pull/757/files): UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE `name`="consoleproxy.url.domain" OR `name`="secstorage.ssl.cert.domain”; We’re currently working on back porting that to 4.5.x as well. Not sure when 4.5.3 will come, but if you do it manually it’s the same anyway. Good luck with your go-live! Regards, Remi On 13/09/15 18:20, "Keerthiraja SJ" <sjkeer...@gmail.com> wrote: >I update the same on > >https://issues.apache.org/jira/browse/CLOUDSTACK-8836 > >Thanks, >Keerthi > >On Sun, Sep 13, 2015 at 9:44 PM, Keerthiraja SJ <sjkeer...@gmail.com> wrote: > >> Sorry pasted the wrong query. >> >> >> #realhostip changes, before changing table and adding default value >> UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE >> `name`="consoleproxy.url.domain" OR `name`="consoleproxy.url.domain"; >> UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE >> `name`="secstorage.ssl.cert.domain" OR `name`="secstorage.ssl.cert.domain"; >> >> On Sun, Sep 13, 2015 at 9:41 PM, Keerthiraja SJ <sjkeer...@gmail.com> >> wrote: >> >>> After I change the query on >>> /usr/share/cloudstack-management/setup/db/schema-421to430.sql I deploy the >>> database cleanly where I could able to proceed and started successfully. >>> >>> #realhostip changes, before changing table and adding default value >>> UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE >>> `name`="consoleproxy.url.domain" OR `name`="consoleproxy.url.domain"; >>> UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE >>> `name`="consoleproxy.url.domain" OR `name`="secstorage.ssl.cert.domain"; >>> >>> >>> Will this bee patched soon on the upcoming version of 4.5.3 and also on >>> 4.6 >>> >>> Thanks, >>> Keerthi >>> >>> >>> >>> On Sun, Sep 13, 2015 at 9:37 PM, Keerthiraja SJ <sjkeer...@gmail.com> >>> wrote: >>> >>>> I really want to know after I comment this line and do the >>>> database-setup will this effect the cloudstack once I build. >>>> >>>> I really not know what really this query use to do. >>>> >>>> Because I want to build a production environment right now so if I >>>> comment this two query and do the database initialization >>>> the cloudstack started without any issue. >>>> >>>> But will this will impact the CS after I deploy. >>>> >>>> Thanks, >>>> Keerthi >>>> >>>> On Sun, Sep 13, 2015 at 9:02 PM, Keerthiraja SJ <sjkeer...@gmail.com> >>>> wrote: >>>> >>>>> Even After I commented this line on MariaDB-server-10.0.21-1.el6.x86_64. >>>>> >>>>> >>>>> #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.url.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"; >>>>> >>>>> >>>>> Still could see error during the start up with below error on >>>>> catalina.out >>>>> >>>>> ERROR >>>>> ERROR [c.c.u.d.ScriptRunner] (main:null) Error executing: alter table >>>>> vm_template add size bigint unsigned >>>>> ERROR [c.c.u.d.ScriptRunner] (main:null) >>>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate >>>>> column >>>>> name 'size' >>>>> ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to execute >>>>> upgrade script: >>>>> /usr/share/cloudstack-management/setup/db/schema-40to410.sql >>>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate >>>>> column name 'size' >>>>> at >>>>> com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185) >>>>> >>>>> >>>>> 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-40to410.sql >>>>> >>>>> Thanks, >>>>> Keerthi >>>>> >>>>> >>>>> >>>>> On Sat, Sep 12, 2015 at 1:13 PM, Remi Bergsma < >>>>> rberg...@schubergphilis.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> The root cause was recently fixed here: >>>>>> https://github.com/apache/cloudstack/pull/757/files >>>>>> >>>>>> As a workaround you can either alter the query (as mentioned below) or >>>>>> downgrade mariadb: >>>>>> >>>>>> systemctl stop mariadb >>>>>> yum -y remove mariadb-libs >>>>>> yum -y install mariadb-1:5.5.41-2.el7_0.x86_64 >>>>>> mariadb-server-1:5.5.41-2.el7_0.x86_64 >>>>>> systemctl start mariadb >>>>>> >>>>>> Regards, Remi >>>>>> >>>>>> Sent from my iPhone >>>>>> >>>>>> On 12 Sep 2015, at 00:59, giraffeg forestg <giraffefore...@gmail.com >>>>>> <mailto:giraffefore...@gmail.com>> wrote: >>>>>> >>>>>> 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<mailto: >>>>>> 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 >>>>>> <mailto: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 >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >>
