Hi Lewis, I am not sure. I do not remember how i overcome this error.
For mysql with Nutch 2.x, i followed this article (which worked most of the times) and i changed the type of field 'content' to 'LONG BLOB' to overcome data size error. Except that, i do not think i changed much. Sorry,i was not of much help. Regards, Kiran. On Thu, Nov 1, 2012 at 1:16 PM, Lewis John Mcgibbney < [email protected]> wrote: > Hi Kiran, > > Did you ever get anywhere with this one? > > Lewis > > On Tue, Oct 16, 2012 at 10:30 PM, kiran chitturi > <[email protected]> wrote: > > Hi, > > > > I am using Nutch 2.x series with updated tika dependencies with hsql > > database. > > > > I have did the commands 'inject,generate,fetch' and after that when i run > > the 'parse' command i get error below. > > > > Is it because of some size limit ? If so, how can i change the settings ? > > > > java.io.IOException: java.sql.BatchUpdateException: data exception: > string > >> data, right truncation > >> at org.apache.gora.sql.store.SqlStore.flush(SqlStore.java:340) > >> at org.apache.gora.sql.store.SqlStore.close(SqlStore.java:185) > >> at > >> > org.apache.gora.mapreduce.GoraRecordWriter.close(GoraRecordWriter.java:55) > >> at > >> > org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.close(MapTask.java:651) > >> at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:766) > >> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:370) > >> at > org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:212) > >> Caused by: java.sql.BatchUpdateException: data exception: string data, > >> right truncation > >> at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source) > >> at org.apache.gora.sql.store.SqlStore.flush(SqlStore.java:328) > >> ... 6 more > > > > > > Thanks for the help. > > > > Regards, > > -- > > Kiran Chitturi > > > > -- > Lewis > -- Kiran Chitturi

