lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jamie Jackson <jamieja...@gmail.com>
Subject Problem using user.timezone in DIH
Date Sat, 23 Sep 2017 02:07:58 GMT
Solr 6.6.0

I'm getting a weird issue and a misleading error when I try to use the
user.timezone property in a data import handler configuration which has
child entities:

Caused by: java.sql.SQLInvalidAuthorizationSpecException: Could not
connect: Access denied for user '{}'@'111.222.111.222' (using password: YES)

I was trying this in a query for a delta import:

CONVERT_TZ('${dataimporter.last_index_time}','${user.timezone}','${
custom.dataimporter.datasource.tz}')

It works great for cores with no child entities in the DIH config.

However, if I have any child entities, it dies. Here's a failing
configuration and its stack trace:
https://gist.github.com/jamiejackson/1ec544e6b87607098fbb1077a4eece30

I isolated it down to the use of user.timezone. Even if I simply add the
following in a SQL _comment_, it causes the problem. For example:

select /* ${user.timezone} */ column_a, column_b, ...

Bug?

Thanks,
Jamie

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message