Filter out SI and MV from command nodetool snapshot

Prerequisites

[x] Are you rebased to master ?
[ ] Is it reproducible ?
[x] Did you perform a cursory search if this issue isn't opened ?

Versions

SCT: master
scylla: 5.1.dev

Logs

Logs:

db-cluster-6deaba40.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/6deaba40-fe48-4b99-ad24-fab21bb734d5/20220522_071738/db-cluster-6deaba40.tar.gz
monitor-set-6deaba40.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/6deaba40-fe48-4b99-ad24-fab21bb734d5/20220522_071738/monitor-set-6deaba40.tar.gz
loader-set-6deaba40.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/6deaba40-fe48-4b99-ad24-fab21bb734d5/20220522_071738/loader-set-6deaba40.tar.gz
sct-runner-6deaba40.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/6deaba40-fe48-4b99-ad24-fab21bb734d5/20220522_071738/sct-runner-6deaba40.tar.gz
parallel-timelines-report-6deaba40.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/6deaba40-fe48-4b99-ad24-fab21bb734d5/20220522_071738/parallel-timelines-report-6deaba40.tar.gz

Jenkins job URL

Description

Nemesis disrupt_snapshot_operations failed with error:

                                            Traceback (most recent call last):
  File "/home/ubuntu/scylla-cluster-tests/sdcm/nemesis.py", line 3378, in wrapper
    result = method(*args, **kwargs)
  File "/home/ubuntu/scylla-cluster-tests/sdcm/nemesis.py", line 2362, in disrupt_snapshot_operations
    result = self.target_node.run_nodetool(nodetool_cmd)
  File "/home/ubuntu/scylla-cluster-tests/sdcm/cluster.py", line 2628, in run_nodetool
    result = self.remoter.run(cmd, timeout=timeout, ignore_status=ignore_status, verbose=verbose)
  File "/home/ubuntu/scylla-cluster-tests/sdcm/remote/remote_base.py", line 613, in run
    result = _run()
  File "/home/ubuntu/scylla-cluster-tests/sdcm/utils/decorators.py", line 64, in inner
    return func(*args, **kwargs)
  File "/home/ubuntu/scylla-cluster-tests/sdcm/remote/remote_base.py", line 604, in _run
    return self._run_execute(cmd, timeout, ignore_status, verbose, new_session, watchers)
  File "/home/ubuntu/scylla-cluster-tests/sdcm/remote/remote_base.py", line 537, in _run_execute
    result = connection.run(**command_kwargs)
  File "/home/ubuntu/scylla-cluster-tests/sdcm/remote/libssh2_client/__init__.py", line 620, in run
    return self._complete_run(channel, exception, timeout_reached, timeout, result, warn, stdout, stderr)
  File "/home/ubuntu/scylla-cluster-tests/sdcm/remote/libssh2_client/__init__.py", line 654, in _complete_run
    raise UnexpectedExit(result)
sdcm.remote.libssh2_client.exceptions.UnexpectedExit: Encountered a bad command exit code!

Command: '/usr/bin/nodetool  snapshot cqlstress_lwt_example -cf blogposts,blogposts_update_2_columns_lwt_indicator,blogposts_update_2_columns_lwt_indicator_expect,blogposts_update_2_columns_lwt_indicator_after_update,blogposts_update_one_column_lwt_indicator,blogposts_update_one_column_lwt_indicator_after_update,blogposts_update_one_column_lwt_indicator_expect,blogposts_not_updated_lwt_indicator_expect,blogposts_not_updated_lwt_indicator '

Exit code: 1

Stdout:

Requested creating snapshot(s) for [cqlstress_lwt_example] with snapshot name [1653200714816] and options {skipFlush=false}
nodetool: Scylla API server HTTP POST to URL '/storage_service/snapshots' failed: std::invalid_argument (Do not take a snapshot of a materialized view or a secondary index by itself. Run snapshot on the base table instead.)
See 'nodetool help' or 'nodetool help <command>'.

Stderr:

It is need to filter out the MV and SI from command nodetool snapshot

Reproduced in:

Installation details

Kernel Version: 5.13.0-1025-aws Scylla version (or git commit hash): 5.1.dev-20220603.72f629c2b6e8 with build-id 638f7f8a174b83ff26c780b3d7f258217c663339 Cluster size: 3 nodes (i3.large)

Scylla Nodes used in this run:

gemini-with-nemesis-3h-normal-maste-oracle-db-node-ad392830-1 (3.237.95.19 | 10.0.1.215) (shards: 2)
gemini-with-nemesis-3h-normal-maste-db-node-ad392830-4 (3.231.215.131 | 10.0.3.123) (shards: 2)
gemini-with-nemesis-3h-normal-maste-db-node-ad392830-3 (3.235.52.95 | 10.0.3.220) (shards: 2)
gemini-with-nemesis-3h-normal-maste-db-node-ad392830-2 (3.237.50.216 | 10.0.1.0) (shards: 2)
gemini-with-nemesis-3h-normal-maste-db-node-ad392830-1 (44.203.23.172 | 10.0.1.133) (shards: 2)

OS / Image: ami-0b85f1962845e8501 (aws: us-east-1)

Test: gemini-3h-with-nemesis-test Test id: ad392830-eb8b-433b-9285-4535b69c1ee0 Test name: scylla-master/gemini-/gemini-3h-with-nemesis-test Test config file(s):

gemini-3h-with-nemesis.yaml
Restore Monitor Stack command: $ hydra investigate show-monitor ad392830-eb8b-433b-9285-4535b69c1ee0
Restore monitor on AWS instance using Jenkins job
Show all stored logs command: $ hydra investigate show-logs ad392830-eb8b-433b-9285-4535b69c1ee0

Logs:

db-cluster-ad392830.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/ad392830-eb8b-433b-9285-4535b69c1ee0/20220605_072710/db-cluster-ad392830.tar.gz
monitor-set-ad392830.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/ad392830-eb8b-433b-9285-4535b69c1ee0/20220605_072710/monitor-set-ad392830.tar.gz
loader-set-ad392830.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/ad392830-eb8b-433b-9285-4535b69c1ee0/20220605_072710/loader-set-ad392830.tar.gz
sct-runner-ad392830.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/ad392830-eb8b-433b-9285-4535b69c1ee0/20220605_072710/sct-runner-ad392830.tar.gz
parallel-timelines-report-ad392830.tar.gz - https://cloudius-jenkins-test.s3.amazonaws.com/ad392830-eb8b-433b-9285-4535b69c1ee0/20220605_072710/parallel-timelines-report-ad392830.tar.gz

Jenkins job URL

scylladb / scylla-cluster-tests