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 84090183EC for ; Thu, 11 Feb 2016 14:56:17 +0000 (UTC) Received: (qmail 60205 invoked by uid 500); 11 Feb 2016 14:54:21 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 59563 invoked by uid 500); 11 Feb 2016 14:54:21 -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 57536 invoked by uid 99); 11 Feb 2016 14:48:35 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Feb 2016 14:48:35 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id BBB93C0873 for ; Thu, 11 Feb 2016 14:48:34 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=datastax.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id gLOWvKiXlWYW for ; Thu, 11 Feb 2016 14:48:32 +0000 (UTC) Received: from mail-wm0-f44.google.com (mail-wm0-f44.google.com [74.125.82.44]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 118FC42BA7 for ; Thu, 11 Feb 2016 14:48:32 +0000 (UTC) Received: by mail-wm0-f44.google.com with SMTP id c200so76653085wme.0 for ; Thu, 11 Feb 2016 06:48:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=datastax.com; s=google; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=NaesSCOwAjT/SO0Y25otAbjPuN4wOoEpZwtykxjYGFo=; b=oqkQ7Rzdc4fWzBYYvHqCryPnLh0+eG/DrVWGfT69gWBLcGpLed4XJvoG96ck3+Qmc0 aVch0tTjc8LaSH61UmHn1Pt6XYt7qd3s+gjlmPirvHBiBF/KilzvJJEL+CtmjRKzSXhR sCjFO2/X7GDWTAc11j6VOsbGpQ0Dy3fmoDnQs= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=NaesSCOwAjT/SO0Y25otAbjPuN4wOoEpZwtykxjYGFo=; b=UAKRs1JyUUEHEf2MtraS45pLS+lT5mko9S2oVc10N629keE0rgzI0BA0VA1+CJ+6p/ OxHJxQTazRxIYujjWC6WBplaJHn2COXy9GkZi7plHmZsBHj2FoS0G/4Y4Bh450+5TDld hI/+ZnZsC+RwlG2qnGiPzJS1IGsytD3U5eUSKeuCguqfX4sAKWhe+xdDfJBIEWdSuaf1 xscMIEbrGt+C6+a9E9PXQKzgE0R8r1//Uh08bBmmRJ/1jl3QR/36MYJa8Aeosxp3DyjN 8V/Tx1/O/9gkv29eX+FNUh6Im7pnP5cqKTkkTeltzR1hRv+HFFCrveaSObtX0LktioTk 0ElQ== X-Gm-Message-State: AG10YOSoIpx3nLpJafTMhKaqVQdp0TZ56+qWUij3S4janwIv4l1yHm8Jlcq5C60WgF5dk7EGV7DDHdykDiYHKE7l MIME-Version: 1.0 X-Received: by 10.28.175.139 with SMTP id y133mr17065158wme.45.1455202111248; Thu, 11 Feb 2016 06:48:31 -0800 (PST) Received: by 10.194.170.169 with HTTP; Thu, 11 Feb 2016 06:48:30 -0800 (PST) Received: by 10.194.170.169 with HTTP; Thu, 11 Feb 2016 06:48:30 -0800 (PST) In-Reply-To: <56BC9A8E.6000202@netcore.co.in> References: <56BC68F3.30406@netcore.co.in> <1229871856.4192636.1455188756689.JavaMail.yahoo@mail.yahoo.com> <56BC7093.2070201@netcore.co.in> <56BC9A8E.6000202@netcore.co.in> Date: Thu, 11 Feb 2016 09:48:30 -0500 Message-ID: Subject: Re: Keyspaces not found in cqlsh From: Sebastian Estevez To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=001a11444bceeafff3052b7fa4b8 --001a11444bceeafff3052b7fa4b8 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable If its a tarball then root should be fine but there were some files owned by the Cassandra user so you may want to chown those back to root. I haven't seen your exact issue before but you have two schema versions from your describe cluster so a rolling restart should help. all the best, Sebasti=C3=A1n On Feb 11, 2016 9:28 AM, "kedar" wrote: > Thanks Sebastian, > > Cassandra installation in our case is simply an untar. > > Cassandra is started using supervisord and user as root, would you still > recommend I try using Cassandra user. > > ./nodetool describecluster > Cluster Information: > Name: Test Cluster > Snitch: org.apache.cassandra.locator.DynamicEndpointSnitch > Partitioner: org.apache.cassandra.dht.Murmur3Partitioner > Schema versions: > cd361577-6947-3390-a787-be28fe499787: [Ip1] > > 9f5b5675-c9e7-3ae3-8ad6-6654fa4fb3e7: [Ip2] > > Interestingly > ./nodetool cfstats shows all the tables > > Thanks, > Kedar Parikh > > On Thursday 11 February 2016 07:34 PM, Sebastian Estevez wrote: > > Keep this on. The user list, it's not appropriate for the dev list. > > 1) I noticed that some of your files are owned by root and others by > Cassandra. If this is a package install you should always start C* as a > service and chown your files and directories so they are owned by the > Cassandra user, not root. Never start Cassandra directly as root. > > 2) Once you have fixed your file ownerships, restart Cassandra on each > node one at a time. You should see your sstables and commitlog get picked > up by Cassandra in the the system.log on startup. Share the output of > 'nodetool describecluster' before and after. > > all the best, > > Sebasti=C3=A1n > On Feb 11, 2016 6:30 AM, "kedar" wrote: > >> Thanks, >> >> kindly refer the following: >> >> https://gist.github.com/anonymous/3dddbe728a52c07d7c52 >> https://gist.github.com/anonymous/302ade0875dd6410087b >> >> Thanks, >> Kedar Parikh >> >> >> >> On Thursday 11 February 2016 04:35 PM, Romain Hardouin wrote: >> >>> Would you mind pasting the ouput for both nodes in gist/paste/whatever? >>> https://gist.github.com http://paste.debian.net >>> >>> >>> >>> Le Jeudi 11 f=C3=A9vrier 2016 11h57, kedar = a >>> =C3=A9crit : >>> Thanks for the reply. >>> >>> ls -l cassandra/data/* lists various *.db files >>> >>> This problem is on both nodes. >>> >>> Thanks, >>> Kedar Parikh >>> >>> >>> >>> >>> >>> >> >> >> > --001a11444bceeafff3052b7fa4b8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

If its a tarball then root should be fine but there were som= e files owned by the Cassandra user so you may want to chown those back to = root.

I haven't seen your exact issue before but you have two = schema versions from your describe cluster so a rolling restart should help= .

all the best,

Sebasti=C3=A1n

On Feb 11, 2016 9:28 AM, "kedar" <<= a href=3D"mailto:kedar.parikh@netcore.co.in">kedar.parikh@netcore.co.in= > wrote:
=20 =20 =20
Thanks Sebastian,

Cassandra installation in our case is simply an untar.

Cassandra is started using supervisord and user as root, would you still recommend I try using Cassandra user.

=C2=A0./nodetool describecluster
Cluster Information:
=C2=A0=C2=A0=C2=A0 Name: Test Cluster
=C2=A0=C2=A0=C2=A0 Snitch: org.apache.cassandra.locator.DynamicEndpointSnitch
=C2=A0=C2=A0=C2=A0 Partitioner: org.apache.cassandra.dht.Murmur3Partitioner
=C2=A0=C2=A0=C2=A0 Schema versions:
=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 cd361577-6947-3390-a787-= be28fe499787: [Ip1]

=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 9f5b5675-c9e7-3ae3-8ad6-= 6654fa4fb3e7: [Ip2]

Interestingly
./nodetool cfstats shows all the tables
Thanks,
Kedar Parikh
On Thursday 11 February 2016 07:34 PM, Sebastian Estevez wrote:

Keep this on. The user list, it's not appropriate = for the dev list.

1) I noticed that some of your files are owned by root and others by Cassandra. If this is a package install you should always start C* as a service and chown your files and directories so they are owned by the Cassandra user, not root.=C2= =A0 Never start Cassandra directly as root.

2) Once you have fixed your file ownerships, restart Cassandra on each node one at a time. You should see your sstables and commitlog get picked up by Cassandra in the the system.log on startup. Share the output of 'nodetool describecluster' before and after.

all the best,

Sebasti=C3=A1n

On Feb 11, 2016 6:30 AM, "kedar"= <kedar.parikh@netc= ore.co.in> wrote:
Thanks,

kindly refer the following:

https://gist.github.com/anonymous/3d= ddbe728a52c07d7c52
https://gist.github.com/anonymous/30= 2ade0875dd6410087b

Thanks,
Kedar Parikh



On Thursday 11 February 2016 04:35 PM, Romain Hardouin wrote:
Would you mind pasting the ouput for both nodes in gist/paste/whatever? https://gist.github.com http://paste.debian.net



Le Jeudi 11 f=C3=A9vrier 2016 11h57, kedar <kedar.parikh@netcore.co.in> a =C3=A9crit :
Thanks for the reply.

ls -l cassandra/data/* lists various *.db files

This problem is on both nodes.

Thanks,
Kedar Parikh









--001a11444bceeafff3052b7fa4b8--