You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Paulo Motta (Jira)" <ji...@apache.org> on 2021/03/21 23:25:00 UTC
[jira] [Updated] (CASSANDRA-15918) materialized view rebuild
automatically after drop multiple views
[ https://issues.apache.org/jira/browse/CASSANDRA-15918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paulo Motta updated CASSANDRA-15918:
------------------------------------
Bug Category: Parent values: Degradation(12984)
Complexity: Normal
Component/s: (was: Consistency/Repair)
(was: Cluster/Schema)
Discovered By: User Report
Severity: Low
Status: Open (was: Triage Needed)
> materialized view rebuild automatically after drop multiple views
> -----------------------------------------------------------------
>
> Key: CASSANDRA-15918
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15918
> Project: Cassandra
> Issue Type: Bug
> Components: Feature/Materialized Views
> Reporter: chonghao li
> Priority: Normal
>
> Background:
> Cassandra version: 3.0.12
> Our cassandra cluster has 9 host for DC1 and 3 host for DC2,
> each host :
> ||node||memory||disk||
> |DC1 1|256 GB|5*788GB|
> |DC1 2|256 GB|5*788GB|
> |DC1 3|256 GB|5*788GB|
> |DC1 4|256 GB|5*788GB|
> |DC1 5|256 GB|5*788GB|
> |DC1 6|256 GB|5*788GB|
> |DC1 7|512 GB|5 TB|
> |DC1 8|512 GB|5 TB|
> |DC1 9|512 GB|5 TB|
> |DC2 1|256 GB|8*788GB|
> |DC2 2|256 GB|8*788GB|
> |DC2 3|256 GB|8*788GB|
> by using nodetool status, node load in DC1 is about 1.5 TB, node load in DC2 is about 4 TB
> QPS: 270
> -------------------------------------
> Problem we met:
> In DC1 1 node, enter the cql command line and execute command like following in sametime:
> "drop materialized view if exists view1;
> drop materialized view if exists view2;
> drop materialized view if exists view3;
> drop materialized view if exists view4;"
> after a while, command line display warning like "schema version mismatch detected..." (sorry we cannot find the exact output for that time)
> After that we find view files in node: "DC1 7" hasn't be deleted yet.
> at this moment, we find performance of cluster drop sharp, the cluster almost stop response to any request.
> by runing: select * from system.views_builds_in_progress;
> we can see several views were building.
> then we execte:
> 1, nodetool stop VIEW_BUILD in each node
> 2, in cql: delete from system.views_builds_in_progress where view_name=XXXX
> 3, rolling restart cassandra nodes
>
> about an hours later, performance increase to normal.
> --------------------------------------------------------------
> Why this happen?
> How to avoid this problem?
> Any better way to deal with this problem?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org