Cassandra - uk.sky.cqlmigrate.exception.CannotAcquireLockException: Lock currently in use

java.util.concurrent.TimeoutException: Timed out after waiting 3034 ms, with timeout 3000 ms
        at uk.sky.cqlmigrate.RetryTask.untilSuccess(RetryTask.java:28)
        at uk.sky.cqlmigrate.Lock.lock(Lock.java:47)
        at uk.sky.cqlmigrate.CqlMigratorImpl.migrate(CqlMigratorImpl.java:77)
        at com.xxx.xxx.cassandra.Main.main(Main.java:145)
#[051219 03:08:26,155 | xxxxx-19.0.0-20190813042221-f5zrl | ERROR | main | Main | Exception: {}]#
uk.sky.cqlmigrate.exception.CannotAcquireLockException: Lock currently in use
        at uk.sky.cqlmigrate.Lock.lock(Lock.java:50)
        at uk.sky.cqlmigrate.CqlMigratorImpl.migrate(CqlMigratorImpl.java:77)
        at com.xxx.xxx.cassandra.Main.main(Main.java:145)
Caused by: java.util.concurrent.TimeoutException: Timed out after waiting 3034 ms, with timeout 3000 ms
        at uk.sky.cqlmigrate.RetryTask.untilSuccess(RetryTask.java:28)
        at uk.sky.cqlmigrate.Lock.lock(Lock.java:47)
        ... 2 common frames omitted

网上搜咯了一圈,也没有解决我的问题,有说是 原因为:Spring 事务嵌套造成死锁。但是并不适合我这个问题;

后来跟同事一起排查发现,在Cassandra的keyspace中,多了一个叫做schema的表空间,导致脚本在执行的时候,冲突了从而将整个库锁了。。。手动删除这个多余的表空间,重新执行脚本就好了;

##删除表空间
DROP keyspace schema;
##创建表空间
CREATE KEYSPACE "devdb" WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '3'}  AND durable_writes = true;
##创建用户及密码
CREATE USER dev WITH PASSWORD 'dev123' SUPERUSER ;
微信公众号,搜索:zhangdaopin,也可方便快捷的看到本人的博客哦,谢谢~

 

posted @   zhangdaopin  阅读(40)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
点击右上角即可分享
微信分享提示