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 <bertie.s...@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 <tyo...@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 > goks...@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.
