Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Wed, 4 Jul 2012 05:06:34 +0000 (UTC)
From: =?utf-8?Q?Stefan_H=C3=A4ck_=28JIRA=29?= <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <702679197.2023.1341378394726.JavaMail.jiratomcat@issues-vm>
In-Reply-To: <1400998432.75172.1341066703815.JavaMail.jiratomcat@issues-vm>
Subject: [jira] [Commented] (CASSANDRA-4397) Schema changes not working
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/CASSANDRA-4397?page=3Dcom.atlas=
sian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D=
13406279#comment-13406279 ]=20

Stefan H=C3=A4ck commented on CASSANDRA-4397:
----------------------------------------

Update to 1.1.2 increased the problem. All indexes were gone. Rebuild didn'=
t work.=20
After a cluster wide reset (deleting data-/commit-/cache-folders), cassandr=
a seems to work again normally.
               =20
> Schema changes not working=20
> ---------------------------
>
>                 Key: CASSANDRA-4397
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4397
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.1.1
>         Environment: [cqlsh 2.2.0 | Cassandra 1.1.1 | CQL spec 2.0.0 | Th=
rift protocol 19.32.0]
>            Reporter: Stefan H=C3=A4ck
>         Attachments: output.txt, system.txt
>
>
> No schema change is possible in several keyspaces.=20
> No error message appears, everything seems to be o.k., but the schema cha=
nge isn't adopted.=20
> I'll already tried a nodetool repair, nodetool cleanup, nodetool repair_i=
ndex.
> Both nodes are connected to a local ntp-server.=20
> Here's the cqlsh output:
> {code:none}
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
>   KEY text PRIMARY KEY,
>   css text,
>   description text,
>   language text,
>   html text,
>   company_id varint,
>   title text
> ) WITH
>   comment=3D'Different cover pages for each company.' AND
>   comparator=3Dtext AND
>   read_repair_chance=3D1.000000 AND
>   gc_grace_seconds=3D864000 AND
>   default_validation=3Dtext AND
>   min_compaction_threshold=3D4 AND
>   max_compaction_threshold=3D32 AND
>   replicate_on_write=3D'true' AND
>   compaction_strategy_class=3D'SizeTieredCompactionStrategy' AND
>   compression_parameters:sstable_compression=3D'SnappyCompressor';
> CREATE INDEX rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager> DROP COLUMNFAMILY rm_cover_pages ;
> cqlsh:bite_personalmanager> DESCRIBE COLUMNFAMILY rm_cover_pages ;
> CREATE TABLE rm_cover_pages (
>   KEY text PRIMARY KEY,
>   css text,
>   description text,
>   language text,
>   html text,
>   company_id varint,
>   title text
> ) WITH
>   comment=3D'Different cover pages for each company.' AND
>   comparator=3Dtext AND
>   read_repair_chance=3D1.000000 AND
>   gc_grace_seconds=3D864000 AND
>   default_validation=3Dtext AND
>   min_compaction_threshold=3D4 AND
>   max_compaction_threshold=3D32 AND
>   replicate_on_write=3D'true' AND
>   compaction_strategy_class=3D'SizeTieredCompactionStrategy' AND
>   compression_parameters:sstable_compression=3D'SnappyCompressor';
> CREATE INDEX rm_cover_pages_language ON rm_cover_pages (language);
> CREATE INDEX rm_cover_pages_company_id ON rm_cover_pages (company_id);
> cqlsh:bite_personalmanager>=20
> {code}
> In the attachments are the system.log and the output.log.
> The CassandraCli is also not working.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs: https://issues.apache.org/jira/secure/ContactAdministrators!default.jsp=
a
For more information on JIRA, see: http://www.atlassian.com/software/jira