Return-Path: Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: (qmail 96428 invoked from network); 4 Dec 2009 04:51:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 4 Dec 2009 04:51:40 -0000 Received: (qmail 40865 invoked by uid 500); 4 Dec 2009 04:51:38 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 40768 invoked by uid 500); 4 Dec 2009 04:51:35 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 40758 invoked by uid 99); 4 Dec 2009 04:51:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 04 Dec 2009 04:51:35 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of noble.paul@gmail.com designates 209.85.160.46 as permitted sender) Received: from [209.85.160.46] (HELO mail-pw0-f46.google.com) (209.85.160.46) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 04 Dec 2009 04:51:28 +0000 Received: by pwj17 with SMTP id 17so2016622pwj.5 for ; Thu, 03 Dec 2009 20:51:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:reply-to:received :in-reply-to:references:from:date:x-google-sender-auth:message-id :subject:to:content-type:content-transfer-encoding; bh=f0PzFe2+8xkN9PjyzXqL+Ixq6Tsdde8wQ0c2HefRSZA=; b=yGf9mVw8Nnb5/f8pDO6Yidwh+HYvtzApv9scgG3GLU3nzTg09Lm3q0DAJoc/RrCuFO eESdPKO5OC58GBouy7h7krapno9PqdTQAqNg9wackwkz0teKvuG9HhIBWRTUxi3tUlOZ 8sXXvTuNMOwj1ltKvR7TRaQCfdM9dBMH4eoAw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:reply-to:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:content-type :content-transfer-encoding; b=nONZfXq1xeiKKxm7HMobjJJ25AhaYj7oXpb9VdCyfttMsoQ7ahT/pOtZZZ6OOOPlSW Zu6oMekg27YfpM6FUV8BFXbHCkb6PpEWnRNtX1OU9D5Ewmdjng2m6rDR4oTa7/uUct2c IhDLrpd6UyUjsKw8z7BzzVPBHvpmEdcDaDLcY= MIME-Version: 1.0 Sender: noble.paul@gmail.com Reply-To: noble.paul@gmail.com Received: by 10.141.41.10 with SMTP id t10mr165686rvj.221.1259902266065; Thu, 03 Dec 2009 20:51:06 -0800 (PST) In-Reply-To: References: <5e76b0ad0912022320v59402125kb1f03d1ab8885186@mail.gmail.com> From: =?UTF-8?B?Tm9ibGUgUGF1bCDgtKjgtYvgtKzgtL/gtLPgtY3igI0gIOCkqOCli+CkrOCljeCks+CljQ==?= Date: Fri, 4 Dec 2009 10:20:45 +0530 X-Google-Sender-Auth: 160fa577c2270e96 Message-ID: <5e76b0ad0912032050h11bfad97xd029b8d7aecffcc0@mail.gmail.com> Subject: Re: no error delta fail with DataImportHandler To: solr-user@lucene.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org probably you can try out this http://wiki.apache.org/solr/DataImportHandlerFaq#fullimportdelta and it may give you more info on what is happeining On Thu, Dec 3, 2009 at 10:58 PM, Thomas Woodard wrote= : > > Unfortunately that isn't it. I have tried id, product_id, and PRODUCT_ID,= and they all produce the same result. It finds the modified item, but then= does nothing. > > INFO: Running ModifiedRowKey() for Entity: product > Dec 3, 2009 9:25:25 AM org.apache.solr.handler.dataimport.JdbcDataSource$= 1 call > INFO: Creating a connection for entity product with URL: jdbc:oracle:oci:= @dev.eline.com > Dec 3, 2009 9:25:25 AM org.apache.solr.handler.dataimport.JdbcDataSource$= 1 call > INFO: Time taken for getConnection(): 283 > Dec 3, 2009 9:25:25 AM org.apache.solr.handler.dataimport.DocBuilder coll= ectDelta > INFO: Completed ModifiedRowKey for Entity: product rows obtained : 1 > Dec 3, 2009 9:25:25 AM org.apache.solr.handler.dataimport.DocBuilder coll= ectDelta > INFO: Completed DeletedRowKey for Entity: product rows obtained : 0 > Dec 3, 2009 9:25:25 AM org.apache.solr.handler.dataimport.DocBuilder coll= ectDelta > INFO: Completed parentDeltaQuery for Entity: product > Dec 3, 2009 9:25:25 AM org.apache.solr.handler.dataimport.DocBuilder doDe= lta > INFO: Delta Import completed successfully > Dec 3, 2009 9:25:25 AM org.apache.solr.handler.dataimport.DocBuilder exec= ute > INFO: Time taken =3D 0:0:0.404 > > >> From: noble.paul@corp.aol.com >> Date: Thu, 3 Dec 2009 12:50:15 +0530 >> Subject: Re: no error delta fail with DataImportHandler >> To: solr-user@lucene.apache.org >> >> the deltaQuery select 'product_id' and your deltaImportQuery uses >> ${dataimporter.delta.id} >> I guess it should have been ${dataimporter.delta. product_id} >> >> On Wed, Dec 2, 2009 at 11:52 PM, Thomas Woodard wr= ote: >> > >> > I'm trying to get delta indexing set up. My configuration allows a ful= l index no problem, but when I create a test delta of a single record, the = delta import finds the record but then does nothing. I can only assume I ha= ve something subtly wrong with my configuration, but according to the wiki,= my configuration should be valid. What I am trying to do is have a single = delta detected on the top level entity trigger a rebuild of everything unde= r that entity, the same as the first example in the wiki. Any help would be= greatly appreciated. >> > >> > >> > =E1 =E1> > =E1 =E1user=3D"XXX" password=3D"XXX" autoCommit=3D"false" transactionI= solation=3D"TRANSACTION_READ_COMMITTED"/> >> > >> > =E1 =E1 >> > =E1 =E1 =E1 =E1> > =E1 =E1 =E1 =E1select dp.product_id, dp.display_name, dp.long_descript= ion, gp.orientation >> > =E1 =E1 =E1 =E1from dcs_product dp, gl_product gp >> > =E1 =E1 =E1 =E1where dp.product_id =3D gp.product_id" transformer=3D"C= lobTransformer,HTMLStripTransformer" >> > =E1 =E1 =E1 =E1deltaImportQuery=3D"select dp.product_id, dp.display_na= me, dp.long_description, gp.orientation >> > =E1 =E1 =E1 =E1from dcs_product dp, gl_product gp >> > =E1 =E1 =E1 =E1where dp.product_id =3D gp.product_id >> > =E1 =E1 =E1 =E1AND dp.product_id =3D '${dataimporter.delta.id}'" >> > =E1 =E1 =E1 =E1deltaQuery=3D"select product_id from gl_product_modifie= d where last_modified > TO_DATE('${dataimporter.last_index_time}', 'yyyy-mm= -dd hh:mi:ss')" >> > =E1 =E1 =E1 =E1rootEntity=3D"false" >> > =E1 =E1 =E1 =E1pk=3D"PRODUCT_ID"> >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > >> > =E1 =E1 =E1 =E1 =E1 =E1> > =E1 =E1 =E1 =E1from dcs_prd_chldsku dpc, dcs_sku ds >> > =E1 =E1 =E1 =E1where dpc.product_id =3D '${product.PRODUCT_ID}' >> > =E1 =E1 =E1 =E1and dpc.sku_id =3D ds.sku_id" >> > =E1 =E1 =E1 =E1rootEntity=3D"true" pk=3D"PRODUCT_ID, SKU_ID"> >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1from gl_prd_cat= alog pc, gl_sku_catalog sc >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1where pc.produc= t_id =3D '${product.PRODUCT_ID}' and sc.sku_id =3D '${sku.SKU_ID}' and pc.c= atalog_id =3D sc.catalog_id" pk=3D"SKU_ID, CATALOG_ID"> >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1from dcs_sku ds >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1where ds.sku_id= =3D '${sku.SKU_ID}' >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and ds.on_sale = =3D 0 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1UNION >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1select ds.sale_= price as price >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1from dcs_sku ds >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1where ds.sku_id= =3D '${sku.SKU_ID}' >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and ds.on_sale = =3D 1" >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1pk=3D"SKU_ID"> >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > >> > =E1 =E1 =E1 =E1 =E1 =E1> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1where gc.contributor_id =3D gpc.contrib= utor_id and gpc.product_id =3D '${product.PRODUCT_ID}'" rootEntity=3D"false= " pk=3D"PRODUCT_ID, CONTRIBUTOR_ID"> >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > >> > =E1 =E1 =E1 =E1 =E1 =E1> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1where gc.contributor_id =3D gpd.contrib= utor_id and gpd.product_id =3D '${product.PRODUCT_ID}'" rootEntity=3D"false= " pk=3D"PRODUCT_ID, CONTRIBUTOR_ID"> >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > >> > =E1 =E1 =E1 =E1 =E1 =E1> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1from dcs_cat_chldprd, d= cs_category, gl_category >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1where gl_category.avail= ability =3D 0 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and gl_category.exclude= _in_vivisimo =3D 0 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and dcs_category.catego= ry_id =3D gl_category.category_id >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and dcs_cat_chl= dprd.category_id =3D dcs_category.category_id >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and dcs_cat_chl= dprd.child_prd_id =3D '${product.PRODUCT_ID}' >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1union >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1select display_name as keyword_= name >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1from gl_product_scene p= s, gl_scene_tag st, gl_tag tag >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1where ps.scene_id =3D s= t.scene_id >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and st.tag_id = =3D tag.tag_id >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and tag.type in= (0,1) >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and ps.product_= id =3D '${product.PRODUCT_ID}' >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1union >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1select display_name as keyword_= name >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1from gl_product_scene p= s, gl_scene_tag st, gl_tag tag >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1where ps.scene_id =3D s= t.scene_id >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and st.tag_id = =3D tag.tag_id >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and tag.type = =3D 2 >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1and ps.product_= id =3D '${product.PRODUCT_ID}'" rootEntity=3D"false" pk=3D"PRODUCT_ID, KEYW= ORD_NAME"> >> > =E1 =E1 =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 =E1 =E1 >> > =E1 =E1 =E1 =E1 >> > =E1 =E1 >> > >> > >> > >> > _________________________________________________________________ >> > Windows Live Hotmail gives you a free,exclusive =E1gift. >> > http://www.microsoft.com/windows/windowslive/hotmail_bl1/hotmail_bl1.a= spx?ocid=3DPID23879::T:WLMTAGL:ON:WL:en-ww:WM_IMHM_7:092009 >> >> >> >> -- >> ----------------------------------------------------- >> Noble Paul | Principal Engineer| AOL | http://aol.com > > _________________________________________________________________ > Windows 7: Unclutter your desktop. Learn more. > http://www.microsoft.com/windows/windows-7/videos-tours.aspx?h=3D7sec&sli= deid=3D1&media=3Daero-shake-7second&listid=3D1&stop=3D1&ocid=3DPID24727::T:= WLMTAGL:ON:WL:en-US:WWL_WIN_7secdemo:122009 --=20 ----------------------------------------------------- Noble Paul | Principal Engineer| AOL | http://aol.com