From user-return-33872-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Thu May 2 18:26:12 2013 Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1B8A4100FB for ; Thu, 2 May 2013 18:26:12 +0000 (UTC) Received: (qmail 1729 invoked by uid 500); 2 May 2013 18:26:09 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 1697 invoked by uid 500); 2 May 2013 18:26:09 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 1686 invoked by uid 99); 2 May 2013 18:26:09 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 May 2013 18:26:09 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a45.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 May 2013 18:26:01 +0000 Received: from homiemail-a45.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a45.g.dreamhost.com (Postfix) with ESMTP id 1787F480CD for ; Thu, 2 May 2013 11:25:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=from :content-type:message-id:mime-version:subject:date:references:to :in-reply-to; s=thelastpickle.com; bh=ZBoc6volDkXx6SEV5R28tHQ1Yr M=; b=KBTuGYGRxKFAr9j3yvaXlTrq3Ooc0wYjlnCRh40BDNpyxoNDMEr22+rC8A fCSEPx+lxFEAm1xDqd809LAsw6IlyG2Kku6Kgdl5//KzlpUoWkG4vzknGzcV4qTj 2EGFjRQjnteVsvWJvrLItZTzEOqTpzlDKie017TRsccUjdu6k= Received: from [172.16.1.8] (unknown [203.86.207.101]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a45.g.dreamhost.com (Postfix) with ESMTPSA id 75C52480D2 for ; Thu, 2 May 2013 11:25:32 -0700 (PDT) From: aaron morton Content-Type: multipart/alternative; boundary="Apple-Mail=_522FAFD3-87AA-48C5-951F-DA733A403609" Message-Id: <0EB955D9-B17F-4C94-A734-1509C253F4A3@thelastpickle.com> Mime-Version: 1.0 (Mac OS X Mail 6.3 \(1503\)) Subject: Re: SSTables not opened on new cluste Date: Fri, 3 May 2013 06:25:17 +1200 References: <4D27E6A2-9816-4431-9A04-8B1A8ACD49C4@thelastpickle.com> To: user@cassandra.apache.org In-Reply-To: X-Mailer: Apple Mail (2.1503) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_522FAFD3-87AA-48C5-951F-DA733A403609 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 > When I created the schema, the KS were created as directory in the = .../data/ directory Can you provide the logs from start up ?=20 > I just noticed that when the new cluster nodes start up, = auto_bootstrap is set to true. Given that it's no longer in the YAML = file, I didn't set it to false; would that explain it ? That will not cause any problems.=20 Cheers ----------------- Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 1/05/2013, at 9:08 AM, Philippe wrote: > Hi Aaron, > thanks for the response. >=20 > Permissions are correct : owner is cassandra (ubuntu) and permissions = are drwxr-xr-x >=20 > When I created the schema, the KS were created as directory in the = .../data/ directory > When I use cassandra-cli, set the CL to QUORUM, ensure two instances = are up (nodetool ring) and set a bogus column, I get an Unavailable = exception which is weird. >=20 > I just noticed that when the new cluster nodes start up, = auto_bootstrap is set to true. Given that it's no longer in the YAML = file, I didn't set it to false; would that explain it ? >=20 > Once I removed it and set logging to TRACE, I get these relevant log = lines >=20 > SliceQueryFilter.java (line 123) collecting 1 of 2147483647: = XXX:5123@1367333147034 > a bunch of Schema.java (line 382) Adding = org.apache.cassandra.config.CFMetaData@45f8acdc[cfId=3D1009,ksName=3DXXX,c= fName=3DYYY... > Removing compacted SSTable files from XXX > No bootstrapping, leaving or moving nodes -> empty pending ranges for = XXX (my KS) > Table.java (line 317) Initializing XXX.YYY (KS and CF) >=20 > Any ideas ? >=20 >=20 > 2013/4/30 aaron morton > Double check the file permissions ? >=20 > Write some data (using cqlsh or cassandra-cli) and flush to make sure = the new files are created where you expect them to be. >=20 > Cheers >=20 > ----------------- > Aaron Morton > Freelance Cassandra Consultant > New Zealand >=20 > @aaronmorton > http://www.thelastpickle.com >=20 > On 1/05/2013, at 4:15 AM, Philippe wrote: >=20 > > Hello, > > > > I'm trying to bring up a copy of an existing 3-node cluster running = 1.0.8 into a 3-node cluster running 1.0.11. > > The new cluster has been configured to have the same tokens and the = same partitioner. > > > > Initially, I copied the files in the data directory of each node = into their corresponding node on the new cluster. When starting the new = cluster, it didn't pick up the KS & CF. > > So I remove the directories, created the schema, stopped cassandra = and copied the data back. None of the SSTables are opened at startup. > > > > When I nodetool refresh them, it says "No new SSTables where found = for XXX/YYY" where X is my KS and Y is my CF > > > > I'm totally stumped: any ideas as to why this is happening ? I've = checked that there are actual files there and that the permissions are = correct. > > > > Thanks. > > >=20 >=20 --Apple-Mail=_522FAFD3-87AA-48C5-951F-DA733A403609 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1
When I created the schema, = the KS were created as directory in the .../data/ = directory
Can you provide the logs from start up = ? 


I just noticed that when the new cluster nodes start = up, auto_bootstrap is set to true. Given that it's no longer in the = YAML file, I didn't set it to false; would that explain it = ?
That will not cause any = problems. 

Cheers

http://www.thelastpickle.com

On 1/05/2013, at 9:08 AM, Philippe <watcherfr@gmail.com> = wrote:

Hi Aaron,
thanks for the = response.

Permissions are correct : owner is = cassandra (ubuntu) and permissions = are drwxr-xr-x

When I created the = schema, the KS were created as directory in the .../data/ = directory
When I use cassandra-cli, set the CL to QUORUM, ensure = two instances are up (nodetool ring) and set a bogus column, I get an = Unavailable exception which is weird.

I just noticed that when the new cluster nodes start = up, auto_bootstrap is set to true. Given that it's no longer in the = YAML file, I didn't set it to false; would that explain it ?

Once I removed it and set = logging to TRACE, I get these relevant log lines

SliceQueryFilter.java (line 123) = collecting 1 of 2147483647: XXX:5123@1367333147034
a bunch of Schema.java (line 382) Adding = org.apache.cassandra.config.CFMetaData@45f8acdc[cfId=3D1009,ksName=3DXXX,c= fName=3DYYY...
Removing compacted SSTable files = from XXX
No bootstrapping, leaving or moving = nodes -> empty pending ranges for XXX (my KS)
Table.java (line 317) Initializing XXX.YYY (KS and = CF)

Any ideas = ?


2013/4/30 aaron morton <aaron@thelastpickle.com>
Double check the file = permissions ?

Write some data (using cqlsh or cassandra-cli) and flush to make sure = the new files are created where you expect them to be.

Cheers

-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand

@aaronmorton
http://www.thelastpickle.com

On 1/05/2013, at 4:15 AM, Philippe <watcherfr@gmail.com> = wrote:

> Hello,
>
> I'm trying to bring up a copy of an existing 3-node cluster running = 1.0.8 into a 3-node cluster running 1.0.11.
> The new cluster has been configured to have the same tokens and the = same partitioner.
>
> Initially, I copied the files in the data directory of each node = into their corresponding node on the new cluster. When starting the new = cluster, it didn't pick up the KS & CF.
> So I remove the directories, created the schema, stopped cassandra = and copied the data back. None of the SSTables are opened at = startup.
>
> When I nodetool refresh them, it says "No new SSTables where found = for  XXX/YYY" where X is my KS and Y is my CF
>
> I'm totally stumped: any ideas as to why this is happening ? I've = checked that there are actual files there and that the permissions are = correct.
>
> Thanks.
>



= --Apple-Mail=_522FAFD3-87AA-48C5-951F-DA733A403609--