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 B94C017813 for ; Thu, 1 Oct 2015 14:14:48 +0000 (UTC) Received: (qmail 33178 invoked by uid 500); 1 Oct 2015 14:14:45 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 33139 invoked by uid 500); 1 Oct 2015 14:14:45 -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 33129 invoked by uid 99); 1 Oct 2015 14:14:45 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Oct 2015 14:14:45 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 599D8180973 for ; Thu, 1 Oct 2015 14:14:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.9 X-Spam-Level: ** X-Spam-Status: No, score=2.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=datastax.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id jXtDxlTjxSmw for ; Thu, 1 Oct 2015 14:14:34 +0000 (UTC) Received: from mail-wi0-f177.google.com (mail-wi0-f177.google.com [209.85.212.177]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 0141C201FB for ; Thu, 1 Oct 2015 14:14:33 +0000 (UTC) Received: by wicfx3 with SMTP id fx3so35434723wic.1 for ; Thu, 01 Oct 2015 07:14:33 -0700 (PDT) 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=WRjHjWZZ67tJv20VfE9eHKHxk/J5hgyXy+WvpTnfPwM=; b=ETEFyq1nOAAQi4lt1gegztuTWl2X6nbh/5iBra8qb9Jb10fpSf5mJC+IoI4EYohirY yPcochjz7yTo/lAwBBm+Y+ow8Juvxu9NDksvHZOIITdZCR/J+ktQywAX3QTnxkYw4wDk paK7G1DMJ9N8lPdVBQ7lwu2gqdJgcIqOwgQeM= 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=WRjHjWZZ67tJv20VfE9eHKHxk/J5hgyXy+WvpTnfPwM=; b=BlxEFex7TDPS1zLlfMw6viGZzkEPSnrnFL2r+lEH17h5P8uheZwCiG3Jg7YL7Mq7qp WJCNUL89JekI7DGKxVChiftBGrowrZjNX6bCPXLAY5uIslPKjJ0dRjEvl1Yk85j37v4S IEJ1IuyYVvob31UUYhBCOW1DBCzSwIFdEEHKhxcclriAEwWtBINC70cQYTjRPfInW43a 9ezrpD/93xSlpJTMuXWZr9UjCfp+r/taZ0ILqccG5IyqSp7vQcVlupImRBOs+yYwcTI8 YIBKCLXvpx0+fVUlw5eBZW3/nY9/gm1fmSzlGk7hYatQk1mTMQcUaNqvh/iAhYsxRMfK Rmkg== X-Gm-Message-State: ALoCoQlVrldCHB03Xg2BcY6UHCdlL9H83//FkKz+1RbgWjD4M3kZluOvsYXGanKVVQbNNAYZZ+Zf MIME-Version: 1.0 X-Received: by 10.180.182.107 with SMTP id ed11mr3571396wic.52.1443708873355; Thu, 01 Oct 2015 07:14:33 -0700 (PDT) Received: by 10.194.41.69 with HTTP; Thu, 1 Oct 2015 07:14:32 -0700 (PDT) Received: by 10.194.41.69 with HTTP; Thu, 1 Oct 2015 07:14:32 -0700 (PDT) In-Reply-To: <560CEFC5.1020200@netcore.co.in> References: <55CCB43C.8040409@netcore.co.in> <560CEFC5.1020200@netcore.co.in> Date: Thu, 1 Oct 2015 10:14:32 -0400 Message-ID: Subject: Re: Fwd: Column family ID mismatch From: Sebastian Estevez To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=047d7b6045e88e543505210baa55 --047d7b6045e88e543505210baa55 Content-Type: text/plain; charset=UTF-8 Check this post & my response: http://stackoverflow.com/questions/31576180/cassandra-2-1-system-schema-missing&ved=0CBoQFjAAahUKEwit6uK1uqHIAhXLcD4KHWsxDK8&usg=AFQjCNFfvPld2OOInC6B_M0X_QpfqHUbxA&sig2=aLeCqqe7vhpQlL10p9WFJA On Oct 1, 2015 4:33 AM, "kedar" wrote: > Got this error again on a single node cassandra. > > Would appreciate some pointers. > > -------- Forwarded Message -------- Subject: Column family ID mismatch Date: > Thu, 13 Aug 2015 20:44:04 +0530 From: kedar > Reply-To: user@cassandra.apache.org To: > user@cassandra.apache.org > > > Hi All, > > My keyspace is created as: > > CREATE KEYSPACE WITH replication = {'class': > 'SimpleStrategy', 'replication_factor': '2'} AND durable_writes = true; > > However I am running a single node cluster: > > ./nodetool status > Datacenter: datacenter1 > ======================= > Status=Up/Down > |/ State=Normal/Leaving/Joining/Moving > -- Address Load Tokens Owns (effective) Host > ID Rack > XX XXX.XXX.XXX.XX 3.73 GB 256 100.0% rack1 > > And things were still running fine till today we encountered: > > ERROR [MigrationStage:1] 2015-08-13 01:58:49,249 CassandraDaemon.java:153 > - Exception in thread Thread[MigrationStage:1,5,main] > java.lang.RuntimeException: > org.apache.cassandra.exceptions.ConfigurationException: Column family ID > mismatch (found ; expected ) > at > org.apache.cassandra.config.CFMetaData.reload(CFMetaData.java:1125) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.updateColumnFamily(DefsTables.java:422) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeColumnFamilies(DefsTables.java:295) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeSchemaInternal(DefsTables.java:194) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.db.DefsTables.mergeSchema(DefsTables.java:166) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.service.MigrationManager$2.runMayThrow(MigrationManager.java:393) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.java:28) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > ~[na:1.7.0_65] > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > ~[na:1.7.0_65] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > ~[na:1.7.0_65] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_65] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65] > Caused by: org.apache.cassandra.exceptions.ConfigurationException: Column > family ID mismatch (found ; expected ) > at > org.apache.cassandra.config.CFMetaData.validateCompatility(CFMetaData.java:1208) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:1140) > ~[apache-cassandra-2.1.2.jar:2.1.2] > at > org.apache.cassandra.config.CFMetaData.reload(CFMetaData.java:1121) > ~[apache-cassandra-2.1.2.jar:2.1.2] > ... 11 common frames omitted > > > Did notetool repair, probably didn't work so after few mins did a restart > and then the problem went away. > > Need help in understanding what caused it and how it was resolved. > > Thanks > > > > --047d7b6045e88e543505210baa55 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Check this post & my response:

http://stackoverflow.com/questions/31576180/cassandra-2-1-syste= m-schema-missing&ved=3D0CBoQFjAAahUKEwit6uK1uqHIAhXLcD4KHWsxDK8&usg= =3DAFQjCNFfvPld2OOInC6B_M0X_QpfqHUbxA&sig2=3DaLeCqqe7vhpQlL10p9WFJA=

On Oct 1, 2015 4:33 AM, "kedar" <kedar.parikh@netcore.co.in&= gt; wrote:
=20 =20 =20
Got this error again on a single node cassandra.

Would appreciate some pointers.

-------- Forwarded Message --------
Subject: Column family ID mismatch
Date: Thu, 13 Aug 2015 20:44:04 +0530
From: kedar <kedar.parikh@netcore.co.in>
Reply-To: user@cassandra.apache.org
To: user@cassandra.apache.org <user@cassandra.apache.org>


=20 Hi All,

My keyspace is created as:

CREATE KEYSPACE <some_keyspace> WITH replication =3D {'class': 'SimpleStrategy', 'replication_fact= or': '2'}=C2=A0 AND durable_writ= es =3D true;

However I am running a single node cluster:

./nodetool status <some_keyspace>
Datacenter: datacenter1
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
Status=3DUp/Down
|/ State=3DNormal/Leaving/Joining/Moving
--=C2=A0 Address=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = Load=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Tokens=C2=A0 Owns (effective)=C2= =A0 Host ID=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Rack
XX=C2=A0 XXX.XXX.XXX.XX=C2=A0 3.73 GB=C2=A0=C2=A0=C2=A0 256=C2=A0= =C2=A0=C2=A0=C2=A0 100.0%=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 <uid>=C2=A0 rack1

And things were still running fine till today we encountered:

ERROR [MigrationStage:1] 2015-08-13 01:58:49,249 CassandraDaemon.java:153 - Exception in thread Thread[MigrationStage:1,5,main]
java.lang.RuntimeException: org.apache.cassandra.exceptions.ConfigurationException: Column family ID mismatch (found <uid>; expected <uid>)
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.config.CFMetaData.reload(CFMetaData.java:112= 5) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.db.DefsTables.updateColumnFamily(DefsTables.= java:422) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.db.DefsTables.mergeColumnFamilies(DefsTables= .java:295) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.db.DefsTables.mergeSchemaInternal(DefsTables= .java:194) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.db.DefsTables.mergeSchema(DefsTables.java:16= 6) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.service.MigrationManager$2.runMayThrow(Migra= tionManager.java:393) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.utils.WrappedRunnable.run(WrappedRunnable.ja= va:28) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.jav= a:471) ~[na:1.7.0_65]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at java.util.concurrent.FutureTask.run(FutureTask.java:262) ~[na:1.7.0_65]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecu= tor.java:1145) ~[na:1.7.0_65]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExec= utor.java:615) [na:1.7.0_65]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at java.lang.Thread.ru= n(Thread.java:745) [na:1.7.0_65]
Caused by: org.apache.cassandra.exceptions.ConfigurationException: Column family ID mismatch (found <uid>; expected <uid>)
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.config.CFMetaData.validateCompatility(CFMeta= Data.java:1208) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:1140= ) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 at org.apache.cassandra.config.CFMetaData.reload(CFMetaData.java:112= 1) ~[apache-cassandra-2.1.2.jar:2.1.2]
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ... 11 common frames o= mitted


Did notetool repair, probably didn't work so after few mins did a restart and then the problem went away.

Need help in understanding what caused it and how it was resolved.

Thanks



--047d7b6045e88e543505210baa55--