On 16.03.2010, at 15:42, Lukas Kahwe Smith wrote:
> Hi,
>
> I am trying to use $deleteDocById to delete rows based on an SQL query in my
> db-data-config.xml. The following tag is a top level tag in the <document>
> tag.
>
> <entity name="company_del" query="SELECT e.id AS `$deleteDocById` ROM
> deletedentity AS e"/>
thats obviously a typo from trying to simplify the example .. should be "FROM"
> However it seems like its only fetching the rows, its not actually issuing
> any index deletes.
I can see that the special case handler is triggered when looking at the
console, but no actual deletes are happening as I can verify via luke or just
trying a query
INFO: [core1] webapp=/solr path=/dataimport
params={command=full-import&clean=false} status=0 QTime=7
Mar 17, 2010 11:29:15 AM org.apache.solr.handler.dataimport.SolrWriter
readIndexerProperties
INFO: Read dataimport.properties
Mar 17, 2010 11:29:15 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Creating a connection for entity company_del with URL:
jdbc:mysql://localhost/xxx
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Time taken for getConnection(): 809
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 1
Mar 17, 2010 11:29:16 AM org.apache.solr.core.SolrDeletionPolicy onInit
INFO: SolrDeletionPolicy.onInit: commits:num=1
commit{dir=/Users/lsmith/htdocs/liip/xxx/trunk/jetty/solr/core1/data_test/index,segFN=segments_9,version=1268742459863,generation=9,filenames=[_8.nrm,
segments_9, _8.tis, _8.prx, _8.fnm, _8.tii, _8.frq, _8.fdx, _8.fdt]
Mar 17, 2010 11:29:16 AM org.apache.solr.core.SolrDeletionPolicy updateCommits
INFO: newest commit = 1268742459863
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 2
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 3
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 4
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 5
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 6
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 7
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 8
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 9
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 10
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 11
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 12
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 13
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 14
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 15
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 16
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 17
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 18
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 19
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 20
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 21
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 22
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 23
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 24
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 25
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 26
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 27
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 28
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 29
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 30
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 31
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 32
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 33
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 34
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 35
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 36
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 37
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 38
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 39
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 40
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 41
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 42
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 43
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 44
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 45
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 46
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 47
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 48
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.SolrWriter deleteDoc
INFO: Deleting document: 49
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Creating a connection for entity person_grund_del with URL:
jdbc:mysql://localhost/xxx
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Time taken for getConnection(): 14
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Creating a connection for entity person_stamm_del with URL:
jdbc:mysql://localhost/xxx
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Time taken for getConnection(): 12
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Creating a connection for entity entity with URL:
jdbc:mysql://localhost/xxx
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.JdbcDataSource$1
call
INFO: Time taken for getConnection(): 13
Mar 17, 2010 11:29:16 AM org.apache.solr.handler.dataimport.DocBuilder execute
INFO: Time taken = 0:0:1.189
http://localhost:8983/solr/core1/select?indent=on&q=2&qf=id&wt=xml&qt=auto&version=2.2&debugQuery=on&rows=10
<result name="response" numFound="1" start="0">
−
<doc>
<int name="id">2</int>
</doc>
With <uniqueKey>id</uniqueKey> in the schema.xml
regards,
Lukas Kahwe Smith
m...@pooteeweet.org
