are you sure that the doc w/ the same id was not created after that?
On Mon, Nov 16, 2009 at 11:12 PM, Mark Ellul <m...@catalystic.com> wrote:
> Hi,
>
> I have added a deleted field in my database, and am using the
> Dataimporthandler to add rows to the index...
>
> I am using solr 1.4
>
> I have added my the deleted field to the query and the RegexTransformer...
> and the field definition below
>
> <field column="$deleteDocByQuery"
> regex="^true$"
> replaceWith="id:${List.id}" sourceColName="deleted"/>
>
> When I run the deltaImport command... I see the below output
>
> INFO: [] webapp=/solr path=/dataimport
> params={command=delta-import&debug=true&expungeDeletes=true} status=0
> QTime=1
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.DataImporter
> doDeltaImport
> INFO: Starting Delta Import
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.SolrWriter
> readIndexerProperties
> INFO: Read dataimport.properties
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.DocBuilder
> doDelta
> INFO: Starting delta collection.
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Running ModifiedRowKey() for Entity: List
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Creating a connection for entity List with URL:
> jdbc:postgresql://localhost:5432/tlists
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.JdbcDataSource$1
> call
> INFO: Time taken for getConnection(): 4
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed ModifiedRowKey for Entity: List rows obtained : 1
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed DeletedRowKey for Entity: List rows obtained : 0
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.DocBuilder
> collectDelta
> INFO: Completed parentDeltaQuery for Entity: List
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.SolrWriter
> deleteByQuery
> INFO: Deleting documents from Solr with query: id:api__list__365522
> Nov 16, 2009 5:29:10 PM org.apache.solr.core.SolrDeletionPolicy onInit
> INFO: SolrDeletionPolicy.onInit: commits:num=1
> commit{dir=/mnt/solr-index/index,segFN=segments_r,version=1257863009839,generation=27,filenames=[_bg.fdt,
> _bg.tii, segments_r, _bg.fnm, _bg.nrm, _bg.fdx, _bg.prx, _bg.tis, _bg.frq]
> Nov 16, 2009 5:29:10 PM org.apache.solr.core.SolrDeletionPolicy
> updateCommits
> INFO: newest commit = 1257863009839
> Nov 16, 2009 5:29:10 PM org.apache.solr.handler.dataimport.DocBuilder
> doDelta
> INFO: Delta Import completed successfully
>
> It says its deleting the document... but when I do the search its still
> showing up....
>
> Any Ideas?
>
> Regards
>
> Mark
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
