And to clarify my reply, this was a loop in compactions on system-schema_columns specifically.
From: Michael Kjellman <mkjell...@barracuda.com<mailto:mkjell...@barracuda.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>> Date: Monday, October 15, 2012 8:11 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>> Subject: Re: Why my Cassandra is compacting like mad I had a similar bug with 1.1.5 but I couldn't reproduce it so I didn't file a bug. I did a rolling restart of my nodes and things went back to normal. From: Manu Zhang <owenzhang1...@gmail.com<mailto:owenzhang1...@gmail.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>> Date: Monday, October 15, 2012 8:02 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" <user@cassandra.apache.org<mailto:user@cassandra.apache.org>> Subject: Why my Cassandra is compacting like mad My Cassandra is compacting like mad (look at the following messages) after I restart it after a timeout query. It won't stop until I kill the process. INFO 22:57:41,839 Compacting [SSTableReader(path='/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1258-Data.db')] INFO 22:57:42,077 Compacted to [/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1259-Data.db,]. 4,377 to 4,377 (~100% of original) bytes for 3 keys at 0.017539MB/s. Time: 238ms. INFO 22:57:42,079 Compacting [SSTableReader(path='/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1259-Data.db')] INFO 22:57:42,309 Compacted to [/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1260-Data.db,]. 4,377 to 4,377 (~100% of original) bytes for 3 keys at 0.018149MB/s. Time: 230ms. INFO 22:57:42,311 Compacting [SSTableReader(path='/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1260-Data.db')] INFO 22:57:42,574 Compacted to [/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1261-Data.db,]. 4,377 to 4,377 (~100% of original) bytes for 3 keys at 0.015872MB/s. Time: 263ms. INFO 22:57:42,576 Compacting [SSTableReader(path='/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1261-Data.db')] INFO 22:57:42,814 Compacted to [/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1262-Data.db,]. 4,377 to 4,377 (~100% of original) bytes for 3 keys at 0.017539MB/s. Time: 238ms. INFO 22:57:42,816 Compacting [SSTableReader(path='/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1262-Data.db')] INFO 22:57:43,070 Compacted to [/home/manuzhang/cassandra/data/system/schema_columns/system-schema_columns-ia-1263-Data.db,]. 4,377 to 4,377 (~100% of original) bytes for 3 keys at 0.016434MB/s. Time: 254ms. ---------------------------------- 'Like' us on Facebook for exclusive content and other resources on all Barracuda Networks solutions. Visit http://barracudanetworks.com/facebook 'Like' us on Facebook for exclusive content and other resources on all Barracuda Networks solutions. Visit http://barracudanetworks.com/facebook
