cassandra drop keyspace永远挂起

Question

我尝试使用cqlsh删除一个键空间：

drop keyspace test;

然后它会无限期地挂起。当我最终中断它时，我不能再使用cqlsh。例如，这也挂起了：

describe keyspaces;

然后我必须重新启动cqlsh。在描述键空间时，我有这样的想法：

cqlsh> describe keyspace test;

CREATE KEYSPACE test WITH replication = {
  'class': 'SimpleStrategy',
  'replication_factor': '1'
};
Bad Request: unconfigured table schema_columnfamilies

在/var/log/cassandra/system.log中，我所拥有的就是：

INFO  [Thrift:12] 2016-03-30 12:20:27,145 MigrationManager.java:448 - Drop Keyspace 'test'

我试过了：

❱❱❱ sstablescrub keyspace test                                            
WARN  10:27:00 Small commitlog volume detected at /var/lib/cassandra/commitlog; setting commitlog_total_space_in_mb to 2314.  You can override this in cassandra.yaml
WARN  10:27:00 Only 4248 MB free across all data volumes. Consider adding more capacity to your cluster or removing obsolete snapshots
ERROR 10:27:01 Exiting due to error while processing commit log during initialization.
org.apache.cassandra.io.FSWriteError: java.nio.file.AccessDeniedException: /var/lib/cassandra/commitlog/CommitLog-6-1459333621738.log
    at org.apache.cassandra.db.commitlog.CommitLogSegment.<init>(CommitLogSegment.java:149) ~[apache-cassandra-3.0.4.jar:3.0.4]
    at org.apache.cassandra.db.commitlog.MemoryMappedSegment.<init>(MemoryMappedSegment.java:47) ~[apache-cassandra-3.0.4.jar:3.0.4]
    at org.apache.cassandra.db.commitlog.CommitLogSegment.createSegment(CommitLogSegment.java:122) ~[apache-cassandra-3.0.4.jar:3.0.4]
    at org.apache.cassandra.db.commitlog.CommitLogSegmentManager$1.runMayThrow(CommitLogSegmentManager.java:121) ~[apache-cassandra-3.0.4.jar:3.0.4]
    at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) [apache-cassandra-3.0.4.jar:3.0.4]
    at java.lang.Thread.run(Thread.java:745) [na:1.8.0_73]
Caused by: java.nio.file.AccessDeniedException: /var/lib/cassandra/commitlog/CommitLog-6-1459333621738.log
    at sun.nio.fs.UnixException.translateToIOException(UnixException.java:84) ~[na:1.8.0_73]
    at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:102) ~[na:1.8.0_73]
    at sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:107) ~[na:1.8.0_73]
    at sun.nio.fs.UnixFileSystemProvider.newFileChannel(UnixFileSystemProvider.java:177) ~[na:1.8.0_73]
    at java.nio.channels.FileChannel.open(FileChannel.java:287) ~[na:1.8.0_73]
    at java.nio.channels.FileChannel.open(FileChannel.java:335) ~[na:1.8.0_73]
    at org.apache.cassandra.db.commitlog.CommitLogSegment.<init>(CommitLogSegment.java:144) ~[apache-cassandra-3.0.4.jar:3.0.4]
    ... 5 common frames omitted

还有这个：

nodetool scrub test

还有这个：

❱❱❱ nodetool repair test
[2016-03-30 12:28:44,970] Nothing to repair for keyspace 'test'

还有这个：

❱❱❱ nodetool clearsnapshot
Requested clearing snapshot(s) for [all keyspaces]

但似乎什么都不起作用。知道我怎么才能修好它吗？

Answer 1

这也发生在我身上--由于Cassandra服务器版本和Cassandra客户端版本(CQLSH)不一致。

您正在使用cqlsh，因此请确保您正在运行的cqlsh的版本与您要连接到的Cassandra的版本相同。