Re: SQL and $deleteDocById

2010-03-17 Thread Lukas Kahwe Smith 

On 17.03.2010, at 11:36, Lukas Kahwe Smith wrote:

> 
> 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  
>> tag.
>> 
>>   


I have managed to get things working with a different approach now:



regards,
Lukas Kahwe Smith
m...@pooteeweet.org

Re: SQL and $deleteDocById

2010-03-17 Thread Lukas Kahwe Smith 

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  
> tag.
> 
>

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.dataimpor

SQL and $deleteDocById

2010-03-16 Thread Lukas Kahwe Smith 
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  tag.



However it seems like its only fetching the rows, its not actually issuing any 
index deletes.

regards,
Lukas Kahwe Smith
m...@pooteeweet.org