Hi keerthiaja,
In vm_template table ,have a column with the name of 'size'. Seems your db
deployment was not complete so can drop database and redeploy cloudstack....
Regards,
Prapul sriram,
Cloud Architect,
PSI Cloud Solutions,
Psiclouds.com.
On Friday, 11 September 2015 3:13 PM, Keerthiraja SJ <sjkeer...@gmail.com>
wrote:
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 63 milliseconds
ago. The last packet sent successfully to the server was 63 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
ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) Unable to upgrade the
database
On Fri, Sep 11, 2015 at 2:46 PM, Keerthiraja SJ <sjkeer...@gmail.com> wrote:
> Hi All,
>
> After successfully installation I could while starting the
> cloudstack-management ther seems to some error while connecting to my
> database.
>
> I am right now into production setup.
>
> 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
>
> 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
>
>
> The Version of the MYSQL
>
> MariaDB-server-10.1.7-1.el6.x86_64
> MariaDB-common-10.1.7-1.el6.x86_64
> MariaDB-client-10.1.7-1.el6.x86_64
>
> If this is not the right version MARIADB then what version should I have
> to install.
>
> Thanks,
> Keerthi
>
