cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Venkata Siva Vijayendra Bhamidipati (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-1375) deploydb failing with acs master
Date Fri, 22 Feb 2013 21:14:12 GMT
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

Mime
View raw message