卡桑德拉（Cassandra）“检测到无法读取的稳定器”错误 [英] Cassandra "Detected unreadable sstables " Error

问题描述

在我的Windows框上，正常重启Windows更新后，我在Cassandra（2.2.0）中收到以下错误，它将无法启动：

On my windows box, after a graceful restart for windows update, I get the following error in Cassandra (2.2.0) and it will not start:

ERROR 10:36:41检测到不可读的sstables D：\cassandra_data\data\gputptest-abcdedf-5040777060fe11e5a8557fcd8340170b-KeyCache-b.db，D：\cassandra_data\data\OpsCenter-events_timeline-afbbeee05cea11e59ba77fcd-340b db，D：\cassandra_data\data\system-IndexInfo-9f5c6374d48532299a0a5094af9ad1e3-KeyCache-b.db .....，请检查NEWS.txt并确保已通过所有必需的中间版本进行升级，并运行upgradesstables

ERROR 10:36:41 Detected unreadable sstables D:\cassandra_data\data\gputptest-abcdedf-5040777060fe11e5a8557fcd8340170b-KeyCache-b.db,D:\cassandra_data\data\OpsCenter-events_timeline-afbbeee05cea11e59ba77fcd8340170b-KeyCache-b.db,D:\cassandra_data\data\system-IndexInfo-9f5c6374d48532299a0a5094af9ad1e3-KeyCache-b.db,...., please check NEWS.txt and ensure that you have upgraded through all required intermediate versions, running upgradesstables

关于如何恢复数据库的任何建议？还是至少丢掉那些不可读的sstables并恢复其余的？？

Any suggestion how I can recover the database? Or, at least drop those unreadable sstables and recover the rest?

推荐答案

问题已解决[信用卡代号Jeff Jirsa的帖子< a href = http://mail-archives.apache.org/mod_mbox/cassandra-user/201508.mbox/[e-mail]%3E rel = nofollow title = here>此处]

Problem solved [Credit goes to Jeff Jirsa for his post here]

我只是删除了错误消息中报告的所有* .- KeyCache-b.db文件。然后，我启动了Cassandra，一切都很好。

I simply deleted all *.-KeyCache-b.db files reported in the error message. Then, I started Cassandra and everything was fine.

要删除有问题的* .- KeyCache-b.db文件（错误消息中有30个文件），我将文件名放在一个文本文件中，并在Powershell中运行以下命令：

To delete the problematic *.-KeyCache-b.db files (there were 30 of them in the error message), I put the file names in a text file and ran the following command in powershell:

Get-Content unreadables_stables.txt | Remove-Item

这篇关于卡桑德拉（Cassandra）“检测到无法读取的稳定器”错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！