[
https://issues.apache.org/jira/browse/CASSANDRA-15845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17124978#comment-17124978
]
Berenguer Blasi commented on CASSANDRA-15845:
---------------------------------------------
Ok I did run this for 1.5h continuously and it's all green except for 2
failures which are 'new' or different from how this was failing before this
fix. I submitted a PR for review. Meanwhile the 'new failure' I would address
in a new ticket.
New failure:
{noformat}
------------------------------------------------------------------------------------------------------------------------------
Captured stdout setup
------------------------------------------------------------------------------------------------------------------------------
15:47:37,189 ccm DEBUG Log-watching thread starting.
-------------------------------------------------------------------------------------------------------------------------------
Captured log setup
--------------------------------------------------------------------------------------------------------------------------------
15:47:37,151 conftest INFO Starting execution of
test_populate_mv_after_insert_wide_rows at 2020-06-03 15:47:37.151758
15:47:37,152 dtest_setup INFO cluster ccm directory: /tmp/dtest-3_i9j_ku
--------------------------------------------------------------------------------------------------------------------------------
Captured log call
--------------------------------------------------------------------------------------------------------------------------------
15:47:51,930 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.3 dc1>
discovered
15:47:51,930 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.2 dc1>
discovered
15:48:24,880 cassandra.protocol WARNING Server warning: Materialized views are
experimental and are not recommended for production use.
15:48:25,920 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.3 dc1>
discovered
15:48:25,921 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.2 dc1>
discovered
15:48:25,947 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.3 dc1>
discovered
15:48:25,947 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.1 dc1>
discovered
15:48:25,984 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.1 dc1>
discovered
15:48:25,984 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.2 dc1>
discovered
15:48:27,973 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.3 dc1>
discovered
15:48:27,973 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.2 dc1>
discovered
15:48:28,108 cassandra.protocol WARNING Server warning: Aggregation query used
without partition key
----------------------------------------------------------------------------------------------------------------------------
Captured stdout teardown
-----------------------------------------------------------------------------------------------------------------------------
15:48:28,320 ccm DEBUG Log-watching thread exiting.
------------------------------------------------------------------------------------------------------------------------------
Captured stdout setup
------------------------------------------------------------------------------------------------------------------------------
15:48:29,170 ccm DEBUG Log-watching thread starting.
-------------------------------------------------------------------------------------------------------------------------------
Captured log setup
--------------------------------------------------------------------------------------------------------------------------------
15:48:29,134 conftest INFO Starting execution of
test_populate_mv_after_insert_wide_rows at 2020-06-03 15:48:29.134170
15:48:29,134 dtest_setup INFO cluster ccm directory: /tmp/dtest-a84sugqx
--------------------------------------------------------------------------------------------------------------------------------
Captured log call
--------------------------------------------------------------------------------------------------------------------------------
15:48:43,900 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.3 dc1>
discovered
15:48:43,900 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.2 dc1>
discovered
15:49:16,846 cassandra.protocol WARNING Server warning: Materialized views are
experimental and are not recommended for production use.
15:49:17,911 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.3 dc1>
discovered
15:49:17,911 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.2 dc1>
discovered
15:49:17,946 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.3 dc1>
discovered
15:49:17,946 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.1 dc1>
discovered
15:49:17,977 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.1 dc1>
discovered
15:49:17,977 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.2 dc1>
discovered
15:49:20,349 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.3 dc1>
discovered
15:49:20,350 cassandra.cluster INFO New Cassandra host <Host: 127.0.0.2 dc1>
discovered
15:49:20,614 cassandra.protocol WARNING Server warning: Aggregation query used
without partition key
----------------------------------------------------------------------------------------------------------------------------
Captured stdout teardown
-----------------------------------------------------------------------------------------------------------------------------
15:48:28,320 ccm DEBUG Log-watching thread exiting.
----------------------------------------------------------------------------------------------------------------------------
Captured stdout teardown
-----------------------------------------------------------------------------------------------------------------------------
15:48:28,320 ccm DEBUG Log-watching thread exiting.
----------------------------------------------------------------------------------------------------------------------------
Captured stdout teardown
-----------------------------------------------------------------------------------------------------------------------------
15:49:21,329 ccm DEBUG Log-watching thread exiting.
===Flaky Test Report===
test_populate_mv_after_insert_wide_rows failed (1 runs remaining out of 2).
<class 'AssertionError'>
assert 12 == 0
+ where 12 = Row(count=12).count
[<TracebackEntry
/home/bereng/work/repos/bdpWS/mvdtesttest/materialized_views_test.py:350>,
<TracebackEntry
/home/bereng/work/repos/bdpWS/mvdtesttest/materialized_views_test.py:171>]
test_populate_mv_after_insert_wide_rows failed; it passed 0 out of the required
1 times.
<class 'AssertionError'>
assert 1 == 0
+ where 1 = Row(count=1).count
[<TracebackEntry
/home/bereng/work/repos/bdpWS/mvdtesttest/materialized_views_test.py:350>,
<TracebackEntry
/home/bereng/work/repos/bdpWS/mvdtesttest/materialized_views_test.py:171>]
===End Flaky Test Report===
===========================================================================================================================
1 failed in 105.02 seconds
============================================================================================================================
{noformat}
> test_populate_mv_after_insert_wide_rows schema version update race
> ------------------------------------------------------------------
>
> Key: CASSANDRA-15845
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15845
> Project: Cassandra
> Issue Type: Bug
> Components: Test/dtest
> Reporter: Berenguer Blasi
> Assignee: Berenguer Blasi
> Priority: Normal
> Fix For: 4.0-beta
>
>
> See failure
> [here|https://ci-cassandra.apache.org/job/Cassandra-trunk/155/testReport/dtest-novnode.materialized_views_test/TestMaterializedViews/test_populate_mv_after_insert_wide_rows_2/]
> {quote}Error Message
> assert 160 == 0 + where 160 = Row(count=160).count
> Stacktrace
> self = <materialized_views_test.TestMaterializedViews object at
> 0x7fcb232b5760>
> def test_populate_mv_after_insert_wide_rows(self):
> """Test that a view is OK when created with existing data with wide
> rows"""
> session = self.prepare(consistency_level=ConsistencyLevel.QUORUM)
>
> session.execute("CREATE TABLE t (id int, v int, PRIMARY KEY (id, v))")
>
> for i in range(5):
> for j in range(10000):
> session.execute("INSERT INTO t (id, v) VALUES ({},
> {})".format(i, j))
>
> session.execute(("CREATE MATERIALIZED VIEW t_by_v AS SELECT * FROM t
> WHERE v IS NOT NULL "
> "AND id IS NOT NULL PRIMARY KEY (v, id)"))
>
> logger.debug("wait for view to build")
> self._wait_for_view("ks", "t_by_v")
>
> logger.debug("wait that all batchlogs are replayed")
> > self._replay_batchlogs()
> materialized_views_test.py:350:
> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
> _
> self = <materialized_views_test.TestMaterializedViews object at
> 0x7fcb232b5760>
> def _replay_batchlogs(self):
> for node in self.cluster.nodelist():
> if node.is_running():
> logger.debug("Replaying batchlog on node
> {}".format(node.name))
> node.nodetool("replaybatchlog")
> # CASSANDRA-13069 - Ensure replayed mutations are removed
> from the batchlog
> node_session = self.patient_exclusive_cql_connection(node)
> result = list(node_session.execute("SELECT count(*) FROM
> system.batches;"))
> > assert result[0].count == 0
> E assert 160 == 0
> E + where 160 = Row(count=160).count
> materialized_views_test.py:171: AssertionError{quote}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
