flowable启动一直处于锁定等待状态

Blade 未结 1 3295
admin
admin 2019-08-01 10:02

2019-08-01 09:57:15.142  INFO 53449 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM BLADEX_FLOW.ACT_CO_DATABASECHANGELOGLOCK

2019-08-01 09:57:15.164  INFO 53449 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT COUNT(*) FROM BLADEX_FLOW.ACT_CO_DATABASECHANGELOGLOCK

2019-08-01 09:57:15.185  INFO 53449 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT LOCKED FROM BLADEX_FLOW.ACT_CO_DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE

2019-08-01 09:57:15.237  INFO 53449 --- [           main] l.lockservice.StandardLockService        : Waiting for changelog lock....

2019-08-01 09:57:25.240  INFO 53449 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT LOCKED FROM BLADEX_FLOW.ACT_CO_DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE

2019-08-01 09:57:25.330  INFO 53449 --- [           main] l.lockservice.StandardLockService        : Waiting for changelog lock....

2019-08-01 09:57:35.333  INFO 53449 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT LOCKED FROM BLADEX_FLOW.ACT_CO_DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE

2019-08-01 09:57:35.372  INFO 53449 --- [           main] l.lockservice.StandardLockService        : Waiting for changelog lock....

2019-08-01 09:57:45.376  INFO 53449 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT LOCKED FROM BLADEX_FLOW.ACT_CO_DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE

2019-08-01 09:57:45.643  INFO 53449 --- [           main] l.lockservice.StandardLockService        : Waiting for changelog lock....

2019-08-01 09:57:55.647  INFO 53449 --- [           main] liquibase.executor.jvm.JdbcExecutor      : SELECT LOCKED FROM BLADEX_FLOW.ACT_CO_DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE

2019-08-01 09:58:00.634  INFO 53449 --- [           main] l.lockservice.StandardLockService        : Waiting for changelog lock....

Disconnected from the target VM, address: '127.0.0.1:57103', transport: 'socket'


1条回答
  •  admin
    admin (楼主)
    2019-08-01 10:03

    看到这一类错误,一般是flowable在启动更新表的时候,会先锁表,如果中途突发情况中断,没有解锁。就会有如上报错,解决方案如下:

    1.找到表 ACT_CO_DATABASECHANGELOGLOCK

    image.png

    2.将locked字段改为0,并将后面两个字段清空

    image.png



    image.png


    0 讨论(0)
提交回复