Re: Cassandra and GPU's...

2015-12-01 Thread Rock Zhang
unsubscribe On Tue, Dec 1, 2015 at 5:55 PM, james anderson wrote: > good morning; > > On 2015-12-01, at 21:53, Steve Robenalt wrote: > > Hi James, > > Yup, the analytics side of database usage is ripe with possibilities, as > the site at your

Re: Help diagnosing performance issue

2015-11-19 Thread rock zhang
unsubscribe. > On Nov 19, 2015, at 3:58 PM, Antoine Bonavita wrote: > > Sebastian, > > I took into account your suggestion and set max_sstable_age_days to 1. > > I left the TTL at 432000 and the gc_grace_seconds at 172800. So, I expect > SSTable older than 7 days to get

Re: unsubscribe

2015-10-14 Thread rock zhang
unsubscribe > On Oct 14, 2015, at 7:28 AM, Alain RODRIGUEZ wrote: > > From http://cassandra.apache.org/#lists > --> just email user-unsubscr...@cassandra.apache.org > > > > Alain > >

Node in DL status cannot be removed

2015-10-07 Thread Rock Zhang
Hi All, After I decommission the node, i see the node status is DL and always there, even after i removed the node, anybody knows how to remove it ? Many thanks. ubuntu@ip-172-31-30-145:~$ nodetool status Datacenter: DC1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving

Regarding " node tool move "

2015-09-24 Thread Rock Zhang
Hi All, I want to manually move some token from one hostA to host B, i do not fully understand this command, * move- Move node on the token ring to a new token* Say host A has token: (i got it with nodetool info -T) Token : -9096422322933500933 Token :

Re: Cassandra adding node issue (no UJ status)

2015-09-20 Thread Rock Zhang
ect of "Stream failed" > > When I encounter this issue, I make an attempt to bootstrap the new node > again. If that doesn't help, I run a repair on the new node. > > > On Tue, Sep 15, 2015 at 3:14 AM, Rock Zhang <r...@alohar.com> wrote: > >> Hi All, >

Cassandra adding node issue (no UJ status)

2015-09-15 Thread Rock Zhang
Hi All, Now I got a problem everything when add new node, the data is not balance again, just add it as new node. Originally I saw the UJ status, anybody experienced this kind of issue ? I don't know what changed . ubuntu@ip-172-31-15-242:/etc/cassandra$ nodetool status rawdata Datacenter:

OOM when Adding host

2015-08-10 Thread rock zhang
Hi All, Currently i have three hosts. The data is not balanced, one is 79G, another two have 300GB. When I adding a new host, firstly I got too many open files error, then i changed file open limit from 100,000 to 1, 000, 000. Then I got OOM error. Should I change the limits to 20,

Re: OOM when Adding host

2015-08-10 Thread rock zhang
My Cassandra version is 2.1.4. Thanks Rock On Aug 10, 2015, at 9:52 AM, rock zhang r...@alohar.com wrote: Hi All, Currently i have three hosts. The data is not balanced, one is 79G, another two have 300GB. When I adding a new host, firstly I got too many open files error, then i

Re: OOM when Adding host

2015-08-10 Thread rock zhang
I logged the open files every 10 mins, last record is : lsof -p $cassadnraPID | wc -l 74728 lsof |wc-l 5887913 # this is a very large number, don't know why. After OOM the open file numbers back to few hundreds (lsof | wc -l ). On Aug 10, 2015, at 9:59 AM, rock zhang r

Re: only grant select , but still can modify data

2015-08-06 Thread Rock Zhang
and DevCenter 1.4. What versions are you using? Did you check that the DevCenter connection properties are using the readonly account and that any existing connection was closed and re-opened? Did you get the expected result with cqlsh? dan On Mon, Aug 3, 2015 at 7:12 PM, rock zhang r...@alohar.com

only grant select , but still can modify data

2015-08-03 Thread rock zhang
Hi All, I want to create a readonly account, so i run the following command following: http://docs.datastax.com/en/cassandra/1.2/cassandra/security/security_config_native_authenticate_t.html CREATE USER readonly WITH PASSWORD '' ; GRANT SELECT ON ALL KEYSPACES TO readonly; Then I login

After clean up, the whole system is down

2015-07-25 Thread rock zhang
) ~[na:1.7.0_80] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_80] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80] On Jul 24, 2015, at 5:10 PM, Robert Coli rc...@eventbrite.com wrote: On Fri, Jul 24, 2015 at 5:03 PM, rock

if seed is diff on diff nodes, any problem ?

2015-07-25 Thread rock zhang
Hi All, I have 6 node, most of them are using node1 as seed, but I just find out 2 nodes are using node3 as seed, but everything looks fine. Does that mean seed node does not have to be same on all nodes ? Thanks Rock

Re: After clean up, the whole system is down

2015-07-25 Thread rock zhang
I tried to restart , but always get out of memory error. Then I changed to use new seed node, then it works. I guess the possible reason is I run cleanup twice ? I need to run repair to fix some inconsistency issue, right ? Thanks Rock On Jul 25, 2015, at 8:39 AM, rock zhang r

Nodetool cleanup takes long time and no progress

2015-07-24 Thread rock zhang
Hi All, After I added node, I run node tool cleanup on the old notes , but it takes forever, no error message, and I don't see space are freed. What should I do ? Repair first ? Thanks Rock

Re: Nodetool cleanup takes long time and no progress

2015-07-24 Thread rock zhang
, at 4:58 PM, rock zhang r...@alohar.com wrote: Thank you Jeff. I just added one more node, so i want to delete moved tokens. ubuntu@ip-172-31-30-145:~$ nodetool compactionstats pending tasks: 1413 compaction type keyspace table completed totalunit progress

Re: Nodetool cleanup takes long time and no progress

2015-07-24 Thread rock zhang
trying to clean up space after issuing a lot of deletes? On 7/24/15, 3:55 PM, rock zhang r...@alohar.com wrote: Hi All, After I added node, I run node tool cleanup on the old notes , but it takes forever, no error message, and I don't see space are freed. What should I do