Venkata Siva Vijayendra Bhamidipati created CLOUDSTACK-1375:
---------------------------------------------------------------
Summary: deploydb failing with acs master
Key: CLOUDSTACK-1375
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1375
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Management Server
Affects Versions: 4.1.0
Reporter: Venkata Siva Vijayendra Bhamidipati
Assignee: Venkata Siva Vijayendra Bhamidipati
Fix For: 4.1.0
Deploying a db is failing on the master:
[root@RichActon3-CC2 incubator-cloudstack]# mvn -e -P developer -pl developer
-Ddeploydb
Listening for transport dt_socket at address: 8787
[INFO] Error stacktraces are turned on.
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building Apache CloudStack Developer Tools 4.2.0-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- properties-maven-plugin:1.0-alpha-2:read-project-properties
(default) @ cloud-developer ---
[INFO]
[INFO] --- maven-remote-resources-plugin:1.3:process (default) @
cloud-developer ---
[INFO]
[INFO] --- maven-antrun-plugin:1.7:run (default) @ cloud-developer ---
[INFO] Executing tasks
main:
[INFO] Executed tasks
[INFO]
[INFO] >>> exec-maven-plugin:1.2.1:java (create-schema) @ cloud-developer >>>
[INFO]
[INFO] <<< exec-maven-plugin:1.2.1:java (create-schema) @ cloud-developer <<<
[INFO]
[INFO] --- exec-maven-plugin:1.2.1:java (create-schema) @ cloud-developer ---
2013-02-22 13:03:08,884 DEBUG [utils.crypt.EncryptionSecretKeyChecker]
(com.cloud.upgrade.DatabaseCreator.main():) Encryption Type: null
========> Initializing database=cloud with host=localhost port=3306
username=cloud password=cloud
============> Running query: drop database if exists `cloud`
============> Running query: create database `cloud`
============> Running query: GRANT ALL ON cloud.* to 'cloud'@`localhost`
identified by 'cloud'
============> Running query: GRANT ALL ON cloud.* to 'cloud'@`%` identified by
'cloud'
========> Initializing database=cloud_usage with host=localhost port=3306
username=cloud password=cloud
============> Running query: drop database if exists `cloud_usage`
============> Running query: create database `cloud_usage`
============> Running query: GRANT ALL ON cloud_usage.* to 'cloud'@`localhost`
identified by 'cloud'
============> Running query: GRANT ALL ON cloud_usage.* to 'cloud'@`%`
identified by 'cloud'
========> Initializing database=cloudbridge with host=localhost port=3306
username=cloud password=cloud
============> Running query: drop database if exists `cloudbridge`
============> Running query: create database `cloudbridge`
============> Running query: GRANT ALL ON cloudbridge.* to 'cloud'@`localhost`
identified by 'cloud'
============> Running query: GRANT ALL ON cloudbridge.* to 'cloud'@`%`
identified by 'cloud'
========> Processing SQL file at
/root/vijay/mywork/cloudstack/asf/asf-ws/incubator-cloudstack/developer/target/db/create-schema.sql
========> Processing SQL file at
/root/vijay/mywork/cloudstack/asf/asf-ws/incubator-cloudstack/developer/target/db/create-schema-premium.sql
========> Processing SQL file at
/root/vijay/mywork/cloudstack/asf/asf-ws/incubator-cloudstack/developer/target/db/templates.sql
2013-02-22 13:03:17,340 ERROR [utils.db.ScriptRunner]
(com.cloud.upgrade.DatabaseCreator.main():) Error executing: INSERT INTO
`cloud`.`vm_template` (id, uuid, unique_name, name, public, created, removed,
type, hvm, bits, account_id, url, checksum, enable_password, display_text,
format, guest_os_id, featured, cross_zones, hypervisor_type, extractable)
VALUES (2, UUID(), 'centos53-x86_64', 'CentOS 5.3(64-bit) no GUI (XenServer)',
1, now(), now(), 'BUILTIN', 0, 64, 1,
'http://download.cloud.com/templates/builtin/f59f18fb-ae94-4f97-afd2-f84755767aca.vhd.bz2',
'b63d854a9560c013142567bbae8d98cf', 0, 'CentOS 5.3(64-bit) no GUI
(XenServer)', 'VHD', 12, 1, 1, 'XenServer', 1, 1)
2013-02-22 13:03:17,341 ERROR [utils.db.ScriptRunner]
(com.cloud.upgrade.DatabaseCreator.main():) java.sql.SQLException: Column count
doesn't match value count at row 1
Unable to execute
/root/vijay/mywork/cloudstack/asf/asf-ws/incubator-cloudstack/developer/target/db/templates.sql:
Column count doesn't match value count at row 1
[root@RichActon3-CC2 incubator-cloudstack]#
Cause:
The "extractable" flag value is being specified twice in some of the sql insert
statements in setup/db/templates.sql.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
