AnsweredAssumed Answered

while updating config table we are getting read only transaction not able to update the record

Question asked by HazarathReddy Boreddy on Jun 11, 2018
Latest reply on Jun 12, 2018 by Chris Eicher

we are running multiple jobs parallel each job starts, we read the value from config table which is my sql and each end we update the value for each job, each job having one entry

 

we are getting error like this 

org.pentaho.di.core.exception.KettleStepException:Error while running this step!

Couldn't execute SQL: update job_config set max_date_time = '2018/06/08 07:45:44.000' where job_name = 'xxxxxxx' and job_type = 'xxxxx'

 

Could not retrieve transation read-only status server

at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:251)

at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)

at java.lang.Thread.run(Thread.java:701)

Caused by: org.pentaho.di.core.exception.KettleDatabaseException:

 

we are using the below driver

 

driver=org.gjt.mm.mysql.Driver

Outcomes