[
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shawn Heisey updated SOLR-4788:
-------------------------------
Attachment: entitytest.patch
>From what I can tell, there have never been any tests for the
>[entityName].last_index_time properties, so I have no idea when this problem
>started happening.
I tried to create a test for this in trunk, by duplicating
TestSqlEntityProcessorDelta to a new class called
TestSqlEntityProcessorDeltaEntity, and then changing all the
dih.last_index_time values so they have the proper entity name, but the test
fails, showing twice as many database calls at it expected. Hopefully someone
can tell me what I did wrong.
Attaching entitytest.patch.
> Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time
> is empty
> --------------------------------------------------------------------------------------
>
> Key: SOLR-4788
> URL: https://issues.apache.org/jira/browse/SOLR-4788
> Project: Solr
> Issue Type: Bug
> Affects Versions: 4.2, 4.3
> Environment: solr-spec
> 4.2.1.2013.03.26.08.26.55
> solr-impl
> 4.2.1 1461071 - mark - 2013-03-26 08:26:55
> lucene-spec
> 4.2.1
> lucene-impl
> 4.2.1 1461071 - mark - 2013-03-26 08:23:34
> OR
> solr-spec
> 4.3.0
> solr-impl
> 4.3.0 1477023 - simonw - 2013-04-29 15:10:12
> lucene-spec
> 4.3.0
> lucene-impl
> 4.3.0 1477023 - simonw - 2013-04-29 14:55:14
> Reporter: chakming wong
> Assignee: Shalin Shekhar Mangar
> Attachments: entitytest.patch
>
>
> {code:title=conf/dataimport.properties|borderStyle=solid}entity1.last_index_time=2013-05-06
> 03\:02\:06
> last_index_time=2013-05-06 03\:05\:22
> entity2.last_index_time=2013-05-06 03\:03\:14
> entity3.last_index_time=2013-05-06 03\:05\:22
> {code}
> {code:title=conf/solrconfig.xml|borderStyle=solid}<?xml version="1.0"
> encoding="UTF-8" ?>
> ...
> <requestHandler name="/dataimport"
> class="org.apache.solr.handler.dataimport.DataImportHandler">
> <lst name="defaults">
> <str name="config">dihconfig.xml</str>
> </lst>
> </requestHandler>
> ...
> {code}
> {code:title=conf/dihconfig.xml|borderStyle=solid}<?xml version="1.0"
> encoding="UTF-8" ?>
> <dataConfig>
> <dataSource name="source1"
> type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://*:*/*"
> user="*" password="*"/>
> <document name="strings">
> <entity name="entity1" pk="id" dataSource="source1"
> query="SELECT * FROM table_a"
> deltaQuery="SELECT table_a_id FROM table_b WHERE
> last_modified > '${dataimporter.entity1.last_index_time}'"
> deltaImportQuery="SELECT * FROM table_a WHERE id =
> '${dataimporter.entity1.id}'"
> transformer="TemplateTransformer">
> <field> ...
> ...
> ... </field>
> </entity>
> <entity name="entity2">
> ...
> ...
> </entity>
> <entity name="entity3">
> ...
> ...
> </entity>
> </document>
> </dataConfig>
> {code}
> In above setup, *dataimporter.entity1.last_index_time* is *empty string* and
> cause the sql query having error
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
