Sometimes the status of a job chain node is not persistent when using mysql

You can reproduce the error by starting mysql with a low value of wait_timeout < 4 (e.g. wait_timeout=3). Then change the status of a job chain node to skipped.

You will get the error

Z-JAVA-105 Java exception com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException("No operations allowed after statement closed."), method=executeUpdate [] / sos::scheduler::order::job_chain::Node::database_record_store

The settings in factory are like this:

db = jdbc -class=com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/scheduler -user=myuser-password=mypwd