StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSOLR: Indexing failed. Rolled back all changes.
text
Body
copied!<p>i have the following in dataconfig_1.xml</p> <pre> <?xml version="1.0" encoding="UTF-8"?> <dataConfig> <dataSource batchSize="-1" convertType="true" driver="com.mysql.jdbc.Driver" password="solrpw" url="jdbc:mysql://127.0.0.1/solrDB" user="solruser"/> <document name="items"> <entity name="root" pk="id" preImportDeleteQuery="data_source:1" query="select a.id, a.body, a.headline title ,a.date datecreated, a.title_id ,t.name publisher_name from article as a inner join title as t on t.id=a.title_id" transformer="TemplateTransformer" deltaImportQuery="select a.id, a.body, a.headline title ,a.date datecreated, a.title_id ,t.name publisher_name from article as a inner join title as t on t.id=a.title_id where last_update_time > '${dataimporter.last_index_time}'" deltaQuery="select id from article where last_update_time > '${dataimporter.last_index_time}'"> <field column="data_source" template="1"/> <field column="data_source_type" template="Jdbc"/> <field column="data_source_name" template="syndigate_solr"/> </entity> </document> </dataConfig> </pre> <p>and in dataimport_1.properties i have</p> <pre> #Tue Aug 02 06:53:21 UTC 2011 last_index_time=2011-08-02 06\:52\:51 root.last_index_time=2011-08-02 06\:52\:51 </pre> <p>now whenever i run deltaimport </p> <pre> http://myip:8888/solr/collection1/dataimport_1?command=delta-import </pre> <p>i got the following response</p> <pre> <response> <lst name="responseHeader"> <int name="status">0</int> <int name="QTime">8</int> </lst> <lst name="initArgs"> <lst name="defaults"> <str name="config">dataconfig_1.xml</str> </lst> </lst> <str name="command">delta-import</str> <str name="status">idle</str> <str name="importResponse"/> <lst name="statusMessages"> <str name="Time Elapsed">0:0:1.552</str> <str name="Total Requests made to DataSource">2</str> <str name="Total Rows Fetched">18954</str> <str name="Total Documents Processed">0</str> <str name="Total Documents Skipped">0</str> <str name="Delta Dump started">2011-08-02 09:35:52</str> <str name="Identifying Delta">2011-08-02 09:35:52</str> <str name="Deltas Obtained">2011-08-02 09:35:52</str> <str name="Building documents">2011-08-02 09:35:52</str> <str name="Total Changed Documents">18954</str> <str name="">Indexing failed. Rolled back all changes.</str> <str name="Rolledback">2011-08-02 09:35:52</str> </lst> <str name="WARNING"> This response format is experimental. It is likely to change in the future. </str> </response> </pre> <p>any idea of what i am doing wrong?? Thanks for your help</p> <p></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload