You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by "Venkata Siva Vijayendra Bhamidipati (JIRA)" <ji...@apache.org> on 2013/02/25 22:00:13 UTC
[jira] [Resolved] (CLOUDSTACK-1375) deploydb failing with acs
master
[ 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