search

flowable / flowable-engine

A compact and highly efficient workflow and Business Process Management (BPM) platform for developers, system admins and business users.
https://www.flowable.org
Apache License 2.0
7.95k stars 2.62k forks source link

Flowable all-in-one docker image does not have REST API #1958

Closed prabhushan closed 3 years ago

prabhushan commented 5 years ago

Describe the bug Installed flowable engine using docker run -p8080:8080 flowable/all-in-one But i could access only process tasks as REST. curl -i 'http://admin:test@localhost:8080/flowable-task/process-api/repository/deployments' but no user management etc.

Expected behavior Expected to have user API also in the all-in-one docker. Should I run REST separately? Can i have 2 dockers running with same database? So i can have modeler UI and also REST API. Code If applicable, add the code that you are using when having the issue.

Additional context Flowable as REST

unamanic commented 5 years ago

The Task app should have all of the REST endpoints. During startup you should see something like the following showing where they are mapped:

o.s.b.w.servlet.ServletRegistrationBean  : Servlet Flowable IDM Rest API mapped to [/idm-api/*]
o.s.b.w.servlet.ServletRegistrationBean  : Servlet Flowable Form Rest API mapped to [/form-api/*]
o.s.b.w.servlet.ServletRegistrationBean  : Servlet Flowable DMN Rest API mapped to [/dmn-api/*]
o.s.b.w.servlet.ServletRegistrationBean  : Servlet Flowable Content Rest API mapped to [/content-api/*]
o.s.b.w.servlet.ServletRegistrationBean  : Servlet Flowable CMMN Rest API mapped to [/cmmn-api/*]
o.s.b.w.servlet.ServletRegistrationBean  : Servlet Flowable BPMN Rest API mapped to [/process-api/*]

While there is no need to run the Flowable-Rest app separately, Flowable was designed to allow multiple instances to connect to the same database. This allows it to scale horizontally as you add new instances. For further assistance setting up a multi-instance configuration, I would suggest you head over to https://forum.flowable.org

prabhushan commented 5 years ago

Thanks for the quick turn around.

I see only the following in logs

26-Sep-2019 14:35:17.243 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [56,534] milliseconds 2019-09-26 14:35:17.366 INFO 1 --- [nio-8080-exec-2] o.s.w.s.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2019-09-26 14:35:17.377 INFO 1 --- [nio-8080-exec-2] o.s.w.s.DispatcherServlet : Completed initialization in 10 ms 2019-09-26 14:47:07.412 INFO 1 --- [nio-8080-exec-3] o.s.w.s.DispatcherServlet : Initializing Servlet 'Flowable BPMN Rest API' 2019-09-26 14:47:08.148 INFO 1 --- [nio-8080-exec-3] o.s.w.s.DispatcherServlet : Completed initialization in 735 ms 2019-09-26 15:00:28.486 INFO 1 --- [nio-8080-exec-9] o.s.w.s.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2019-09-26 15:00:28.510 INFO 1 --- [nio-8080-exec-9] o.s.w.s.DispatcherServlet : Completed initialization in 23 ms 2019-09-26 15:00:34.341 INFO 1 --- [nio-8080-exec-3] o.s.w.s.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2019-09-26 15:00:34.346 INFO 1 --- [nio-8080-exec-3] o.s.w.s.DispatcherServlet : Completed initialization in 4 ms 2019-09-26 15:00:41.630 INFO 1 --- [nio-8080-exec-5] o.s.w.s.DispatcherServlet : Initializing Servlet 'Flowable App Rest API' 2019-09-26 15:00:41.763 INFO 1 --- [nio-8080-exec-5] o.s.w.s.DispatcherServlet : Completed initialization in 131 ms 2019-09-26 15:00:42.848 INFO 1 --- [nio-8080-exec-6] o.s.w.s.DispatcherServlet : Initializing Servlet 'Flowable CMMN Rest API' 2019-09-26 15:00:43.257 INFO 1 --- [nio-8080-exec-6] o.s.w.s.DispatcherServlet : Completed initialization in 408 ms 2019-09-26 15:00:44.062 INFO 1 --- [nio-8080-exec-4] o.s.w.s.DispatcherServlet : Initializing Servlet 'Flowable Form Rest API' 2019-09-26 15:00:44.193 INFO 1 --- [nio-8080-exec-4] o.s.w.s.DispatcherServlet : Completed initialization in 130 ms 2019-09-26 15:00:45.251 INFO 1 --- [nio-8080-exec-5] o.s.w.s.DispatcherServlet : Initializing Servlet 'Flowable DMN Rest API' 2019-09-26 15:00:45.399 INFO 1 --- [nio-8080-exec-5] o.s.w.s.DispatcherServlet : Completed initialization in 148 ms 2019-09-26 15:00:46.022 INFO 1 --- [io-8080-exec-10] o.s.w.s.DispatcherServlet : Initializing Servlet 'Flowable Content Rest API'

If you see i have users as per screen shot Screen Shot 2019-09-26 at 1 13 06 PM

But I do not get the response when i do the following curl http://admin:test@localhost:8080/flowable-task/idm-api/identity/users {"timestamp":"2019-09-26T17:13:50.787+0000","status":404,"error":"Not Found","message":"No message available","path":"/flowable-task/idm-api/identity/users"}

On changing the context path to process-api I see some response.. Still no users though. curl http://admin:test@localhost:8080/flowable-task/process-api/identity/users {"data":[],"total":0,"start":0,"sort":"id","order":"asc","size":0}

Appreciate your help ..

Robinyo commented 4 years ago

Hmmm ...

docker run -d --name flowable \
  -p 8080:8080 \
  --env-file ldap-env.txt \
  flowable/all-in-one:6.5.0.event-SNAPSHOT
docker logs flowable

Output:


    //////////          &&&& &&&                                          ,,,         ,,,
  //////////////     &&&&&&& &&&                                          ,,,         ,,,
 ///          ///   &&&      &&&                                          ,,,         ,,,
 ////////     ///   &&&&&&&& &&&   &&&&&&&   &&&   &&&    &&&  ,,,,,,,,,, ,,,,,,,,,   ,,,   ,,,,,,,
 //////   //  ///   &&&&&&&& &&& &&&&   &&&& &&&   &&&    &&& ,,,    ,,,, ,,,,   ,,,, ,,, ,,,    ,,
 ///    ////  ///   &&&      &&& &&&     &&& &&&   &&&    &&& ,,      ,,, ,,,     ,,, ,,, ,,,,,,,,,
 //    /////  ///   &&&      &&& &&&    &&&& &&&   &&&    &&& ,,,    ,,,, ,,,,    ,,, ,,, ,,,
     ///////////    &&&      &&&  &&&&&&&&    &&&&&&&&&&&&&&   ,,,,,,,,,,   ,,,,,,,,  ,,,  ,,,,,,,,

  :: Flowable :: (v6.5.0-SNAPSHOT)    :: Spring Boot ::  (v2.2.2.RELEASE)

2020-01-07 02:23:53.715  INFO 1 --- [           main] o.f.u.m.a.FlowableModelerApplication     : Starting FlowableModelerApplication v6.5.0-SNAPSHOT on 25d7e898c602 with PID 1 (/opt/tomcat/webapps/flowable-modeler/WEB-INF/classes started by tomcat in /opt/tomcat)
2020-01-07 02:23:53.735  INFO 1 --- [           main] o.f.u.m.a.FlowableModelerApplication     : No active profile set, falling back to default profiles: default
2020-01-07 02:23:56.519  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:23:56.564  INFO 1 --- [           main] o.s.w.c.ContextLoader                    : Root WebApplicationContext: initialization completed in 2542 ms
2020-01-07 02:23:56.665  WARN 1 --- [           main] uration$JodaDateTimeJacksonConfiguration : Auto-configuration of Jackson's Joda-Time integration is deprecated in favor of using java.time (JSR-310).
2020-01-07 02:23:57.537  INFO 1 --- [           main] c.z.h.HikariDataSource                   : flowable-ui-modeler - Starting...
2020-01-07 02:23:57.979  INFO 1 --- [           main] c.z.h.HikariDataSource                   : flowable-ui-modeler - Start completed.
2020-01-07 02:23:57.992  INFO 1 --- [           main] o.f.u.m.c.DatabaseConfiguration          : database product name: 'H2'
2020-01-07 02:23:57.993  INFO 1 --- [           main] o.f.u.m.c.DatabaseConfiguration          : using database type: h2
2020-01-07 02:23:58.933  INFO 1 --- [           main] o.f.u.m.c.DatabaseConfiguration          : Configuring Liquibase
2020-01-07 02:23:59.639  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_DE_DATABASECHANGELOGLOCK
2020-01-07 02:23:59.656  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DE_DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_ACT_DE_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2020-01-07 02:23:59.660  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_DE_DATABASECHANGELOGLOCK
2020-01-07 02:23:59.664  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : DELETE FROM PUBLIC.ACT_DE_DATABASECHANGELOGLOCK
2020-01-07 02:23:59.665  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DE_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2020-01-07 02:23:59.667  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT LOCKED FROM PUBLIC.ACT_DE_DATABASECHANGELOGLOCK WHERE ID=1
2020-01-07 02:23:59.676  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully acquired change log lock
2020-01-07 02:24:00.854  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: PUBLIC.ACT_DE_DATABASECHANGELOG
2020-01-07 02:24:00.855  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DE_DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2020-01-07 02:24:00.857  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_DE_DATABASECHANGELOG
2020-01-07 02:24:00.857  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.ACT_DE_DATABASECHANGELOG
2020-01-07 02:24:00.858  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT * FROM PUBLIC.ACT_DE_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-01-07 02:24:00.859  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_DE_DATABASECHANGELOGLOCK
2020-01-07 02:24:00.920  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DE_MODEL (id VARCHAR(255) NOT NULL, name VARCHAR(400) NOT NULL, model_key VARCHAR(400) NOT NULL, description VARCHAR(4000), model_comment VARCHAR(4000), created TIMESTAMP, created_by VARCHAR(255), last_updated TIMESTAMP, last_updated_by VARCHAR(255), version INT, model_editor_json CLOB, thumbnail BLOB, model_type INT, CONSTRAINT PK_ACT_DE_MODEL PRIMARY KEY (id))
2020-01-07 02:24:00.925  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_DE_MODEL created
2020-01-07 02:24:00.926  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.idx_proc_mod_created ON PUBLIC.ACT_DE_MODEL(created_by)
2020-01-07 02:24:00.928  INFO 1 --- [           main] l.c.ChangeSet                            : Index idx_proc_mod_created created
2020-01-07 02:24:00.929  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DE_MODEL_HISTORY (id VARCHAR(255) NOT NULL, name VARCHAR(400) NOT NULL, model_key VARCHAR(400) NOT NULL, description VARCHAR(4000), model_comment VARCHAR(4000), created TIMESTAMP, created_by VARCHAR(255), last_updated TIMESTAMP, last_updated_by VARCHAR(255), removal_date TIMESTAMP, version INT, model_editor_json CLOB, model_id VARCHAR(255) NOT NULL, model_type INT, CONSTRAINT PK_ACT_DE_MODEL_HISTORY PRIMARY KEY (id))
2020-01-07 02:24:00.932  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_DE_MODEL_HISTORY created
2020-01-07 02:24:00.932  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.idx_proc_mod_history_proc ON PUBLIC.ACT_DE_MODEL_HISTORY(model_id)
2020-01-07 02:24:00.933  INFO 1 --- [           main] l.c.ChangeSet                            : Index idx_proc_mod_history_proc created
2020-01-07 02:24:00.934  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DE_MODEL_RELATION (id VARCHAR(255) NOT NULL, parent_model_id VARCHAR(255), model_id VARCHAR(255), relation_type VARCHAR(255), CONSTRAINT PK_ACT_DE_MODEL_RELATION PRIMARY KEY (id))
2020-01-07 02:24:00.935  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_DE_MODEL_RELATION created
2020-01-07 02:24:00.936  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_DE_MODEL_RELATION ADD CONSTRAINT fk_relation_parent FOREIGN KEY (parent_model_id) REFERENCES PUBLIC.ACT_DE_MODEL (id)
2020-01-07 02:24:00.945  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_DE_MODEL_RELATION (parent_model_id)
2020-01-07 02:24:00.946  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_DE_MODEL_RELATION ADD CONSTRAINT fk_relation_child FOREIGN KEY (model_id) REFERENCES PUBLIC.ACT_DE_MODEL (id)
2020-01-07 02:24:00.948  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_DE_MODEL_RELATION (model_id)
2020-01-07 02:24:00.948  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet META-INF/liquibase/flowable-modeler-app-db-changelog.xml::1::flowable ran successfully in 34ms
2020-01-07 02:24:00.950  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT MAX(ORDEREXECUTED) FROM PUBLIC.ACT_DE_DATABASECHANGELOG
2020-01-07 02:24:00.961  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DE_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'flowable', 'META-INF/liquibase/flowable-modeler-app-db-changelog.xml', NOW(), 1, '8:e70d1d9d3899a734296b2514ccc71501', 'createTable tableName=ACT_DE_MODEL; createIndex indexName=idx_proc_mod_created, tableName=ACT_DE_MODEL; createTable tableName=ACT_DE_MODEL_HISTORY; createIndex indexName=idx_proc_mod_history_proc, tableName=ACT_DE_MODEL_HISTORY; createTable tableN...', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363840859')
2020-01-07 02:24:00.964  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_DE_MODEL ADD tenant_id VARCHAR(255)
2020-01-07 02:24:00.976  INFO 1 --- [           main] l.c.ChangeSet                            : Columns tenant_id(varchar(255)) added to ACT_DE_MODEL
2020-01-07 02:24:00.977  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_DE_MODEL_HISTORY ADD tenant_id VARCHAR(255)
2020-01-07 02:24:00.982  INFO 1 --- [           main] l.c.ChangeSet                            : Columns tenant_id(varchar(255)) added to ACT_DE_MODEL_HISTORY
2020-01-07 02:24:00.982  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet META-INF/liquibase/flowable-modeler-app-db-changelog.xml::3::flowable ran successfully in 19ms
2020-01-07 02:24:00.984  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DE_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('3', 'flowable', 'META-INF/liquibase/flowable-modeler-app-db-changelog.xml', NOW(), 2, '8:3a9143bef2e45f2316231cc1369138b6', 'addColumn tableName=ACT_DE_MODEL; addColumn tableName=ACT_DE_MODEL_HISTORY', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363840859')
2020-01-07 02:24:00.986  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully released change log lock
2020-01-07 02:24:01.370  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: Ant [pattern='/api/**'], [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@5b3d20cc, org.springframework.security.web.context.SecurityContextPersistenceFilter@1b621efe, org.springframework.security.web.header.HeaderWriterFilter@79ed2670, org.springframework.security.web.authentication.logout.LogoutFilter@452946df, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@632fce34, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@65cb9158, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@4e51d06e, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@2f94abcc, org.springframework.security.web.session.SessionManagementFilter@783f8e9b, org.springframework.security.web.access.ExceptionTranslationFilter@71e70f8d, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@24415283]
2020-01-07 02:24:01.384  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: org.flowable.ui.common.security.ActuatorRequestMatcher@1b3d68b6, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@5c33ab81, org.springframework.security.web.context.SecurityContextPersistenceFilter@4d0cb2c5, org.springframework.security.web.header.HeaderWriterFilter@526d278, org.springframework.security.web.authentication.logout.LogoutFilter@23d06658, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@77f0b0de, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@2189ac45, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@128f0f1e, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@558c3671, org.springframework.security.web.session.SessionManagementFilter@13814eba, org.springframework.security.web.access.ExceptionTranslationFilter@14df06df, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@2d349056]
2020-01-07 02:24:01.388  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@3f2919c7, org.springframework.security.web.context.SecurityContextPersistenceFilter@f51c595, org.springframework.security.web.header.HeaderWriterFilter@7f475bd5, org.springframework.security.web.authentication.logout.LogoutFilter@4411aea2, org.flowable.ui.common.filter.FlowableCookieFilter@7f8510d3, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@41717985, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@4ad1b8d, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@7a4c28d, org.springframework.security.web.session.SessionManagementFilter@78a724c3, org.springframework.security.web.access.ExceptionTranslationFilter@72b79b29, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@3a4d2ad]
2020-01-07 02:24:01.983  INFO 1 --- [           main] o.s.s.c.ThreadPoolTaskExecutor           : Initializing ExecutorService 'applicationTaskExecutor'
2020-01-07 02:24:02.158  INFO 1 --- [           main] o.s.b.a.w.s.WelcomePageHandlerMapping    : Adding welcome page: class path resource [static/index.html]
2020-01-07 02:24:02.414  INFO 1 --- [           main] o.s.b.a.e.w.EndpointLinksResolver        : Exposing 13 endpoint(s) beneath base path '/actuator'
2020-01-07 02:24:02.592  INFO 1 --- [           main] o.f.u.m.a.FlowableModelerApplication     : Started FlowableModelerApplication in 9.871 seconds (JVM running for 15.411)
2020-01-07 02:24:02.768  INFO 1 --- [           main] o.s.w.s.DispatcherServlet                : Initializing Servlet 'Flowable Modeler App API Servlet'
2020-01-07 02:24:02.865  INFO 1 --- [           main] o.s.w.s.DispatcherServlet                : Completed initialization in 97 ms

    //////////          &&&& &&&                                          ,,,         ,,,
  //////////////     &&&&&&& &&&                                          ,,,         ,,,
 ///          ///   &&&      &&&                                          ,,,         ,,,
 ////////     ///   &&&&&&&& &&&   &&&&&&&   &&&   &&&    &&&  ,,,,,,,,,, ,,,,,,,,,   ,,,   ,,,,,,,
 //////   //  ///   &&&&&&&& &&& &&&&   &&&& &&&   &&&    &&& ,,,    ,,,, ,,,,   ,,,, ,,, ,,,    ,,
 ///    ////  ///   &&&      &&& &&&     &&& &&&   &&&    &&& ,,      ,,, ,,,     ,,, ,,, ,,,,,,,,,
 //    /////  ///   &&&      &&& &&&    &&&& &&&   &&&    &&& ,,,    ,,,, ,,,,    ,,, ,,, ,,,
     ///////////    &&&      &&&  &&&&&&&&    &&&&&&&&&&&&&&   ,,,,,,,,,,   ,,,,,,,,  ,,,  ,,,,,,,,

  :: Flowable :: (v6.5.0-SNAPSHOT)    :: Spring Boot ::  (v2.2.2.RELEASE)

2020-01-07 02:24:05.887  INFO 1 --- [           main] o.f.u.i.a.FlowableIdmApplication         : Starting FlowableIdmApplication v6.5.0-SNAPSHOT on 25d7e898c602 with PID 1 (/opt/tomcat/webapps/flowable-idm/WEB-INF/classes started by tomcat in /opt/tomcat)
2020-01-07 02:24:05.898  INFO 1 --- [           main] o.f.u.i.a.FlowableIdmApplication         : No active profile set, falling back to default profiles: default
2020-01-07 02:24:07.973  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.security.config.annotation.configuration.ObjectPostProcessorConfiguration' of type [org.springframework.security.config.annotation.configuration.ObjectPostProcessorConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:07.980  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.008  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'objectPostProcessor' of type [org.springframework.security.config.annotation.configuration.AutowireBeanFactoryObjectPostProcessor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.010  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler@72e474f1' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.012  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.security.config.annotation.method.configuration.GlobalMethodSecurityConfiguration' of type [org.springframework.security.config.annotation.method.configuration.GlobalMethodSecurityConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.018  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.flowable.ui.common.properties.FlowableRemoteIdmAutoConfiguration' of type [org.flowable.ui.common.properties.FlowableRemoteIdmAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.060  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'flowable.common.app-org.flowable.ui.common.properties.FlowableCommonAppProperties' of type [org.flowable.ui.common.properties.FlowableCommonAppProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.063  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'grantedAuthorityDefaults' of type [org.springframework.security.config.core.GrantedAuthorityDefaults] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.066  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.security.config.annotation.method.configuration.Jsr250MetadataSourceConfiguration' of type [org.springframework.security.config.annotation.method.configuration.Jsr250MetadataSourceConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.071  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jsr250MethodSecurityMetadataSource' of type [org.springframework.security.access.annotation.Jsr250MethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.074  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'methodSecurityMetadataSource' of type [org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:08.102  INFO 1 --- [           main] o.s.w.c.ContextLoader                    : Root WebApplicationContext: initialization completed in 1955 ms
2020-01-07 02:24:08.927  INFO 1 --- [           main] c.z.h.HikariDataSource                   : flowable-ui-idm - Starting...
2020-01-07 02:24:09.110  INFO 1 --- [           main] c.z.h.HikariDataSource                   : flowable-ui-idm - Start completed.
2020-01-07 02:24:09.655  INFO 1 --- [           main] o.f.i.e.i.d.IdmDbSchemaManager           : performing create on identity with resource org/flowable/idm/db/create/flowable.h2.create.identity.sql
2020-01-07 02:24:09.687  INFO 1 --- [           main] o.f.i.e.i.IdmEngineImpl                  : IdmEngine default created
2020-01-07 02:24:09.897  INFO 1 --- [           main] u.i.s.CustomPersistentRememberMeServices : Cookie max-age set to 2678400 seconds
2020-01-07 02:24:09.898  INFO 1 --- [           main] u.i.s.CustomPersistentRememberMeServices : Cookie refresh age set to 86400 seconds
2020-01-07 02:24:09.914  INFO 1 --- [           main] u.i.s.CustomPersistentRememberMeServices : Cookie max-age set to 2678400 seconds
2020-01-07 02:24:09.915  INFO 1 --- [           main] u.i.s.CustomPersistentRememberMeServices : Cookie refresh age set to 86400 seconds
2020-01-07 02:24:09.951  WARN 1 --- [           main] uration$JodaDateTimeJacksonConfiguration : Auto-configuration of Jackson's Joda-Time integration is deprecated in favor of using java.time (JSR-310).
2020-01-07 02:24:10.187  INFO 1 --- [           main] o.s.s.c.ThreadPoolTaskExecutor           : Initializing ExecutorService 'applicationTaskExecutor'
2020-01-07 02:24:10.325  INFO 1 --- [           main] o.s.b.a.w.s.WelcomePageHandlerMapping    : Adding welcome page: class path resource [static/index.html]
2020-01-07 02:24:10.705  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: Ant [pattern='/api/**'], [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@36b0ef9c, org.springframework.security.web.context.SecurityContextPersistenceFilter@c7a9483, org.springframework.security.web.header.HeaderWriterFilter@387ded4f, org.springframework.security.web.authentication.logout.LogoutFilter@50fb4861, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@65483308, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@60ef1f1a, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@4e50d42b, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@5ed9e9f7, org.springframework.security.web.session.SessionManagementFilter@4dadab96, org.springframework.security.web.access.ExceptionTranslationFilter@d2a1a39, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@554ccf12]
2020-01-07 02:24:10.709  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: org.flowable.ui.common.security.ActuatorRequestMatcher@3c1ddc7b, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@22f4b295, org.springframework.security.web.context.SecurityContextPersistenceFilter@599f0c8d, org.springframework.security.web.header.HeaderWriterFilter@7501f05, org.springframework.security.web.authentication.logout.LogoutFilter@ee6d890, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@4b7ecf23, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@25594ae9, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@22f6d170, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@44750231, org.springframework.security.web.session.SessionManagementFilter@f4050e0, org.springframework.security.web.access.ExceptionTranslationFilter@6303e730, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@363a1ba9]
2020-01-07 02:24:10.721  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@7e580455, org.springframework.security.web.context.SecurityContextPersistenceFilter@57f1635f, org.springframework.security.web.header.HeaderWriterFilter@65b1909d, org.springframework.security.web.authentication.logout.LogoutFilter@26051540, org.flowable.ui.idm.web.CustomUsernamePasswordAuthenticationFilter@3f7689dd, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@60c73e8d, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@91b6f70, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@2d5de439, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@75eb4222, org.springframework.security.web.session.SessionManagementFilter@32e8265f, org.springframework.security.web.access.ExceptionTranslationFilter@27b2166a, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@7cd507ea]
2020-01-07 02:24:10.764  INFO 1 --- [           main] o.s.b.a.e.w.EndpointLinksResolver        : Exposing 13 endpoint(s) beneath base path '/actuator'
2020-01-07 02:24:10.950  INFO 1 --- [           main] o.f.u.i.a.FlowableIdmApplication         : Started FlowableIdmApplication in 5.651 seconds (JVM running for 23.769)
2020-01-07 02:24:11.001  INFO 1 --- [           main] o.s.w.s.DispatcherServlet                : Initializing Servlet 'Flowable IDM App API Servlet'
2020-01-07 02:24:11.128  INFO 1 --- [           main] o.s.w.s.DispatcherServlet                : Completed initialization in 127 ms

    //////////          &&&& &&&                                          ,,,         ,,,
  //////////////     &&&&&&& &&&                                          ,,,         ,,,
 ///          ///   &&&      &&&                                          ,,,         ,,,
 ////////     ///   &&&&&&&& &&&   &&&&&&&   &&&   &&&    &&&  ,,,,,,,,,, ,,,,,,,,,   ,,,   ,,,,,,,
 //////   //  ///   &&&&&&&& &&& &&&&   &&&& &&&   &&&    &&& ,,,    ,,,, ,,,,   ,,,, ,,, ,,,    ,,
 ///    ////  ///   &&&      &&& &&&     &&& &&&   &&&    &&& ,,      ,,, ,,,     ,,, ,,, ,,,,,,,,,
 //    /////  ///   &&&      &&& &&&    &&&& &&&   &&&    &&& ,,,    ,,,, ,,,,    ,,, ,,, ,,,
     ///////////    &&&      &&&  &&&&&&&&    &&&&&&&&&&&&&&   ,,,,,,,,,,   ,,,,,,,,  ,,,  ,,,,,,,,

  :: Flowable :: (v6.5.0-SNAPSHOT)    :: Spring Boot ::  (v2.2.2.RELEASE)

2020-01-07 02:24:15.996  INFO 1 --- [           main] o.f.u.t.a.FlowableTaskApplication        : Starting FlowableTaskApplication v6.5.0-SNAPSHOT on 25d7e898c602 with PID 1 (/opt/tomcat/webapps/flowable-task/WEB-INF/classes started by tomcat in /opt/tomcat)
2020-01-07 02:24:16.007  INFO 1 --- [           main] o.f.u.t.a.FlowableTaskApplication        : No active profile set, falling back to default profiles: default
2020-01-07 02:24:19.006  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:19.055  INFO 1 --- [           main] o.s.w.c.ContextLoader                    : Root WebApplicationContext: initialization completed in 2623 ms
2020-01-07 02:24:19.148  WARN 1 --- [           main] uration$JodaDateTimeJacksonConfiguration : Auto-configuration of Jackson's Joda-Time integration is deprecated in favor of using java.time (JSR-310).
2020-01-07 02:24:19.823  INFO 1 --- [           main] o.f.s.b.ProcessEngineAutoConfiguration   : No deployment resources were found for autodeployment
2020-01-07 02:24:19.852  INFO 1 --- [           main] o.s.s.c.ThreadPoolTaskExecutor           : Initializing ExecutorService 'applicationTaskExecutor'
2020-01-07 02:24:20.052  INFO 1 --- [           main] o.f.s.b.c.CmmnEngineAutoConfiguration    : No deployment resources were found for autodeployment
2020-01-07 02:24:20.179  INFO 1 --- [           main] o.f.s.b.d.DmnEngineAutoConfiguration     : No deployment resources were found for autodeployment
2020-01-07 02:24:20.233  INFO 1 --- [           main] o.f.s.b.f.FormEngineAutoConfiguration    : No deployment resources were found for autodeployment
2020-01-07 02:24:20.281  INFO 1 --- [           main] o.f.s.b.e.EventRegistryAutoConfiguration : No deployment resources were found for autodeployment
2020-01-07 02:24:20.676  INFO 1 --- [           main] o.f.s.b.a.AppEngineAutoConfiguration     : No deployment resources were found for autodeployment
2020-01-07 02:24:20.723  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Found 7 Engine Configurators in total:
2020-01-07 02:24:20.723  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2020-01-07 02:24:20.723  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator (priority:100000)
2020-01-07 02:24:20.723  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:150000)
2020-01-07 02:24:20.724  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
2020-01-07 02:24:20.724  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
2020-01-07 02:24:20.724  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
2020-01-07 02:24:20.724  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
2020-01-07 02:24:20.725  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2020-01-07 02:24:20.744  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator (priority:100000)
2020-01-07 02:24:20.750  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:150000)
2020-01-07 02:24:20.754  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
2020-01-07 02:24:20.760  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
2020-01-07 02:24:20.767  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
2020-01-07 02:24:20.770  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing beforeInit() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
2020-01-07 02:24:20.797  INFO 1 --- [           main] c.z.h.HikariDataSource                   : flowable-ui-task - Starting...
2020-01-07 02:24:21.144  INFO 1 --- [           main] c.z.h.HikariDataSource                   : flowable-ui-task - Start completed.
2020-01-07 02:24:23.242  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator (priority:50000)
2020-01-07 02:24:23.609  INFO 1 --- [           main] o.f.c.e.i.d.CommonDbSchemaManager        : performing create on common with resource org/flowable/common/db/create/flowable.h2.create.common.sql
2020-01-07 02:24:23.620  INFO 1 --- [           main] o.f.i.s.i.d.IdentityLinkDbSchemaManager  : performing create on identitylink with resource org/flowable/identitylink/service/db/create/flowable.h2.create.identitylink.sql
2020-01-07 02:24:23.625  INFO 1 --- [           main] o.f.i.s.i.d.IdentityLinkDbSchemaManager  : performing create on identitylink.history with resource org/flowable/identitylink/service/db/create/flowable.h2.create.identitylink.history.sql
2020-01-07 02:24:23.630  INFO 1 --- [           main] o.f.e.s.i.d.EntityLinkDbSchemaManager    : performing create on entitylink with resource org/flowable/entitylink/service/db/create/flowable.h2.create.entitylink.sql
2020-01-07 02:24:23.634  INFO 1 --- [           main] o.f.e.s.i.d.EntityLinkDbSchemaManager    : performing create on entitylink.history with resource org/flowable/entitylink/service/db/create/flowable.h2.create.entitylink.history.sql
2020-01-07 02:24:23.639  INFO 1 --- [           main] e.s.i.d.EventSubscriptionDbSchemaManager : performing create on eventsubscription with resource org/flowable/eventsubscription/service/db/create/flowable.h2.create.eventsubscription.sql
2020-01-07 02:24:23.644  INFO 1 --- [           main] o.f.t.s.i.d.TaskDbSchemaManager          : performing create on task with resource org/flowable/task/service/db/create/flowable.h2.create.task.sql
2020-01-07 02:24:23.647  INFO 1 --- [           main] o.f.t.s.i.d.TaskDbSchemaManager          : performing create on task.history with resource org/flowable/task/service/db/create/flowable.h2.create.task.history.sql
2020-01-07 02:24:23.656  INFO 1 --- [           main] o.f.v.s.i.d.VariableDbSchemaManager      : performing create on variable with resource org/flowable/variable/service/db/create/flowable.h2.create.variable.sql
2020-01-07 02:24:23.666  INFO 1 --- [           main] o.f.v.s.i.d.VariableDbSchemaManager      : performing create on variable.history with resource org/flowable/variable/service/db/create/flowable.h2.create.variable.history.sql
2020-01-07 02:24:23.672  INFO 1 --- [           main] o.f.j.s.i.d.JobDbSchemaManager           : performing create on job with resource org/flowable/job/service/db/create/flowable.h2.create.job.sql
2020-01-07 02:24:23.697  INFO 1 --- [           main] o.f.b.s.i.d.BatchDbSchemaManager         : performing create on batch with resource org/flowable/batch/service/db/create/flowable.h2.create.batch.sql
2020-01-07 02:24:23.702  INFO 1 --- [           main] o.f.e.i.d.ProcessDbSchemaManager         : performing create on engine with resource org/flowable/db/create/flowable.h2.create.engine.sql
2020-01-07 02:24:23.754  INFO 1 --- [           main] o.f.e.i.d.ProcessDbSchemaManager         : performing create on history with resource org/flowable/db/create/flowable.h2.create.history.sql
2020-01-07 02:24:23.768  INFO 1 --- [           main] o.f.e.i.ProcessEngineImpl                : ProcessEngine default created
2020-01-07 02:24:23.845  INFO 1 --- [           main] o.f.e.i.c.ValidateV5EntitiesCmd          : Total of v5 deployments found: 0
2020-01-07 02:24:23.853  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.eventregistry.spring.configurator.SpringEventRegistryConfigurator (priority:100000)
2020-01-07 02:24:24.411  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.FLW_EV_DATABASECHANGELOGLOCK
2020-01-07 02:24:24.427  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.FLW_EV_DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_FLW_EV_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2020-01-07 02:24:24.432  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.FLW_EV_DATABASECHANGELOGLOCK
2020-01-07 02:24:24.435  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : DELETE FROM PUBLIC.FLW_EV_DATABASECHANGELOGLOCK
2020-01-07 02:24:24.436  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.FLW_EV_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2020-01-07 02:24:24.438  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT LOCKED FROM PUBLIC.FLW_EV_DATABASECHANGELOGLOCK WHERE ID=1
2020-01-07 02:24:24.445  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully acquired change log lock
2020-01-07 02:24:25.448  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: PUBLIC.FLW_EV_DATABASECHANGELOG
2020-01-07 02:24:25.449  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.FLW_EV_DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2020-01-07 02:24:25.451  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.FLW_EV_DATABASECHANGELOG
2020-01-07 02:24:25.452  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.FLW_EV_DATABASECHANGELOG
2020-01-07 02:24:25.453  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT * FROM PUBLIC.FLW_EV_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-01-07 02:24:25.453  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.FLW_EV_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.484  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.FLW_EVENT_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), CATEGORY_ VARCHAR(255), DEPLOY_TIME_ TIMESTAMP, TENANT_ID_ VARCHAR(255), PARENT_DEPLOYMENT_ID_ VARCHAR(255), CONSTRAINT PK_FLW_EVENT_DEPLOYMENT PRIMARY KEY (ID_))
2020-01-07 02:24:25.487  INFO 1 --- [           main] l.c.ChangeSet                            : Table FLW_EVENT_DEPLOYMENT created
2020-01-07 02:24:25.488  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.FLW_EVENT_RESOURCE (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), RESOURCE_BYTES_ BLOB, CONSTRAINT PK_FLW_EVENT_RESOURCE PRIMARY KEY (ID_))
2020-01-07 02:24:25.489  INFO 1 --- [           main] l.c.ChangeSet                            : Table FLW_EVENT_RESOURCE created
2020-01-07 02:24:25.490  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.FLW_EVENT_DEFINITION (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), VERSION_ INT, KEY_ VARCHAR(255), CATEGORY_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), TENANT_ID_ VARCHAR(255), RESOURCE_NAME_ VARCHAR(255), DESCRIPTION_ VARCHAR(255), CONSTRAINT PK_FLW_EVENT_DEFINITION PRIMARY KEY (ID_))
2020-01-07 02:24:25.490  INFO 1 --- [           main] l.c.ChangeSet                            : Table FLW_EVENT_DEFINITION created
2020-01-07 02:24:25.491  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE UNIQUE INDEX PUBLIC.ACT_IDX_EVENT_DEF_UNIQ ON PUBLIC.FLW_EVENT_DEFINITION(KEY_, VERSION_, TENANT_ID_)
2020-01-07 02:24:25.492  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_EVENT_DEF_UNIQ created
2020-01-07 02:24:25.493  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.FLW_CHANNEL_DEFINITION (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), VERSION_ INT, KEY_ VARCHAR(255), CATEGORY_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), CREATE_TIME_ TIMESTAMP, TENANT_ID_ VARCHAR(255), RESOURCE_NAME_ VARCHAR(255), DESCRIPTION_ VARCHAR(255), CONSTRAINT PK_FLW_CHANNEL_DEFINITION PRIMARY KEY (ID_))
2020-01-07 02:24:25.493  INFO 1 --- [           main] l.c.ChangeSet                            : Table FLW_CHANNEL_DEFINITION created
2020-01-07 02:24:25.494  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE UNIQUE INDEX PUBLIC.ACT_IDX_CHANNEL_DEF_UNIQ ON PUBLIC.FLW_CHANNEL_DEFINITION(KEY_, VERSION_, TENANT_ID_)
2020-01-07 02:24:25.494  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_CHANNEL_DEF_UNIQ created
2020-01-07 02:24:25.494  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml::1::flowable ran successfully in 14ms
2020-01-07 02:24:25.495  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT MAX(ORDEREXECUTED) FROM PUBLIC.FLW_EV_DATABASECHANGELOG
2020-01-07 02:24:25.498  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.FLW_EV_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', NOW(), 1, '8:1b0c48c9cf7945be799d868a2626d687', 'createTable tableName=FLW_EVENT_DEPLOYMENT; createTable tableName=FLW_EVENT_RESOURCE; createTable tableName=FLW_EVENT_DEFINITION; createIndex indexName=ACT_IDX_EVENT_DEF_UNIQ, tableName=FLW_EVENT_DEFINITION; createTable tableName=FLW_CHANNEL_DEFIN...', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865454')
2020-01-07 02:24:25.502  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully released change log lock
2020-01-07 02:24:25.503  INFO 1 --- [           main] o.f.e.i.EventRegistryEngineImpl          : EventRegistryEngine default created
2020-01-07 02:24:25.513  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.idm.spring.configurator.SpringIdmEngineConfigurator (priority:150000)
2020-01-07 02:24:25.543  INFO 1 --- [           main] o.f.i.e.i.d.IdmDbSchemaManager           : performing create on identity with resource org/flowable/idm/db/create/flowable.h2.create.identity.sql
2020-01-07 02:24:25.552  INFO 1 --- [           main] o.f.i.e.i.IdmEngineImpl                  : IdmEngine default created
2020-01-07 02:24:25.555  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.dmn.spring.configurator.SpringDmnEngineConfigurator (priority:200000)
2020-01-07 02:24:25.599  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_DMN_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.600  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DMN_DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_ACT_DMN_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2020-01-07 02:24:25.602  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_DMN_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.603  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : DELETE FROM PUBLIC.ACT_DMN_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.603  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DMN_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2020-01-07 02:24:25.604  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT LOCKED FROM PUBLIC.ACT_DMN_DATABASECHANGELOGLOCK WHERE ID=1
2020-01-07 02:24:25.605  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully acquired change log lock
2020-01-07 02:24:25.627  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: PUBLIC.ACT_DMN_DATABASECHANGELOG
2020-01-07 02:24:25.628  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DMN_DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2020-01-07 02:24:25.629  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_DMN_DATABASECHANGELOG
2020-01-07 02:24:25.629  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.ACT_DMN_DATABASECHANGELOG
2020-01-07 02:24:25.630  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT * FROM PUBLIC.ACT_DMN_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-01-07 02:24:25.630  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_DMN_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.649  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DMN_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), CATEGORY_ VARCHAR(255), DEPLOY_TIME_ TIMESTAMP, TENANT_ID_ VARCHAR(255), PARENT_DEPLOYMENT_ID_ VARCHAR(255), CONSTRAINT PK_ACT_DMN_DEPLOYMENT PRIMARY KEY (ID_))
2020-01-07 02:24:25.650  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_DMN_DEPLOYMENT created
2020-01-07 02:24:25.651  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DMN_DEPLOYMENT_RESOURCE (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), RESOURCE_BYTES_ BLOB, CONSTRAINT PK_ACT_DMN_DEPLOYMENT_RESOURCE PRIMARY KEY (ID_))
2020-01-07 02:24:25.652  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_DMN_DEPLOYMENT_RESOURCE created
2020-01-07 02:24:25.653  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DMN_DECISION_TABLE (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), VERSION_ INT, KEY_ VARCHAR(255), CATEGORY_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), PARENT_DEPLOYMENT_ID_ VARCHAR(255), TENANT_ID_ VARCHAR(255), RESOURCE_NAME_ VARCHAR(255), DESCRIPTION_ VARCHAR(255), CONSTRAINT PK_ACT_DMN_DECISION_TABLE PRIMARY KEY (ID_))
2020-01-07 02:24:25.653  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_DMN_DECISION_TABLE created
2020-01-07 02:24:25.654  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml::1::activiti ran successfully in 6ms
2020-01-07 02:24:25.654  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT MAX(ORDEREXECUTED) FROM PUBLIC.ACT_DMN_DATABASECHANGELOG
2020-01-07 02:24:25.655  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'activiti', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', NOW(), 1, '8:c8701f1c71018b55029f450b2e9a10a1', 'createTable tableName=ACT_DMN_DEPLOYMENT; createTable tableName=ACT_DMN_DEPLOYMENT_RESOURCE; createTable tableName=ACT_DMN_DECISION_TABLE', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865631')
2020-01-07 02:24:25.657  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_DMN_HI_DECISION_EXECUTION (ID_ VARCHAR(255) NOT NULL, DECISION_DEFINITION_ID_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), START_TIME_ TIMESTAMP, END_TIME_ TIMESTAMP, INSTANCE_ID_ VARCHAR(255), EXECUTION_ID_ VARCHAR(255), ACTIVITY_ID_ VARCHAR(255), FAILED_ BOOLEAN DEFAULT FALSE, TENANT_ID_ VARCHAR(255), EXECUTION_JSON_ CLOB, CONSTRAINT PK_ACT_DMN_HI_DECISION_EXECUTION PRIMARY KEY (ID_))
2020-01-07 02:24:25.658  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_DMN_HI_DECISION_EXECUTION created
2020-01-07 02:24:25.658  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml::2::flowable ran successfully in 2ms
2020-01-07 02:24:25.659  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', NOW(), 2, '8:47f94b27feb7df8a30d4e338c7bd5fb8', 'createTable tableName=ACT_DMN_HI_DECISION_EXECUTION', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865631')
2020-01-07 02:24:25.660  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_DMN_HI_DECISION_EXECUTION ADD SCOPE_TYPE_ VARCHAR(255)
2020-01-07 02:24:25.669  INFO 1 --- [           main] l.c.ChangeSet                            : Columns SCOPE_TYPE_(varchar(255)) added to ACT_DMN_HI_DECISION_EXECUTION
2020-01-07 02:24:25.669  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml::3::flowable ran successfully in 10ms
2020-01-07 02:24:25.670  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('3', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', NOW(), 3, '8:ac17eae89fbdccb6e08daf3c7797b579', 'addColumn tableName=ACT_DMN_HI_DECISION_EXECUTION', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865631')
2020-01-07 02:24:25.672  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_DMN_DECISION_TABLE DROP COLUMN PARENT_DEPLOYMENT_ID_
2020-01-07 02:24:25.674  INFO 1 --- [           main] l.c.ChangeSet                            : Column ACT_DMN_DECISION_TABLE.PARENT_DEPLOYMENT_ID_ dropped
2020-01-07 02:24:25.674  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml::4::flowable ran successfully in 3ms
2020-01-07 02:24:25.675  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('4', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', NOW(), 4, '8:f73aabc4529e7292c2942073d1cff6f9', 'dropColumn columnName=PARENT_DEPLOYMENT_ID_, tableName=ACT_DMN_DECISION_TABLE', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865631')
2020-01-07 02:24:25.676  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE UNIQUE INDEX PUBLIC.ACT_IDX_DEC_TBL_UNIQ ON PUBLIC.ACT_DMN_DECISION_TABLE(KEY_, VERSION_, TENANT_ID_)
2020-01-07 02:24:25.677  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_DEC_TBL_UNIQ created
2020-01-07 02:24:25.677  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml::6::flowable ran successfully in 1ms
2020-01-07 02:24:25.678  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_DMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('6', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', NOW(), 5, '8:646c6a061e0b6e8a62e69844ff96abb0', 'createIndex indexName=ACT_IDX_DEC_TBL_UNIQ, tableName=ACT_DMN_DECISION_TABLE', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865631')
2020-01-07 02:24:25.679  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully released change log lock
2020-01-07 02:24:25.680  INFO 1 --- [           main] o.f.d.e.i.DmnEngineImpl                  : DmnEngine default created
2020-01-07 02:24:25.682  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.form.spring.configurator.SpringFormEngineConfigurator (priority:300000)
2020-01-07 02:24:25.714  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_FO_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.715  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_FO_DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_ACT_FO_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2020-01-07 02:24:25.716  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_FO_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.717  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : DELETE FROM PUBLIC.ACT_FO_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.717  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_FO_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2020-01-07 02:24:25.718  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT LOCKED FROM PUBLIC.ACT_FO_DATABASECHANGELOGLOCK WHERE ID=1
2020-01-07 02:24:25.720  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully acquired change log lock
2020-01-07 02:24:25.741  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: PUBLIC.ACT_FO_DATABASECHANGELOG
2020-01-07 02:24:25.742  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_FO_DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2020-01-07 02:24:25.743  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_FO_DATABASECHANGELOG
2020-01-07 02:24:25.743  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.ACT_FO_DATABASECHANGELOG
2020-01-07 02:24:25.744  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT * FROM PUBLIC.ACT_FO_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-01-07 02:24:25.744  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_FO_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.758  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_FO_FORM_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), CATEGORY_ VARCHAR(255), DEPLOY_TIME_ TIMESTAMP, TENANT_ID_ VARCHAR(255), PARENT_DEPLOYMENT_ID_ VARCHAR(255), CONSTRAINT PK_ACT_FO_FORM_DEPLOYMENT PRIMARY KEY (ID_))
2020-01-07 02:24:25.759  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_FO_FORM_DEPLOYMENT created
2020-01-07 02:24:25.760  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_FO_FORM_RESOURCE (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), RESOURCE_BYTES_ BLOB, CONSTRAINT PK_ACT_FO_FORM_RESOURCE PRIMARY KEY (ID_))
2020-01-07 02:24:25.760  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_FO_FORM_RESOURCE created
2020-01-07 02:24:25.761  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_FO_FORM_DEFINITION (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), VERSION_ INT, KEY_ VARCHAR(255), CATEGORY_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), PARENT_DEPLOYMENT_ID_ VARCHAR(255), TENANT_ID_ VARCHAR(255), RESOURCE_NAME_ VARCHAR(255), DESCRIPTION_ VARCHAR(255), CONSTRAINT PK_ACT_FO_FORM_DEFINITION PRIMARY KEY (ID_))
2020-01-07 02:24:25.762  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_FO_FORM_DEFINITION created
2020-01-07 02:24:25.763  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_FO_FORM_INSTANCE (ID_ VARCHAR(255) NOT NULL, FORM_DEFINITION_ID_ VARCHAR(255) NOT NULL, TASK_ID_ VARCHAR(255), PROC_INST_ID_ VARCHAR(255), PROC_DEF_ID_ VARCHAR(255), SUBMITTED_DATE_ TIMESTAMP, SUBMITTED_BY_ VARCHAR(255), FORM_VALUES_ID_ VARCHAR(255), TENANT_ID_ VARCHAR(255), CONSTRAINT PK_ACT_FO_FORM_INSTANCE PRIMARY KEY (ID_))
2020-01-07 02:24:25.763  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_FO_FORM_INSTANCE created
2020-01-07 02:24:25.763  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/form/db/liquibase/flowable-form-db-changelog.xml::1::activiti ran successfully in 6ms
2020-01-07 02:24:25.764  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT MAX(ORDEREXECUTED) FROM PUBLIC.ACT_FO_DATABASECHANGELOG
2020-01-07 02:24:25.765  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_FO_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'activiti', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', NOW(), 1, '8:033ebf9380889aed7c453927ecc3250d', 'createTable tableName=ACT_FO_FORM_DEPLOYMENT; createTable tableName=ACT_FO_FORM_RESOURCE; createTable tableName=ACT_FO_FORM_DEFINITION; createTable tableName=ACT_FO_FORM_INSTANCE', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865745')
2020-01-07 02:24:25.767  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_FO_FORM_INSTANCE ADD SCOPE_ID_ VARCHAR(255)
2020-01-07 02:24:25.769  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_FO_FORM_INSTANCE ADD SCOPE_TYPE_ VARCHAR(255)
2020-01-07 02:24:25.772  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_FO_FORM_INSTANCE ADD SCOPE_DEFINITION_ID_ VARCHAR(255)
2020-01-07 02:24:25.774  INFO 1 --- [           main] l.c.ChangeSet                            : Columns SCOPE_ID_(varchar(255)),SCOPE_TYPE_(varchar(255)),SCOPE_DEFINITION_ID_(varchar(255)) added to ACT_FO_FORM_INSTANCE
2020-01-07 02:24:25.774  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/form/db/liquibase/flowable-form-db-changelog.xml::2::flowable ran successfully in 8ms
2020-01-07 02:24:25.776  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_FO_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', NOW(), 2, '8:986365ceb40445ce3b27a8e6b40f159b', 'addColumn tableName=ACT_FO_FORM_INSTANCE', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865745')
2020-01-07 02:24:25.777  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_FO_FORM_DEFINITION DROP COLUMN PARENT_DEPLOYMENT_ID_
2020-01-07 02:24:25.779  INFO 1 --- [           main] l.c.ChangeSet                            : Column ACT_FO_FORM_DEFINITION.PARENT_DEPLOYMENT_ID_ dropped
2020-01-07 02:24:25.780  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/form/db/liquibase/flowable-form-db-changelog.xml::3::flowable ran successfully in 3ms
2020-01-07 02:24:25.781  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_FO_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('3', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', NOW(), 3, '8:abf482518ceb09830ef674e52c06bf15', 'dropColumn columnName=PARENT_DEPLOYMENT_ID_, tableName=ACT_FO_FORM_DEFINITION', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865745')
2020-01-07 02:24:25.783  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE UNIQUE INDEX PUBLIC.ACT_IDX_FORM_DEF_UNIQ ON PUBLIC.ACT_FO_FORM_DEFINITION(KEY_, VERSION_, TENANT_ID_)
2020-01-07 02:24:25.783  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_FORM_DEF_UNIQ created
2020-01-07 02:24:25.784  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/form/db/liquibase/flowable-form-db-changelog.xml::5::flowable ran successfully in 2ms
2020-01-07 02:24:25.785  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_FO_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('5', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', NOW(), 4, '8:b4be732b89e5ca028bdd520c6ad4d446', 'createIndex indexName=ACT_IDX_FORM_DEF_UNIQ, tableName=ACT_FO_FORM_DEFINITION', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865745')
2020-01-07 02:24:25.786  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully released change log lock
2020-01-07 02:24:25.787  INFO 1 --- [           main] o.f.f.e.i.FormEngineImpl                 : FormEngine default created
2020-01-07 02:24:25.789  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.content.spring.configurator.SpringContentEngineConfigurator (priority:400000)
2020-01-07 02:24:25.798  INFO 1 --- [           main] o.f.c.s.SpringContentEngineConfiguration : Content file system root : /opt/tomcat/data
2020-01-07 02:24:25.802  INFO 1 --- [           main] f.c.e.i.f.SimpleFileSystemContentStorage : Created content folder in /opt/tomcat/data/task-content
2020-01-07 02:24:25.802  INFO 1 --- [           main] f.c.e.i.f.SimpleFileSystemContentStorage : Created content folder in /opt/tomcat/data/process-instance-content
2020-01-07 02:24:25.802  INFO 1 --- [           main] f.c.e.i.f.SimpleFileSystemContentStorage : Created content folder in /opt/tomcat/data/cmmn
2020-01-07 02:24:25.802  INFO 1 --- [           main] f.c.e.i.f.SimpleFileSystemContentStorage : Created content folder in /opt/tomcat/data/uncategorized
2020-01-07 02:24:25.817  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_CO_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.818  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CO_DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_ACT_CO_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2020-01-07 02:24:25.820  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_CO_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.820  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : DELETE FROM PUBLIC.ACT_CO_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.820  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CO_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2020-01-07 02:24:25.821  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT LOCKED FROM PUBLIC.ACT_CO_DATABASECHANGELOGLOCK WHERE ID=1
2020-01-07 02:24:25.822  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully acquired change log lock
2020-01-07 02:24:25.838  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: PUBLIC.ACT_CO_DATABASECHANGELOG
2020-01-07 02:24:25.838  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CO_DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2020-01-07 02:24:25.839  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_CO_DATABASECHANGELOG
2020-01-07 02:24:25.840  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.ACT_CO_DATABASECHANGELOG
2020-01-07 02:24:25.840  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT * FROM PUBLIC.ACT_CO_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-01-07 02:24:25.840  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_CO_DATABASECHANGELOGLOCK
2020-01-07 02:24:25.849  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CO_CONTENT_ITEM (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255) NOT NULL, MIME_TYPE_ VARCHAR(255), TASK_ID_ VARCHAR(255), PROC_INST_ID_ VARCHAR(255), CONTENT_STORE_ID_ VARCHAR(255), CONTENT_STORE_NAME_ VARCHAR(255), FIELD_ VARCHAR(400), CONTENT_AVAILABLE_ BOOLEAN DEFAULT FALSE, CREATED_ TIMESTAMP(6), CREATED_BY_ VARCHAR(255), LAST_MODIFIED_ TIMESTAMP(6), LAST_MODIFIED_BY_ VARCHAR(255), CONTENT_SIZE_ BIGINT DEFAULT 0, TENANT_ID_ VARCHAR(255), CONSTRAINT PK_ACT_CO_CONTENT_ITEM PRIMARY KEY (ID_))
2020-01-07 02:24:25.849  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CO_CONTENT_ITEM created
2020-01-07 02:24:25.850  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.idx_contitem_taskid ON PUBLIC.ACT_CO_CONTENT_ITEM(TASK_ID_)
2020-01-07 02:24:25.850  INFO 1 --- [           main] l.c.ChangeSet                            : Index idx_contitem_taskid created
2020-01-07 02:24:25.850  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.idx_contitem_procid ON PUBLIC.ACT_CO_CONTENT_ITEM(PROC_INST_ID_)
2020-01-07 02:24:25.851  INFO 1 --- [           main] l.c.ChangeSet                            : Index idx_contitem_procid created
2020-01-07 02:24:25.851  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/content/db/liquibase/flowable-content-db-changelog.xml::1::activiti ran successfully in 3ms
2020-01-07 02:24:25.851  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT MAX(ORDEREXECUTED) FROM PUBLIC.ACT_CO_DATABASECHANGELOG
2020-01-07 02:24:25.853  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CO_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'activiti', 'org/flowable/content/db/liquibase/flowable-content-db-changelog.xml', NOW(), 1, '8:7644d7165cfe799200a2abdd3419e8b6', 'createTable tableName=ACT_CO_CONTENT_ITEM; createIndex indexName=idx_contitem_taskid, tableName=ACT_CO_CONTENT_ITEM; createIndex indexName=idx_contitem_procid, tableName=ACT_CO_CONTENT_ITEM', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865841')
2020-01-07 02:24:25.854  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CO_CONTENT_ITEM ADD SCOPE_ID_ VARCHAR(255)
2020-01-07 02:24:25.857  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CO_CONTENT_ITEM ADD SCOPE_TYPE_ VARCHAR(255)
2020-01-07 02:24:25.860  INFO 1 --- [           main] l.c.ChangeSet                            : Columns SCOPE_ID_(varchar(255)),SCOPE_TYPE_(varchar(255)) added to ACT_CO_CONTENT_ITEM
2020-01-07 02:24:25.860  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.idx_contitem_scope ON PUBLIC.ACT_CO_CONTENT_ITEM(SCOPE_ID_, SCOPE_TYPE_)
2020-01-07 02:24:25.860  INFO 1 --- [           main] l.c.ChangeSet                            : Index idx_contitem_scope created
2020-01-07 02:24:25.860  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/content/db/liquibase/flowable-content-db-changelog.xml::2::flowable ran successfully in 6ms
2020-01-07 02:24:25.861  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CO_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2', 'flowable', 'org/flowable/content/db/liquibase/flowable-content-db-changelog.xml', NOW(), 2, '8:fe7b11ac7dbbf9c43006b23bbab60bab', 'addColumn tableName=ACT_CO_CONTENT_ITEM; createIndex indexName=idx_contitem_scope, tableName=ACT_CO_CONTENT_ITEM', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363865841')
2020-01-07 02:24:25.862  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully released change log lock
2020-01-07 02:24:25.863  INFO 1 --- [           main] o.f.c.e.i.ContentEngineImpl              : ContentEngine default created
2020-01-07 02:24:25.865  INFO 1 --- [           main] o.f.a.s.SpringAppEngineConfiguration     : Executing configure() of class org.flowable.cmmn.spring.configurator.SpringCmmnEngineConfigurator (priority:500000)
2020-01-07 02:24:26.000  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_CMMN_DATABASECHANGELOGLOCK
2020-01-07 02:24:26.001  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_ACT_CMMN_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2020-01-07 02:24:26.003  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_CMMN_DATABASECHANGELOGLOCK
2020-01-07 02:24:26.003  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : DELETE FROM PUBLIC.ACT_CMMN_DATABASECHANGELOGLOCK
2020-01-07 02:24:26.004  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2020-01-07 02:24:26.004  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT LOCKED FROM PUBLIC.ACT_CMMN_DATABASECHANGELOGLOCK WHERE ID=1
2020-01-07 02:24:26.005  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully acquired change log lock
2020-01-07 02:24:26.077  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: PUBLIC.ACT_CMMN_DATABASECHANGELOG
2020-01-07 02:24:26.078  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2020-01-07 02:24:26.078  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_CMMN_DATABASECHANGELOG
2020-01-07 02:24:26.079  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.ACT_CMMN_DATABASECHANGELOG
2020-01-07 02:24:26.079  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT * FROM PUBLIC.ACT_CMMN_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-01-07 02:24:26.079  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_CMMN_DATABASECHANGELOGLOCK
2020-01-07 02:24:26.137  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), CATEGORY_ VARCHAR(255), KEY_ VARCHAR(255), DEPLOY_TIME_ TIMESTAMP, PARENT_DEPLOYMENT_ID_ VARCHAR(255), TENANT_ID_ VARCHAR(255) DEFAULT '', CONSTRAINT PK_ACT_CMMN_DEPLOYMENT PRIMARY KEY (ID_))
2020-01-07 02:24:26.139  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_DEPLOYMENT created
2020-01-07 02:24:26.139  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_DEPLOYMENT_RESOURCE (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), RESOURCE_BYTES_ BLOB, CONSTRAINT PK_CMMN_DEPLOYMENT_RESOURCE PRIMARY KEY (ID_))
2020-01-07 02:24:26.140  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_DEPLOYMENT_RESOURCE created
2020-01-07 02:24:26.141  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_DEPLOYMENT_RESOURCE ADD CONSTRAINT ACT_FK_CMMN_RSRC_DPL FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES PUBLIC.ACT_CMMN_DEPLOYMENT (ID_)
2020-01-07 02:24:26.143  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_DEPLOYMENT_RESOURCE (DEPLOYMENT_ID_)
2020-01-07 02:24:26.144  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_CMMN_RSRC_DPL ON PUBLIC.ACT_CMMN_DEPLOYMENT_RESOURCE(DEPLOYMENT_ID_)
2020-01-07 02:24:26.144  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_CMMN_RSRC_DPL created
2020-01-07 02:24:26.145  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_CASEDEF (ID_ VARCHAR(255) NOT NULL, REV_ INT NOT NULL, NAME_ VARCHAR(255), KEY_ VARCHAR(255) NOT NULL, VERSION_ INT NOT NULL, CATEGORY_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), RESOURCE_NAME_ VARCHAR(4000), DESCRIPTION_ VARCHAR(4000), HAS_GRAPHICAL_NOTATION_ BOOLEAN, TENANT_ID_ VARCHAR(255) DEFAULT '', CONSTRAINT PK_ACT_CMMN_CASEDEF PRIMARY KEY (ID_))
2020-01-07 02:24:26.145  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_CASEDEF created
2020-01-07 02:24:26.146  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_CASEDEF ADD CONSTRAINT ACT_FK_CASE_DEF_DPLY FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES PUBLIC.ACT_CMMN_DEPLOYMENT (ID_)
2020-01-07 02:24:26.147  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_CASEDEF (DEPLOYMENT_ID_)
2020-01-07 02:24:26.147  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_CASE_DEF_DPLY ON PUBLIC.ACT_CMMN_CASEDEF(DEPLOYMENT_ID_)
2020-01-07 02:24:26.147  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_CASE_DEF_DPLY created
2020-01-07 02:24:26.148  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_RU_CASE_INST (ID_ VARCHAR(255) NOT NULL, REV_ INT NOT NULL, BUSINESS_KEY_ VARCHAR(255), NAME_ VARCHAR(255), PARENT_ID_ VARCHAR(255), CASE_DEF_ID_ VARCHAR(255), STATE_ VARCHAR(255), START_TIME_ TIMESTAMP, START_USER_ID_ VARCHAR(255), CALLBACK_ID_ VARCHAR(255), CALLBACK_TYPE_ VARCHAR(255), TENANT_ID_ VARCHAR(255) DEFAULT '', CONSTRAINT PK_ACT_CMMN_RU_CASE_INST PRIMARY KEY (ID_))
2020-01-07 02:24:26.149  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_RU_CASE_INST created
2020-01-07 02:24:26.149  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_CASE_INST ADD CONSTRAINT ACT_FK_CASE_INST_CASE_DEF FOREIGN KEY (CASE_DEF_ID_) REFERENCES PUBLIC.ACT_CMMN_CASEDEF (ID_)
2020-01-07 02:24:26.150  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_RU_CASE_INST (CASE_DEF_ID_)
2020-01-07 02:24:26.150  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_CASE_INST_CASE_DEF ON PUBLIC.ACT_CMMN_RU_CASE_INST(CASE_DEF_ID_)
2020-01-07 02:24:26.150  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_CASE_INST_CASE_DEF created
2020-01-07 02:24:26.151  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_CASE_INST_PARENT ON PUBLIC.ACT_CMMN_RU_CASE_INST(PARENT_ID_)
2020-01-07 02:24:26.151  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_CASE_INST_PARENT created
2020-01-07 02:24:26.152  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST (ID_ VARCHAR(255) NOT NULL, REV_ INT NOT NULL, CASE_DEF_ID_ VARCHAR(255), CASE_INST_ID_ VARCHAR(255), STAGE_INST_ID_ VARCHAR(255), IS_STAGE_ BOOLEAN, ELEMENT_ID_ VARCHAR(255), NAME_ VARCHAR(255), STATE_ VARCHAR(255), START_TIME_ TIMESTAMP, START_USER_ID_ VARCHAR(255), REFERENCE_ID_ VARCHAR(255), REFERENCE_TYPE_ VARCHAR(255), TENANT_ID_ VARCHAR(255) DEFAULT '', CONSTRAINT PK_CMMN_PLAN_ITEM_INST PRIMARY KEY (ID_))
2020-01-07 02:24:26.152  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_RU_PLAN_ITEM_INST created
2020-01-07 02:24:26.153  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD CONSTRAINT ACT_FK_PLAN_ITEM_CASE_DEF FOREIGN KEY (CASE_DEF_ID_) REFERENCES PUBLIC.ACT_CMMN_CASEDEF (ID_)
2020-01-07 02:24:26.154  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_RU_PLAN_ITEM_INST (CASE_DEF_ID_)
2020-01-07 02:24:26.154  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_PLAN_ITEM_CASE_DEF ON PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST(CASE_DEF_ID_)
2020-01-07 02:24:26.154  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_PLAN_ITEM_CASE_DEF created
2020-01-07 02:24:26.154  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD CONSTRAINT ACT_FK_PLAN_ITEM_CASE_INST FOREIGN KEY (CASE_INST_ID_) REFERENCES PUBLIC.ACT_CMMN_RU_CASE_INST (ID_)
2020-01-07 02:24:26.155  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_RU_PLAN_ITEM_INST (CASE_INST_ID_)
2020-01-07 02:24:26.156  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_PLAN_ITEM_CASE_INST ON PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST(CASE_INST_ID_)
2020-01-07 02:24:26.156  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_PLAN_ITEM_CASE_INST created
2020-01-07 02:24:26.156  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_RU_SENTRY_PART_INST (ID_ VARCHAR(255) NOT NULL, REV_ INT NOT NULL, CASE_DEF_ID_ VARCHAR(255), CASE_INST_ID_ VARCHAR(255), PLAN_ITEM_INST_ID_ VARCHAR(255), ON_PART_ID_ VARCHAR(255), IF_PART_ID_ VARCHAR(255), TIME_STAMP_ TIMESTAMP, CONSTRAINT PK_CMMN_SENTRY_PART_INST PRIMARY KEY (ID_))
2020-01-07 02:24:26.157  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_RU_SENTRY_PART_INST created
2020-01-07 02:24:26.157  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_SENTRY_PART_INST ADD CONSTRAINT ACT_FK_SENTRY_CASE_DEF FOREIGN KEY (CASE_DEF_ID_) REFERENCES PUBLIC.ACT_CMMN_CASEDEF (ID_)
2020-01-07 02:24:26.158  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_RU_SENTRY_PART_INST (CASE_DEF_ID_)
2020-01-07 02:24:26.159  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_SENTRY_CASE_DEF ON PUBLIC.ACT_CMMN_RU_SENTRY_PART_INST(CASE_DEF_ID_)
2020-01-07 02:24:26.159  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_SENTRY_CASE_DEF created
2020-01-07 02:24:26.159  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_SENTRY_PART_INST ADD CONSTRAINT ACT_FK_SENTRY_CASE_INST FOREIGN KEY (CASE_INST_ID_) REFERENCES PUBLIC.ACT_CMMN_RU_CASE_INST (ID_)
2020-01-07 02:24:26.160  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_RU_SENTRY_PART_INST (CASE_INST_ID_)
2020-01-07 02:24:26.161  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_SENTRY_CASE_INST ON PUBLIC.ACT_CMMN_RU_SENTRY_PART_INST(CASE_INST_ID_)
2020-01-07 02:24:26.161  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_SENTRY_CASE_INST created
2020-01-07 02:24:26.161  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_SENTRY_PART_INST ADD CONSTRAINT ACT_FK_SENTRY_PLAN_ITEM FOREIGN KEY (PLAN_ITEM_INST_ID_) REFERENCES PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST (ID_)
2020-01-07 02:24:26.162  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_RU_SENTRY_PART_INST (PLAN_ITEM_INST_ID_)
2020-01-07 02:24:26.163  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_SENTRY_PLAN_ITEM ON PUBLIC.ACT_CMMN_RU_SENTRY_PART_INST(PLAN_ITEM_INST_ID_)
2020-01-07 02:24:26.163  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_SENTRY_PLAN_ITEM created
2020-01-07 02:24:26.164  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_RU_MIL_INST (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255) NOT NULL, TIME_STAMP_ TIMESTAMP NOT NULL, CASE_INST_ID_ VARCHAR(255) NOT NULL, CASE_DEF_ID_ VARCHAR(255) NOT NULL, ELEMENT_ID_ VARCHAR(255) NOT NULL, CONSTRAINT PK_ACT_CMMN_RU_MIL_INST PRIMARY KEY (ID_))
2020-01-07 02:24:26.164  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_RU_MIL_INST created
2020-01-07 02:24:26.165  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_MIL_INST ADD CONSTRAINT ACT_FK_MIL_CASE_DEF FOREIGN KEY (CASE_DEF_ID_) REFERENCES PUBLIC.ACT_CMMN_CASEDEF (ID_)
2020-01-07 02:24:26.165  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_RU_MIL_INST (CASE_DEF_ID_)
2020-01-07 02:24:26.166  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_MIL_CASE_DEF ON PUBLIC.ACT_CMMN_RU_MIL_INST(CASE_DEF_ID_)
2020-01-07 02:24:26.166  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_MIL_CASE_DEF created
2020-01-07 02:24:26.166  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_MIL_INST ADD CONSTRAINT ACT_FK_MIL_CASE_INST FOREIGN KEY (CASE_INST_ID_) REFERENCES PUBLIC.ACT_CMMN_RU_CASE_INST (ID_)
2020-01-07 02:24:26.167  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_CMMN_RU_MIL_INST (CASE_INST_ID_)
2020-01-07 02:24:26.167  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_MIL_CASE_INST ON PUBLIC.ACT_CMMN_RU_MIL_INST(CASE_INST_ID_)
2020-01-07 02:24:26.168  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_MIL_CASE_INST created
2020-01-07 02:24:26.168  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_HI_CASE_INST (ID_ VARCHAR(255) NOT NULL, REV_ INT NOT NULL, BUSINESS_KEY_ VARCHAR(255), NAME_ VARCHAR(255), PARENT_ID_ VARCHAR(255), CASE_DEF_ID_ VARCHAR(255), STATE_ VARCHAR(255), START_TIME_ TIMESTAMP, END_TIME_ TIMESTAMP, START_USER_ID_ VARCHAR(255), CALLBACK_ID_ VARCHAR(255), CALLBACK_TYPE_ VARCHAR(255), TENANT_ID_ VARCHAR(255) DEFAULT '', CONSTRAINT PK_ACT_CMMN_HI_CASE_INST PRIMARY KEY (ID_))
2020-01-07 02:24:26.169  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_HI_CASE_INST created
2020-01-07 02:24:26.169  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_HI_MIL_INST (ID_ VARCHAR(255) NOT NULL, REV_ INT NOT NULL, NAME_ VARCHAR(255) NOT NULL, TIME_STAMP_ TIMESTAMP NOT NULL, CASE_INST_ID_ VARCHAR(255) NOT NULL, CASE_DEF_ID_ VARCHAR(255) NOT NULL, ELEMENT_ID_ VARCHAR(255) NOT NULL, CONSTRAINT PK_ACT_CMMN_HI_MIL_INST PRIMARY KEY (ID_))
2020-01-07 02:24:26.170  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_HI_MIL_INST created
2020-01-07 02:24:26.170  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::1::flowable ran successfully in 34ms
2020-01-07 02:24:26.170  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT MAX(ORDEREXECUTED) FROM PUBLIC.ACT_CMMN_DATABASECHANGELOG
2020-01-07 02:24:26.172  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 1, '8:8b4b922d90b05ff27483abefc9597aa6', 'createTable tableName=ACT_CMMN_DEPLOYMENT; createTable tableName=ACT_CMMN_DEPLOYMENT_RESOURCE; addForeignKeyConstraint baseTableName=ACT_CMMN_DEPLOYMENT_RESOURCE, constraintName=ACT_FK_CMMN_RSRC_DPL, referencedTableName=ACT_CMMN_DEPLOYMENT; create...', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.174  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_CASEDEF ADD DGRM_RESOURCE_NAME_ VARCHAR(4000)
2020-01-07 02:24:26.177  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_CASEDEF ADD HAS_START_FORM_KEY_ BOOLEAN
2020-01-07 02:24:26.180  INFO 1 --- [           main] l.c.ChangeSet                            : Columns DGRM_RESOURCE_NAME_(varchar(4000)),HAS_START_FORM_KEY_(boolean) added to ACT_CMMN_CASEDEF
2020-01-07 02:24:26.181  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_DEPLOYMENT_RESOURCE ADD GENERATED_ BOOLEAN
2020-01-07 02:24:26.183  INFO 1 --- [           main] l.c.ChangeSet                            : Columns GENERATED_(boolean) added to ACT_CMMN_DEPLOYMENT_RESOURCE
2020-01-07 02:24:26.184  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_CASE_INST ADD LOCK_TIME_ TIMESTAMP
2020-01-07 02:24:26.187  INFO 1 --- [           main] l.c.ChangeSet                            : Columns LOCK_TIME_(datetime) added to ACT_CMMN_RU_CASE_INST
2020-01-07 02:24:26.188  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD ITEM_DEFINITION_ID_ VARCHAR(255)
2020-01-07 02:24:26.191  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD ITEM_DEFINITION_TYPE_ VARCHAR(255)
2020-01-07 02:24:26.193  INFO 1 --- [           main] l.c.ChangeSet                            : Columns ITEM_DEFINITION_ID_(varchar(255)),ITEM_DEFINITION_TYPE_(varchar(255)) added to ACT_CMMN_RU_PLAN_ITEM_INST
2020-01-07 02:24:26.194  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::2::flowable ran successfully in 20ms
2020-01-07 02:24:26.194  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 2, '8:65e39b3d385706bb261cbeffe7533cbe', 'addColumn tableName=ACT_CMMN_CASEDEF; addColumn tableName=ACT_CMMN_DEPLOYMENT_RESOURCE; addColumn tableName=ACT_CMMN_RU_CASE_INST; addColumn tableName=ACT_CMMN_RU_PLAN_ITEM_INST', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.195  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD IS_COMPLETEABLE_ BOOLEAN
2020-01-07 02:24:26.198  INFO 1 --- [           main] l.c.ChangeSet                            : Columns IS_COMPLETEABLE_(boolean) added to ACT_CMMN_RU_PLAN_ITEM_INST
2020-01-07 02:24:26.199  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_CASE_INST ADD IS_COMPLETEABLE_ BOOLEAN
2020-01-07 02:24:26.201  INFO 1 --- [           main] l.c.ChangeSet                            : Columns IS_COMPLETEABLE_(boolean) added to ACT_CMMN_RU_CASE_INST
2020-01-07 02:24:26.202  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_PLAN_ITEM_STAGE_INST ON PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST(STAGE_INST_ID_)
2020-01-07 02:24:26.202  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_PLAN_ITEM_STAGE_INST created
2020-01-07 02:24:26.203  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD IS_COUNT_ENABLED_ BOOLEAN
2020-01-07 02:24:26.206  INFO 1 --- [           main] l.c.ChangeSet                            : Columns IS_COUNT_ENABLED_(boolean) added to ACT_CMMN_RU_PLAN_ITEM_INST
2020-01-07 02:24:26.207  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD VAR_COUNT_ INT
2020-01-07 02:24:26.210  INFO 1 --- [           main] l.c.ChangeSet                            : Columns VAR_COUNT_(integer) added to ACT_CMMN_RU_PLAN_ITEM_INST
2020-01-07 02:24:26.211  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD SENTRY_PART_INST_COUNT_ INT
2020-01-07 02:24:26.214  INFO 1 --- [           main] l.c.ChangeSet                            : Columns SENTRY_PART_INST_COUNT_(integer) added to ACT_CMMN_RU_PLAN_ITEM_INST
2020-01-07 02:24:26.214  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::3::flowable ran successfully in 19ms
2020-01-07 02:24:26.215  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('3', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 3, '8:c01f6e802b49436b4489040da3012359', 'addColumn tableName=ACT_CMMN_RU_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_RU_CASE_INST; createIndex indexName=ACT_IDX_PLAN_ITEM_STAGE_INST, tableName=ACT_CMMN_RU_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_RU_PLAN_ITEM_INST; addColumn tableNam...', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.217  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_CMMN_HI_PLAN_ITEM_INST (ID_ VARCHAR(255) NOT NULL, REV_ INT NOT NULL, NAME_ VARCHAR(255), STATE_ VARCHAR(255), CASE_DEF_ID_ VARCHAR(255), CASE_INST_ID_ VARCHAR(255), STAGE_INST_ID_ VARCHAR(255), IS_STAGE_ BOOLEAN, ELEMENT_ID_ VARCHAR(255), ITEM_DEFINITION_ID_ VARCHAR(255), ITEM_DEFINITION_TYPE_ VARCHAR(255), CREATED_TIME_ TIMESTAMP, LAST_AVAILABLE_TIME_ TIMESTAMP, LAST_ENABLED_TIME_ TIMESTAMP, LAST_DISABLED_TIME_ TIMESTAMP, LAST_STARTED_TIME_ TIMESTAMP, LAST_SUSPENDED_TIME_ TIMESTAMP, COMPLETED_TIME_ TIMESTAMP, OCCURRED_TIME_ TIMESTAMP, TERMINATED_TIME_ TIMESTAMP, EXIT_TIME_ TIMESTAMP, ENDED_TIME_ TIMESTAMP, LAST_UPDATED_TIME_ TIMESTAMP, START_USER_ID_ VARCHAR(255), REFERENCE_ID_ VARCHAR(255), REFERENCE_TYPE_ VARCHAR(255), TENANT_ID_ VARCHAR(255) DEFAULT '', CONSTRAINT PK_ACT_CMMN_HI_PLAN_ITEM_INST PRIMARY KEY (ID_))
2020-01-07 02:24:26.218  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_CMMN_HI_PLAN_ITEM_INST created
2020-01-07 02:24:26.218  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_MIL_INST ADD TENANT_ID_ VARCHAR(255) DEFAULT ''
2020-01-07 02:24:26.220  INFO 1 --- [           main] l.c.ChangeSet                            : Columns TENANT_ID_(varchar(255)) added to ACT_CMMN_RU_MIL_INST
2020-01-07 02:24:26.221  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_HI_MIL_INST ADD TENANT_ID_ VARCHAR(255) DEFAULT ''
2020-01-07 02:24:26.222  INFO 1 --- [           main] l.c.ChangeSet                            : Columns TENANT_ID_(varchar(255)) added to ACT_CMMN_HI_MIL_INST
2020-01-07 02:24:26.223  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::4::flowable ran successfully in 7ms
2020-01-07 02:24:26.224  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('4', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 4, '8:e40d29cb79345b7fb5afd38a7f0ba8fc', 'createTable tableName=ACT_CMMN_HI_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_RU_MIL_INST; addColumn tableName=ACT_CMMN_HI_MIL_INST', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.224  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE UNIQUE INDEX PUBLIC.ACT_IDX_CASE_DEF_UNIQ ON PUBLIC.ACT_CMMN_CASEDEF(KEY_, VERSION_, TENANT_ID_)
2020-01-07 02:24:26.225  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_CASE_DEF_UNIQ created
2020-01-07 02:24:26.225  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::6::flowable ran successfully in 1ms
2020-01-07 02:24:26.226  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('6', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 5, '8:10e82e26a7fee94c32a92099c059c18c', 'createIndex indexName=ACT_IDX_CASE_DEF_UNIQ, tableName=ACT_CMMN_CASEDEF', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.227  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ALTER COLUMN START_TIME_ RENAME TO CREATE_TIME_
2020-01-07 02:24:26.227  INFO 1 --- [           main] l.c.ChangeSet                            : Column ACT_CMMN_RU_PLAN_ITEM_INST.START_TIME_ renamed to CREATE_TIME_
2020-01-07 02:24:26.227  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_HI_PLAN_ITEM_INST ALTER COLUMN CREATED_TIME_ RENAME TO CREATE_TIME_
2020-01-07 02:24:26.228  INFO 1 --- [           main] l.c.ChangeSet                            : Column ACT_CMMN_HI_PLAN_ITEM_INST.CREATED_TIME_ renamed to CREATE_TIME_
2020-01-07 02:24:26.228  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD LAST_AVAILABLE_TIME_ TIMESTAMP
2020-01-07 02:24:26.232  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD LAST_ENABLED_TIME_ TIMESTAMP
2020-01-07 02:24:26.234  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD LAST_DISABLED_TIME_ TIMESTAMP
2020-01-07 02:24:26.236  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD LAST_STARTED_TIME_ TIMESTAMP
2020-01-07 02:24:26.239  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD LAST_SUSPENDED_TIME_ TIMESTAMP
2020-01-07 02:24:26.241  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD COMPLETED_TIME_ TIMESTAMP
2020-01-07 02:24:26.244  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD OCCURRED_TIME_ TIMESTAMP
2020-01-07 02:24:26.246  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD TERMINATED_TIME_ TIMESTAMP
2020-01-07 02:24:26.249  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD EXIT_TIME_ TIMESTAMP
2020-01-07 02:24:26.251  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD ENDED_TIME_ TIMESTAMP
2020-01-07 02:24:26.254  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD ENTRY_CRITERION_ID_ VARCHAR(255)
2020-01-07 02:24:26.256  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD EXIT_CRITERION_ID_ VARCHAR(255)
2020-01-07 02:24:26.259  INFO 1 --- [           main] l.c.ChangeSet                            : Columns LAST_AVAILABLE_TIME_(datetime(3)),LAST_ENABLED_TIME_(datetime(3)),LAST_DISABLED_TIME_(datetime(3)),LAST_STARTED_TIME_(datetime(3)),LAST_SUSPENDED_TIME_(datetime(3)),COMPLETED_TIME_(datetime(3)),OCCURRED_TIME_(datetime(3)),TERMINATED_TIME_(datetime(3)),EXIT_TIME_(datetime(3)),ENDED_TIME_(datetime(3)),ENTRY_CRITERION_ID_(varchar(255)),EXIT_CRITERION_ID_(varchar(255)) added to ACT_CMMN_RU_PLAN_ITEM_INST
2020-01-07 02:24:26.259  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_HI_PLAN_ITEM_INST ADD ENTRY_CRITERION_ID_ VARCHAR(255)
2020-01-07 02:24:26.261  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_HI_PLAN_ITEM_INST ADD EXIT_CRITERION_ID_ VARCHAR(255)
2020-01-07 02:24:26.262  INFO 1 --- [           main] l.c.ChangeSet                            : Columns ENTRY_CRITERION_ID_(varchar(255)),EXIT_CRITERION_ID_(varchar(255)) added to ACT_CMMN_HI_PLAN_ITEM_INST
2020-01-07 02:24:26.262  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::7::flowable ran successfully in 36ms
2020-01-07 02:24:26.263  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('7', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 6, '8:530bc81a1e30618ccf4a2da1f7c6c043', 'renameColumn newColumnName=CREATE_TIME_, oldColumnName=START_TIME_, tableName=ACT_CMMN_RU_PLAN_ITEM_INST; renameColumn newColumnName=CREATE_TIME_, oldColumnName=CREATED_TIME_, tableName=ACT_CMMN_HI_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_RU_P...', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.264  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_HI_PLAN_ITEM_INST ADD SHOW_IN_OVERVIEW_ BOOLEAN
2020-01-07 02:24:26.266  INFO 1 --- [           main] l.c.ChangeSet                            : Columns SHOW_IN_OVERVIEW_(boolean) added to ACT_CMMN_HI_PLAN_ITEM_INST
2020-01-07 02:24:26.266  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::8::flowable ran successfully in 2ms
2020-01-07 02:24:26.267  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('8', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 7, '8:e8c2eb1ce28bc301efe07e0e29757781', 'addColumn tableName=ACT_CMMN_HI_PLAN_ITEM_INST', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.268  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_PLAN_ITEM_INST ADD EXTRA_VALUE_ VARCHAR(255)
2020-01-07 02:24:26.270  INFO 1 --- [           main] l.c.ChangeSet                            : Columns EXTRA_VALUE_(varchar(255)) added to ACT_CMMN_RU_PLAN_ITEM_INST
2020-01-07 02:24:26.270  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_HI_PLAN_ITEM_INST ADD EXTRA_VALUE_ VARCHAR(255)
2020-01-07 02:24:26.272  INFO 1 --- [           main] l.c.ChangeSet                            : Columns EXTRA_VALUE_(varchar(255)) added to ACT_CMMN_HI_PLAN_ITEM_INST
2020-01-07 02:24:26.272  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::9::flowable ran successfully in 5ms
2020-01-07 02:24:26.273  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('9', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 8, '8:4cb4782b9bdec5ced2a64c525aa7b3a0', 'addColumn tableName=ACT_CMMN_RU_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_HI_PLAN_ITEM_INST', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.274  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_CASE_INST ADD REFERENCE_ID_ VARCHAR(255)
2020-01-07 02:24:26.276  INFO 1 --- [           main] l.c.ChangeSet                            : Columns REFERENCE_ID_(varchar(255)) added to ACT_CMMN_RU_CASE_INST
2020-01-07 02:24:26.277  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_RU_CASE_INST ADD REFERENCE_TYPE_ VARCHAR(255)
2020-01-07 02:24:26.279  INFO 1 --- [           main] l.c.ChangeSet                            : Columns REFERENCE_TYPE_(varchar(255)) added to ACT_CMMN_RU_CASE_INST
2020-01-07 02:24:26.279  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_CASE_INST_REF_ID_ ON PUBLIC.ACT_CMMN_RU_CASE_INST(REFERENCE_ID_)
2020-01-07 02:24:26.280  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_CASE_INST_REF_ID_ created
2020-01-07 02:24:26.280  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_HI_CASE_INST ADD REFERENCE_ID_ VARCHAR(255)
2020-01-07 02:24:26.282  INFO 1 --- [           main] l.c.ChangeSet                            : Columns REFERENCE_ID_(varchar(255)) added to ACT_CMMN_HI_CASE_INST
2020-01-07 02:24:26.282  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_CMMN_HI_CASE_INST ADD REFERENCE_TYPE_ VARCHAR(255)
2020-01-07 02:24:26.284  INFO 1 --- [           main] l.c.ChangeSet                            : Columns REFERENCE_TYPE_(varchar(255)) added to ACT_CMMN_HI_CASE_INST
2020-01-07 02:24:26.284  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml::10::flowable ran successfully in 11ms
2020-01-07 02:24:26.285  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_CMMN_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('10', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', NOW(), 9, '8:341c16be247f5d17badc9809da8691f9', 'addColumn tableName=ACT_CMMN_RU_CASE_INST; addColumn tableName=ACT_CMMN_RU_CASE_INST; createIndex indexName=ACT_IDX_CASE_INST_REF_ID_, tableName=ACT_CMMN_RU_CASE_INST; addColumn tableName=ACT_CMMN_HI_CASE_INST; addColumn tableName=ACT_CMMN_HI_CASE...', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866080')
2020-01-07 02:24:26.286  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully released change log lock
2020-01-07 02:24:26.286  INFO 1 --- [           main] o.f.c.e.i.CmmnEngineImpl                 : CmmnEngine default created
2020-01-07 02:24:26.310  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_APP_DATABASECHANGELOGLOCK
2020-01-07 02:24:26.311  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_APP_DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_ACT_APP_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2020-01-07 02:24:26.312  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_APP_DATABASECHANGELOGLOCK
2020-01-07 02:24:26.313  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : DELETE FROM PUBLIC.ACT_APP_DATABASECHANGELOGLOCK
2020-01-07 02:24:26.313  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_APP_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2020-01-07 02:24:26.313  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT LOCKED FROM PUBLIC.ACT_APP_DATABASECHANGELOGLOCK WHERE ID=1
2020-01-07 02:24:26.314  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully acquired change log lock
2020-01-07 02:24:26.327  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: PUBLIC.ACT_APP_DATABASECHANGELOG
2020-01-07 02:24:26.328  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_APP_DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2020-01-07 02:24:26.329  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_APP_DATABASECHANGELOG
2020-01-07 02:24:26.329  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.ACT_APP_DATABASECHANGELOG
2020-01-07 02:24:26.329  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT * FROM PUBLIC.ACT_APP_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-01-07 02:24:26.330  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_APP_DATABASECHANGELOGLOCK
2020-01-07 02:24:26.338  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_APP_DEPLOYMENT (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), CATEGORY_ VARCHAR(255), KEY_ VARCHAR(255), DEPLOY_TIME_ TIMESTAMP, TENANT_ID_ VARCHAR(255) DEFAULT '', CONSTRAINT PK_ACT_APP_DEPLOYMENT PRIMARY KEY (ID_))
2020-01-07 02:24:26.339  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_APP_DEPLOYMENT created
2020-01-07 02:24:26.339  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_APP_DEPLOYMENT_RESOURCE (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), RESOURCE_BYTES_ BLOB, CONSTRAINT PK_APP_DEPLOYMENT_RESOURCE PRIMARY KEY (ID_))
2020-01-07 02:24:26.339  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_APP_DEPLOYMENT_RESOURCE created
2020-01-07 02:24:26.340  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_APP_DEPLOYMENT_RESOURCE ADD CONSTRAINT ACT_FK_APP_RSRC_DPL FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES PUBLIC.ACT_APP_DEPLOYMENT (ID_)
2020-01-07 02:24:26.341  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_APP_DEPLOYMENT_RESOURCE (DEPLOYMENT_ID_)
2020-01-07 02:24:26.341  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_APP_RSRC_DPL ON PUBLIC.ACT_APP_DEPLOYMENT_RESOURCE(DEPLOYMENT_ID_)
2020-01-07 02:24:26.341  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_APP_RSRC_DPL created
2020-01-07 02:24:26.342  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_APP_APPDEF (ID_ VARCHAR(255) NOT NULL, REV_ INT NOT NULL, NAME_ VARCHAR(255), KEY_ VARCHAR(255) NOT NULL, VERSION_ INT NOT NULL, CATEGORY_ VARCHAR(255), DEPLOYMENT_ID_ VARCHAR(255), RESOURCE_NAME_ VARCHAR(4000), DESCRIPTION_ VARCHAR(4000), TENANT_ID_ VARCHAR(255) DEFAULT '', CONSTRAINT PK_ACT_APP_APPDEF PRIMARY KEY (ID_))
2020-01-07 02:24:26.342  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_APP_APPDEF created
2020-01-07 02:24:26.343  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : ALTER TABLE PUBLIC.ACT_APP_APPDEF ADD CONSTRAINT ACT_FK_APP_DEF_DPLY FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES PUBLIC.ACT_APP_DEPLOYMENT (ID_)
2020-01-07 02:24:26.343  INFO 1 --- [           main] l.c.ChangeSet                            : Foreign key constraint added to ACT_APP_APPDEF (DEPLOYMENT_ID_)
2020-01-07 02:24:26.344  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE INDEX PUBLIC.ACT_IDX_APP_DEF_DPLY ON PUBLIC.ACT_APP_APPDEF(DEPLOYMENT_ID_)
2020-01-07 02:24:26.344  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_APP_DEF_DPLY created
2020-01-07 02:24:26.344  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/app/db/liquibase/flowable-app-db-changelog.xml::1::flowable ran successfully in 6ms
2020-01-07 02:24:26.344  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT MAX(ORDEREXECUTED) FROM PUBLIC.ACT_APP_DATABASECHANGELOG
2020-01-07 02:24:26.345  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_APP_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', NOW(), 1, '8:496fc778bdf2ab13f2e1926d0e63e0a2', 'createTable tableName=ACT_APP_DEPLOYMENT; createTable tableName=ACT_APP_DEPLOYMENT_RESOURCE; addForeignKeyConstraint baseTableName=ACT_APP_DEPLOYMENT_RESOURCE, constraintName=ACT_FK_APP_RSRC_DPL, referencedTableName=ACT_APP_DEPLOYMENT; createIndex...', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866330')
2020-01-07 02:24:26.346  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE UNIQUE INDEX PUBLIC.ACT_IDX_APP_DEF_UNIQ ON PUBLIC.ACT_APP_APPDEF(KEY_, VERSION_, TENANT_ID_)
2020-01-07 02:24:26.347  INFO 1 --- [           main] l.c.ChangeSet                            : Index ACT_IDX_APP_DEF_UNIQ created
2020-01-07 02:24:26.347  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet org/flowable/app/db/liquibase/flowable-app-db-changelog.xml::3::flowable ran successfully in 1ms
2020-01-07 02:24:26.348  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_APP_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('3', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', NOW(), 2, '8:f1f8aff320aade831944ebad24355f3d', 'createIndex indexName=ACT_IDX_APP_DEF_UNIQ, tableName=ACT_APP_APPDEF', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363866330')
2020-01-07 02:24:26.349  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully released change log lock
2020-01-07 02:24:26.349  INFO 1 --- [           main] o.f.a.e.i.AppEngineImpl                  : AppEngine default created
2020-01-07 02:24:27.352  INFO 1 --- [           main] o.s.b.a.w.s.WelcomePageHandlerMapping    : Adding welcome page: class path resource [static/index.html]
2020-01-07 02:24:27.983  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: Ant [pattern='/*-api/**'], [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@7be4eb98, org.springframework.security.web.context.SecurityContextPersistenceFilter@4616eeeb, org.springframework.security.web.header.HeaderWriterFilter@26f4e38a, org.springframework.security.web.authentication.logout.LogoutFilter@5323a6b0, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@e94b759, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@4f9764e5, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@53f22c10, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@3da55063, org.springframework.security.web.session.SessionManagementFilter@da101da, org.springframework.security.web.access.ExceptionTranslationFilter@3e77b98f, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@5664df7f]
2020-01-07 02:24:27.986  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: org.flowable.ui.common.security.ActuatorRequestMatcher@4d12cf0b, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@2f377795, org.springframework.security.web.context.SecurityContextPersistenceFilter@51d5c5f6, org.springframework.security.web.header.HeaderWriterFilter@7474bf08, org.springframework.security.web.authentication.logout.LogoutFilter@7943035d, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@74c2791a, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@4c27e7f1, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@1dfa9d82, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@73934653, org.springframework.security.web.session.SessionManagementFilter@610f450e, org.springframework.security.web.access.ExceptionTranslationFilter@3d54076a, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@19bbc7c]
2020-01-07 02:24:27.989  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@45a80d53, org.springframework.security.web.context.SecurityContextPersistenceFilter@1c21d87b, org.springframework.security.web.header.HeaderWriterFilter@4cc0275a, org.springframework.security.web.authentication.logout.LogoutFilter@31d91e2, org.flowable.ui.common.filter.FlowableCookieFilter@7ca4de84, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@d6ad24e, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@40ddce4e, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@665f6f70, org.springframework.security.web.session.SessionManagementFilter@5690fe27, org.springframework.security.web.access.ExceptionTranslationFilter@3fc5d3f2, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@4d93b66a]
2020-01-07 02:24:28.022  INFO 1 --- [           main] o.s.s.c.ThreadPoolTaskScheduler          : Initializing ExecutorService 'taskScheduler'
2020-01-07 02:24:28.034  INFO 1 --- [           main] o.s.b.a.e.w.EndpointLinksResolver        : Exposing 14 endpoint(s) beneath base path '/actuator'
2020-01-07 02:24:28.100  INFO 1 --- [           main] o.f.j.s.i.a.AbstractAsyncExecutor        : Starting up the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].
2020-01-07 02:24:28.104  INFO 1 --- [       Thread-9] o.f.j.s.i.a.AcquireAsyncJobsDueRunnable  : starting to acquire async jobs due
2020-01-07 02:24:28.104  INFO 1 --- [      Thread-10] o.f.j.s.i.a.AcquireTimerJobsRunnable     : starting to acquire async jobs due
2020-01-07 02:24:28.107  INFO 1 --- [           main] o.f.j.s.i.a.AbstractAsyncExecutor        : Starting up the async job executor [org.flowable.spring.job.service.SpringAsyncExecutor].
2020-01-07 02:24:28.109  INFO 1 --- [      Thread-11] o.f.j.s.i.a.ResetExpiredJobsRunnable     : starting to reset expired jobs for engine cmmn
2020-01-07 02:24:28.109  INFO 1 --- [      Thread-12] o.f.j.s.i.a.AcquireAsyncJobsDueRunnable  : starting to acquire async jobs due
2020-01-07 02:24:28.114  INFO 1 --- [      Thread-13] o.f.j.s.i.a.AcquireTimerJobsRunnable     : starting to acquire async jobs due
2020-01-07 02:24:28.113  INFO 1 --- [      Thread-14] o.f.j.s.i.a.ResetExpiredJobsRunnable     : starting to reset expired jobs for engine bpmn
2020-01-07 02:24:28.160  INFO 1 --- [           main] o.f.u.t.c.Bootstrapper                   : Migrated 0 app deployments
2020-01-07 02:24:28.166  INFO 1 --- [           main] o.f.u.t.a.FlowableTaskApplication        : Started FlowableTaskApplication in 12.938 seconds (JVM running for 41.019)

    //////////          &&&& &&&                                          ,,,         ,,,
  //////////////     &&&&&&& &&&                                          ,,,         ,,,
 ///          ///   &&&      &&&                                          ,,,         ,,,
 ////////     ///   &&&&&&&& &&&   &&&&&&&   &&&   &&&    &&&  ,,,,,,,,,, ,,,,,,,,,   ,,,   ,,,,,,,
 //////   //  ///   &&&&&&&& &&& &&&&   &&&& &&&   &&&    &&& ,,,    ,,,, ,,,,   ,,,, ,,, ,,,    ,,
 ///    ////  ///   &&&      &&& &&&     &&& &&&   &&&    &&& ,,      ,,, ,,,     ,,, ,,, ,,,,,,,,,
 //    /////  ///   &&&      &&& &&&    &&&& &&&   &&&    &&& ,,,    ,,,, ,,,,    ,,, ,,, ,,,
     ///////////    &&&      &&&  &&&&&&&&    &&&&&&&&&&&&&&   ,,,,,,,,,,   ,,,,,,,,  ,,,  ,,,,,,,,

  :: Flowable :: (v6.5.0-SNAPSHOT)    :: Spring Boot ::  (v2.2.2.RELEASE)

2020-01-07 02:24:31.426  INFO 1 --- [           main] o.f.u.a.a.FlowableAdminApplication       : Starting FlowableAdminApplication v6.5.0-SNAPSHOT on 25d7e898c602 with PID 1 (/opt/tomcat/webapps/flowable-admin/WEB-INF/classes started by tomcat in /opt/tomcat)
2020-01-07 02:24:31.437  INFO 1 --- [           main] o.f.u.a.a.FlowableAdminApplication       : No active profile set, falling back to default profiles: default
2020-01-07 02:24:33.538  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2020-01-07 02:24:33.568  INFO 1 --- [           main] o.s.w.c.ContextLoader                    : Root WebApplicationContext: initialization completed in 1897 ms
2020-01-07 02:24:33.640  WARN 1 --- [           main] uration$JodaDateTimeJacksonConfiguration : Auto-configuration of Jackson's Joda-Time integration is deprecated in favor of using java.time (JSR-310).
2020-01-07 02:24:35.052  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: org.flowable.ui.common.security.ActuatorRequestMatcher@26ddf45d, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@2542c2a8, org.springframework.security.web.context.SecurityContextPersistenceFilter@45abd8ca, org.springframework.security.web.header.HeaderWriterFilter@793de3d5, org.springframework.security.web.authentication.logout.LogoutFilter@696fe814, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@294cb308, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@2743e56f, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@4c4f339f, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@73986d63, org.springframework.security.web.session.SessionManagementFilter@78bc6d74, org.springframework.security.web.access.ExceptionTranslationFilter@1abf6a81, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@59e63e8f]
2020-01-07 02:24:35.062  INFO 1 --- [           main] o.s.s.w.DefaultSecurityFilterChain       : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@63c05c5e, org.springframework.security.web.context.SecurityContextPersistenceFilter@1d1db793, org.springframework.security.web.header.HeaderWriterFilter@2152062c, org.springframework.security.web.authentication.logout.LogoutFilter@33bb0e03, org.flowable.ui.common.filter.FlowableCookieFilter@d80ba64, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@54bd9bc6, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@656f941b, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@4347a546, org.springframework.security.web.session.SessionManagementFilter@6af99b57, org.springframework.security.web.access.ExceptionTranslationFilter@bd84630, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@6e2db99a]
2020-01-07 02:24:35.075  INFO 1 --- [           main] c.z.h.HikariDataSource                   : flowable-ui-admin - Starting...
2020-01-07 02:24:35.194  INFO 1 --- [           main] c.z.h.HikariDataSource                   : flowable-ui-admin - Start completed.
2020-01-07 02:24:35.765  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_ADM_DATABASECHANGELOGLOCK
2020-01-07 02:24:35.780  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_ADM_DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_ACT_ADM_DATABASECHANGELOGLOCK PRIMARY KEY (ID))
2020-01-07 02:24:35.785  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_ADM_DATABASECHANGELOGLOCK
2020-01-07 02:24:35.788  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : DELETE FROM PUBLIC.ACT_ADM_DATABASECHANGELOGLOCK
2020-01-07 02:24:35.790  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_ADM_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE)
2020-01-07 02:24:35.793  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT LOCKED FROM PUBLIC.ACT_ADM_DATABASECHANGELOGLOCK WHERE ID=1
2020-01-07 02:24:35.799  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully acquired change log lock
2020-01-07 02:24:36.867  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Creating database history table with name: PUBLIC.ACT_ADM_DATABASECHANGELOG
2020-01-07 02:24:36.869  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_ADM_DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35), DESCRIPTION VARCHAR(255), COMMENTS VARCHAR(255), TAG VARCHAR(255), LIQUIBASE VARCHAR(20), CONTEXTS VARCHAR(255), LABELS VARCHAR(255), DEPLOYMENT_ID VARCHAR(10))
2020-01-07 02:24:36.873  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_ADM_DATABASECHANGELOG
2020-01-07 02:24:36.874  INFO 1 --- [           main] l.c.StandardChangeLogHistoryService      : Reading from PUBLIC.ACT_ADM_DATABASECHANGELOG
2020-01-07 02:24:36.875  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT * FROM PUBLIC.ACT_ADM_DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
2020-01-07 02:24:36.877  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT COUNT(*) FROM PUBLIC.ACT_ADM_DATABASECHANGELOGLOCK
2020-01-07 02:24:36.896  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : CREATE TABLE PUBLIC.ACT_ADM_SERVER_CONFIG (ID_ VARCHAR(255) NOT NULL, NAME_ VARCHAR(50), DESCRIPTION_ VARCHAR(255), SERVER_ADDRESS_ VARCHAR(100), PORT_ INT, CONTEXT_ROOT_ VARCHAR(100), REST_ROOT_ VARCHAR(100), USER_NAME_ VARCHAR(100), PASSWORD_ VARCHAR(100), ENDPOINT_TYPE_ INT, TENANT_ID_ VARCHAR(50), CONSTRAINT PK_ACT_ADM_SERVER_CONFIG PRIMARY KEY (ID_))
2020-01-07 02:24:36.898  INFO 1 --- [           main] l.c.ChangeSet                            : Table ACT_ADM_SERVER_CONFIG created
2020-01-07 02:24:36.898  INFO 1 --- [           main] l.c.ChangeSet                            : ChangeSet META-INF/liquibase/flowable-admin-app-db-changelog.xml::1::flowable ran successfully in 6ms
2020-01-07 02:24:36.899  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : SELECT MAX(ORDEREXECUTED) FROM PUBLIC.ACT_ADM_DATABASECHANGELOG
2020-01-07 02:24:36.902  INFO 1 --- [           main] l.e.j.JdbcExecutor                       : INSERT INTO PUBLIC.ACT_ADM_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'flowable', 'META-INF/liquibase/flowable-admin-app-db-changelog.xml', NOW(), 1, '8:655e3bb142f7d051dfc2d641ee0eeebd', 'createTable tableName=ACT_ADM_SERVER_CONFIG', '', 'EXECUTED', NULL, NULL, '3.8.0', '8363876878')
2020-01-07 02:24:36.906  INFO 1 --- [           main] l.l.StandardLockService                  : Successfully released change log lock
2020-01-07 02:24:37.055  INFO 1 --- [           main] o.s.s.c.ThreadPoolTaskExecutor           : Initializing ExecutorService 'applicationTaskExecutor'
2020-01-07 02:24:37.214  INFO 1 --- [           main] o.s.b.a.w.s.WelcomePageHandlerMapping    : Adding welcome page: class path resource [static/index.html]
2020-01-07 02:24:37.589  INFO 1 --- [           main] o.s.b.a.e.w.EndpointLinksResolver        : Exposing 13 endpoint(s) beneath base path '/actuator'
2020-01-07 02:24:37.635  INFO 1 --- [           main] o.f.u.a.d.g.MinimalDataGenerator         : Verifying if minimal data is present
2020-01-07 02:24:37.695  INFO 1 --- [           main] o.f.u.a.d.g.MinimalDataGenerator         : No server configurations found, creating default server configurations
2020-01-07 02:24:37.805  INFO 1 --- [           main] o.f.u.a.a.FlowableAdminApplication       : Started FlowableAdminApplication in 6.965 seconds (JVM running for 50.658)
2020-01-07 02:29:42.857  INFO 1 --- [nio-8080-exec-2] o.s.w.s.DispatcherServlet                : Initializing Servlet 'dispatcherServlet'
2020-01-07 02:29:42.872  INFO 1 --- [nio-8080-exec-2] o.s.w.s.DispatcherServlet                : Completed initialization in 13 ms
2020-01-07 02:29:43.907  INFO 1 --- [nio-8080-exec-5] o.s.w.s.DispatcherServlet                : Initializing Servlet 'dispatcherServlet'
2020-01-07 02:29:43.914  INFO 1 --- [nio-8080-exec-5] o.s.w.s.DispatcherServlet                : Completed initialization in 6 ms
2020-01-07 02:29:46.215  INFO 1 --- [io-8080-exec-10] o.s.w.s.DispatcherServlet                : Initializing Servlet 'dispatcherServlet'
2020-01-07 02:29:46.224  INFO 1 --- [io-8080-exec-10] o.s.w.s.DispatcherServlet                : Completed initialization in 8 ms

No mention of REST endpoints in logs?

curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/runtime/tasks'

Output:

{
    "data": [
        {
            "id": "c3a48b57-30f6-11ea-806d-0242ac110004",
            "url": "http://localhost:8080/flowable-task/process-api/runtime/tasks/c3a48b57-30f6-11ea-806d-0242ac110004",
            "owner": null,
            "assignee": "flowable",
            "delegationState": null,
            "name": "My First Task",
            "description": "My first Flowable task",
            "createTime": "2020-01-07T02:38:19.062Z",
            "dueDate": null,
            "priority": 50,
            "suspended": false,
            "claimTime": null,
            "taskDefinitionKey": null,
            "scopeDefinitionId": null,
            "scopeId": null,
            "scopeType": null,
            "tenantId": "",
            "category": null,
            "formKey": null,
            "parentTaskId": null,
            "parentTaskUrl": null,
            "executionId": null,
            "executionUrl": null,
            "processInstanceId": null,
            "processInstanceUrl": null,
            "processDefinitionId": null,
            "processDefinitionUrl": null,
            "variables": []
        }
    ],
    "total": 1,
    "start": 0,
    "sort": "id",
    "order": "asc",
    "size": 1
}
curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/identity/users'

Output:

{
    "data": [],
    "total": 0,
    "start": 0,
    "sort": "id",
    "order": "asc",
    "size": 0
}

Screen Shot 2020-01-07 at 13 47 55

Robinyo commented 4 years ago

Screen Shot 2020-01-07 at 14 08 10

Try:

curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/identity/users/rob.ferguson'

Output:

{
    "message": "Not found",
    "exception": "Could not find a user with id 'rob.ferguson'."
}

Try:

curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/runtime/tasks?assignee=rob.ferguson'

Output:

{
    "data": [
        {
            "id": "c3a48b57-30f6-11ea-806d-0242ac110004",
            "url": "http://localhost:8080/flowable-task/process-api/runtime/tasks/c3a48b57-30f6-11ea-806d-0242ac110004",
            "owner": null,
            "assignee": "rob.ferguson",
            "delegationState": null,
            "name": "My First Task",
            "description": "My first Flowable task",
            "createTime": "2020-01-07T02:38:19.062Z",
            "dueDate": null,
            "priority": 50,
            "suspended": false,
            "claimTime": null,
            "taskDefinitionKey": null,
            "scopeDefinitionId": null,
            "scopeId": null,
            "scopeType": null,
            "tenantId": "",
            "category": null,
            "formKey": null,
            "parentTaskId": null,
            "parentTaskUrl": null,
            "executionId": null,
            "executionUrl": null,
            "processInstanceId": null,
            "processInstanceUrl": null,
            "processDefinitionId": null,
            "processDefinitionUrl": null,
            "variables": []
        }
    ],
    "total": 1,
    "start": 0,
    "sort": "id",
    "order": "asc",
    "size": 1
}

Try:

curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/identity/users/c3a48b57-30f6-11ea-806d-0242ac110004'

Output:

{
    "message": "Not found",
    "exception": "Could not find a user with id 'c3a48b57-30f6-11ea-806d-0242ac110004'."
}
yvoswillens commented 4 years ago

Currently; by default; the different applications in the Flowable all-in-one image use the default configuration / properties. Each have different database configurations (ports). This results in separate 'in mem' h2 databases for each application.

Fetching the users via the Flowable Process REST API will query the users table from the Task app db instance. Because in this case the users are managed by Flowable IDM this table is empty; hence no results.

In this specific situation; the Flowable all-in-one docker image; this is confusing. I will add 1 shared configuration (1 shared db) for all Flowable apps in the container.

In the meantime you can achieve this with the current docker image by setting a property with an environment variable.

docker run -p8080:8080 \
 -e "spring.datasource.url=jdbc:h2:~/flowable-db/db;AUTO_SERVER=TRUE;AUTO_SERVER_PORT=9091;DB_CLOSE_DELAY=-1" \
 flowable/all-in-one

Let me know if this helps.

Regards,

Yvo

Robinyo commented 4 years ago

Hi Yvo :)

Yes, this addresses the issue for non-LDAP users:

docker run -d --name flowable \
  -p 8080:8080 \
  -e "spring.datasource.url=jdbc:h2:~/flowable-db/db;AUTO_SERVER=TRUE;AUTO_SERVER_PORT=9091;DB_CLOSE_DELAY=-1" \
  --env-file no-ldap-env.txt \
  flowable/all-in-one

For example:

curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/identity/users'

Output:

{
    "data": [
        {
            "id": "flowable",
            "firstName": "Flowable",
            "lastName": "Administrator",
            "displayName": null,
            "url": "http://localhost:8080/flowable-task/process-api/identity/users/flowable",
            "email": "admin@flowable.org",
            "pictureUrl": null
        }
    ],
    "total": 1,
    "start": 0,
    "sort": "id",
    "order": "asc",
    "size": 1
}

However, for LDAP users

docker run -d --name flowable \
  -p 8080:8080 \
  -e "spring.datasource.url=jdbc:h2:~/flowable-db/db;AUTO_SERVER=TRUE;AUTO_SERVER_PORT=9091;DB_CLOSE_DELAY=-1" \
  --env-file ldap-env.txt \
  flowable/all-in-one

The (LDAP) user's are available in Flowable's web applications:

Screen Shot 2020-01-08 at 07 54 35

But they are not available via the REST API, for example:

curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/identity/users'

Output:

{
    "data": [],
    "total": 0,
    "start": 0,
    "sort": "id",
    "order": "asc",
    "size": 0
}

For example:

curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/identity/users/rob.ferguson'

Output:

{
    "message": "Not found",
    "exception": "Could not find a user with id 'rob.ferguson'."
}
yvoswillens commented 4 years ago

Hi,

The default /identity/users resource does not use the RemoteIDMService to fetch the users but the IdentityService. When running with an LDAP config like in your example a custom IdentityService implementation leveraging the RemoteIDMService logic could be configured.

But this is beyond the scope of the all-in-container which is targeted as 'quick start' solution.

Robinyo commented 4 years ago

OK, thanks.

It's great that it is configurable :) it's just that seeing users in Flowable's web applications kind of leads you to think that they will also show up in queries to the REST API (an interesting dichotomy).

I'm using Keycloak for IDM, user's register/login (from my Angular PWA) via an OIDC flow (Authorisation Code Flow with PKCE) and are created in OpenLDAP. I point Flowable to OpenLDAP so that user's are available in Flowable (and in my Angular PWA).

See: Serendipity's Developer Documentation

tlightsky commented 3 years ago

I also use keycloak for IDM in flowable-ui, it's very strange that I get different users from flowable-ui(using keycloak) and flowable-rest(using local db I think)

MIBc commented 3 years ago

OK, thanks.

It's great that it is configurable :) it's just that seeing users in Flowable's web applications kind of leads you to think that they will also show up in queries to the REST API (an interesting dichotomy).

Did it work if run all-in-one like docker run -p8080:8080 \ -e "spring.datasource.url=jdbc:h2:~/flowable-db/db;AUTO_SERVER=TRUE;AUTO_SERVER_PORT=9091;DB_CLOSE_DELAY=-1" \ flowable/all-in-one

The curl -i 'http://flowable:test@localhost:8080/flowable-task/process-api/identity/users' can get the same result with flowable ui? @Robinyo

yvoswillens commented 3 years ago

Closing this because this does not appear to be a valid issue. Please feel free to continue the discussion on the Flowable forum.