Re: Corrupted sstables

2019-05-09 Thread Jason Wee
maybe print out value into the logfile and that should lead to some clue where it might be the problem? On Tue, May 7, 2019 at 4:58 PM Paul Chandler wrote: > > Roy, We spent along time trying to fix it, but didn’t find a solution, it was > a test cluster, so we ended up rebuilding the cluster, r

Re: JOB | Permanent Java Development Manager (Montreal, Canada)

2018-08-01 Thread Jason Wee
Hi Eric, I agree with you. On Wed, Aug 1, 2018 at 11:15 PM, Eric Evans wrote: > On Tue, Jul 31, 2018 at 11:42 PM James Tobin wrote: >> Hello, I'm working with an employer that is looking to hire (for their >> Montreal office) a permanent development manager that has extensive >> hands-on Java co

Re: Cassandra Needs to Grow Up by Version Five!

2018-02-21 Thread Jason Brown
leads somewhere positive, that benefits everyone, -Jason On Wed, Feb 21, 2018 at 2:53 PM, Kenneth Brotman < kenbrot...@yahoo.com.invalid> wrote: > Hi Akash, > > I get the part about outside work which is why in replying to Jeff Jirsa I > was suggesting the big companies could jus

Re: Hints replay incompatible between 2.x and 3.x

2017-08-30 Thread Jason Brown
Hi Andrew, This question is best for the user@ list, included here. Thanks, -Jason On Wed, Aug 30, 2017 at 10:00 AM, Andrew Whang wrote: > In evaluating 3.x, we found that hints are unable to be replayed between > 2.x and 3.x nodes. This introduces a risk during the upgrade path fo

Re: Reg:- Cassandra Data modelling for Search

2017-06-12 Thread Jason Brown
removing dev@ from this conversation, as the thread is more appropriately for user@ On Mon, Jun 12, 2017 at 4:51 AM, Eduardo Alonso wrote: > -Virtual tokens are not recommended when using SOLR or > cassandra-lucene-index. > > If you use your table schema you will not have any problem with partit

Re: Long running compaction on huge hint table.

2017-05-16 Thread Jason Brown
Varun, This a message better for the user@ ML. Thanks, -Jason On Tue, May 16, 2017 at 3:41 AM, varun saluja wrote: > Hi Experts, > > We are facing issue on production cluster. Compaction on system.hint table > is running from last 2 days. > > > pending tasks: 1

Re: why dose it still have to seach in SSTable when getting data in memtable in the read flow?

2017-03-27 Thread jason zhao yang
Hi, Cassandra uses last-writetime-win strategy. In memory data doesn't mean it is the latest data due to custom write time, if data is also in Sstable, Cassandra has to read it and reconcile. Jasonstack On Mon, 27 Mar 2017 at 7:53 PM, 赵豫峰 wrote: > hello, I get the message that "If the memtable

Re: Does anyone store larger values in Cassandra E.g. 500 KB?

2016-10-21 Thread jason zhao yang
1. usually before storing object, serialization is needed, so we can know the size. 2. add "chunk id" as last clustering key. Vikas Jaiman 于2016年10月21日周五 下午11:46写道: > Thanks for your answer but I am just curious about: > > i)How do you identify the size of the object which you are going to chunk?

Re: Introducing Cassandra 3.7 LTS

2016-10-19 Thread Jason J. W. Williams
+1 On Wed, Oct 19, 2016 at 2:07 PM, sfesc...@gmail.com wrote: > Wow, thank you for doing this. This sentiment regarding stability seems to > be widespread. Is the team reconsidering the whole tick-tock cadence? If > not, I would add my voice to those asking that it is revisited. > > Steve > > On

Missing table suffix in data directory directories

2016-10-08 Thread Jason Kania
this command: SELECT keyspace_name, table_name, id FROM system_schema.tables ; Can someone indicate why some would have suffixes and others not? Thanks, Jason

Re: Understanding cassandra data directory contents

2016-10-08 Thread Jason Kania
these unused directories? Thanks, Jason Kania From: Vladimir Yudovin To: user@cassandra.apache.org; Jason Kania Sent: Saturday, October 8, 2016 2:05 PM Subject: Re: Understanding cassandra data directory contents Each table has unique id (suffix). If you drop and then recreate

Understanding cassandra data directory contents

2016-10-08 Thread Jason Kania
be removed. Thanks, Jason

Re: regarding drain process

2016-09-25 Thread jason zhao yang
Hi Varun, It looks like a scheduled job that runs "nodetool drain".. Zhao Yang Varun Barala 于2016年9月25日周日 下午7:45写道: > Jeff Jirsa thanks for your reply!! > > We are not using any chef/puppet and It happens only at one node other > nodes are working fine. > And all machines are using same AMI ima

Re: Corrupt SSTABLE over and over

2016-08-12 Thread Jason Wee
ill persist, wipe the node and it happen again, then i change the hardware (disk and mem). things went good. hth jason On Fri, Aug 12, 2016 at 9:20 AM, Alaa Zubaidi (PDF) wrote: > Hi, > > I have a 16 Node cluster, Cassandra 2.2.1 on Windows, local installation > (NOT on the cloud) >

Re: Adding Materialized View triggers "Mutation Too Large" error.

2016-08-08 Thread Jason J. W. Williams
Re-create the base table and views and reinsert all data again to the > base able. > > 2016-08-08 19:52 GMT-03:00 Jason J. W. Williams >: > >> HI Guys, >> >> We're running Cassandra 3.0.8, and needed to add a field to a table and >> it's materialize

Adding Materialized View triggers "Mutation Too Large" error.

2016-08-08 Thread Jason J. W. Williams
HI Guys, We're running Cassandra 3.0.8, and needed to add a field to a table and it's materialized views. We dropped the MVs, added the fields to the underlying table, and recreated MVs with the new fields. However, the MV creation is failing with: WARN [CompactionExecutor:6933] 2016-08-08 22:4

Re: DTCS SSTable count issue

2016-07-11 Thread Jason J. W. Williams
I can vouch for TWCS...we switched from DTCS to TWCS using Jeff's plugin w/ Cassandra 3.0.5 and just upgraded to 3.0.8 today and switched over to the built-in version of TWCS. -J On Mon, Jul 11, 2016 at 1:38 PM, Jeff Jirsa wrote: > DTCS is deprecated in favor of TWCS in new versions, yes. > > >

Re: Adding column to materialized view

2016-06-28 Thread Jason J. W. Williams
Thanks Tyler. -J On Tue, Jun 28, 2016 at 3:48 PM, Tyler Hobbs wrote: > This is expected. It's something we plan to support, but it hasn't been > done yet: https://issues.apache.org/jira/browse/CASSANDRA-9736 > > On Mon, Jun 27, 2016 at 4:25 PM, Jason J. W. Wil

Adding column to materialized view

2016-06-27 Thread Jason J. W. Williams
Hey Guys, Running Cassandra 3.0.5. Needed to add a column to a materialized view, but ALTER MATERIALIZED VIEW doesn't seem to allow that. So we ended up dropping the view and recreating it. Is that expected or did I miss something in the docs? -J

Re: Understanding when Cassandra drops expired time series data

2016-06-17 Thread Jason J. W. Williams
Hey Jeff, Do most of those behaviors apply to TWCS too? -J On Fri, Jun 17, 2016 at 1:25 PM, Jeff Jirsa wrote: > First, DTCS in 2.0.15 has some weird behaviors - > https://issues.apache.org/jira/browse/CASSANDRA-9572 . > > > > That said, some other general notes: > > > Data deleted by TTL isn’t

Re: Multi-DC Cluster w/ non-replicated Keyspace

2016-06-16 Thread Jason J. W. Williams
Ben > > On Fri, 17 Jun 2016 at 12:02 Jason J. W. Williams < > jasonjwwilli...@gmail.com> wrote: > >> Hey Ben, >> >> Looks like just the schema. I was surprised that running SELECTs against >> the DC which should not have any data (because it's not

Re: Multi-DC Cluster w/ non-replicated Keyspace

2016-06-16 Thread Jason J. W. Williams
J On Thu, Jun 16, 2016 at 7:55 PM, Ben Slater wrote: > Do you mean the data is getting replicated or just the schema? > > On Fri, 17 Jun 2016 at 11:48 Jason J. W. Williams < > jasonjwwilli...@gmail.com> wrote: > >> Hi Guys, >> >> We have a 2 DC cluster wher

Multi-DC Cluster w/ non-replicated Keyspace

2016-06-16 Thread Jason J. W. Williams
Hi Guys, We have a 2 DC cluster where the keyspaces are replicated between the 2. Is it possible to add a keyspace to one of the DCs that won't be replicated to the other? Whenever we add a new keyspace it seems to get replicated even if we don't specify the other DC in the keyspace's NetworkTopo

Re: Nodetool repair inconsistencies

2016-06-08 Thread Jason Kania
letely eliminate the sstables in a directory on one machine, run 'nodetool repair' followed by 'nodetool compact', that directory remains empty. My understanding has been that these equivalently named directories should contain roughly the same amount of content. Thanks,

Re: Nodetool repair inconsistencies

2016-06-08 Thread Jason Kania
compact error. Thanks, Jason From: Romain Hardouin To: "user@cassandra.apache.org" ; Jason Kania Sent: Wednesday, June 8, 2016 8:30 AM Subject: Re: Nodetool repair inconsistencies Hi Jason, It's difficult for the community to help you if you don't share the error ;

Nodetool repair inconsistencies

2016-06-07 Thread Jason Kania
nt to be caught because replication/repair is silently failing. I noticed that there is always an "some repair failed" amongst the repair output but that is so completely unhelpful and has always been present. Thanks, Jason

Re: Read data from specific node in cassandra

2016-05-05 Thread jason zhao yang
Hi, Can you check LoadBalancing Policy -> whiteList ? jasonstack Varun Barala 于2016年5月5日周四 下午5:40写道: > Hi Siddharth Verma, > > You can define consistency level LOCAL_ONE. > > and you can applyh consistency level during statement creation. > > like this -> statement.setConsistencyLevel(Consisten

StatusLogger is logging too many information

2016-04-25 Thread jason zhao yang
Hi, Currently StatusLogger will log info when there are dropped messages or GC more than 200 ms. In my use case, there are about 1000 tables. The status-logger is logging too many information for each tables. I wonder is there a way to reduce this log? for example, only print the thread pool in

Re: Most stable version?

2016-04-22 Thread Jason J. W. Williams
ythian | Twitter: @cjrolo | Linkedin: *linkedin.com/in/carlosjuzarterolo > <http://linkedin.com/in/carlosjuzarterolo>* > Mobile: +351 91 891 81 00 | Tel: +1 613 565 8696 x1649 > www.pythian.com > > On Fri, Apr 22, 2016 at 6:42 PM, Jason Williams > wrote: > >> Hi Car

Re: Most stable version?

2016-04-22 Thread Jason Williams
t; Regards, > > Carlos Juzarte Rolo > Cassandra Consultant / Datastax Certified Architect / Cassandra MVP > > Pythian - Love your data > > rolo@pythian | Twitter: @cjrolo | Linkedin: linkedin.com/in/carlosjuzarterolo > Mobile: +351 91 891 81 00 | Tel: +1 613 565 8696 x1

Re: Most stable version?

2016-04-22 Thread Jason Williams
My reading of the tick-rock cycle, is that we've moved from a stable train that receives mostly bug fixes until the next major stable, to one where every odd minor version is a bug fix-only...likely mostly for the previous even. The goal being a relatively continuously stable code base in odd mi

Re: Optional TLS CQL Encryption

2016-04-20 Thread Jason Williams
connections. > See https://issues.apache.org/jira/browse/CASSANDRA-9590 > >> On Wed, Apr 20, 2016 at 8:51 AM, Jason J. W. Williams >> wrote: >> Hi Ben, >> >> Thanks for confirming what I saw occur. The Datastax drivers don't play very >> nicely with Twisted Pyth

Re: Optional TLS CQL Encryption

2016-04-20 Thread Jason J. W. Williams
alls when using Twisted I'd appreciate insight on how you got that working because its pretty much undocumented. -J On Tue, Apr 19, 2016 at 11:46 PM, Ben Bromhead wrote: > Hi Jason > > If you enable encryption it will be always on. Optional encryption is > generally a bad idea

Optional TLS CQL Encryption

2016-04-19 Thread Jason J. W. Williams
Hey Guys, Is there a way to make TLS encryption optional for the CQL listener? We'd like to be able to use for remote management connections but not for same datacenter usage (since the build/up tear down cost is too high for things that don't use pools). Right now it appears if we enable encryp

Re: Cassandra table limitation

2016-04-06 Thread jason zhao yang
the different (probably competing) workloads >> effectively. >> >> Mike >> >> On Tue, Apr 5, 2016 at 8:40 PM, jason zhao yang < >> zhaoyangsingap...@gmail.com> wrote: >> >>> Hi Jack, >>> >>> Thanks for the reply. >>&g

Re: Cassandra table limitation

2016-04-05 Thread jason zhao yang
to scale with the table count. For one each >> table/CF has some fixed memory footprint on *ALL* nodes. The consensus is >> you shouldn't have more than "a few hundreds" of tables. >> >> On Mon, Apr 4, 2016 at 10:17 AM, jason zhao yang < >> zhaoyangsin

Re: Cassandra table limitation

2016-04-05 Thread jason zhao yang
oogle.com/forum/#!topic/nosql-databases/IblAhiLUXdk > > In short C* is not designed to scale with the table count. For one each > table/CF has some fixed memory footprint on *ALL* nodes. The consensus is > you shouldn't have more than "a few hundreds" of tables. > > O

Cassandra table limitation

2016-04-04 Thread jason zhao yang
Hi, This is Jason. Currently, I am using C* 2.1.10, I want to ask what's the optimal number of tables I should create in one cluster? My use case is that I will prepare a keyspace for each of my tenant, and every tenant will create tables they needed. Assume each tenant created 50 tables

Re: Inconsistent query results and node state

2016-03-31 Thread Jason Kania
result is the epoch 0 value. Thoughts on how to proceed? Thanks, Jason From: Tyler Hobbs To: user@cassandra.apache.org Sent: Wednesday, March 30, 2016 11:31 AM Subject: Re: Inconsistent query results and node state org.apache.cassandra.service.DigestMismatchException: Mismatch for

Re: Inconsistent query results and node state

2016-03-31 Thread Jason Kania
Thanks for the response. All nodes are using NTP. Thanks, Jason From: Kai Wang To: user@cassandra.apache.org; Jason Kania Sent: Wednesday, March 30, 2016 10:59 AM Subject: Re: Inconsistent query results and node state Do you have NTP setup on all nodes? On Tue, Mar 29, 2016 at

Inconsistent query results and node state

2016-03-29 Thread Jason Kania
on 192.168.10.9 Unfortunately, attempts to compact on 192.168.10.9 only give the following error without any stack trace detail and are not fixed with repair. root@cutthroat:/usr/local/bin/analyzer/bin# nodetool compact error: null -- StackTrace -- java.lang.ArrayIndexOutOfBoundsException

Re: Strategy for dividing wide rows beyond just adding to the partition key

2016-03-12 Thread Jason Kania
, these queries focus on raw, bulk retrieval of sensor data readings, but do you have reading-based queries, such as range of an actual sensor reading? -- Jack Krupansky On Fri, Mar 11, 2016 at 7:08 PM, Jason Kania wrote: The 5000 readings mentioned would be against a single sensor on a single sensor

Re: Strategy for dividing wide rows beyond just adding to the partition key

2016-03-12 Thread Jason Kania
en we don't know where to start and end. Thanks, Jason From: Carlos Alonso To: "user@cassandra.apache.org" Sent: Friday, March 11, 2016 7:24 PM Subject: Re: Strategy for dividing wide rows beyond just adding to the partition key Hi Jason, If I understand correctly you h

Re: Strategy for dividing wide rows beyond just adding to the partition key

2016-03-11 Thread Jason Kania
IMIT 5000 Splitting the bulk content out of the main table is something we considered too but we didn't find any detail on whether that would solve our timeout problem. If there is a reference for using this approach, it would be of interest to us to avoid any assumptions on how we would app

Re: Strategy for dividing wide rows beyond just adding to the partition key

2016-03-11 Thread Jason Kania
rectly supply the timeShard portion of our partition key. I appreciate your input, Thanks, Jason From: Jack Krupansky To: "user@cassandra.apache.org" Sent: Friday, March 11, 2016 4:45 PM Subject: Re: Strategy for dividing wide rows beyond just adding to the partition key

Re: Strategy for dividing wide rows beyond just adding to the partition key

2016-03-10 Thread Jason Kania
list of partition keys for the table because we cannot reduce the scope with a where clause. If there is a recommended pattern that solves this, we haven't come across it. I hope makes the problem clearer. Thanks, Jason From: Jack Krupansky To: user@cassandra.apache.org; Jason Kan

Re: Strategy for dividing wide rows beyond just adding to the partition key

2016-03-10 Thread Jason Kania
ld be appreciated. Thanks, Jason From: Jonathan Haddad To: user@cassandra.apache.org; Jason Kania Sent: Thursday, March 10, 2016 11:21 AM Subject: Re: Strategy for dividing wide rows beyond just adding to the partition key Have you considered making the date (or week, or whatever, some

Strategy for dividing wide rows beyond just adding to the partition key

2016-03-10 Thread Jason Kania
en looking around, but haven't found any references beyond the initial suggestion to add some sort of shard id to the partition key to handle wide rows. Thanks, Jason

Re: How to complete bootstrap with exception due to stream failure?

2016-02-28 Thread Jason Kania
I raised https://issues.apache.org/jira/browse/CASSANDRA-11273 with these details and the workaround that I found. From: Paulo Motta To: "user@cassandra.apache.org" ; Jason Kania Sent: Sunday, February 28, 2016 10:01 PM Subject: Re: How to complete bootstrap with except

Re: How to complete bootstrap with exception due to stream failure?

2016-02-27 Thread Jason Kania
Hi, I just reran the command and collected following. Any suggestions would be appreciated. Thanks, Jason from 192.168.10.8 ERROR [STREAM-IN-/192.168.10.10] 2016-02-27 20:37:53,857 StreamSession.java:635 - [Stream #c9868f90-ddbb-11e5-80c0-89f591237aca] Remote peer 192.168.10.10 failed stream

How to complete bootstrap with exception due to stream failure?

2016-02-27 Thread Jason Kania
indicates that the replication factor is 1: root@bull:~# nodetool repair [2016-02-27 18:04:55,083] Nothing to repair for keyspace 'sensordb' Thanks, Jason

Migrating from single node to cluster

2016-02-25 Thread Jason Kania
. Thanks, Jason

Re: Reenable data access after temporarily moving data out of data directory

2016-02-24 Thread Jason Kania
Thanks for the tool reference. That will help. The second part of my question was whether there is a way to actually perform data repair aside from copying data from a replica. Thanks, Jason From: Carlos Alonso To: user@cassandra.apache.org; Jason Kania Sent: Wednesday, February 24

Reenable data access after temporarily moving data out of data directory

2016-02-23 Thread Jason Kania
any tools to actually repair the data rather than copy it from a replica elsewhere because with the JVM error, the database JVMs are not staying up. Suggestions would be appreciated. Thanks, Jason

Re: too many full gc in one node of the cluster

2015-11-13 Thread Jason Wee
keyspace replication. hth, jason On Fri, Nov 13, 2015 at 2:35 PM, Shuo Chen wrote: > Hi, > > We have a small cassandra cluster with 4 nodes for production. All the > nodes have similar hardware configuration and similar data load. The C* > version is 1.0.7 (prretty old) > >

Re: Too many open files Cassandra 2.1.11.872

2015-11-06 Thread Jason Lewis
> On Fri, Nov 6, 2015 at 12:49 PM, Bryan Cheng >> wrote: >> >>> Is your compaction progressing as expected? If not, this may cause an >>> excessive number of tiny db files. Had a node refuse to start recently >>> because of this, had to temporarily

Too many open files Cassandra 2.1.11.872

2015-11-06 Thread Jason Lewis
I'm getting too many open files errors and I'm wondering what the cause may be. lsof -n | grep java show 1.4M files ~90k are inodes ~70k are pipes ~500k are cassandra services in /usr ~700K are the data files. What might be causing so many files to be open? jas

Re: Cassandra security using openssl or keytool

2015-10-29 Thread Jason J. W. Williams
> > I certainly don't vouch for the advisability of attempting a task you've > described as a "real pain" ... but if OP wants/needs to, it's their > funeral? :D > Agreed. I just wanted to elaborate what a "real pain" meant so OP would know I wasn't just blowing him off. -J

Re: Cassandra security using openssl or keytool

2015-10-29 Thread Jason J. W. Williams
> > Google words like : > > " > import openssl private key into keytool > " > > Find results like : > > > http://stackoverflow.com/questions/906402/importing-an-existing-x509-certificate-and-private-key-in-java-keystore-to-use-i/8224863#8224863 > > I wasted 4-5 hours of my life recently importing a

Re: Cassandra security using openssl or keytool

2015-10-29 Thread Jason Williams
Because when you use keytool it stores the generated private key in the keystore and tags it waiting for the certificate. Then when you import the issued certificate it is paired in the same record with the key. It's a real pain to get OpenSSL encoded private keys into a keytool keystore. Don't

Data Streamed successfully but not queryable

2015-10-22 Thread Jason Turner
10.129.1.112 |726 Executing seq scan across 3 sstables for [min(-9223372036854775808), min(-9223372036854775808)] [SharedPool-Worker-2] | 2015-10-22 16:06:56.045000 | 10.129.1.112 | 1423 Read 0 live and 0 tombstone cells [SharedPool-Worker-2] | 2015-10-22 16:06:56.045000 | 10.129.1.112 | 1779 Read 1 live and 0 tombstone cells [SharedPool-Worker-2] | 2015-10-22 16:06:56.045000 | 10.129.1.112 | 1850 Scanned 2 rows and matched 2 [SharedPool-Worker-2] | 2015-10-22 16:06:56.045000 | 10.129.1.112 | 1881 Submitted 1 concurrent range requests covering 257 ranges [SharedPool-Worker-1] | 2015-10-22 16:06:56.046000 | 10.129.1.112 | 5390 Request complete | 2015-10-22 16:06:56.045807 | 10.129.1.112 | 6807 Can anyone suggest why my data isn't being returned or where to continue digging? Thank you! Jason

Re: Verifying internode SSL

2015-10-13 Thread Jason J. W. Williams
Awesome. Thanks Nate! On Tue, Oct 13, 2015 at 10:32 AM, Nate McCall wrote: > > I've configured internode SSL and set it to be used between datacenters > only. Is there a way in the logs to verify SSL is operating between nodes > in different DCs or do I need to break out tcpdump? > > > > Even on

Verifying internode SSL

2015-10-13 Thread Jason Williams
Hi Guys, I've configured internode SSL and set it to be used between datacenters only. Is there a way in the logs to verify SSL is operating between nodes in different DCs or do I need to break out tcpdump? Thank you in advance. -J Sent via iPhone

Snapshots - Backup/Restore requirements

2015-10-12 Thread Jason Turner
server and if all nodes need to be Snapshotted, and have the snapshots and tokens backed up. Can anyone share their DR setups and maybe an overview of how you would recover if you lost your entire cluster? Thanks! Jason Turner HostedOps Engineer | Hosted Operations | 503.416.5080 (d

Re: Importing data from SQL Server

2015-09-14 Thread Jason Kushmaul
it. > I have to load data from SQL Server into Cassandra and I am completely new > to Cassandra and all of the posts I seem to be able to find are demos > about loading from MySQL into Cassandra. > Any, any help would be extremely appreciated! > Thank you very much! > Raluca > > > > > > -- Jason Kushmaul | 517.899.7852 Engineering Manager

Re: 'no such object in table'

2015-09-03 Thread Jason Lewis
I should probably add.. /etc/hosts had the hostname set to 127.0.1.1. On Thu, Sep 3, 2015 at 11:00 PM, Jason Lewis wrote: > I figured this one out. As it turns out, the nodes that I couldn't > connect to, had the hostname set to 127.0.1.1. The listen IP is *not* > that IP. >

Re: 'no such object in table'

2015-09-03 Thread Jason Lewis
I figured this one out. As it turns out, the nodes that I couldn't connect to, had the hostname set to 127.0.1.1. The listen IP is *not* that IP. Thanks for the logging tip, it helped track it down. On Thu, Sep 3, 2015 at 10:43 PM, Jason Lewis wrote: > After enabling that option, I&

Re: 'no such object in table'

2015-09-03 Thread Jason Lewis
After enabling that option, I'm seeing errors like this on the node I can't connect to. Sep 04, 2015 2:35:48 AM sun.rmi.server.UnicastServerRef logCallException FINE: RMI TCP Connection(4)-127.0.0.1: [127.0.0.1] exception: javax.management.InstanceNotFoundException: org.apache.cassandra.metrics:t

Re: 'no such object in table'

2015-08-26 Thread Jason Lewis
un.management.jmxremote.password.file=/etc/cassandra/jmxremote.password" fi On Tue, Aug 25, 2015 at 4:35 PM, Michael Shuler wrote: > On 08/25/2015 02:19 PM, Jason Lewis wrote: >> >> I'm trying to run nodetool from one node, connecting to another. I >> can successful

'no such object in table'

2015-08-25 Thread Jason Lewis
I'm trying to run nodetool from one node, connecting to another. I can successfully connect to the majority of nodes in my ring, but two nodes throw the following error. nodetool: Failed to connect to ':7199' NoSuchObjectException: 'no such object in table'. Any idea why this is happening? Misc

RE: Written data is lost and no exception thrown back to the client

2015-08-20 Thread Jason
What consistency level were the writes? -Original Message- From: "Robert Wille" Sent: ‎8/‎20/‎2015 18:25 To: "user@cassandra.apache.org" Subject: Written data is lost and no exception thrown back to the client I wrote a data migration application which I was testing, and I pushed it to

Re: Validation of Data after data migration from RDBMS to Cassandra

2015-08-06 Thread Jason Kushmaul
ubject:* Validation of Data after data migration from RDBMS to Cassandra > > > > Hi, > > > > We have to migrate the data from Oracle/mysql to Cassandra. > > I wanted to understand, if we have any tool/utilitiy which can help in > validation the data after the data migration to Cassandra. > > > > Thanks > Surbhi > -- Jason Kushmaul | 517.899.7852 Engineering Manager

Re: High CPU load

2015-07-20 Thread Jason Wee
just a guess, gc? On Mon, Jul 20, 2015 at 3:15 PM, Marcin Pietraszek wrote: > Hello! > > I've noticed a strange CPU utilisation patterns on machines in our > cluster. After C* daemon restart it behaves in a normal way, after a > few weeks since a restart CPU usage starts to raise. Currently on o

Re: Experiencing Timeouts on one node

2015-07-06 Thread Jason Wee
3. How do we rebuild System keyspace? wipe this node and start it all over. hth jason On Tue, Jul 7, 2015 at 12:16 AM, Shashi Yachavaram wrote: > When we reboot the problematic node, we see the following errors in > system.log. > > 1. Does this mean hints column family is corrupt

Re: Experiencing Timeouts on one node

2015-07-02 Thread Jason Wee
you should check the network connectivity for this node and also its system average load. is that typo or literary what it is, cassandra 1.2.15.*1* and java 6 update *85* ? On Thu, Jul 2, 2015 at 12:59 AM, Shashi Yachavaram wrote: > We have a 28 node cluster, out of which only one node is expe

Re: Error while adding a new node.

2015-07-01 Thread Jason Wee
nodetool cfstats? On Wed, Jul 1, 2015 at 8:08 PM, Neha Trivedi wrote: > Hey.. > nodetool compactionstats > pending tasks: 0 > > no pending tasks. > > Dont have opscenter. how do I monitor sstables? > > > On Wed, Jul 1, 2015 at 4:28 PM, Alain RODRIGUEZ > wrote: > >> You also might want to check

Re: Cassandra leap second

2015-07-01 Thread Jason Wee
same here too, on branch 1.1 and have not seen any high cpu usage. On Wed, Jul 1, 2015 at 2:52 PM, John Wong wrote: > Which version are you running and what's your kernel version? We are still > running on 1.2 branch but we have not seen any high cpu usage yet... > > On Tue, Jun 30, 2015 at 11:1

Re: Insert (and delete) data loss?

2015-06-30 Thread Jason Kushmaul
te e di distruggere il messaggio originale e > ogni file allegato senza farne copia alcuna o riprodurne in alcun modo il > contenuto. * This e-mail and its attachments are intended > for the addressee(s) only and are confidential and/or may contain legally > privileg

Re: After Restart Nodes had lost data

2015-06-23 Thread Jason Wee
on the node 192.168.2.100, did you run repair after its status is UN? On Wed, Jun 24, 2015 at 2:46 AM, Jean Tremblay < jean.tremb...@zen-innovations.com> wrote: > Dear Alain, > > Thank you for your reply. > > Ok, yes I did not drain. The cluster was loaded with tons of records, > and no new re

Re: system-hints compaction all the time

2015-06-22 Thread Jason Wee
what's your questions? On Mon, Jun 22, 2015 at 12:05 AM, 曹志富 wrote: > the logger like this : > > > INFO [CompactionExecutor:501] 2015-06-21 21:42:36,306 > CompactionTask.java:140 - Compacting > [SSTableReader(path='/home/ant/apache-cassandra-2.1.6/bin/../data/data/system/hints/system-hints-ka-3

Re: Garbage collector launched on all nodes at once

2015-06-17 Thread Jason Wee
okay, iirc memtable has been removed off heap, google and got this http://www.datastax.com/dev/blog/off-heap-memtables-in-Cassandra-2-1 apparently, there are still some reference on heap. On Thu, Jun 18, 2015 at 1:11 PM, Marcus Eriksson wrote: > It is probably this: https://issues.apache.org/ji

Re: Nodetool ring and "Replicas" after 1.2 upgrade

2015-06-15 Thread Jason Wee
maybe check the system.log to see if there is any exception and/or error? check as well if they are having consistent schema for the keyspace? hth jason On Tue, Jun 16, 2015 at 7:17 AM, Michael Theroux wrote: > Hello, > > We (finally) have just upgraded from Cassandra 1.1 to Cassand

Re: How to minimize Cassandra memory usage for test environment?

2015-06-09 Thread Jason Wee
for a start, maybe you can see the setting use by raspberry pi project, for instance http://ac31004.blogspot.com/2012/05/apache-cassandra-on-raspberry-pi.html you can look at these two files, to tune down the settings for test environment. cassandra-env.sh cassandra.yaml hth jason On Tue, Jun 9

Re: How to set datastax-angent connect with jmx an

2015-06-02 Thread Jason Wee
the error in the log output looks similar to this http://serverfault.com/questions/614810/opscenter-4-1-4-authentication-failing , in the opscenter 5.1.2 , do you configure the username/password same with the agent and cassandra node too? jason On Wed, Jun 3, 2015 at 11:13 AM, 贺伟平 wrote

Re: ERROR Compaction Interrupted

2015-06-01 Thread Jason Wee
/CompactionTask.java#L156-L157 jason On Tue, Jun 2, 2015 at 2:31 AM, Aiman Parvaiz wrote: > Hi everyone, > I am running C* 2.0.9 without vnodes and RF=2. Recently while repairing, > rebalancing the cluster I encountered one instance of this(just one on one > node): > > ERROR

Re: How to interpret some GC logs

2015-06-01 Thread Jason Wee
can you tell what jvm is that? jason On Mon, Jun 1, 2015 at 5:46 PM, Michał Łowicki wrote: > Hi, > > Normally I get logs like: > > 2015-06-01T09:19:50.610+: 4736.314: [GC 6505591K->4895804K(8178944K), > 0.0494560 secs] > > which is fine and understandable but o

Re: what this error mean

2015-05-28 Thread Jason Wee
://github.com/apache/cassandra/blob/cassandra-2.1.5/src/java/org/apache/cassandra/io/sstable/SSTableReader.java#L921 hth jason On Fri, May 29, 2015 at 9:39 AM, 曹志富 wrote: > I have a 25 noedes C* cluster with C* 2.1.3. These days a node occur split > brain many times。 > > che

Re: Start with single node, move to 3-node cluster

2015-05-27 Thread Jason Wee
hmm..i supposed you start with rf = 1 and then when 3n arrived, just add into the cluster and later decomission this one node? http://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_remove_node_t.html hth jason On Tue, May 26, 2015 at 10:02 PM, Matthew Johnson wrote: > Hi Ja

Cassandra 1.2.x EOL date

2015-05-27 Thread Jason Unovitch
icial EOL date was. Thanks! Jason

Re: Start with single node, move to 3-node cluster

2015-05-26 Thread Jason Wee
. with this single node, you can easily simulate like c* upgrade. for instance, c* right now is at 2.1.5, when 2.2 went stable, you can test using your multiple instances on this single node to simulate your production environment safely. hth jason On Tue, May 26, 2015 at 9:24 PM, Matthew Johnson

Re: Leveled Compaction Strategy with a really intensive delete workload

2015-05-25 Thread Jason Wee
ition ReplayPosition(segmentId=1432265013436, position=423408) INFO [MigrationStage:1] 2015-05-26 12:12:26,598 ColumnFamilyStore.java:882 - Enqueuing flush of dogtypes: 0 (0%) on-heap, 0 (0%) off-heap INFO [CompactionExecutor:191] 2015-05-26 12:12:26,668 CompactionTask.java:270 - Compacted 4 sstab

Re: Leveled Compaction Strategy with a really intensive delete workload

2015-05-25 Thread Jason Wee
, due to a really intensive delete workloads, the SSTable is promoted to t.. Is cassandra design for *delete* workloads? doubt so. Perhaps looking at some other alternative like ttl? jason On Mon, May 25, 2015 at 10:12 AM, Manoj Khangaonkar wrote: > Hi, > > For a delete

Re: Nodetool on 2.1.5

2015-05-21 Thread Jason Wee
yeah, you can confirm in the log such as the one below. WARN [main] 2015-05-22 11:23:25,584 CassandraDaemon.java:81 - JMX is not enabled to receive remote connections. Please see cassandra-env.sh for more info. we are running c* with ipv6, cqlsh works superb but not on local link. $ nodetool -h f

Re: C*1.2 on JVM 1.7

2015-05-16 Thread Jason Wee
Running java7u72 with c* 1.1 with no issues.. yet (hope not) :) Jason On Sat, May 16, 2015 at 2:39 AM, wrote: > I have run plenty of 1.2.x Cassandra versions on the Oracle JVM 1.7. I > have used both 1.7.0_40 and 1.7.0_72 with no issues. Also have 3.2.7 DSE > running on 1.7.0_72 in P

Re: java.lang.InternalError: a fault occurred in a recent unsafe memory access operation in compiled Java code

2015-05-03 Thread Jason Wee
try different jvm version or find out why is that happening? hth jason On Mon, May 4, 2015 at 10:10 AM, 曹志富 wrote: > Hi guys: > > I havle C* 2.1.3 cluster,25 nodes ,running in JDK_1.7.0_71, CentOS > 2.6.32-220.el6.x86_64,4 Core,32GB RAM. > > Today one of the nodes,has so

Re: Help understanding aftermath of death by GC

2015-03-31 Thread Jason Wee
begin to understand where and how to determine the root cause. jason On Tue, Mar 31, 2015 at 8:22 PM, Robert Wille wrote: > I moved my site over to Cassandra a few months ago, and everything has been > just peachy until a few hours ago (yes, it would be in the middle of the > night) when

Re: upgrade from 1.0.12 to 1.1.12

2015-03-27 Thread Jason Wee
is needed? Why not scrub? when you run command nodetool upgradesstables , it is actually scrubing the data? Can you explain ? Jason On Fri, Mar 27, 2015 at 7:21 AM, Robert Coli wrote: > On Wed, Mar 25, 2015 at 7:16 PM, Jonathan Haddad wrote: >> >> There's no downside to run

Re: upgrade from 1.0.12 to 1.1.12

2015-03-25 Thread Jason Wee
Sean, thanks and I will keep that in mind for this upgrade. Jason On Thu, Mar 26, 2015 at 1:23 AM, wrote: > Yes, run upgradesstables on all nodes - unless you already force major > compactions on all tables. I run them on a few nodes at a time to minimize > impact to performance. Th

Re: upgrade from 1.0.12 to 1.1.12

2015-03-25 Thread Jason Wee
hmm... okay. one more question https://github.com/apache/cassandra/blob/cassandra-1.1.12/NEWS.txt I upgraded directly to 1.1.12 , do I need to run nodetool upgradesstables as stipulated in version 1.1.3 ? jason On Wed, Mar 25, 2015 at 1:04 AM, Jonathan Haddad wrote: > Streaming is rep

upgrade from 1.0.12 to 1.1.12

2015-03-24 Thread Jason Wee
? Thanks. Jason

  1   2   3   4   >