You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Keerthiraja SJ <sj...@gmail.com> on 2015/09/11 11:16:44 UTC
Cloudstack 4.5.2 startup ERROR
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
Re: Cloudstack 4.5.2 startup ERROR
Posted by Remi Bergsma <RB...@schubergphilis.com>.
Hi,
Same issue as someone in another thread had. I'll copy/paste it here:
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 the PR does) 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 11 Sep 2015, at 12:23, Keerthiraja SJ <sj...@gmail.com>> wrote:
During the fresh implementation I could see below error in catalina.out
Error
INFO [c.c.u.DatabaseUpgradeChecker] (main:null) Database upgrade must be
performed from 4.0.0 to 4.5.2
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'
Kindly help me out right now I am doing production installation.
On Fri, Sep 11, 2015 at 3:34 PM, Keerthiraja SJ <sj...@gmail.com>> wrote:
ariaDB [cloud]> select * from vm_template;
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
| id | unique_name | name |
uuid | public | featured | type | hvm |
bits |
url
| format | created | removed | account_id |
checksum | display_text |
enable_password | enable_sshkey | guest_os_id | bootable | prepopulate |
cross_zones | extractable | hypervisor_type | source_template_id |
template_tag | sort_key | size | state | update_count | updated |
dynamically_scalable |
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
| 1 | routing-1 | SystemVM Template (XenServer) |
cf459945-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-xen.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
74b92f031cc5c2089ee89efb81344dcf | SystemVM Template (XenServer)
| 0 | 0 | 184 | 1 | 0
| 1 | 0 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 2 | centos53-x86_64 | CentOS 5.3(64-bit) no GUI (XenServer) |
cf45be09-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 |
http://download.cloud.com/templates/builtin/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2
| VHD | 2015-09-11 02:38:08 | 2015-09-11 02:38:08 | 1 |
b63d854a9560c013142567bbae8d98cf | CentOS 5.3(64-bit) no GUI (XenServer)
| 0 | 0 | 12 | 1 | 0
| 1 | 1 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 3 | routing-3 | SystemVM Template (KVM) |
cf45d927-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-kvm.qcow2.bz2
| QCOW2 | 2015-09-11 02:38:08 | NULL | 1 |
85a1bed07bf43cbf022451cb2ecae4ff | SystemVM Template (KVM)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | KVM | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 4 | centos55-x86_64 | CentOS 5.5(64-bit) no GUI (KVM) |
cf45eb74-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 |
http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2
| QCOW2 | 2015-09-11 02:38:08 | NULL | 1 |
ed0e788280ff2912ea40f7f91ca7a249 | CentOS 5.5(64-bit) no GUI (KVM)
| 0 | 0 | 112 | 1 | 0
| 1 | 1 | KVM | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 5 | centos56-x86_64-xen | CentOS 5.6(64-bit) no GUI (XenServer) |
cf45fae4-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 |
http://download.cloud.com/templates/builtin/centos56-x86_64.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
905cec879afd9c9d22ecc8036131a180 | CentOS 5.6(64-bit) no GUI (XenServer)
| 0 | 0 | 142 | 1 | 0
| 1 | 1 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 1 |
| 6 | centos64-x64 | CentOS 6.4(64-bit) GUI (Hyperv) |
cf46438e-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 | http://download.cloud.com/releases/4.3/centos6_4_64bit.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
eef6b9940ea3ed01221d963d4a012d0a | CentOS 6.4 (64-bit) GUI (Hyperv)
| 0 | 0 | 182 | 1 | 0
| 1 | 1 | Hyperv | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 7 | centos53-x64 | CentOS 5.3(64-bit) no GUI (vSphere) |
cf460fcc-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 | http://download.cloud.com/releases/2.2.0/CentOS5.3-x86_64.ova
| OVA | 2015-09-11 02:38:08 | NULL | 1 |
f6f881b7f2292948d8494db837fe0f47 | CentOS 5.3(64-bit) no GUI (vSphere)
| 0 | 0 | 12 | 1 | 0
| 1 | 1 | VMware | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 8 | routing-8 | SystemVM Template (vSphere) |
cf461e57-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-vmware.ova
| OVA | 2015-09-11 02:38:08 | NULL | 1 |
ef593a061f3b7594ab0bfd9b0ed0a0d4 | SystemVM Template (vSphere)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | VMware | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 1 |
| 9 | routing-9 | SystemVM Template (HyperV) |
cf4634f1-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2013-12-23-hyperv.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
5df45ee6ebe1b703a8805f4e1f4d0818 | SystemVM Template (HyperV)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | Hyperv | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 10 | routing-10 | SystemVM Template (LXC) |
23c9be31-5869-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2
| QCOW2 | 2015-09-11 02:40:29 | NULL | 1 |
2755de1f9ef2ce4d6f2bee2efbb4da92 | SystemVM Template (LXC)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | LXC | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
10 rows in set (0.00 sec)
On Fri, Sep 11, 2015 at 3:27 PM, prapul cool <
prapul_cool2000@yahoo.com.invalid<ma...@yahoo.com.invalid>> wrote:
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<http://Psiclouds.com>.
On Friday, 11 September 2015 3:13 PM, Keerthiraja SJ <
sjkeerthi@gmail.com<ma...@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 <sj...@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
Re: Cloudstack 4.5.2 startup ERROR
Posted by Keerthiraja SJ <sj...@gmail.com>.
During the fresh implementation I could see below error in catalina.out
Error
INFO [c.c.u.DatabaseUpgradeChecker] (main:null) Database upgrade must be
performed from 4.0.0 to 4.5.2
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'
Kindly help me out right now I am doing production installation.
On Fri, Sep 11, 2015 at 3:34 PM, Keerthiraja SJ <sj...@gmail.com> wrote:
> ariaDB [cloud]> select * from vm_template;
>
> +----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
> | id | unique_name | name |
> uuid | public | featured | type | hvm |
> bits |
> url
> | format | created | removed | account_id |
> checksum | display_text |
> enable_password | enable_sshkey | guest_os_id | bootable | prepopulate |
> cross_zones | extractable | hypervisor_type | source_template_id |
> template_tag | sort_key | size | state | update_count | updated |
> dynamically_scalable |
>
> +----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
> | 1 | routing-1 | SystemVM Template (XenServer) |
> cf459945-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
> | 64 |
> http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-xen.vhd.bz2
> | VHD | 2015-09-11 02:38:08 | NULL | 1 |
> 74b92f031cc5c2089ee89efb81344dcf | SystemVM Template (XenServer)
> | 0 | 0 | 184 | 1 | 0
> | 1 | 0 | XenServer | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 0 |
> | 2 | centos53-x86_64 | CentOS 5.3(64-bit) no GUI (XenServer) |
> cf45be09-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
> | 64 |
> http://download.cloud.com/templates/builtin/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2
> | VHD | 2015-09-11 02:38:08 | 2015-09-11 02:38:08 | 1 |
> b63d854a9560c013142567bbae8d98cf | CentOS 5.3(64-bit) no GUI (XenServer)
> | 0 | 0 | 12 | 1 | 0
> | 1 | 1 | XenServer | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 0 |
> | 3 | routing-3 | SystemVM Template (KVM) |
> cf45d927-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
> | 64 |
> http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-kvm.qcow2.bz2
> | QCOW2 | 2015-09-11 02:38:08 | NULL | 1 |
> 85a1bed07bf43cbf022451cb2ecae4ff | SystemVM Template (KVM)
> | 0 | 0 | 15 | 1 | 0
> | 1 | 0 | KVM | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 0 |
> | 4 | centos55-x86_64 | CentOS 5.5(64-bit) no GUI (KVM) |
> cf45eb74-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
> | 64 |
> http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2
> | QCOW2 | 2015-09-11 02:38:08 | NULL | 1 |
> ed0e788280ff2912ea40f7f91ca7a249 | CentOS 5.5(64-bit) no GUI (KVM)
> | 0 | 0 | 112 | 1 | 0
> | 1 | 1 | KVM | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 0 |
> | 5 | centos56-x86_64-xen | CentOS 5.6(64-bit) no GUI (XenServer) |
> cf45fae4-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
> | 64 |
> http://download.cloud.com/templates/builtin/centos56-x86_64.vhd.bz2
> | VHD | 2015-09-11 02:38:08 | NULL | 1 |
> 905cec879afd9c9d22ecc8036131a180 | CentOS 5.6(64-bit) no GUI (XenServer)
> | 0 | 0 | 142 | 1 | 0
> | 1 | 1 | XenServer | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 1 |
> | 6 | centos64-x64 | CentOS 6.4(64-bit) GUI (Hyperv) |
> cf46438e-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
> | 64 | http://download.cloud.com/releases/4.3/centos6_4_64bit.vhd.bz2
> | VHD | 2015-09-11 02:38:08 | NULL | 1 |
> eef6b9940ea3ed01221d963d4a012d0a | CentOS 6.4 (64-bit) GUI (Hyperv)
> | 0 | 0 | 182 | 1 | 0
> | 1 | 1 | Hyperv | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 0 |
> | 7 | centos53-x64 | CentOS 5.3(64-bit) no GUI (vSphere) |
> cf460fcc-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
> | 64 | http://download.cloud.com/releases/2.2.0/CentOS5.3-x86_64.ova
> | OVA | 2015-09-11 02:38:08 | NULL | 1 |
> f6f881b7f2292948d8494db837fe0f47 | CentOS 5.3(64-bit) no GUI (vSphere)
> | 0 | 0 | 12 | 1 | 0
> | 1 | 1 | VMware | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 0 |
> | 8 | routing-8 | SystemVM Template (vSphere) |
> cf461e57-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
> | 64 |
> http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-vmware.ova
> | OVA | 2015-09-11 02:38:08 | NULL | 1 |
> ef593a061f3b7594ab0bfd9b0ed0a0d4 | SystemVM Template (vSphere)
> | 0 | 0 | 15 | 1 | 0
> | 1 | 0 | VMware | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 1 |
> | 9 | routing-9 | SystemVM Template (HyperV) |
> cf4634f1-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
> | 64 |
> http://download.cloud.com/templates/4.3/systemvm64template-2013-12-23-hyperv.vhd.bz2
> | VHD | 2015-09-11 02:38:08 | NULL | 1 |
> 5df45ee6ebe1b703a8805f4e1f4d0818 | SystemVM Template (HyperV)
> | 0 | 0 | 15 | 1 | 0
> | 1 | 0 | Hyperv | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 0 |
> | 10 | routing-10 | SystemVM Template (LXC) |
> 23c9be31-5869-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
> | 64 |
> http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2
> | QCOW2 | 2015-09-11 02:40:29 | NULL | 1 |
> 2755de1f9ef2ce4d6f2bee2efbb4da92 | SystemVM Template (LXC)
> | 0 | 0 | 15 | 1 | 0
> | 1 | 0 | LXC | NULL |
> NULL | 0 | NULL | Allocated | 0 | NULL
> | 0 |
>
> +----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
> 10 rows in set (0.00 sec)
>
>
> On Fri, Sep 11, 2015 at 3:27 PM, prapul cool <
> prapul_cool2000@yahoo.com.invalid> wrote:
>
>> 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 <
>> sjkeerthi@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 <sj...@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
>> >
>>
>>
>>
>
>
>
Re: Cloudstack 4.5.2 startup ERROR
Posted by Keerthiraja SJ <sj...@gmail.com>.
ariaDB [cloud]> select * from vm_template;
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
| id | unique_name | name |
uuid | public | featured | type | hvm |
bits |
url
| format | created | removed | account_id |
checksum | display_text |
enable_password | enable_sshkey | guest_os_id | bootable | prepopulate |
cross_zones | extractable | hypervisor_type | source_template_id |
template_tag | sort_key | size | state | update_count | updated |
dynamically_scalable |
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
| 1 | routing-1 | SystemVM Template (XenServer) |
cf459945-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-xen.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
74b92f031cc5c2089ee89efb81344dcf | SystemVM Template (XenServer)
| 0 | 0 | 184 | 1 | 0
| 1 | 0 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 2 | centos53-x86_64 | CentOS 5.3(64-bit) no GUI (XenServer) |
cf45be09-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 |
http://download.cloud.com/templates/builtin/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2
| VHD | 2015-09-11 02:38:08 | 2015-09-11 02:38:08 | 1 |
b63d854a9560c013142567bbae8d98cf | CentOS 5.3(64-bit) no GUI (XenServer)
| 0 | 0 | 12 | 1 | 0
| 1 | 1 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 3 | routing-3 | SystemVM Template (KVM) |
cf45d927-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-kvm.qcow2.bz2
| QCOW2 | 2015-09-11 02:38:08 | NULL | 1 |
85a1bed07bf43cbf022451cb2ecae4ff | SystemVM Template (KVM)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | KVM | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 4 | centos55-x86_64 | CentOS 5.5(64-bit) no GUI (KVM) |
cf45eb74-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 |
http://download.cloud.com/releases/2.2.0/eec2209b-9875-3c8d-92be-c001bd8a0faf.qcow2.bz2
| QCOW2 | 2015-09-11 02:38:08 | NULL | 1 |
ed0e788280ff2912ea40f7f91ca7a249 | CentOS 5.5(64-bit) no GUI (KVM)
| 0 | 0 | 112 | 1 | 0
| 1 | 1 | KVM | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 5 | centos56-x86_64-xen | CentOS 5.6(64-bit) no GUI (XenServer) |
cf45fae4-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 | http://download.cloud.com/templates/builtin/centos56-x86_64.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
905cec879afd9c9d22ecc8036131a180 | CentOS 5.6(64-bit) no GUI (XenServer)
| 0 | 0 | 142 | 1 | 0
| 1 | 1 | XenServer | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 1 |
| 6 | centos64-x64 | CentOS 6.4(64-bit) GUI (Hyperv) |
cf46438e-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 | http://download.cloud.com/releases/4.3/centos6_4_64bit.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
eef6b9940ea3ed01221d963d4a012d0a | CentOS 6.4 (64-bit) GUI (Hyperv)
| 0 | 0 | 182 | 1 | 0
| 1 | 1 | Hyperv | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 7 | centos53-x64 | CentOS 5.3(64-bit) no GUI (vSphere) |
cf460fcc-5868-11e5-9d7e-1458d04cf748 | 1 | 1 | BUILTIN | 0
| 64 | http://download.cloud.com/releases/2.2.0/CentOS5.3-x86_64.ova
| OVA | 2015-09-11 02:38:08 | NULL | 1 |
f6f881b7f2292948d8494db837fe0f47 | CentOS 5.3(64-bit) no GUI (vSphere)
| 0 | 0 | 12 | 1 | 0
| 1 | 1 | VMware | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 8 | routing-8 | SystemVM Template (vSphere) |
cf461e57-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-vmware.ova
| OVA | 2015-09-11 02:38:08 | NULL | 1 |
ef593a061f3b7594ab0bfd9b0ed0a0d4 | SystemVM Template (vSphere)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | VMware | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 1 |
| 9 | routing-9 | SystemVM Template (HyperV) |
cf4634f1-5868-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/4.3/systemvm64template-2013-12-23-hyperv.vhd.bz2
| VHD | 2015-09-11 02:38:08 | NULL | 1 |
5df45ee6ebe1b703a8805f4e1f4d0818 | SystemVM Template (HyperV)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | Hyperv | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
| 10 | routing-10 | SystemVM Template (LXC) |
23c9be31-5869-11e5-9d7e-1458d04cf748 | 0 | 0 | SYSTEM | 0
| 64 |
http://download.cloud.com/templates/acton/acton-systemvm-02062012.qcow2.bz2
| QCOW2 | 2015-09-11 02:40:29 | NULL | 1 |
2755de1f9ef2ce4d6f2bee2efbb4da92 | SystemVM Template (LXC)
| 0 | 0 | 15 | 1 | 0
| 1 | 0 | LXC | NULL |
NULL | 0 | NULL | Allocated | 0 | NULL
| 0 |
+----+---------------------+---------------------------------------+--------------------------------------+--------+----------+---------+-----+------+--------------------------------------------------------------------------------------------+--------+---------------------+---------------------+------------+----------------------------------+---------------------------------------+-----------------+---------------+-------------+----------+-------------+-------------+-------------+-----------------+--------------------+--------------+----------+------+-----------+--------------+---------+----------------------+
10 rows in set (0.00 sec)
On Fri, Sep 11, 2015 at 3:27 PM, prapul cool <
prapul_cool2000@yahoo.com.invalid> wrote:
> 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 <
> sjkeerthi@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 <sj...@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
> >
>
>
>
Re: Cloudstack 4.5.2 startup ERROR
Posted by prapul cool <pr...@yahoo.com.INVALID>.
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 <sj...@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 <sj...@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
>
Re: Cloudstack 4.5.2 startup ERROR
Posted by Keerthiraja SJ <sj...@gmail.com>.
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 <sj...@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
>