iconara Software, Support, and Training for Apache Cassandra en-US Sat, 18 May 2013 11:23:24 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/cql-3-truncate-and-batch-times-out#post-8536 Sun, 20 Jan 2013 10:18:28 +0000 Theo 8536@http://www.datastax.com/support-forums/ <p>I see now that the CQL 3 protocol specification says that "is ignored by some queries" for example <code>TRUNCATE</code>, so it doesn't seem like that could be the issue. </p> <p>For <code>BATCH</code> I'm specifying the consistency level in the driver, since I'm writing a driver. I'm not using <code>WITH CONSISTENCY LEVEL</code>. The command I send is exactly this:</p> <p>BEGIN BATCH<br /> INSERT INTO users (user_name, email) VALUES ('phil', 'phil@heck.com')<br /> INSERT INTO users (user_name, email) VALUES ('sue', 'sue@inter.net')<br /> APPLY BATCH </p> http://www.datastax.com/support-forums/topic/cql-3-truncate-and-batch-times-out#post-8523 Sat, 19 Jan 2013 18:35:51 +0000 khahn 8523@http://www.datastax.com/support-forums/ <p>and It might be a mistake to specify a consistency level for TRUNCATE. </p> http://www.datastax.com/support-forums/topic/cql-3-truncate-and-batch-times-out#post-8521 Sat, 19 Jan 2013 17:30:44 +0000 khahn 8521@http://www.datastax.com/support-forums/ <p>Your problem might be caused by a change in setting the consistency level in the release version of CQL 3 (in Cassandra 1.2). The BATCH operation no longer includes WITH CONSISTENCY LEVEL: <a href="http://www.datastax.com/docs/1.2/cql_cli/cql/BATCH#cql-batch" rel="nofollow">http://www.datastax.com/docs/1.2/cql_cli/cql/BATCH#cql-batch</a></p> <p>Programatically you set consistency at the driver level. Here's the cql2 method:</p> <p> CqlResult execute_cql_query(1:required binary query, 2:required<br /> Compression compression)</p> <p>And cql3:</p> <p> CqlResult execute_cql3_query(1:required binary query, 2:required<br /> Compression compression, 3:required ConsistencyLevel consistency) </p> http://www.datastax.com/support-forums/topic/cql-3-truncate-and-batch-times-out#post-8514 Sat, 19 Jan 2013 12:17:44 +0000 Theo 8514@http://www.datastax.com/support-forums/ <p>Hi,</p> <p>I'm writing a Ruby driver for the CQL 3 binary protocol (<a href="http://github.com/iconara/cql-rb" rel="nofollow">http://github.com/iconara/cql-rb</a>) and there are a few things that I can't get to work properly:</p> <p>* <code>TRUNCATE</code> commands block for around a minute and then return error #4099 "Error during truncate: Truncate timed out - received only 0 responses". It doesn't seem to matter which consistency level I run the command with, it always times out. The table I'm trying to truncate exists (if it hadn't I would have received another error -- I've checked). The exact CQL I send is <code>TRUNCATE users</code> with consistency level <code>ONE</code></p> <p>* <code>BACH</code> times similarily to <code>TRUNCATE</code>, but it responds with a little more information: the error is #4352 "Operation timed out - received only 0 responses." and the extra details (here as a Ruby hash): <code>{:cl=&gt;:one, :received=&gt;0, :blockfor=&gt;1, :write_type=&gt;&quot;BATCH_LOG&quot;}</code>. The exact CQL I send is</p> <p> BEGIN BATCH<br /> INSERT INTO users (user_name, email) VALUES ('phil', 'phil@heck.com')<br /> INSERT INTO users (user_name, email) VALUES ('sue', 'sue@inter.net')<br /> APPLY BATCH</p> <p>with consistency level <code>ONE</code>.</p> <p>All other CQL commands I've tried seem to work fine (you can see my whole integration test suite here: <a href="https://github.com/iconara/cql-rb/blob/master/spec/integration/integration_spec.rb)" rel="nofollow">https://github.com/iconara/cql-rb/blob/master/spec/integration/integration_spec.rb)</a></p> <p>yours<br /> Theo </p>