[
https://issues.apache.org/jira/browse/CLOUDSTACK-1375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venkata Siva Vijayendra Bhamidipati resolved CLOUDSTACK-1375.
-------------------------------------------------------------
Resolution: Fixed
Resolved in commit # 8761a1d0dbddfdfb68238bf4fccc74e91fe03bd7 on master.
> 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: Hugo Trippaers
> 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
