[no subject]
We're using cassandra 2.0.9 with datastax java cassandra driver 2.0.0 in a cluster of eight nodes. We're doing an insert and after a delete like: delete from *column_family_name* where *id* = value Immediatly select to check whether the DELETE was successful. Sometimes the value still there!! Any suggestions? -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re:
RF=1 and CF=ONE. The clocks were sync. It was my first assumption. 2014-08-25 17:36 GMT-03:00 Jonathan Haddad : > This is actually a more correct response than mine, I made a few > assumptions that may or may not be true. > > On Mon, Aug 25, 2014 at 1:31 PM, Robert Coli wrote: > > On Mon, Aug 25, 2014 at 1:25 PM, Sávio S. Teles de Oliveira > > wrote: > >> > >> We're using cassandra 2.0.9 with datastax java cassandra driver 2.0.0 > in a > >> cluster of eight nodes. > >> > >> We're doing an insert and after a delete like: > >> > >> delete from column_family_name where id = value > >> > >> Immediatly select to check whether the DELETE was successful. Sometimes > >> the value still there!! > > > > What are Replication Factor (RF) and Consistency Level (CL)? > > > > =Rob > > > > > > -- > Jon Haddad > http://www.rustyrazorblade.com > twitter: rustyrazorblade > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Error on Memory Meter
I'm using Cassandra 2.0.9 embedded and got this error: java.lang.NoClassDefFoundError: Ljavax/transaction/TransactionManager; at java.lang.Class.getDeclaredFields0(Native Method) at java.lang.Class.privateGetDeclaredFields(Class.java:2436) at java.lang.Class.getDeclaredFields(Class.java:1806) at org.github.jamm.MemoryMeter.addFieldChildren(MemoryMeter.java:151) at org.github.jamm.MemoryMeter.measureDeep(MemoryMeter.java:110) at org.apache.cassandra.db.Memtable$MeteringRunnable.run(Memtable.java:458) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.ClassNotFoundException: javax.transaction.TransactionManager at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) ... 11 more Any suggestion? -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Concurrents deletes and updates
I'm using the Cassandra 2.0.9 with JAVA datastax driver. I'm running the tests in a cluster with 3 nodes, RF=3 and CL=ALL for each operation. I have a Column family filled with some keys (for example 'a' and 'b'). When this keys are deleted and inserted hereafter, sporadically this keys disappear. Is it a bug on Cassandra or on Datastax driver? Any suggestions? Tks
Re: Concurrents deletes and updates
The clocks are synced. Could you be experiencing > https://issues.apache.org/jira/browse/CASSANDRA-7801 ? Yes, its similar Philip. How can I solve this problem? 2014-09-17 16:16 GMT-03:00 Philip Thompson : > Could you be experiencing > https://issues.apache.org/jira/browse/CASSANDRA-7801 ? > > On Wed, Sep 17, 2014 at 2:09 PM, Jonathan Haddad > wrote: > >> Make sure your clocks are synced. If they aren't, the writetime that >> determines the most recent value will be incorrect. >> >> On Wed, Sep 17, 2014 at 11:58 AM, Robert Coli >> wrote: >> > On Wed, Sep 17, 2014 at 11:55 AM, Sávio S. Teles de Oliveira >> > wrote: >> >> >> >> I'm using the Cassandra 2.0.9 with JAVA datastax driver. >> >> I'm running the tests in a cluster with 3 nodes, RF=3 and CL=ALL for >> each >> >> operation. >> >> >> >> I have a Column family filled with some keys (for example 'a' and 'b'). >> >> When this keys are deleted and inserted hereafter, sporadically this >> keys >> >> disappear. >> >> >> >> Is it a bug on Cassandra or on Datastax driver? >> >> Any suggestions? >> > >> > >> > I would file a Cassandra JIRA with reproduction steps. >> > >> > http://issues.apache.org >> > >> > =Rob >> > http://twitter.com/rcolidba >> >> >> >> -- >> Jon Haddad >> http://www.rustyrazorblade.com >> twitter: rustyrazorblade >> > > -- Sávio Salvarino Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Master in Computer Science at Federal University of Goiás Software Analyst at GoGeo http://www.gogeo.io/
Re: Concurrents deletes and updates
Philip, I'm not using "IF NOT EXISTS" on insert command. 2014-09-17 16:51 GMT-03:00 Sávio S. Teles de Oliveira < savio.te...@cuia.com.br>: > The clocks are synced. > > Could you be experiencing >> https://issues.apache.org/jira/browse/CASSANDRA-7801 ? > > > Yes, its similar Philip. How can I solve this problem? > > 2014-09-17 16:16 GMT-03:00 Philip Thompson : > > Could you be experiencing >> https://issues.apache.org/jira/browse/CASSANDRA-7801 ? >> >> On Wed, Sep 17, 2014 at 2:09 PM, Jonathan Haddad >> wrote: >> >>> Make sure your clocks are synced. If they aren't, the writetime that >>> determines the most recent value will be incorrect. >>> >>> On Wed, Sep 17, 2014 at 11:58 AM, Robert Coli >>> wrote: >>> > On Wed, Sep 17, 2014 at 11:55 AM, Sávio S. Teles de Oliveira >>> > wrote: >>> >> >>> >> I'm using the Cassandra 2.0.9 with JAVA datastax driver. >>> >> I'm running the tests in a cluster with 3 nodes, RF=3 and CL=ALL for >>> each >>> >> operation. >>> >> >>> >> I have a Column family filled with some keys (for example 'a' and >>> 'b'). >>> >> When this keys are deleted and inserted hereafter, sporadically this >>> keys >>> >> disappear. >>> >> >>> >> Is it a bug on Cassandra or on Datastax driver? >>> >> Any suggestions? >>> > >>> > >>> > I would file a Cassandra JIRA with reproduction steps. >>> > >>> > http://issues.apache.org >>> > >>> > =Rob >>> > http://twitter.com/rcolidba >>> >>> >>> >>> -- >>> Jon Haddad >>> http://www.rustyrazorblade.com >>> twitter: rustyrazorblade >>> >> >> > > > -- > Sávio Salvarino Teles de Oliveira > voice: +55 62 9136 6996 > http://br.linkedin.com/in/savioteles > Master in Computer Science at Federal University of Goiás > Software Analyst at GoGeo > http://www.gogeo.io/ > -- Sávio Salvarino Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Master in Computer Science at Federal University of Goiás Software Analyst at GoGeo http://www.gogeo.io/
Write Inconsistency to update a row
I have two Cassandra 2.0.5 servers running with some datas inserted, where each row have one empty column. When the client send a lot of update commands to fill this column in each row, some lines update their content, but some lines remain with the empty column. Using one server, this never happens! Any suggestions? Tks. -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re: Write Inconsistency to update a row
replication_factor=1 CL=ONE Does the data show up eventually? Yes. Can be the clocks? 2014-07-03 10:47 GMT-03:00 graham sanderson : > What is your keyspace replication_factor? > > What consistency level are you reading/writing with? > > Does the data show up eventually? > > I’m assuming you don’t have any errors (timeouts etc) on the write site > > > On Jul 3, 2014, at 7:55 AM, Sávio S. Teles de Oliveira < > savio.te...@cuia.com.br> wrote: > > I have two Cassandra 2.0.5 servers running with some datas inserted, where > each row have one empty column. When the client send a lot of update > commands to fill this column in each row, some lines update their content, > but some lines remain with the empty column. > > Using one server, this never happens! > > Any suggestions? > > Tks. > -- > Atenciosamente, > Sávio S. Teles de Oliveira > voice: +55 62 9136 6996 > http://br.linkedin.com/in/savioteles > Mestrando em Ciências da Computação - UFG > Arquiteto de Software > CUIA Internet Brasil > > > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re: Write Inconsistency to update a row
> > Are you sure all the nodes are working at that time? Yes. They are working. I would suggest increasing the replication factor (for example 3) and use > CL=ALL or QUORUM to find out what is going wrong. I did! I still have the same problem. 2014-07-03 13:40 GMT-03:00 Panagiotis Garefalakis : > This seems like a hinted handoff issue but since you use CL = ONE it > should happen. > Are you sure all the nodes are working at that time? You could use > nodetool status to check that. > I would suggest increasing the replication factor (for example 3) and use > CL=ALL or QUORUM to find out what is going wrong. > > Regards, > Panagiotis > > > On Thu, Jul 3, 2014 at 5:11 PM, Sávio S. Teles de Oliveira < > savio.te...@cuia.com.br> wrote: > >> replication_factor=1 >> CL=ONE >> >> Does the data show up eventually? >> >> Yes. >> >> Can be the clocks? >> >> >> 2014-07-03 10:47 GMT-03:00 graham sanderson : >> >> What is your keyspace replication_factor? >>> >>> What consistency level are you reading/writing with? >>> >>> Does the data show up eventually? >>> >>> I’m assuming you don’t have any errors (timeouts etc) on the write site >>> >>> >>> On Jul 3, 2014, at 7:55 AM, Sávio S. Teles de Oliveira < >>> savio.te...@cuia.com.br> wrote: >>> >>> I have two Cassandra 2.0.5 servers running with some datas inserted, >>> where each row have one empty column. When the client send a lot of update >>> commands to fill this column in each row, some lines update their content, >>> but some lines remain with the empty column. >>> >>> Using one server, this never happens! >>> >>> Any suggestions? >>> >>> Tks. >>> -- >>> Atenciosamente, >>> Sávio S. Teles de Oliveira >>> voice: +55 62 9136 6996 >>> http://br.linkedin.com/in/savioteles >>> Mestrando em Ciências da Computação - UFG >>> Arquiteto de Software >>> CUIA Internet Brasil >>> >>> >>> >> >> >> -- >> Atenciosamente, >> Sávio S. Teles de Oliveira >> voice: +55 62 9136 6996 >> http://br.linkedin.com/in/savioteles >> Mestrando em Ciências da Computação - UFG >> Arquiteto de Software >> CUIA Internet Brasil >> > > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re: Write Inconsistency to update a row
> > Did you make sure all the nodes are on the same time? If they're not, > you'll get some weird results. They were not on the same time. I've synchronized the time and works! Tks 2014-07-03 16:58 GMT-03:00 Jack Krupansky : > You said that the updates do show up eventually – how long does it take? > > -- Jack Krupansky > > *From:* Sávio S. Teles de Oliveira > *Sent:* Thursday, July 3, 2014 1:30 PM > *To:* user@cassandra.apache.org > *Subject:* Re: Write Inconsistency to update a row > > >> Are you sure all the nodes are working at that time? > > > Yes. They are working. > > >> I would suggest increasing the replication factor (for example 3) and use >> CL=ALL or QUORUM to find out what is going wrong. > > > I did! I still have the same problem. > > > > 2014-07-03 13:40 GMT-03:00 Panagiotis Garefalakis : > >> This seems like a hinted handoff issue but since you use CL = ONE it >> should happen. >> Are you sure all the nodes are working at that time? You could use >> nodetool status to check that. >> I would suggest increasing the replication factor (for example 3) and use >> CL=ALL or QUORUM to find out what is going wrong. >> >> Regards, >> Panagiotis >> >> >> On Thu, Jul 3, 2014 at 5:11 PM, Sávio S. Teles de Oliveira < >> savio.te...@cuia.com.br> wrote: >> >>> replication_factor=1 >>> CL=ONE >>> >>> >>>> Does the data show up eventually? >>> >>> Yes. >>> >>> Can be the clocks? >>> >>> >>> 2014-07-03 10:47 GMT-03:00 graham sanderson : >>> >>> What is your keyspace replication_factor? >>>> >>>> What consistency level are you reading/writing with? >>>> >>>> Does the data show up eventually? >>>> >>>> I’m assuming you don’t have any errors (timeouts etc) on the write site >>>> >>>> >>>> On Jul 3, 2014, at 7:55 AM, Sávio S. Teles de Oliveira < >>>> savio.te...@cuia.com.br> wrote: >>>> >>>> I have two Cassandra 2.0.5 servers running with some datas inserted, >>>> where each row have one empty column. When the client send a lot of update >>>> commands to fill this column in each row, some lines update their content, >>>> but some lines remain with the empty column. >>>> >>>> Using one server, this never happens! >>>> >>>> Any suggestions? >>>> >>>> Tks. >>>> -- >>>> Atenciosamente, >>>> Sávio S. Teles de Oliveira >>>> voice: +55 62 9136 6996 >>>> http://br.linkedin.com/in/savioteles >>>> Mestrando em Ciências da Computação - UFG >>>> Arquiteto de Software >>>> CUIA Internet Brasil >>>> >>>> >>>> >>> >>> >>> >>> -- >>> Atenciosamente, >>> Sávio S. Teles de Oliveira >>> voice: +55 62 9136 6996 >>> http://br.linkedin.com/in/savioteles >>> Mestrando em Ciências da Computação - UFG >>> Arquiteto de Software >>> CUIA Internet Brasil >>> >> >> > > > > -- > Atenciosamente, > Sávio S. Teles de Oliveira > voice: +55 62 9136 6996 > http://br.linkedin.com/in/savioteles > Mestrando em Ciências da Computação - UFG > Arquiteto de Software > CUIA Internet Brasil > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re: Write Inconsistency to update a row
I have synchronized the clocks and works! 2014-07-03 20:58 GMT-03:00 Sávio S. Teles de Oliveira < savio.te...@cuia.com.br>: > Did you make sure all the nodes are on the same time? If they're not, >> you'll get some weird results. > > > They were not on the same time. I've synchronized the time and works! > > Tks > > > 2014-07-03 16:58 GMT-03:00 Jack Krupansky : > > You said that the updates do show up eventually – how long does it take? >> >> -- Jack Krupansky >> >> *From:* Sávio S. Teles de Oliveira >> *Sent:* Thursday, July 3, 2014 1:30 PM >> *To:* user@cassandra.apache.org >> *Subject:* Re: Write Inconsistency to update a row >> >> >>> Are you sure all the nodes are working at that time? >> >> >> Yes. They are working. >> >> >>> I would suggest increasing the replication factor (for example 3) and >>> use CL=ALL or QUORUM to find out what is going wrong. >> >> >> I did! I still have the same problem. >> >> >> >> 2014-07-03 13:40 GMT-03:00 Panagiotis Garefalakis : >> >>> This seems like a hinted handoff issue but since you use CL = ONE it >>> should happen. >>> Are you sure all the nodes are working at that time? You could use >>> nodetool status to check that. >>> I would suggest increasing the replication factor (for example 3) and >>> use CL=ALL or QUORUM to find out what is going wrong. >>> >>> Regards, >>> Panagiotis >>> >>> >>> On Thu, Jul 3, 2014 at 5:11 PM, Sávio S. Teles de Oliveira < >>> savio.te...@cuia.com.br> wrote: >>> >>>> replication_factor=1 >>>> CL=ONE >>>> >>>> >>>>> Does the data show up eventually? >>>> >>>> Yes. >>>> >>>> Can be the clocks? >>>> >>>> >>>> 2014-07-03 10:47 GMT-03:00 graham sanderson : >>>> >>>> What is your keyspace replication_factor? >>>>> >>>>> What consistency level are you reading/writing with? >>>>> >>>>> Does the data show up eventually? >>>>> >>>>> I’m assuming you don’t have any errors (timeouts etc) on the write >>>>> site >>>>> >>>>> >>>>> On Jul 3, 2014, at 7:55 AM, Sávio S. Teles de Oliveira < >>>>> savio.te...@cuia.com.br> wrote: >>>>> >>>>> I have two Cassandra 2.0.5 servers running with some datas inserted, >>>>> where each row have one empty column. When the client send a lot of update >>>>> commands to fill this column in each row, some lines update their content, >>>>> but some lines remain with the empty column. >>>>> >>>>> Using one server, this never happens! >>>>> >>>>> Any suggestions? >>>>> >>>>> Tks. >>>>> -- >>>>> Atenciosamente, >>>>> Sávio S. Teles de Oliveira >>>>> voice: +55 62 9136 6996 >>>>> http://br.linkedin.com/in/savioteles >>>>> Mestrando em Ciências da Computação - UFG >>>>> Arquiteto de Software >>>>> CUIA Internet Brasil >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> Atenciosamente, >>>> Sávio S. Teles de Oliveira >>>> voice: +55 62 9136 6996 >>>> http://br.linkedin.com/in/savioteles >>>> Mestrando em Ciências da Computação - UFG >>>> Arquiteto de Software >>>> CUIA Internet Brasil >>>> >>> >>> >> >> >> >> -- >> Atenciosamente, >> Sávio S. Teles de Oliveira >> voice: +55 62 9136 6996 >> http://br.linkedin.com/in/savioteles >> Mestrando em Ciências da Computação - UFG >> Arquiteto de Software >> CUIA Internet Brasil >> > > > > -- > Atenciosamente, > Sávio S. Teles de Oliveira > voice: +55 62 9136 6996 > http://br.linkedin.com/in/savioteles > Mestrando em Ciências da Computação - UFG > Arquiteto de Software > CUIA Internet Brasil > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re: Write Inconsistency to update a row
I've installed ntpd. Thanks! 2014-07-03 23:14 GMT-03:00 Jonathan Haddad : > Make sure you've got ntpd running, otherwise this will be an ongoing > nightmare. > > On Thu, Jul 3, 2014 at 5:00 PM, Sávio S. Teles de Oliveira > wrote: > > I have synchronized the clocks and works! > > > > > > 2014-07-03 20:58 GMT-03:00 Sávio S. Teles de Oliveira > > : > > > >>> Did you make sure all the nodes are on the same time? If they're not, > >>> you'll get some weird results. > >> > >> > >> They were not on the same time. I've synchronized the time and works! > >> > >> Tks > >> > >> > >> 2014-07-03 16:58 GMT-03:00 Jack Krupansky : > >> > >>> You said that the updates do show up eventually – how long does it > take? > >>> > >>> -- Jack Krupansky > >>> > >>> From: Sávio S. Teles de Oliveira > >>> Sent: Thursday, July 3, 2014 1:30 PM > >>> To: user@cassandra.apache.org > >>> Subject: Re: Write Inconsistency to update a row > >>> > >>>> > >>>> Are you sure all the nodes are working at that time? > >>> > >>> > >>> Yes. They are working. > >>> > >>>> > >>>> I would suggest increasing the replication factor (for example 3) and > >>>> use CL=ALL or QUORUM to find out what is going wrong. > >>> > >>> > >>> I did! I still have the same problem. > >>> > >>> > >>> > >>> 2014-07-03 13:40 GMT-03:00 Panagiotis Garefalakis >: > >>>> > >>>> This seems like a hinted handoff issue but since you use CL = ONE it > >>>> should happen. > >>>> Are you sure all the nodes are working at that time? You could use > >>>> nodetool status to check that. > >>>> I would suggest increasing the replication factor (for example 3) and > >>>> use CL=ALL or QUORUM to find out what is going wrong. > >>>> > >>>> Regards, > >>>> Panagiotis > >>>> > >>>> > >>>> On Thu, Jul 3, 2014 at 5:11 PM, Sávio S. Teles de Oliveira > >>>> wrote: > >>>>> > >>>>> replication_factor=1 > >>>>> CL=ONE > >>>>> > >>>>>> > >>>>>> Does the data show up eventually? > >>>>> > >>>>> Yes. > >>>>> > >>>>> Can be the clocks? > >>>>> > >>>>> > >>>>> 2014-07-03 10:47 GMT-03:00 graham sanderson : > >>>>> > >>>>>> What is your keyspace replication_factor? > >>>>>> > >>>>>> What consistency level are you reading/writing with? > >>>>>> > >>>>>> Does the data show up eventually? > >>>>>> > >>>>>> I’m assuming you don’t have any errors (timeouts etc) on the write > >>>>>> site > >>>>>> > >>>>>> > >>>>>> On Jul 3, 2014, at 7:55 AM, Sávio S. Teles de Oliveira > >>>>>> wrote: > >>>>>> > >>>>>> I have two Cassandra 2.0.5 servers running with some datas inserted, > >>>>>> where each row have one empty column. When the client send a lot of > update > >>>>>> commands to fill this column in each row, some lines update their > content, > >>>>>> but some lines remain with the empty column. > >>>>>> > >>>>>> Using one server, this never happens! > >>>>>> > >>>>>> Any suggestions? > >>>>>> > >>>>>> Tks. > >>>>>> -- > >>>>>> Atenciosamente, > >>>>>> Sávio S. Teles de Oliveira > >>>>>> voice: +55 62 9136 6996 > >>>>>> http://br.linkedin.com/in/savioteles > >>>>>> Mestrando em Ciências da Computação - UFG > >>>>>> Arquiteto de Software > >>>>>> CUIA Internet Brasil > >>>>>> > >>>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> -- > >>>>> Atenciosamente, > >>>>> Sávio S. Teles de Oliveira > >>>>> voice: +55 62 9136 6996 > >>>>> http://br.linkedin.com/in/savioteles > >>>>> Mestrando em Ciências da Computação - UFG > >>>>> Arquiteto de Software > >>>>> CUIA Internet Brasil > >>>> > >>>> > >>> > >>> > >>> > >>> > >>> -- > >>> Atenciosamente, > >>> Sávio S. Teles de Oliveira > >>> voice: +55 62 9136 6996 > >>> http://br.linkedin.com/in/savioteles > >>> Mestrando em Ciências da Computação - UFG > >>> Arquiteto de Software > >>> CUIA Internet Brasil > >> > >> > >> > >> > >> -- > >> Atenciosamente, > >> Sávio S. Teles de Oliveira > >> voice: +55 62 9136 6996 > >> http://br.linkedin.com/in/savioteles > >> Mestrando em Ciências da Computação - UFG > >> Arquiteto de Software > >> CUIA Internet Brasil > > > > > > > > > > -- > > Atenciosamente, > > Sávio S. Teles de Oliveira > > voice: +55 62 9136 6996 > > http://br.linkedin.com/in/savioteles > > Mestrando em Ciências da Computação - UFG > > Arquiteto de Software > > CUIA Internet Brasil > > > > -- > Jon Haddad > http://www.rustyrazorblade.com > skype: rustyrazorblade > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re: Read timeouts with ALLOW FILTERING turned on
How much did you reduce *read_request_timeout_in_ms* on your local machine? Cassandra timeout during read query is higher than one machine because Cassandra server must run the read operation in more servers (so you have network traffic). 2014-08-05 14:54 GMT-03:00 Robert Coli : > On Tue, Aug 5, 2014 at 10:01 AM, Clint Kelly > wrote: > >> Allow me to rephrase a question I asked last week. I am performing some >> queries with ALLOW FILTERING and getting consistent read timeouts like the >> following: >> > > ALLOW FILTERING should be renamed PROBABLY TIMEOUT in order to properly > describe its typical performance. > > As a general statement, if you have to ALLOW FILTERING, you are probably > Doing It Wrong in terms of schema design. > > A correctly operated cluster is unlikely to need to increase the default > timeouts. If you find yourself "needing" to do so, you are, again, probably > Doing It Wrong. > > =Rob > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re: Issue with ALLOW FILTERING
You need to create an index on attribute *c.* 2014-08-05 9:24 GMT-03:00 Jens Rantil : > Hi, > > I'm having an issue with ALLOW FILTERING with Cassandra 2.0.8. See a > minimal example here: > https://gist.github.com/JensRantil/ec43622c26acb56e5bc9 > > I expect the second last to fail, but the last query to return a single > row. In particular I expect the last SELECT to first select using the > clustering primary id and then do filtering. > > I've been reading > https://cassandra.apache.org/doc/cql3/CQL.html#selectStmt "ALLOW > FILTERING" and can't wrap my head around why this won't work. > > Could anyone clarify this for me? > > Thanks, > Jens > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
Re: moving older tables from SSD to HDD?
Have you looked nodetool? http://www.datastax.com/documentation/cassandra/2.0/cassandra/tools/toolsNodetool_r.html 2014-08-04 16:43 GMT-03:00 Kevin Burton : > Is it possible to take older tables, which are immutable, and move them > from SSD to HDD? > > We lower the SLA on older data so keeping it on HDD is totally fine. > > MySQL can *sort* of do this… and I think that Cassandra could if it was > handled properly. > > Kevin > > -- > > Founder/CEO Spinn3r.com > Location: *San Francisco, CA* > blog: http://burtonator.wordpress.com > … or check out my Google+ profile > <https://plus.google.com/102718274791889610666/posts> > <http://spinn3r.com> > > -- Atenciosamente, Sávio S. Teles de Oliveira voice: +55 62 9136 6996 http://br.linkedin.com/in/savioteles Mestrando em Ciências da Computação - UFG Arquiteto de Software CUIA Internet Brasil
