Hi, while testing 4.3 (with or without devcloud) I get a error in the database creation:
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | simulator | | test | +--------------------+ 5 rows in set (0.00 sec) mysql> exit Bye sebimac:cloudstack sebgoa$ mvn -P developer -pl developer,tools/devcloud -Ddeploydb Listening for transport dt_socket at address: 53306 [INFO] Scanning for projects... [INFO] ------------------------------------------------------------------------ [INFO] Reactor Build Order: [INFO] [INFO] Apache CloudStack Developer Mode [INFO] Apache CloudStack DevCloud [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building Apache CloudStack Developer Mode 4.3.0-SNAPSHOT [INFO] ------------------------------------------------------------------------ [INFO] [INFO] --- properties-maven-plugin:1.0-alpha-2:read-project-properties (default) @ cloud-developer --- [WARNING] Ignoring missing properties file: /Users/sebgoa/Documents/gitforks/cloudstack/developer/../utils/conf/db.properties.override [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 --- log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. ========> WARNING: Provided file does not exist: /Users/sebgoa/Documents/gitforks/cloudstack/developer/../utils/conf/db.properties.override ========> WARNING: Provided file does not exist: /Users/sebgoa/Documents/gitforks/cloudstack/developer/developer-prefill.sql.override ========> 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 /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/create-schema.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/create-schema-premium.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/templates.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/cloudbridge_schema.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/cloudbridge_multipart.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/cloudbridge_index.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/cloudbridge_multipart_alter.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/cloudbridge_bucketpolicy.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/cloudbridge_policy_alter.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/cloudbridge_offering.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/target/db/cloudbridge_offering_alter.sql ========> Processing SQL file at /Users/sebgoa/Documents/gitforks/cloudstack/developer/developer-prefill.sql ========> Processing upgrade: com.cloud.upgrade.DatabaseUpgradeChecker [WARNING] java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297) at java.lang.Thread.run(Thread.java:724) Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:319) at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:414) at com.cloud.upgrade.DatabaseCreator.main(DatabaseCreator.java:229) ... 6 more Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade ram_size of service offering for secondary storage vm. at com.cloud.upgrade.dao.Upgrade421to430.upgradeMemoryOfSsvmOffering(Upgrade421to430.java:93) at com.cloud.upgrade.dao.Upgrade421to430.performDataMigration(Upgrade421to430.java:66) at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:292) ... 8 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at com.cloud.upgrade.dao.Upgrade421to430.upgradeMemoryOfSsvmOffering(Upgrade421to430.java:91) ... 10 more [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary: [INFO] [INFO] Apache CloudStack Developer Mode .................. FAILURE [1:32.571s] [INFO] Apache CloudStack DevCloud ........................ SKIPPED [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 1:34.543s [INFO] Finished at: Wed Jan 15 13:15:18 CET 2014 [INFO] Final Memory: 39M/359M [INFO] ------------------------------------------------------------------------ [ERROR] Failed to execute goal org.codehaus.mojo:exec-maven-plugin:1.2.1:java (create-schema) on project cloud-developer: An exception occured while executing the Java class. null: InvocationTargetException: Unable to upgrade the database: Unable to upgrade ram_size of service offering for secondary storage vm. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1 -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException It's a bit strange because I did not face this error yesterday, Any advice, -sebastien
