[GitHub] [druid] igorvpcleao commented on issue #11868: Druid jdbc lookups: why poll period isn't working?

[GitBox <gi...@apache.org>]

igorvpcleao commented on issue #11868:
URL: https://github.com/apache/druid/issues/11868#issuecomment-960424966


   Hey @EgorEna,
   First things first, I'm just someone with moderate knowledge trying to help, not a Druid expert here.
   
   By focusing on your first spec, do you see something like this when you look at your historical node logs?
   ```
   2021-11-03T20:37:49,917 INFO [NamespaceExtractionCacheManager-1] org.apache.druid.server.lookup.namespace.JdbcCacheGenerator - Finished loading 2990136 values for namespace [JdbcExtractionNamespace{connectorConfig=DbConnectorConfig{createTables=false, connectURI='jdbc:mysql://REDACTED:3306/something?user='REDACTED', passwordProvider=org.apache.druid.metadata.DefaultPasswordProvider, dbcpProperties=null}, table='REDACTED', keyColumn='id', valueColumn='type', tsColumn='updated_at', filter='null', pollPeriod=P1D}] : org.apache.druid.server.lookup.namespace.cache.CacheScheduler$EntryImpl@22e17b56
   ```
   
   1. I'd like to make sure that you're able to see a **Finished loading x values** message recently (or at least see an exception while loading it). 
   2. Also, does `"injective": true` really applies to you? It should only be used when both keys and values are unique.
   3. Finally, by not updating you mean changing existing values, or not deleting entries that were previously deleted from your database?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org