Druid 0.13.0: Why is it not working with MySQL driver version 8.0.xx?

Hi,

we are going to use new mysql drivers in our cluster, so I also tried it with Druid (only broker and coordinator) in our test environment. The result

was a strange behaviour with lookups (global-cached, jdbc-based) and datasource rules. Thats what I found out, I did not search for

other troubles.

We are using MySQL as metadata storage. Startup seems ok, no ERRORs in log…its just not working =(

Original driver: 5.1.38

2019-02-20T15:02:56,468 INFO [main] org.apache.druid.initialization.Initialization - Loading extension [mysql-metadata-storage] for class [interface org.apache.druid.cli.CliCommandCreator]
2019-02-20T15:02:56,468 INFO [main] org.apache.druid.initialization.Initialization - added URL[file:/opt/local/druid/druid-0.13.0/extensions/mysql-metadata-storage/mysql-metadata-storage-0.13.0-incubating.jar] for extension[mysql-metadata-storage]
2019-02-20T15:02:56,468 INFO [main] org.apache.druid.initialization.Initialization - added URL[file:/opt/local/druid/druid-0.13.0/extensions/mysql-metadata-storage/mysql-connector-java-5.1.38.jar] for extension[mysql-metadata-storage]

2019-02-20T15:04:58,858 INFO [DatabaseRuleManager-Exec–0] org.apache.druid.metadata.SQLMetadataRuleManager - Polled and found rules for 2 datasource(s)
2019-02-20T15:04:59,046 INFO [DatabaseSegmentManager-Exec–0] org.apache.druid.metadata.SQLMetadataSegmentManager - Polled and found 355 segments in the database

New driver: 8.0.13

2019-02-20T14:58:49,550 INFO [main] org.apache.druid.initialization.Initialization - Loading extension [mysql-metadata-storage] for class [interface org.apache.druid.cli.CliCommandCreator]
2019-02-20T14:58:49,550 INFO [main] org.apache.druid.initialization.Initialization - added URL[file:/opt/local/druid/druid-0.13.0/extensions/mysql-metadata-storage/mysql-metadata-storage-0.13.0-incubating.jar] for extension[mysql-metadata-storage]
2019-02-20T14:58:49,550 INFO [main] org.apache.druid.initialization.Initialization - added URL[file:/opt/local/druid/druid-0.13.0/extensions/mysql-metadata-storage/mysql-connector-java-8.0.13.jar] for extension[mysql-metadata-storage]

2019-02-20T15:01:52,090 INFO [DatabaseRuleManager-Exec–0] org.apache.druid.metadata.SQLMetadataRuleManager - Polled and found rules for 0 datasource(s)
2019-02-20T15:01:52,385 INFO [DatabaseSegmentManager-Exec–0] org.apache.druid.metadata.SQLMetadataSegmentManager - Polled and found 355 segments in the database

It is inexplicable to me why the number of segments can be determined, but not the drop rules?!

Also Lookups not working…

Original driver: 5.1.38

2019-02-21T09:08:54,636 INFO [NamespaceExtractionCacheManager-1] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 26 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://…
2019-02-21T09:08:54,636 INFO [NamespaceExtractionCacheManager-0] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 123 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://…
2019-02-21T09:08:54,646 INFO [NamespaceExtractionCacheManager-0] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 26 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://…
2019-02-21T09:08:54,646 INFO [NamespaceExtractionCacheManager-1] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 12 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://…

New driver: 8.0.13

2019-02-21T09:04:33,485 INFO [NamespaceExtractionCacheManager-1] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 0 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://…
2019-02-21T09:04:33,485 INFO [NamespaceExtractionCacheManager-0] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 0 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://…
2019-02-21T09:04:33,494 INFO [NamespaceExtractionCacheManager-0] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 0 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://…
2019-02-21T09:04:33,494 INFO [NamespaceExtractionCacheManager-1] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 0 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://…

regards, Alex