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