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

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.


Solutions on the web324

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

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 web
Error cancelling statement Method not supported

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

Solution icon of pentaho
via Pentaho BI Platform Tracking by Curtis Boyden, 8 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 -

Solution icon of stackexchange-dba
via Database Administrators by Unknown author, 10 months 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, 8 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, 8 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
Couldn't get row from result set ERROR: canceling statement due to user request

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

703 times, 2 days ago
85 times, 4 days ago
Once, 6 days ago
101 times, 1 week ago
152 more bugmates