MySQLSyntaxErrorException: You have an error in your SQL syntax;

[David Montgomery]

Hi,

Druid will not work with the latest version.  Below is what I get when I start a master node.  So....how do I resolve?

/usr/bin/java -Duser.timezone=UTC -Dfile.encoding=UTF-8 -cp master/:/home/ubuntu/druid-services-0.5.50/config/master:runtime.properties:/home/ubuntu/druid-services-0.5.50/lib/druid-services-0.5.50-selfcontained.jar com.metamx.druid.http.MasterMain



2013-09-06 09:20:45,897 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning value [root] for [druid.database.user] on [com.metamx.druid.db.DbConnectorConfig#getDatabaseUser()]
2013-09-06 09:20:45,897 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning value [Druid312#] for [druid.database.password] on [com.metamx.druid.db.DbConnectorConfig#getDatabasePassword()]
2013-09-06 09:20:45,898 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning value [prod_segments] for [druid.database.segmentTable] on [com.metamx.druid.db.DbConnectorConfig#getSegmentTable()]
2013-09-06 09:20:45,898 INFO [main] org.skife.config.ConfigurationObjectFactory - Using method itself for [druid.database.validation] on [com.metamx.druid.db.DbConnectorConfig#useValidationQuery()]
2013-09-06 09:20:45,898 INFO [main] org.skife.config.ConfigurationObjectFactory - Using method itself for [druid.database.validationQuery] on [com.metamx.druid.db.DbConnectorConfig#getValidationQuery()]
2013-09-06 09:20:45,923 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning value [] for [druid.database.ruleTable] on [com.metamx.druid.db.DatabaseRuleManagerConfig#getRuleTable()]
2013-09-06 09:20:45,923 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning default value [_default] for [druid.database.defaultDatasource] on [com.metamx.druid.db.DatabaseRuleManagerConfig#getDefaultDatasource()]
2013-09-06 09:20:45,923 INFO [main] org.skife.config.ConfigurationObjectFactory - Assigning default value [PT1M] for [druid.database.rules.poll.duration] on [com.metamx.druid.db.DatabaseRuleManagerConfig#getRulesPollDuration()]
2013-09-06 09:20:46,504 INFO [main] com.metamx.druid.db.DbConnector - Creating table[prod_segments]
2013-09-06 09:20:46,573 INFO [main] com.metamx.druid.db.DbConnector - Table[] existed: [[{tables_in_dry ()=prod_segments}]]
Exception in thread "main" org.skife.jdbi.v2.exceptions.CallbackFailedException: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: 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 'where datasource='_default'' at line 1 [statement:"SELECT id from  where datasource='_default';", located:"SELECT id from  where datasource='_default';", rewritten:"SELECT id from  where datasource='_default';", arguments:{ positional:{}, named:{}, finder:[]}]
    at org.skife.jdbi.v2.DBI.withHandle(DBI.java:262)
    at com.metamx.druid.db.DatabaseRuleManager.createDefaultRule(DatabaseRuleManager.java:65)
    at com.metamx.druid.http.MasterMain.main(MasterMain.java:175)
Caused by: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: 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 'where datasource='_default'' at line 1 [statement:"SELECT id from  where datasource='_default';", located:"SELECT id from  where datasource='_default';", rewritten:"SELECT id from  where datasource='_default';", arguments:{ positional:{}, named:{}, finder:[]}]
    at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1306)
    at org.skife.jdbi.v2.Query.fold(Query.java:172)
    at org.skife.jdbi.v2.Query.list(Query.java:84)
    at org.skife.jdbi.v2.Query.list(Query.java:78)
    at org.skife.jdbi.v2.BasicHandle.select(BasicHandle.java:364)
    at com.metamx.druid.db.DatabaseRuleManager$1.withHandle(DatabaseRuleManager.java:71)
    at com.metamx.druid.db.DatabaseRuleManager$1.withHandle(DatabaseRuleManager.java:67)
    at org.skife.jdbi.v2.DBI.withHandle(DBI.java:259)
    ... 2 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 'where datasource='_default'' 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:532)
    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:1052)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
    at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1300)
    ... 9 more

[David Montgomery]

Sorry..my bad....my ruleTable was null.  Resolved