org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement Unknown thread id: 88280


Samebug tips1

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


7 months ago
Expert tip

Solutions on the web9

Solution icon of web
via pentaho.com by Unknown author, 7 months ago
Error cancelling statement Unknown thread id: 88280

Solution icon of pentaho
via Pentaho BI Platform Tracking by Jasper Knulst, 1 year ago
Error cancelling statement Method not supported

Solution icon of web
Error cancelling statement Method not supported

Solution icon of stackexchange-dba
via Database Administrators by Unknown author, 1 year ago
2014/04/03 13:33:43 - TASK COLLECTION - Error cancelling statement 2014/04/03 13:33:43 - TASK COLLECTION - Invalid state, the Statement object is closed. 2014/04/03 13:33:43 - TASK COLLECTION - 2014/04/03 13:33:43 - TASK COLLECTION -

Solution icon of pentaho
via Pentaho BI Platform Tracking by Jasper Knulst, 10 months ago
2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Error cancelling statement 2012/11/21 12:50:10 - Test_Hive - ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy

Solution icon of pentaho
via Pentaho BI Platform Tracking by shailendra vichare, 10 months ago
2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version 4.2.1-GA, build 15926 from 2011-10-19 15.36.47 by buildguy) : Error cancelling statement 2012/04/03 18:45:25 - C:\Users\shailendrav\Desktop\A.ktr : A - ERROR (version

Solution icon of web
Error cancelling statement Unknown thread id: 16

Solution icon of pentaho
via Pentaho BI Platform Tracking by Curtis Boyden, 1 year ago
Error cancelling statement Method not supported

Solution icon of pentaho
via Pentaho BI Platform Tracking by Curtis Boyden, 10 months ago
2013/09/24 13:16:41 - Untitled 2 - Error cancelling statement 2013/09/24 13:16:41 - Untitled 2 - Method not supported 2013/09/24 13:16:41 - Untitled 2 -

Stack trace

org.pentaho.di.core.exception.KettleDatabaseException: Error cancelling statement

Unknown thread id: 88280
	at org.pentaho.di.core.database.Database.cancelStatement(Database.java:639)
	at org.pentaho.di.core.database.Database.cancelQuery(Database.java:619)
	at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:293)
	at org.pentaho.di.trans.Trans.stopAll(Trans.java:1352)
	at org.pentaho.di.trans.step.BaseStep.stopAll(BaseStep.java:2244)
	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:64)
	at java.lang.Thread.run(Thread.java:636)
Caused by: java.sql.SQLException: Unknown thread id: 88280
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
	at com.mysql.jdbc.StatementImpl.createResultSetUsingServerFetch(StatementImpl.java:601)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:757)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
	at com.mysql.jdbc.StatementImpl.cancel(StatementImpl.java:421)
	at org.pentaho.di.core.database.Database.cancelStatement(Database.java:633)
	... 6 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

2 times, 2 days ago
2 times, 3 days ago
Samebug visitor profile picture
Unknown user
Once, 5 days ago
4 times, 5 days ago
115 times, 6 days ago
159 more bugmates