Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

  1. ,
    Expert tip

    MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

  2. ,

    Make sure you are using InnoDB storage engine and READ-COMMITTED transaction isolation level and increase the database server innodb_lock_wait_timeout variable to about 500.

Solutions on the web

via sqoop-user by Syed Akram, 9 months ago
SQLException in nextKeyValue
via sqoop-user by John Huang, 2 years ago
SQLException in nextKeyValue
via Stack Overflow by matmach
, 1 year ago
SQLException in nextKeyValue
via Stack Overflow by user8663868
, 6 days ago
SQLException in nextKeyValue
java.sql.SQLException: Invalid value for getLong() - 'Orecycle binEvents'	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)	at com.mysql.jdbc.ResultSetImpl.getLong(ResultSetImpl.java:3035)	at com.mysql.jdbc.ResultSetImpl.getLong(ResultSetImpl.java:2946)	at org.apache.sqoop.lib.JdbcWritableBridge.readLong(JdbcWritableBridge.java:62)	at com.cloudera.sqoop.lib.JdbcWritableBridge.readLong(JdbcWritableBridge.java:57)	at QueryResult.readFields(QueryResult.java:131)	at org.apache.sqoop.mapreduce.db.DBRecordReader.nextKeyValue(DBRecordReader.java:244)	at org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.nextKeyValue(MapTask.java:533)	at org.apache.hadoop.mapreduce.task.MapContextImpl.nextKeyValue(MapContextImpl.java:80)	at org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.nextKeyValue(WrappedMapper.java:91)	at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)	at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64)	at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:764)	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:340)	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168)	at java.security.AccessController.doPrivileged(Native Method)	at javax.security.auth.Subject.doAs(Subject.java:415)	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614)	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163)