You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@gora.apache.org by "Alexis (JIRA)" <ji...@apache.org> on 2011/02/23 00:49:38 UTC

[jira] Created: (GORA-24) Throwing EOFException with MEDIUMBLOB type for inlinks column

Throwing EOFException with MEDIUMBLOB type for inlinks column
-------------------------------------------------------------

                 Key: GORA-24
                 URL: https://issues.apache.org/jira/browse/GORA-24
             Project: Gora
          Issue Type: Bug
          Components: storage-sql
         Environment: MySQL
            Reporter: Alexis


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

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (GORA-24) Throwing EOFException with MEDIUMBLOB type for inlinks column

Posted by "Chris A. Mattmann (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/GORA-24?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris A. Mattmann updated GORA-24:
----------------------------------

    Fix Version/s: 0.2-incubating

> Throwing EOFException with MEDIUMBLOB type for inlinks column
> -------------------------------------------------------------
>
>                 Key: GORA-24
>                 URL: https://issues.apache.org/jira/browse/GORA-24
>             Project: Gora
>          Issue Type: Bug
>          Components: storage-sql
>         Environment: MySQL
>            Reporter: Alexis
>             Fix For: 0.2-incubating
>
>
> 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

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Commented: (GORA-24) Throwing EOFException with MEDIUMBLOB type for inlinks column

Posted by "Alexis (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/GORA-24?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12999477#comment-12999477 ] 

Alexis commented on GORA-24:
----------------------------

The exception that occured with the update command and that motivated the change to mediumblob type, was:

java.io.IOException: java.sql.BatchUpdateException: Data truncation: Data too long for column 'inlinks' at row 1
	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.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: Data truncation: Data too long for column 'inlinks' at row 1
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
	at org.apache.gora.sql.store.SqlStore.flush(SqlStore.java:328)
	... 5 more

> Throwing EOFException with MEDIUMBLOB type for inlinks column
> -------------------------------------------------------------
>
>                 Key: GORA-24
>                 URL: https://issues.apache.org/jira/browse/GORA-24
>             Project: Gora
>          Issue Type: Bug
>          Components: storage-sql
>         Environment: MySQL
>            Reporter: Alexis
>
> 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

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (GORA-24) Throwing EOFException with MEDIUMBLOB type for inlinks column

Posted by "Chris A. Mattmann (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/GORA-24?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris A. Mattmann updated GORA-24:
----------------------------------

    Fix Version/s:     (was: 0.2-incubating)
                   0.3-incubating

- push to 0.3

> Throwing EOFException with MEDIUMBLOB type for inlinks column
> -------------------------------------------------------------
>
>                 Key: GORA-24
>                 URL: https://issues.apache.org/jira/browse/GORA-24
>             Project: Gora
>          Issue Type: Bug
>          Components: storage-sql
>         Environment: MySQL
>            Reporter: Alexis
>             Fix For: 0.3-incubating
>
>
> 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

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira