开发者社区> 问答> 正文

canal服务启动的是2个instance,出现以下2个问题

版本1.0.25,canal服务启动的是2个instance,出现以下2个问题

1.canal server启动后会产生unauthenticated user 非认证用户连接

2.锁文件

2018-06-22 14:08:32 database: flush org.h2.message.DbException: General error: "java.lang.IllegalStateException: The file is locked: nio:/usr/local/canal/conf/business/h2.mv.db [1.4.196/7]" [50000-196] at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.mvstore.db.MVTableEngine$1.uncaughtException(MVTableEngine.java:95) at org.h2.mvstore.MVStore.panic(MVStore.java:378) at org.h2.mvstore.MVStore.(MVStore.java:361) at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2930) at org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:155) at org.h2.mvstore.db.MVTableEngine.init(MVTableEngine.java:100) at org.h2.engine.Database.getPageStore(Database.java:2476) at org.h2.engine.Database.open(Database.java:697) at org.h2.engine.Database.openDatabase(Database.java:276) at org.h2.engine.Database.(Database.java:270) at org.h2.engine.Engine.openSession(Engine.java:64) at org.h2.engine.Engine.openSession(Engine.java:176) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154) at org.h2.engine.Engine.createSession(Engine.java:137) at org.h2.engine.Engine.createSession(Engine.java:27) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:354) at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:116) at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:100) at org.h2.Driver.connect(Driver.java:69) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1510) at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1575) at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2450) Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: The file is locked: nio:/usr/local/canal/conf/business/h2.mv.db [1.4.196/7]" [50000-196] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) ... 24 more Caused by: java.lang.IllegalStateException: The file is locked: nio:/usr/local/canal/conf/business/h2.mv.db [1.4.196/7] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:765) at org.h2.mvstore.FileStore.open(FileStore.java:173) at org.h2.mvstore.MVStore.(MVStore.java:347) ... 19 more

原提问者GitHub用户jingshenbusi6530

展开
收起
绿子直子 2023-05-09 10:15:42 155 0
1 条回答
写回答
取消 提交回答
  • The file is locked,估计是重复启动同一个instance的,检查一下这个文件: /usr/local/canal/conf/business/h2.mv.db, 对应的文件句柄被哪个进程已经打开了

    原回答者GitHub用户agapple

    2023-05-10 09:27:34
    赞同 展开评论 打赏
问答分类:
问答地址:
问答排行榜
最热
最新

相关电子书

更多
低代码开发师(初级)实战教程 立即下载
冬季实战营第三期:MySQL数据库进阶实战 立即下载
阿里巴巴DevOps 最佳实践手册 立即下载