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. > >
