RE: timeout creating table

this is expected. Cheers, Matt *From:* y2k...@gmail.com [mailto:y2k...@gmail.com] *On Behalf Of *Jimmy Lin *Sent:* 23 April 2015 18:01 *To:* user@cassandra.apache.org *Subject:* Re: timeout creating table well i am pretty sure our CL is one. and the long pause seems happen somewhat

Re: timeout creating table

well i am pretty sure our CL is one. and the long pause seems happen somewhat randomly. But is creating keyspace or table statements has different treatment in terms of CL that may explain the long pause? thanks On Thu, Apr 23, 2015 at 8:04 AM, Sebastian Estevez < sebastian.este...@datastax.com>

Re: timeout creating table

That is a problem, you should not have RF > N. Do an alter table to fix it. This will affect your reads and writes if you're doing anything > CL 1 --> timeouts. On Apr 23, 2015 4:35 AM, "Jimmy Lin" wrote: > Also I am not sure it matters, but I just realized the keyspace created > has replicatio

Re: timeout creating table

Also I am not sure it matters, but I just realized the keyspace created has replication factor of 2 when my Cassandra is really just a single node. Is Cassandra smart enough to ignore the RF of 2 and work with only 1 single node? On Mon, Apr 20, 2015 at 8:23 PM, Jimmy Lin wrote: > hi, > there

Re: timeout creating table

hi, there were only a few (4 of them across 4 minutes with around 200ms), so shouldn't be the reason The system log has tons of INFO [MigrationStage:1] 2015-04-20 11:03:21,880 ColumnFamilyStore.java (line 633) Enqueuing flush of Memtable-schema_keyspaces@2079381036(138/1215 serialized/live bytes,

Re: timeout creating table

Can you grep for GCInspector in your system.log? Maybe you have long GC pauses. All the best, [image: datastax_logo.png] Sebastián Estévez Solutions Architect | 954 905 8615 | sebastian.este...@datastax.com [image: linkedin.png]

Re: timeout creating table

Yes, sometimes it is create table and sometime it is create index. It doesn't happen all the time, but feel like if multiple tests trying to do schema change(create or drop), Cassandra has a long delay on the schema change statements. I also just read about "auto_snapshot", and I turn it off but s

Re: timeout creating table

Jimmy, What's the exact command that produced this trace? Are you saying that the 16-second wait in your trace what times out in your CREATE TABLE statements? Jim Witschey Software Engineer in Test | jim.witsc...@datastax.com On Sun, Apr 19, 2015 at 7:13 PM, Jimmy Lin wrote: > hi, > we have so