Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Unable to stop a job in 3.1

  1. #1
    Join Date
    Aug 2008
    Posts
    2

    Default Unable to stop a job in 3.1

    I just upgraded from 3.0.4 to 3.1GA (Windows). I used to be able to click on the "Stop Job" button and my job would stop within a few seconds.

    In 3.1, when I click on the "Stop Job" button, it stays on an hourglass cursor and the title screen eventually says "Not Responding". The job has stopped running and there is no CPU activity, however, I never regain control back in the UI. I have to shutdown the application through Task Manager.

    Also, I'm using Java 1.6.0_07.

    Has anybody else experienced this?
    Last edited by elitwin; 11-26-2008 at 07:57 PM.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Maybe something similar as http://jira.pentaho.com/browse/PDI-1527 ... I would suggest to file a JIRA with details instructions on how to duplicate the problem.

    Regards,
    Sven

  3. #3
    Join Date
    Aug 2008
    Posts
    2

    Default

    Thanks for the response. I noticed that when I try to stop this job in 3.0.4, I sometimes get the following error:

    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : Something went wrong while trying to stop the transformation: org.pentaho.di.core.exception.KettleDatabaseException:
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : Error cancelling statement
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : You are not owner of thread 16120
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : org.pentaho.di.core.exception.KettleDatabaseException:
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : Error cancelling statement
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : You are not owner of thread 16120
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) :
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:561)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.core.database.Database.cancelQuery(Database.java:540)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.trans.steps.tableinput.TableInput.stopRunning(TableInput.java:264)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.trans.Trans.stopAll(Trans.java:871)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:668)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.job.Job.execute(Job.java:333)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.job.Job.execute(Job.java:434)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.job.Job.execute(Job.java:434)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.job.Job.execute(Job.java:293)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:60)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at java.lang.Thread.run(Unknown Source)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : Caused by: java.sql.SQLException: You are not owner of thread 16120
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.StatementImpl.createResultSetUsingServerFetch(StatementImpl.java:521)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:674)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at com.mysql.jdbc.StatementImpl.cancel(StatementImpl.java:355)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : at org.pentaho.di.core.database.Database.cancelStatement(Database.java:555)
    2008/12/02 14:19:41 - Appraisal - Create Trendix file - ERROR (version 3.0.4, build 53 from 2008/06/24 11:14:00) : ... 10 more

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.