Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Fri, 19 Feb 2016 21:55:18 +0000 (UTC)
From: =?utf-8?Q?G=C3=A1bor_Auth_=28JIRA=29?= <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12940648.1455916255000.97857.1455918918158@Atlassian.JIRA>
In-Reply-To: <JIRA.12940648.1455916255000@Atlassian.JIRA>
References: <JIRA.12940648.1455916255000@Atlassian.JIRA>
 <JIRA.12940648.1455916255991@arcas>
Subject: [jira] [Comment Edited] (CASSANDRA-11198) Materialized view
 inconsistency
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/CASSANDRA-11198?page=3Dcom.atla=
ssian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=
=3D15154931#comment-15154931 ]=20

G=C3=A1bor Auth edited comment on CASSANDRA-11198 at 2/19/16 9:54 PM:
-----------------------------------------------------------------

Oh, the traced SELECT is enough? Attached.


was (Author: gabor.auth):
Oh, the traced SELECT is enough?

> Materialized view inconsistency
> -------------------------------
>
>                 Key: CASSANDRA-11198
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-1119=
8
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: G=C3=A1bor Auth
>            Assignee: Carl Yeksigian
>         Attachments: CASSANDRA-11198.trace
>
>
> Here is a materialized view:
> {code}
> > DESCRIBE MATERIALIZED VIEW unit_by_transport ;
> CREATE MATERIALIZED VIEW unit_by_transport AS
>     SELECT *
>     FROM unit
>     WHERE transportid IS NOT NULL AND type IS NOT NULL
>     PRIMARY KEY (transportid, id)
>     WITH CLUSTERING ORDER BY (id ASC)
>     AND bloom_filter_fp_chance =3D 0.01
>     AND caching =3D {'keys': 'ALL', 'rows_per_partition': 'NONE'}
>     AND comment =3D ''
>     AND compaction =3D {'class': 'org.apache.cassandra.db.compaction.Size=
TieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
>     AND compression =3D {'chunk_length_in_kb': '64', 'class': 'org.apache=
.cassandra.io.compress.LZ4Compressor'}
>     AND crc_check_chance =3D 1.0
>     AND dclocal_read_repair_chance =3D 0.1
>     AND default_time_to_live =3D 0
>     AND gc_grace_seconds =3D 864000
>     AND max_index_interval =3D 2048
>     AND memtable_flush_period_in_ms =3D 0
>     AND min_index_interval =3D 128
>     AND read_repair_chance =3D 0.0
>     AND speculative_retry =3D '99PERCENTILE';
> {code}
> I cannot reproduce this but sometimes and somehow happened the same issue=
 (https://issues.apache.org/jira/browse/CASSANDRA-10910):
> {code}
> > SELECT transportid, id, type FROM unit_by_transport WHERE transportid=
=3D24f90d20-d61f-11e5-9d3c-8fc3ad6906e2 and id=3D99c05a70-d686-11e5-a169-97=
287061d5d1;
>  transportid                          | id                               =
    | type
> --------------------------------------+----------------------------------=
----+------
>  24f90d20-d61f-11e5-9d3c-8fc3ad6906e2 | 99c05a70-d686-11e5-a169-97287061d=
5d1 | null
> (1 rows)
> > SELECT transportid, id, type FROM unit WHERE id=3D99c05a70-d686-11e5-a1=
69-97287061d5d1;
>  transportid | id | type
> -------------+----+------
> (0 rows)
> {code}


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)