根据日志执行mysql的日志,推执行逻辑
根据日志执行mysql的日志,推执行逻辑
1.ACT_GE_PROPERTY 查看系统配置表 1
2.ACT_RU_TASK 查询当前任务表 1
3.ACT_RU_VARIABLE 查询系统变量表 0
4.ACT_RE_PROCDEF 查询流程定义表 1
5.ACT_GE_BYTEARRAY 查询资源文件表(保存流程图bpmn文件 以及 xml流程图) 1
6.ACT_PROCDEF_INF 查询流程定义信息表 0
7.select * from ACT_RU_TASK where PARENT_TASK_ID_ = ? 查询以当前需要审核结束的节点作为上一个节点的任务数据。 0
8.ACT_RU_IDENTITYLINK 查询当前流程id的任务参与者数据表中信息
9. ACT_HI_TASKINST 查询该审批流程的全部以及生成的流程实例信息 此时 1
10.select E.*, S.PROC_INST_ID_ AS PARENT_PROC_INST_ID_ from ACT_RU_EXECUTION E LEFT OUTER JOIN ACT_RU_EXECUTION S ON E.SUPER_EXEC_ = S.ID_ where E.ID_ = ?
ACT_RU_EXECUTION:流程实例与分支执行表 E S 为同一个表,SUPER_EXEC_为null?
以left左侧的表为基准输出数据
11.select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ?
act_ru_execution: 运行时流程执行实例表
ACT_RU_TASK 也是运行时流程实例相关的表
act_hi_procinst 已经运行的流程的历史流程信息表
10. select E.*, S.PROC_INST_ID_ AS PARENT_PROC_INST_ID_ from ACT_RU_EXECUTION E LEFT OUTER JOIN ACT_RU_EXECUTION S ON E.SUPER_EXEC_ = S.ID_ where E.ID_ = ?
再次查询!
13.select * from ACT_HI_ACTINST RES where EXECUTION_ID_ = ? and ACT_ID_ = ? and END_TIME_ is null
ACT_HI_ACTINST 历史活动信息表
14.update ACT_GE_PROPERTY SET REV_ = ?, VALUE_ = ? where NAME_ = ? and REV_ = ?
Parameters: 15(Integer), 35001(String), next.dbid(String = 35001), 14(Integer)
15.insert into ACT_HI_TASKINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_, CATEGORY_, TENANT_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Parameters: 32502(String), myEvavtion:1:27504(String), 30001(String), 30002(String), 经理审核(String), null, null, null, null, 2021-05-16 08:55:56.56(Timestamp), null, null, null, null, _4(String), null, 50(Integer), null, null, (String)
ACT_HI_TASKINST :记录历史的流程实例的表
11. insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TENANT_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Parameters: 32501(String), myEvavtion:1:27504(String), 30001(String), 30002(String), _4(String), 32502(String), null, 经理审核(String), userTask(String), null, 2021-05-16 08:55:56.477(Timestamp), null, null, null, (String)
ACT_HI_ACTINST :历史活动信息表
13.insert into ACT_RU_TASK (ID_, REV_, NAME_, BUSINESS_KEY_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_, ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_KEY_, DUE_DATE_, CATEGORY_, SUSPENSION_STATE_, TENANT_ID_, FORM_KEY_, CLAIM_TIME_, APP_VERSION_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Parameters: 32502(String), 经理审核(String), null, null, null, 50(Integer), 2021-05-16 08:55:56.477(Timestamp), null, null, null, 30002(String), 30001(String), myEvavtion:1:27504(String), _4(String), null, null, 1(Integer), (String), null, null, null
ACT_RU_TASK :将信息添加到当前正在运行的任务表中
14.update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ? where ID_ = ?
Parameters: 30002(String), null, 2021-05-16 08:55:56.437(Timestamp), 52070542(Long), null, 30004(String)
更新发起出差申请的流程时候添加的历史活动信息表的数据。 END_TIME_ :流程结束时间,
DURATION_ = ?, DELETE_REASON_ :暂时不知道参数含义;
15. update ACT_HI_TASKINST set PROC_DEF_ID_ = ?, EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, CLAIM_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, FORM_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ?, CATEGORY_ = ? where ID_ = ?
Parameters: myEvavtion:1:27504(String), 30002(String), 发起出差审核(String), null, null, null, (String), null, 2021-05-16 08:55:56.407(Timestamp), 52070459(Long), null, _3(String), null, 50(Integer), null, null, 30005(String
更新历史流程数信息
16.Preparing: update ACT_RU_EXECUTION set REV_ = ?, BUSINESS_KEY_ = ?, PROC_DEF_ID_ = ?, ACT_ID_ = ?, IS_ACTIVE_ = ?, IS_CONCURRENT_ = ?, IS_SCOPE_ = ?, IS_EVENT_SCOPE_ = ?, IS_MI_ROOT_ = ?, PARENT_ID_ = ?, SUPER_EXEC_ = ?, ROOT_PROC_INST_ID_ = ?, SUSPENSION_STATE_ = ?, NAME_ = ?, IS_COUNT_ENABLED_ = ?, EVT_SUBSCR_COUNT_ = ?, TASK_COUNT_ = ?, JOB_COUNT_ = ?, TIMER_JOB_COUNT_ = ?, SUSP_JOB_COUNT_ = ?, DEADLETTER_JOB_COUNT_ = ?, VAR_COUNT_ = ?, ID_LINK_COUNT_ = ?, APP_VERSION_ = ? where ID_ = ? and REV_ = ?
2(Integer), null, myEvavtion:1:27504(String), _4(String), true(Boolean), false(Boolean), false(Boolean), false(Boolean), false(Boolean), 30001(String), null, 30001(String), 1(Integer), null, false(Boolean), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), null, 30002(String), 1(Integer)
17.delete from ACT_RU_TASK where ID_ = ? and REV_ = ?
Parameters: 30005(String), 1(Integer)
删除ACT_RU_TASK 表中的已经处理完的数据。
18.流程处理结束。
"C:\Program Files\Java\jdk1.8.0_131\bin\java.exe" -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar=49874:C:\Program Files\JetBrains\IntelliJ IDEA 2019.3.3\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\IntelliJ IDEA 2019.3.3\lib\idea_rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2019.3.3\plugins\junit\lib\junit5-rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2019.3.3\plugins\junit\lib\junit-rt.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_131\jre\lib\rt.jar;C:\Program Files\Java\jdk1.8.0_131;D:\javaPrograms\property\target\test-classes;D:\javaPrograms\property\target\classes;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-web\2.4.4\spring-boot-starter-web-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter\2.4.4\spring-boot-starter-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\yaml\snakeyaml\1.27\snakeyaml-1.27.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-json\2.4.4\spring-boot-starter-json-2.4.4.jar;C:\apache-maven-3.5.4\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.11.4\jackson-datatype-jdk8-2.11.4.jar;C:\apache-maven-3.5.4\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.11.4\jackson-datatype-jsr310-2.11.4.jar;C:\apache-maven-3.5.4\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.11.4\jackson-module-parameter-names-2.11.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-WEB\5.3.5\spring-web-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-webmvc\5.3.5\spring-webmvc-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-expression\5.3.5\spring-expression-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\projectlombok\lombok\1.18.18\lombok-1.18.18.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-tomcat\2.4.4\spring-boot-starter-tomcat-2.4.4.jar;C:\apache-maven-3.5.4\repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;C:\apache-maven-3.5.4\repository\org\apache\tomcat\embed\tomcat-embed-core\9.0.44\tomcat-embed-core-9.0.44.jar;C:\apache-maven-3.5.4\repository\org\glassfish\jakarta.el\3.0.3\jakarta.el-3.0.3.jar;C:\apache-maven-3.5.4\repository\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.44\tomcat-embed-websocket-9.0.44.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-test\2.4.4\spring-boot-starter-test-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-test\2.4.4\spring-boot-test-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-test-autoconfigure\2.4.4\spring-boot-test-autoconfigure-2.4.4.jar;C:\apache-maven-3.5.4\repository\com\jayway\jsonpath\json-path\2.4.0\json-path-2.4.0.jar;C:\apache-maven-3.5.4\repository\net\minidev\json-smart\2.3\json-smart-2.3.jar;C:\apache-maven-3.5.4\repository\net\minidev\accessors-smart\1.2\accessors-smart-1.2.jar;C:\apache-maven-3.5.4\repository\org\ow2\asm\asm\5.0.4\asm-5.0.4.jar;C:\apache-maven-3.5.4\repository\jakarta\xml\bind\jakarta.xml.bind-api\2.3.3\jakarta.xml.bind-api-2.3.3.jar;C:\apache-maven-3.5.4\repository\jakarta\activation\jakarta.activation-api\1.2.2\jakarta.activation-api-1.2.2.jar;C:\apache-maven-3.5.4\repository\org\assertj\assertj-core\3.18.1\assertj-core-3.18.1.jar;C:\apache-maven-3.5.4\repository\org\hamcrest\hamcrest\2.2\hamcrest-2.2.jar;C:\apache-maven-3.5.4\repository\org\junit\jupiter\junit-jupiter\5.7.1\junit-jupiter-5.7.1.jar;C:\apache-maven-3.5.4\repository\org\junit\jupiter\junit-jupiter-api\5.7.1\junit-jupiter-api-5.7.1.jar;C:\apache-maven-3.5.4\repository\org\junit\jupiter\junit-jupiter-params\5.7.1\junit-jupiter-params-5.7.1.jar;C:\apache-maven-3.5.4\repository\org\junit\jupiter\junit-jupiter-engine\5.7.1\junit-jupiter-engine-5.7.1.jar;C:\apache-maven-3.5.4\repository\org\mockito\mockito-core\3.6.28\mockito-core-3.6.28.jar;C:\apache-maven-3.5.4\repository\net\bytebuddy\byte-buddy\1.10.22\byte-buddy-1.10.22.jar;C:\apache-maven-3.5.4\repository\net\bytebuddy\byte-buddy-agent\1.10.22\byte-buddy-agent-1.10.22.jar;C:\apache-maven-3.5.4\repository\org\objenesis\objenesis\3.1\objenesis-3.1.jar;C:\apache-maven-3.5.4\repository\org\mockito\mockito-junit-jupiter\3.6.28\mockito-junit-jupiter-3.6.28.jar;C:\apache-maven-3.5.4\repository\org\skyscreamer\jsonassert\1.5.0\jsonassert-1.5.0.jar;C:\apache-maven-3.5.4\repository\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-core\5.3.5\spring-core-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-jcl\5.3.5\spring-jcl-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-test\5.3.5\spring-test-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\xmlunit\xmlunit-core\2.7.0\xmlunit-core-2.7.0.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-thymeleaf\2.4.4\spring-boot-starter-thymeleaf-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\thymeleaf\thymeleaf-spring5\3.0.12.RELEASE\thymeleaf-spring5-3.0.12.RELEASE.jar;C:\apache-maven-3.5.4\repository\org\thymeleaf\thymeleaf\3.0.12.RELEASE\thymeleaf-3.0.12.RELEASE.jar;C:\apache-maven-3.5.4\repository\org\attoparser\attoparser\2.0.5.RELEASE\attoparser-2.0.5.RELEASE.jar;C:\apache-maven-3.5.4\repository\org\unbescape\unbescape\1.1.6.RELEASE\unbescape-1.1.6.RELEASE.jar;C:\apache-maven-3.5.4\repository\org\thymeleaf\extras\thymeleaf-extras-java8time\3.0.4.RELEASE\thymeleaf-extras-java8time-3.0.4.RELEASE.jar;C:\apache-maven-3.5.4\repository\mysql\mysql-connector-java\8.0.19\mysql-connector-java-8.0.19.jar;C:\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-boot-starter\3.3.1\mybatis-plus-boot-starter-3.3.1.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-autoconfigure\2.4.4\spring-boot-autoconfigure-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-jdbc\2.4.4\spring-boot-starter-jdbc-2.4.4.jar;C:\apache-maven-3.5.4\repository\com\zaxxer\HikariCP\3.4.5\HikariCP-3.4.5.jar;C:\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus\3.3.1\mybatis-plus-3.3.1.jar;C:\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-extension\3.3.1\mybatis-plus-extension-3.3.1.jar;C:\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-core\3.3.1\mybatis-plus-core-3.3.1.jar;C:\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-annotation\3.3.1\mybatis-plus-annotation-3.3.1.jar;C:\apache-maven-3.5.4\repository\com\github\jsqlparser\jsqlparser\3.1\jsqlparser-3.1.jar;C:\apache-maven-3.5.4\repository\org\mybatis\mybatis-spring\2.0.3\mybatis-spring-2.0.3.jar;C:\apache-maven-3.5.4\repository\com\baomidou\mybatis-plus-generator\3.3.1\mybatis-plus-generator-3.3.1.jar;C:\apache-maven-3.5.4\repository\com\alibaba\druid-spring-boot-starter\1.1.10\druid-spring-boot-starter-1.1.10.jar;C:\apache-maven-3.5.4\repository\com\alibaba\druid\1.1.10\druid-1.1.10.jar;C:\apache-maven-3.5.4\repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;C:\apache-maven-3.5.4\repository\org\freemarker\freemarker\2.3.28\freemarker-2.3.28.jar;C:\apache-maven-3.5.4\repository\org\apache\velocity\velocity-engine-core\2.3\velocity-engine-core-2.3.jar;C:\apache-maven-3.5.4\repository\org\apache\commons\commons-lang3\3.11\commons-lang3-3.11.jar;C:\apache-maven-3.5.4\repository\org\junit\vintage\junit-vintage-engine\5.7.1\junit-vintage-engine-5.7.1.jar;C:\apache-maven-3.5.4\repository\org\apiguardian\apiguardian-api\1.1.0\apiguardian-api-1.1.0.jar;C:\apache-maven-3.5.4\repository\org\junit\platform\junit-platform-engine\1.7.1\junit-platform-engine-1.7.1.jar;C:\apache-maven-3.5.4\repository\org\opentest4j\opentest4j\1.2.0\opentest4j-1.2.0.jar;C:\apache-maven-3.5.4\repository\org\junit\platform\junit-platform-commons\1.7.1\junit-platform-commons-1.7.1.jar;C:\apache-maven-3.5.4\repository\junit\junit\4.13.2\junit-4.13.2.jar;C:\apache-maven-3.5.4\repository\org\hamcrest\hamcrest-core\2.2\hamcrest-core-2.2.jar;C:\apache-maven-3.5.4\repository\com\ibeetl\beetl\3.3.2.RELEASE\beetl-3.3.2.RELEASE.jar;C:\apache-maven-3.5.4\repository\org\antlr\antlr4-runtime\4.7.2\antlr4-runtime-4.7.2.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-log4j2\2.4.4\spring-boot-starter-log4j2-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\apache\logging\log4j\log4j-slf4j-impl\2.13.3\log4j-slf4j-impl-2.13.3.jar;C:\apache-maven-3.5.4\repository\org\apache\logging\log4j\log4j-api\2.13.3\log4j-api-2.13.3.jar;C:\apache-maven-3.5.4\repository\org\apache\logging\log4j\log4j-core\2.13.3\log4j-core-2.13.3.jar;C:\apache-maven-3.5.4\repository\org\apache\logging\log4j\log4j-jul\2.13.3\log4j-jul-2.13.3.jar;C:\apache-maven-3.5.4\repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-aop\2.4.4\spring-boot-starter-aop-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-aop\5.3.5\spring-aop-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\aspectj\aspectjweaver\1.9.6\aspectjweaver-1.9.6.jar;C:\apache-maven-3.5.4\repository\org\webjars\webjars-locator\0.32-1\webjars-locator-0.32-1.jar;C:\apache-maven-3.5.4\repository\org\webjars\webjars-locator-core\0.46\webjars-locator-core-0.46.jar;C:\apache-maven-3.5.4\repository\io\github\classgraph\classgraph\4.8.69\classgraph-4.8.69.jar;C:\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-databind\2.11.4\jackson-databind-2.11.4.jar;C:\apache-maven-3.5.4\repository\org\webjars\bootstrap\3.3.7\bootstrap-3.3.7.jar;C:\apache-maven-3.5.4\repository\org\webjars\jquery\3.3.1\jquery-3.3.1.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-spring\1.5.3\shiro-spring-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-core\1.5.3\shiro-core-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-lang\1.5.3\shiro-lang-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-cache\1.5.3\shiro-cache-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-crypto-hash\1.5.3\shiro-crypto-hash-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-crypto-core\1.5.3\shiro-crypto-core-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-crypto-cipher\1.5.3\shiro-crypto-cipher-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-config-core\1.5.3\shiro-config-core-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-config-ogdl\1.5.3\shiro-config-ogdl-1.5.3.jar;C:\apache-maven-3.5.4\repository\commons-beanutils\commons-beanutils\1.9.4\commons-beanutils-1.9.4.jar;C:\apache-maven-3.5.4\repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-event\1.5.3\shiro-event-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\apache\shiro\shiro-web\1.5.3\shiro-web-1.5.3.jar;C:\apache-maven-3.5.4\repository\org\owasp\encoder\encoder\1.2.2\encoder-1.2.2.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-devtools\2.4.4\spring-boot-devtools-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot\2.4.4\spring-boot-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\boot\spring-boot-starter-data-redis\2.4.4\spring-boot-starter-data-redis-2.4.4.jar;C:\apache-maven-3.5.4\repository\org\springframework\data\spring-data-redis\2.4.6\spring-data-redis-2.4.6.jar;C:\apache-maven-3.5.4\repository\org\springframework\data\spring-data-keyvalue\2.4.6\spring-data-keyvalue-2.4.6.jar;C:\apache-maven-3.5.4\repository\org\springframework\data\spring-data-commons\2.4.6\spring-data-commons-2.4.6.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-oxm\5.3.5\spring-oxm-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-context-support\5.3.5\spring-context-support-5.3.5.jar;C:\apache-maven-3.5.4\repository\io\lettuce\lettuce-core\6.0.3.RELEASE\lettuce-core-6.0.3.RELEASE.jar;C:\apache-maven-3.5.4\repository\io\netty\netty-common\4.1.60.Final\netty-common-4.1.60.Final.jar;C:\apache-maven-3.5.4\repository\io\netty\netty-handler\4.1.60.Final\netty-handler-4.1.60.Final.jar;C:\apache-maven-3.5.4\repository\io\netty\netty-resolver\4.1.60.Final\netty-resolver-4.1.60.Final.jar;C:\apache-maven-3.5.4\repository\io\netty\netty-buffer\4.1.60.Final\netty-buffer-4.1.60.Final.jar;C:\apache-maven-3.5.4\repository\io\netty\netty-codec\4.1.60.Final\netty-codec-4.1.60.Final.jar;C:\apache-maven-3.5.4\repository\io\netty\netty-transport\4.1.60.Final\netty-transport-4.1.60.Final.jar;C:\apache-maven-3.5.4\repository\io\projectreactor\reactor-core\3.4.4\reactor-core-3.4.4.jar;C:\apache-maven-3.5.4\repository\org\reactivestreams\reactive-streams\1.0.3\reactive-streams-1.0.3.jar;C:\apache-maven-3.5.4\repository\org\activiti\activiti-engine\7.1.0.M6\activiti-engine-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\activiti\api\activiti-api-runtime-shared\7.1.0.M6\activiti-api-runtime-shared-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\activiti\api\activiti-api-model-shared\7.1.0.M6\activiti-api-model-shared-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\activiti\core\common\activiti-project-model\7.1.0.M6\activiti-project-model-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\activiti\activiti-bpmn-converter\7.1.0.M6\activiti-bpmn-converter-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\activiti\activiti-bpmn-model\7.1.0.M6\activiti-bpmn-model-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\activiti\activiti-process-validation\7.1.0.M6\activiti-process-validation-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\apache\commons\commons-email\1.5\commons-email-1.5.jar;C:\apache-maven-3.5.4\repository\com\sun\mail\javax.mail\1.5.6\javax.mail-1.5.6.jar;C:\apache-maven-3.5.4\repository\javax\activation\activation\1.1\activation-1.1.jar;C:\apache-maven-3.5.4\repository\org\mybatis\mybatis\3.5.0\mybatis-3.5.0.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-beans\5.3.5\spring-beans-5.3.5.jar;C:\apache-maven-3.5.4\repository\de\odysseus\juel\juel-api\2.2.7\juel-api-2.2.7.jar;C:\apache-maven-3.5.4\repository\de\odysseus\juel\juel-impl\2.2.7\juel-impl-2.2.7.jar;C:\apache-maven-3.5.4\repository\de\odysseus\juel\juel-spi\2.2.7\juel-spi-2.2.7.jar;C:\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-core\2.11.4\jackson-core-2.11.4.jar;C:\apache-maven-3.5.4\repository\com\fasterxml\jackson\core\jackson-annotations\2.11.4\jackson-annotations-2.11.4.jar;C:\apache-maven-3.5.4\repository\joda-time\joda-time\2.10.5\joda-time-2.10.5.jar;C:\apache-maven-3.5.4\repository\org\slf4j\jcl-over-slf4j\1.7.30\jcl-over-slf4j-1.7.30.jar;C:\apache-maven-3.5.4\repository\org\activiti\activiti-spring\7.1.0.M6\activiti-spring-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\activiti\core\common\activiti-spring-project\7.1.0.M6\activiti-spring-project-7.1.0.M6.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-context\5.3.5\spring-context-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-jdbc\5.3.5\spring-jdbc-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-tx\5.3.5\spring-tx-5.3.5.jar;C:\apache-maven-3.5.4\repository\org\springframework\spring-orm\5.3.5\spring-orm-5.3.5.jar;C:\apache-maven-3.5.4\repository\javax\el\el-api\2.2\el-api-2.2.jar;C:\apache-maven-3.5.4\repository\commons-dbcp\commons-dbcp\1.4\commons-dbcp-1.4.jar;C:\apache-maven-3.5.4\repository\commons-pool\commons-pool\1.6\commons-pool-1.6.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 com.lixiaowu.property.activiti.test.ActivitiDemo,completeTask
08:55:48.125 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
08:55:48.145 [main] INFO org.activiti.engine.ProcessEngines - Initializing process engine using configuration 'file:/D:/javaPrograms/property/target/classes/activiti.cfg.xml'
08:55:48.146 [main] INFO org.activiti.engine.ProcessEngines - initializing process engine for resource file:/D:/javaPrograms/property/target/classes/activiti.cfg.xml
08:55:48.391 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loaded 2 bean definitions from InputStream resource [resource loaded through InputStream]
08:55:48.396 [main] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'processEngineConfiguration'
08:55:48.755 [main] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'dataSource'
08:55:54.875 [main] DEBUG org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl - database product name: 'MySQL'
08:55:54.875 [main] DEBUG org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl - using database type: mysql
08:55:56.020 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.020 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- starting SchemaOperationsProcessEngineBuild --------------------------------------------------------
08:55:56.026 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.interceptor.CommandInvoker$1 added to agenda
08:55:56.039 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - Executing performSchemaOperationsProcessEngineBuild with setting true
08:55:56.039 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection
08:55:56.102 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.144 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
08:55:56.162 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - ==> Parameters: schema.version(String)
08:55:56.183 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - <== Total: 1
08:55:56.186 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - Flushing dbSqlSession
08:55:56.187 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - flush summary: 0 insert, 0 update, 0 delete.
08:55:56.187 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - now executing flush...
08:55:56.187 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committing...
08:55:56.188 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - committing the ibatis sql session...
08:55:56.188 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committed...
08:55:56.189 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.190 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.191 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- SchemaOperationsProcessEngineBuild finished --------------------------------------------------------
08:55:56.191 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.191 [main] INFO org.activiti.engine.impl.ProcessEngineImpl - ProcessEngine default created
08:55:56.206 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.206 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- starting ValidateExecutionRelatedEntityCountCfgCmd --------------------------------------------------------
08:55:56.206 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.interceptor.CommandInvoker$1 added to agenda
08:55:56.206 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection
08:55:56.207 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.208 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
08:55:56.208 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - ==> Parameters: cfg.execution-related-entities-count(String)
08:55:56.209 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - <== Total: 1
08:55:56.210 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - Flushing dbSqlSession
08:55:56.210 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - flush summary: 0 insert, 0 update, 0 delete.
08:55:56.210 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - now executing flush...
08:55:56.210 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committing...
08:55:56.210 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - committing the ibatis sql session...
08:55:56.210 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committed...
08:55:56.211 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.212 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.212 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- ValidateExecutionRelatedEntityCountCfgCmd finished --------------------------------------------------------
08:55:56.212 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.212 [main] INFO org.activiti.engine.ProcessEngines - initialised process engine default
08:55:56.216 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.216 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- starting CompleteTaskCmd --------------------------------------------------------
08:55:56.216 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.interceptor.CommandInvoker$1 added to agenda
08:55:56.217 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection
08:55:56.218 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.218 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTask - ==> Preparing: select * from ACT_RU_TASK where ID_ = ?
08:55:56.219 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTask - ==> Parameters: 30005(String)
08:55:56.223 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTask - <== Total: 1
08:55:56.223 [main] DEBUG org.activiti.engine.impl.persistence.entity.VariableInstanceEntityImpl.selectVariablesByTaskId - ==> Preparing: select * from ACT_RU_VARIABLE where TASK_ID_ = ?
08:55:56.223 [main] DEBUG org.activiti.engine.impl.persistence.entity.VariableInstanceEntityImpl.selectVariablesByTaskId - ==> Parameters: 30005(String)
08:55:56.231 [main] DEBUG org.activiti.engine.impl.persistence.entity.VariableInstanceEntityImpl.selectVariablesByTaskId - <== Total: 0
08:55:56.232 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityImpl.selectProcessDefinition - ==> Preparing: select * from ACT_RE_PROCDEF where ID_ = ?
08:55:56.232 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityImpl.selectProcessDefinition - ==> Parameters: myEvavtion:1:27504(String)
08:55:56.235 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityImpl.selectProcessDefinition - <== Total: 1
08:55:56.235 [main] DEBUG org.activiti.engine.impl.persistence.entity.DeploymentEntityImpl.selectDeployment - ==> Preparing: select * from ACT_RE_DEPLOYMENT where ID_ = ?
08:55:56.236 [main] DEBUG org.activiti.engine.impl.persistence.entity.DeploymentEntityImpl.selectDeployment - ==> Parameters: 27501(String)
08:55:56.238 [main] DEBUG org.activiti.engine.impl.persistence.entity.DeploymentEntityImpl.selectDeployment - <== Total: 1
08:55:56.239 [main] DEBUG org.activiti.engine.impl.bpmn.deployer.BpmnDeployer - Processing deployment 出差申请流程
08:55:56.241 [main] DEBUG org.activiti.engine.impl.persistence.entity.ResourceEntityImpl.selectResourcesByDeploymentId - ==> Preparing: select * from ACT_GE_BYTEARRAY where DEPLOYMENT_ID_ = ? order by NAME_ asc
08:55:56.241 [main] DEBUG org.activiti.engine.impl.persistence.entity.ResourceEntityImpl.selectResourcesByDeploymentId - ==> Parameters: 27501(String)
08:55:56.248 [main] DEBUG org.activiti.engine.impl.persistence.entity.ResourceEntityImpl.selectResourcesByDeploymentId - <== Total: 2
08:55:56.249 [main] DEBUG org.activiti.engine.impl.bpmn.deployer.ParsedDeploymentBuilder - Processing BPMN resource bpmn/test.bpmn
08:55:56.373 [main] DEBUG org.activiti.engine.impl.bpmn.parser.handler.ProcessParseHandler - Parsing process myEvavtion
08:55:56.384 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityImpl.selectProcessDefinitionByDeploymentAndKey - ==> Preparing: select * from ACT_RE_PROCDEF where DEPLOYMENT_ID_ = ? and KEY_ = ? and (TENANT_ID_ = '' or TENANT_ID_ is null)
08:55:56.385 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityImpl.selectProcessDefinitionByDeploymentAndKey - ==> Parameters: 27501(String), myEvavtion(String)
08:55:56.388 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityImpl.selectProcessDefinitionByDeploymentAndKey - <== Total: 1
08:55:56.390 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.390 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- starting GetProcessDefinitionInfoCmd --------------------------------------------------------
08:55:56.390 [main] DEBUG org.activiti.engine.impl.interceptor.CommandContextInterceptor - Valid context found. Reusing it for the current command 'org.activiti.engine.impl.cmd.GetProcessDefinitionInfoCmd'
08:55:56.390 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.interceptor.CommandInvoker$1 added to agenda
08:55:56.393 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionInfoEntityImpl.selectProcessDefinitionInfoByProcessDefinitionId - ==> Preparing: select * from ACT_PROCDEF_INFO where PROC_DEF_ID_ = ?
08:55:56.394 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionInfoEntityImpl.selectProcessDefinitionInfoByProcessDefinitionId - ==> Parameters: myEvavtion:1:27504(String)
08:55:56.396 [main] DEBUG org.activiti.engine.impl.persistence.entity.ProcessDefinitionInfoEntityImpl.selectProcessDefinitionInfoByProcessDefinitionId - <== Total: 0
08:55:56.397 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- GetProcessDefinitionInfoCmd finished --------------------------------------------------------
08:55:56.397 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.398 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTasksByParentTaskId - ==> Preparing: select * from ACT_RU_TASK where PARENT_TASK_ID_ = ?
08:55:56.398 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTasksByParentTaskId - ==> Parameters: 30005(String)
08:55:56.400 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTasksByParentTaskId - <== Total: 0
08:55:56.400 [main] DEBUG org.activiti.engine.impl.persistence.entity.IdentityLinkEntityImpl.selectIdentityLinksByTask - ==> Preparing: select * from ACT_RU_IDENTITYLINK where TASK_ID_ = ?
08:55:56.400 [main] DEBUG org.activiti.engine.impl.persistence.entity.IdentityLinkEntityImpl.selectIdentityLinksByTask - ==> Parameters: 30005(String)
08:55:56.403 [main] DEBUG org.activiti.engine.impl.persistence.entity.IdentityLinkEntityImpl.selectIdentityLinksByTask - <== Total: 0
08:55:56.404 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: AUDIT
08:55:56.404 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.selectHistoricTaskInstance - ==> Preparing: select * from ACT_HI_TASKINST where ID_ = ?
08:55:56.404 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.selectHistoricTaskInstance - ==> Parameters: 30005(String)
08:55:56.406 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.selectHistoricTaskInstance - <== Total: 1
08:55:56.407 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.selectExecution - ==> Preparing: select E.*, S.PROC_INST_ID_ AS PARENT_PROC_INST_ID_ from ACT_RU_EXECUTION E LEFT OUTER JOIN ACT_RU_EXECUTION S ON E.SUPER_EXEC_ = S.ID_ where E.ID_ = ?
08:55:56.407 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.selectExecution - ==> Parameters: 30002(String)
08:55:56.418 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.selectExecution - <== Total: 1
08:55:56.420 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.agenda.TriggerExecutionOperation added to agenda
08:55:56.420 [main] DEBUG org.activiti.engine.impl.interceptor.CommandInvoker - Executing operation class org.activiti.engine.impl.agenda.TriggerExecutionOperation
08:55:56.420 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTasksByExecutionId - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ?
08:55:56.420 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTasksByExecutionId - ==> Parameters: 30002(String)
08:55:56.422 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.selectTasksByExecutionId - <== Total: 1
08:55:56.423 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.selectExecution - ==> Preparing: select E.*, S.PROC_INST_ID_ AS PARENT_PROC_INST_ID_ from ACT_RU_EXECUTION E LEFT OUTER JOIN ACT_RU_EXECUTION S ON E.SUPER_EXEC_ = S.ID_ where E.ID_ = ?
08:55:56.423 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.selectExecution - ==> Parameters: 30001(String)
08:55:56.426 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.selectExecution - <== Total: 1
08:55:56.428 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.agenda.TakeOutgoingSequenceFlowsOperation added to agenda
08:55:56.429 [main] DEBUG org.activiti.engine.impl.interceptor.CommandInvoker - Executing operation class org.activiti.engine.impl.agenda.TakeOutgoingSequenceFlowsOperation
08:55:56.429 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: ACTIVITY
08:55:56.432 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.selectUnfinishedHistoricActivityInstanceExecutionIdAndActivityId - ==> Preparing: select * from ACT_HI_ACTINST RES where EXECUTION_ID_ = ? and ACT_ID_ = ? and END_TIME_ is null
08:55:56.433 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.selectUnfinishedHistoricActivityInstanceExecutionIdAndActivityId - ==> Parameters: 30002(String), _3(String)
08:55:56.436 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.selectUnfinishedHistoricActivityInstanceExecutionIdAndActivityId - <== Total: 1
08:55:56.438 [main] DEBUG org.activiti.engine.impl.agenda.TakeOutgoingSequenceFlowsOperation - Leaving flow node class org.activiti.bpmn.model.UserTask with id '_3' by following it's 1 outgoing sequenceflow
08:55:56.440 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.agenda.ContinueProcessOperation added to agenda
08:55:56.440 [main] DEBUG org.activiti.engine.impl.interceptor.CommandInvoker - Executing operation class org.activiti.engine.impl.agenda.ContinueProcessOperation
08:55:56.441 [main] DEBUG org.activiti.engine.impl.agenda.ContinueProcessOperation - Sequence flow '_9' encountered. Continuing process by following it using execution 30002
08:55:56.441 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.agenda.ContinueProcessOperation added to agenda
08:55:56.442 [main] DEBUG org.activiti.engine.impl.interceptor.CommandInvoker - Executing operation class org.activiti.engine.impl.agenda.ContinueProcessOperation
08:55:56.442 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: ACTIVITY
08:55:56.443 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.443 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- starting GetNextIdBlockCmd --------------------------------------------------------
08:55:56.443 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.interceptor.CommandInvoker$1 added to agenda
08:55:56.443 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Opening JDBC Connection
08:55:56.461 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Setting autocommit to false on JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.462 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
08:55:56.462 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - ==> Parameters: next.dbid(String)
08:55:56.463 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty - <== Total: 1
08:55:56.464 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - Flushing dbSqlSession
08:55:56.465 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - update PropertyEntity[name=next.dbid, value=35001]
08:55:56.465 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - flush summary: 0 insert, 1 update, 0 delete.
08:55:56.465 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - now executing flush...
08:55:56.465 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - updating: PropertyEntity[name=next.dbid, value=35001]
08:55:56.465 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.updateProperty - ==> Preparing: update ACT_GE_PROPERTY SET REV_ = ?, VALUE_ = ? where NAME_ = ? and REV_ = ?
08:55:56.466 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.updateProperty - ==> Parameters: 15(Integer), 35001(String), next.dbid(String), 14(Integer)
08:55:56.467 [main] DEBUG org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.updateProperty - <== Updates: 1
08:55:56.467 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committing...
08:55:56.467 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - committing the ibatis sql session...
08:55:56.468 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Committing JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.474 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committed...
08:55:56.475 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.476 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.477 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- GetNextIdBlockCmd finished --------------------------------------------------------
08:55:56.477 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
08:55:56.477 [main] DEBUG org.activiti.engine.impl.agenda.ContinueProcessOperation - Executing activityBehavior class org.activiti.engine.impl.bpmn.behavior.UserTaskActivityBehavior on activity '_4' with execution 30002
08:55:56.560 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: AUDIT
08:55:56.560 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: AUDIT
08:55:56.560 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: ACTIVITY
08:55:56.561 [main] DEBUG org.activiti.engine.impl.history.DefaultHistoryManager - Current history level: AUDIT, level required: ACTIVITY
08:55:56.562 [main] DEBUG org.activiti.engine.impl.agenda.DefaultActivitiEngineAgenda - Operation class org.activiti.engine.impl.agenda.ExecuteInactiveBehaviorsOperation added to agenda
08:55:56.562 [main] DEBUG org.activiti.engine.impl.interceptor.CommandInvoker - Executing operation class org.activiti.engine.impl.agenda.ExecuteInactiveBehaviorsOperation
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - Flushing dbSqlSession
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - insert HistoricActivityInstanceEntity[id=32501, activityId=_4, activityName=经理审核]
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - insert org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl@4abf3f0
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - insert Task[id=32502, name=经理审核]
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - update HistoricActivityInstanceEntity[id=30004, activityId=_3, activityName=发起出差审核]
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - update org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl@4e4c3a38
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - update Execution[ id '30002' ] - activity '_4 - parent '30001'
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - delete Task[id=30005, name=发起出差审核] with id 30005
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - flush summary: 3 insert, 3 update, 1 delete.
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - now executing flush...
08:55:56.563 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - inserting: org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl@4abf3f0
08:55:56.563 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.insertHistoricTaskInstance - ==> Preparing: insert into ACT_HI_TASKINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_, CATEGORY_, TENANT_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
08:55:56.568 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.insertHistoricTaskInstance - ==> Parameters: 32502(String), myEvavtion:1:27504(String), 30001(String), 30002(String), 经理审核(String), null, null, null, null, 2021-05-16 08:55:56.56(Timestamp), null, null, null, null, _4(String), null, 50(Integer), null, null, (String)
08:55:56.570 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.insertHistoricTaskInstance - <== Updates: 1
08:55:56.570 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - inserting: HistoricActivityInstanceEntity[id=32501, activityId=_4, activityName=经理审核]
08:55:56.570 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.insertHistoricActivityInstance - ==> Preparing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TENANT_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
08:55:56.572 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.insertHistoricActivityInstance - ==> Parameters: 32501(String), myEvavtion:1:27504(String), 30001(String), 30002(String), _4(String), 32502(String), null, 经理审核(String), userTask(String), null, 2021-05-16 08:55:56.477(Timestamp), null, null, null, (String)
08:55:56.573 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.insertHistoricActivityInstance - <== Updates: 1
08:55:56.574 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - inserting: Task[id=32502, name=经理审核]
08:55:56.574 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.insertTask - ==> Preparing: insert into ACT_RU_TASK (ID_, REV_, NAME_, BUSINESS_KEY_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_, ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_KEY_, DUE_DATE_, CATEGORY_, SUSPENSION_STATE_, TENANT_ID_, FORM_KEY_, CLAIM_TIME_, APP_VERSION_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
08:55:56.575 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.insertTask - ==> Parameters: 32502(String), 经理审核(String), null, null, null, 50(Integer), 2021-05-16 08:55:56.477(Timestamp), null, null, null, 30002(String), 30001(String), myEvavtion:1:27504(String), _4(String), null, null, 1(Integer), (String), null, null, null
08:55:56.577 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.insertTask - <== Updates: 1
08:55:56.577 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - updating: HistoricActivityInstanceEntity[id=30004, activityId=_3, activityName=发起出差审核]
08:55:56.577 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.updateHistoricActivityInstance - ==> Preparing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ? where ID_ = ?
08:55:56.578 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.updateHistoricActivityInstance - ==> Parameters: 30002(String), null, 2021-05-16 08:55:56.437(Timestamp), 52070542(Long), null, 30004(String)
08:55:56.579 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricActivityInstanceEntityImpl.updateHistoricActivityInstance - <== Updates: 1
08:55:56.580 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - updating: org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl@4e4c3a38
08:55:56.580 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.updateHistoricTaskInstance - ==> Preparing: update ACT_HI_TASKINST set PROC_DEF_ID_ = ?, EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, CLAIM_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, FORM_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ?, CATEGORY_ = ? where ID_ = ?
08:55:56.581 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.updateHistoricTaskInstance - ==> Parameters: myEvavtion:1:27504(String), 30002(String), 发起出差审核(String), null, null, null, (String), null, 2021-05-16 08:55:56.407(Timestamp), 52070459(Long), null, _3(String), null, 50(Integer), null, null, 30005(String)
08:55:56.582 [main] DEBUG org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntityImpl.updateHistoricTaskInstance - <== Updates: 1
08:55:56.582 [main] DEBUG org.activiti.engine.impl.db.DbSqlSession - updating: Execution[ id '30002' ] - activity '_4 - parent '30001'
08:55:56.582 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.updateExecution - ==> Preparing: update ACT_RU_EXECUTION set REV_ = ?, BUSINESS_KEY_ = ?, PROC_DEF_ID_ = ?, ACT_ID_ = ?, IS_ACTIVE_ = ?, IS_CONCURRENT_ = ?, IS_SCOPE_ = ?, IS_EVENT_SCOPE_ = ?, IS_MI_ROOT_ = ?, PARENT_ID_ = ?, SUPER_EXEC_ = ?, ROOT_PROC_INST_ID_ = ?, SUSPENSION_STATE_ = ?, NAME_ = ?, IS_COUNT_ENABLED_ = ?, EVT_SUBSCR_COUNT_ = ?, TASK_COUNT_ = ?, JOB_COUNT_ = ?, TIMER_JOB_COUNT_ = ?, SUSP_JOB_COUNT_ = ?, DEADLETTER_JOB_COUNT_ = ?, VAR_COUNT_ = ?, ID_LINK_COUNT_ = ?, APP_VERSION_ = ? where ID_ = ? and REV_ = ?
08:55:56.584 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.updateExecution - ==> Parameters: 2(Integer), null, myEvavtion:1:27504(String), _4(String), true(Boolean), false(Boolean), false(Boolean), false(Boolean), false(Boolean), 30001(String), null, 30001(String), 1(Integer), null, false(Boolean), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), 0(Integer), null, 30002(String), 1(Integer)
08:55:56.587 [main] DEBUG org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl.updateExecution - <== Updates: 1
08:55:56.587 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.deleteTask - ==> Preparing: delete from ACT_RU_TASK where ID_ = ? and REV_ = ?
08:55:56.587 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.deleteTask - ==> Parameters: 30005(String), 1(Integer)
08:55:56.589 [main] DEBUG org.activiti.engine.impl.persistence.entity.TaskEntityImpl.deleteTask - <== Updates: 1
08:55:56.589 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committing...
08:55:56.589 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - committing the ibatis sql session...
08:55:56.590 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Committing JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.598 [main] DEBUG org.activiti.engine.impl.cfg.standalone.StandaloneMybatisTransactionContext - firing event committed...
08:55:56.599 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Resetting autocommit to true on JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.600 [main] DEBUG org.apache.ibatis.transaction.jdbc.JdbcTransaction - Closing JDBC Connection [jdbc:mysql://localhost:3306/activiti?characterEncoding=utf8&serverTimezone=GMT&nullCatalogMeansCurrent=true, UserName=root@localhost, MySQL Connector/J]
08:55:56.601 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor - --- CompleteTaskCmd finished --------------------------------------------------------
08:55:56.601 [main] DEBUG org.activiti.engine.impl.interceptor.LogInterceptor -
Process finished with exit code 0