Re: Question about the message "Indexing failed. Rolled back all changes."

[yountod <ty...@loopdata.com>]

That was it!  Thank you for the tip.  To clarify for other beginners:  Create
a blank file called dataimport.properties in your conf directory and don't
forget to make sure the system has write access to it.




Lance Norskog-2 wrote:
> 
> This is definitely a bug. Please open a JIRA issue for this.
> 
> On Sat, Nov 21, 2009 at 10:53 AM, Bertie Shen <be...@gmail.com>
> wrote:
>> Hey,
>>
>>  I figured out why we always we have see <str name="">Indexing failed.
>> Rolled back all changes.</str>.  It is because we need a
>> dataimport.properties file at conf/, into which indexing will write a
>> last
>> indexing time. Without that file, SolrWriter.java will put throw an
>> exception and Solr will have this misleading  <str name="">Indexing
>> failed.
>> Rolled back all changes.</str>. output, although indexing is actually
>> successfully completed.
>>
>>  I think we need to improve this functionality, at least documentation.
>>
>>  There are one more thing that we need to pay attention to, i.e. we need
>> to
>> make dataimport.properties writable by other users, otherwise,
>> last_index_time will not be written and the error message may still be
>> there.
>>
>> On Fri, Nov 13, 2009 at 9:35 AM, yountod <ty...@loopdata.com> wrote:
>>
>>>
>>> The process initially completes with:
>>>
>>>  <str name="Full Dump Started">2009-11-13 09:40:46</str>
>>>  <str name="">Indexing completed. Added/Updated: 200000 documents.
>>> Deleted
>>> 0 documents.</str>
>>>
>>>
>>> ...but then it fails with:
>>>
>>>  <str name="Full Dump Started">2009-11-13 09:40:46</str>
>>>   <str name="">Indexing failed. Rolled back all changes.</str>
>>>   <str name="Committed">2009-11-13 09:41:10</str>
>>>  <str name="Optimized">2009-11-13 09:41:10</str>
>>>  <str name="Rolledback">2009-11-13 09:41:10</str>
>>>
>>>
>>> ====================================================================
>>> I think it may have something to do with this, which I found by using
>>> the
>>> DataImport.jsp:
>>> ====================================================================
>>> (Thread.java:636) Caused by: java.sql.SQLException: Illegal value for
>>> setFetchSize(). at
>>> com.mysql.jdbc.Statement.setFetchSize(Statement.java:1864) at
>>>
>>> org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.<init>(JdbcDataSource.java:242)
>>> ... 28 more</str>
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://old.nabble.com/Question-about-the-message-%22Indexing-failed.-Rolled-back-all--changes.%22-tp26242714p26340360.html
>>> Sent from the Solr - User mailing list archive at Nabble.com.
>>>
>>>
>>
> 
> 
> 
> -- 
> Lance Norskog
> goksron@gmail.com
> 
> 

-- 
View this message in context: http://old.nabble.com/Question-about-the-message-%22Indexing-failed.-Rolled-back-all--changes.%22-tp26242714p26676982.html
Sent from the Solr - User mailing list archive at Nabble.com.