You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Alan Baker (Created) (JIRA)" <ji...@apache.org> on 2011/11/19 02:40:52 UTC
[jira] [Created] (SOLR-2907) java.lang.IllegalArgumentException:
deltaQuery has no column to resolve to declared primary key pk='ITEM_ID,
CATEGORY_ID'
java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
-------------------------------------------------------------------------------------------------------------------------
Key: SOLR-2907
URL: https://issues.apache.org/jira/browse/SOLR-2907
Project: Solr
Issue Type: Bug
Components: Schema and Analysis
Affects Versions: 3.4
Reporter: Alan Baker
We are using solr for our site and ran into this error in our own schema and I was able to reproduce it using the dataimport example code in the solr project. We do not get this error in SOLR 1.4 only started seeing it as we are working to upgrade to 3.4.0. It fails when delta-importing linked tables.
Complete trace:
Nov 18, 2011 5:21:02 PM org.apache.solr.handler.dataimport.DataImporter doDeltaImport
SEVERE: Delta Import Failed
java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
at org.apache.solr.handler.dataimport.DocBuilder.findMatchingPkColumn(DocBuilder.java:849)
at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:900)
at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:879)
at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:285)
at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:179)
at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:390)
at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:429)
at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408)
I used this dataConfig from the wiki on the data import:
<dataConfig>
<dataSource driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:./example-DIH/hsqldb/ex" user="sa" />
<document>
<entity name="item" pk="ID"
query="select * from item"
deltaImportQuery="select * from item where ID=='${dataimporter.delta.id}'"
deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
<entity name="item_category" pk="ITEM_ID, CATEGORY_ID"
query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'"
deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified > '${dataimporter.last_index_time}'"
parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
<entity name="category" pk="ID"
query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'"
deltaQuery="select ID from category where last_modified > '${dataimporter.last_index_time}'"
parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}"/>
</entity>
</entity>
</document>
</dataConfig>
To reproduce use the data config from above and set the dataimport.properties last update times to before the last_modifed date in the example data. I my case I had to set the year to 1969. Then run a delta-import and the exception occurs. Thanks.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org
[jira] [Updated] (SOLR-2907) java.lang.IllegalArgumentException:
deltaQuery has no column to resolve to declared primary key pk='ITEM_ID,
CATEGORY_ID'
Posted by "Alan Baker (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SOLR-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alan Baker updated SOLR-2907:
-----------------------------
Component/s: contrib - DataImportHandler
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: SOLR-2907
> URL: https://issues.apache.org/jira/browse/SOLR-2907
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler, Schema and Analysis
> Affects Versions: 3.4
> Reporter: Alan Baker
>
> We are using solr for our site and ran into this error in our own schema and I was able to reproduce it using the dataimport example code in the solr project. We do not get this error in SOLR 1.4 only started seeing it as we are working to upgrade to 3.4.0. It fails when delta-importing linked tables.
> Complete trace:
> Nov 18, 2011 5:21:02 PM org.apache.solr.handler.dataimport.DataImporter doDeltaImport
> SEVERE: Delta Import Failed
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
> at org.apache.solr.handler.dataimport.DocBuilder.findMatchingPkColumn(DocBuilder.java:849)
> at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:900)
> at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:879)
> at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:285)
> at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:179)
> at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:390)
> at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:429)
> at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408)
> I used this dataConfig from the wiki on the data import:
> <dataConfig>
> <dataSource driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:./example-DIH/hsqldb/ex" user="sa" />
> <document>
> <entity name="item" pk="ID"
> query="select * from item"
> deltaImportQuery="select * from item where ID=='${dataimporter.delta.id}'"
> deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
> <entity name="item_category" pk="ITEM_ID, CATEGORY_ID"
> query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'"
> deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified > '${dataimporter.last_index_time}'"
> parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
>
> <entity name="category" pk="ID"
> query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'"
> deltaQuery="select ID from category where last_modified > '${dataimporter.last_index_time}'"
> parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}"/>
> </entity>
> </entity>
>
> </document>
> </dataConfig>
> To reproduce use the data config from above and set the dataimport.properties last update times to before the last_modifed date in the example data. I my case I had to set the year to 1969. Then run a delta-import and the exception occurs. Thanks.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org
[jira] [Commented] (SOLR-2907) java.lang.IllegalArgumentException:
deltaQuery has no column to resolve to declared primary key pk='ITEM_ID,
CATEGORY_ID'
Posted by "Adam Lane (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SOLR-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13210748#comment-13210748 ]
Adam Lane commented on SOLR-2907:
---------------------------------
FYI: Found an alternate way of doing delta here in this thread that is much faster. Please refer to this until the bug is fixed or wiki pages are changed.
https://mail-archives.apache.org/mod_mbox/lucene-solr-user/201008.mbox/%3C9F8B39CB3B7C6D4594293EA29CCF438B01702F22@ICQ-MAIL.icq.il.office.aol.com%3E
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: SOLR-2907
> URL: https://issues.apache.org/jira/browse/SOLR-2907
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler, Schema and Analysis
> Affects Versions: 3.4
> Reporter: Alan Baker
>
> We are using solr for our site and ran into this error in our own schema and I was able to reproduce it using the dataimport example code in the solr project. We do not get this error in SOLR 1.4 only started seeing it as we are working to upgrade to 3.4.0. It fails when delta-importing linked tables.
> Complete trace:
> Nov 18, 2011 5:21:02 PM org.apache.solr.handler.dataimport.DataImporter doDeltaImport
> SEVERE: Delta Import Failed
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
> at org.apache.solr.handler.dataimport.DocBuilder.findMatchingPkColumn(DocBuilder.java:849)
> at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:900)
> at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:879)
> at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:285)
> at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:179)
> at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:390)
> at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:429)
> at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408)
> I used this dataConfig from the wiki on the data import:
> <dataConfig>
> <dataSource driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:./example-DIH/hsqldb/ex" user="sa" />
> <document>
> <entity name="item" pk="ID"
> query="select * from item"
> deltaImportQuery="select * from item where ID=='${dataimporter.delta.id}'"
> deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
> <entity name="item_category" pk="ITEM_ID, CATEGORY_ID"
> query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'"
> deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified > '${dataimporter.last_index_time}'"
> parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
>
> <entity name="category" pk="ID"
> query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'"
> deltaQuery="select ID from category where last_modified > '${dataimporter.last_index_time}'"
> parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}"/>
> </entity>
> </entity>
>
> </document>
> </dataConfig>
> To reproduce use the data config from above and set the dataimport.properties last update times to before the last_modifed date in the example data. I my case I had to set the year to 1969. Then run a delta-import and the exception occurs. Thanks.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org
[jira] [Commented] (SOLR-2907) java.lang.IllegalArgumentException:
deltaQuery has no column to resolve to declared primary key pk='ITEM_ID,
CATEGORY_ID'
Posted by "Adam Lane (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SOLR-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13209845#comment-13209845 ]
Adam Lane commented on SOLR-2907:
---------------------------------
Upgraded to 3.5 and confirmed same problem.
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: SOLR-2907
> URL: https://issues.apache.org/jira/browse/SOLR-2907
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler, Schema and Analysis
> Affects Versions: 3.4
> Reporter: Alan Baker
>
> We are using solr for our site and ran into this error in our own schema and I was able to reproduce it using the dataimport example code in the solr project. We do not get this error in SOLR 1.4 only started seeing it as we are working to upgrade to 3.4.0. It fails when delta-importing linked tables.
> Complete trace:
> Nov 18, 2011 5:21:02 PM org.apache.solr.handler.dataimport.DataImporter doDeltaImport
> SEVERE: Delta Import Failed
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
> at org.apache.solr.handler.dataimport.DocBuilder.findMatchingPkColumn(DocBuilder.java:849)
> at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:900)
> at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:879)
> at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:285)
> at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:179)
> at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:390)
> at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:429)
> at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408)
> I used this dataConfig from the wiki on the data import:
> <dataConfig>
> <dataSource driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:./example-DIH/hsqldb/ex" user="sa" />
> <document>
> <entity name="item" pk="ID"
> query="select * from item"
> deltaImportQuery="select * from item where ID=='${dataimporter.delta.id}'"
> deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
> <entity name="item_category" pk="ITEM_ID, CATEGORY_ID"
> query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'"
> deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified > '${dataimporter.last_index_time}'"
> parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
>
> <entity name="category" pk="ID"
> query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'"
> deltaQuery="select ID from category where last_modified > '${dataimporter.last_index_time}'"
> parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}"/>
> </entity>
> </entity>
>
> </document>
> </dataConfig>
> To reproduce use the data config from above and set the dataimport.properties last update times to before the last_modifed date in the example data. I my case I had to set the year to 1969. Then run a delta-import and the exception occurs. Thanks.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org
[jira] [Commented] (SOLR-2907) java.lang.IllegalArgumentException:
deltaQuery has no column to resolve to declared primary key pk='ITEM_ID,
CATEGORY_ID'
Posted by "Adam Lane (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SOLR-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13153345#comment-13153345 ]
Adam Lane commented on SOLR-2907:
---------------------------------
Here is a link to the exact part of the documentation where the example is given on how to delta link tables but unfortunately doesn't work in the latest version:
https://wiki.apache.org/solr/DataImportHandler#Using_delta-import_command
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: SOLR-2907
> URL: https://issues.apache.org/jira/browse/SOLR-2907
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler, Schema and Analysis
> Affects Versions: 3.4
> Reporter: Alan Baker
>
> We are using solr for our site and ran into this error in our own schema and I was able to reproduce it using the dataimport example code in the solr project. We do not get this error in SOLR 1.4 only started seeing it as we are working to upgrade to 3.4.0. It fails when delta-importing linked tables.
> Complete trace:
> Nov 18, 2011 5:21:02 PM org.apache.solr.handler.dataimport.DataImporter doDeltaImport
> SEVERE: Delta Import Failed
> java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ITEM_ID, CATEGORY_ID'
> at org.apache.solr.handler.dataimport.DocBuilder.findMatchingPkColumn(DocBuilder.java:849)
> at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:900)
> at org.apache.solr.handler.dataimport.DocBuilder.collectDelta(DocBuilder.java:879)
> at org.apache.solr.handler.dataimport.DocBuilder.doDelta(DocBuilder.java:285)
> at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:179)
> at org.apache.solr.handler.dataimport.DataImporter.doDeltaImport(DataImporter.java:390)
> at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:429)
> at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:408)
> I used this dataConfig from the wiki on the data import:
> <dataConfig>
> <dataSource driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:./example-DIH/hsqldb/ex" user="sa" />
> <document>
> <entity name="item" pk="ID"
> query="select * from item"
> deltaImportQuery="select * from item where ID=='${dataimporter.delta.id}'"
> deltaQuery="select id from item where last_modified > '${dataimporter.last_index_time}'">
> <entity name="item_category" pk="ITEM_ID, CATEGORY_ID"
> query="select CATEGORY_ID from item_category where ITEM_ID='${item.ID}'"
> deltaQuery="select ITEM_ID, CATEGORY_ID from item_category where last_modified > '${dataimporter.last_index_time}'"
> parentDeltaQuery="select ID from item where ID=${item_category.ITEM_ID}">
>
> <entity name="category" pk="ID"
> query="select DESCRIPTION as cat from category where ID = '${item_category.CATEGORY_ID}'"
> deltaQuery="select ID from category where last_modified > '${dataimporter.last_index_time}'"
> parentDeltaQuery="select ITEM_ID, CATEGORY_ID from item_category where CATEGORY_ID=${category.ID}"/>
> </entity>
> </entity>
>
> </document>
> </dataConfig>
> To reproduce use the data config from above and set the dataimport.properties last update times to before the last_modifed date in the example data. I my case I had to set the year to 1969. Then run a delta-import and the exception occurs. Thanks.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org