[GORA-24] Throwing EOFException with MEDIUMBLOB type for inlinks column

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Fix Version/s: 0.4
• Component/s: gora-sql
• Environment: MySQL
• Assignee: Unassigned
• Reporter: Alexis
• Created: 22/Feb/11 23:48
• Updated: 08/Feb/14 17:50
• Resolved: 08/Feb/14 17:50

Description

I had an exception with DbUpdaterJob complaining that inlinks column of type BLOB in webpage table was not big enough to store all the incoming links. So I changed the column definition in gora-sql-mapping.xml from BLOB to MEDIUMBLOB:

<field name="inlinks" column="inlinks" jdbc-type="MEDIUMBLOB"/>

Now I systematically get an exception in the update step:

java.io.IOException: java.sql.BatchUpdateException: Error reading from InputStream java.io.EOFException
at org.apache.gora.sql.store.SqlStore.flush(SqlStore.java:341)
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.ReduceTask.runNewReducer(ReduceTask.java:567)
at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:408)
at org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:216)
Caused by: java.sql.BatchUpdateException: Error reading from InputStream java.io.EOFException
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2020)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1451)
at org.apache.gora.sql.store.SqlStore.flush(SqlStore.java:329)
... 5 more