Open yarongilor opened 3 weeks ago
Well, this is expected. SM restores schema by applying the output of DESC SCHEMA WITH INTERNALS queried during the backup. The problem is that schema contains topology related information - dcs in which the keyspace is replicated. So in order to use SM restore schema task, the restore destination cluster needs to consist of the same dcs as the backed up cluster.
A workaround is to take the schema file from backup location, modify it to fit your needs, and apply it manually.
@yarongilor Is there anything you suggest to change in Scylla Manager ? As per https://github.com/scylladb/scylla-manager/issues/4041#issuecomment-2370324292 this is expected behavior of the manager.
It looks that there is no datacenter of the "us-east" name in the destination cluster.
# cassandra-rackdc.properties
#
# The lines may include white spaces at the beginning and the end.
# The rack and data center names may also include white spaces.
# All trailing and leading white spaces will be trimmed.
#
dc=thedatacentername
rack=therackname
# prefer_local=<false | true>
# dc_suffix=<Data Center name suffix, used by EC2SnitchXXX snitches>
@roydahan , @fruch , is there any known resolution for this issue?
The test ran on eu-west-1
region (with Datacenter: eu-west
) and failed restoring backup to us-east
datacenter. Is it a matter of wrong selected region to test? or it require an SCT fix?
It's not a new issue, mostly a usability issue. @mikliapko I think the original issue is assigned to you, are you planning to change SCT so it will change the DC name while trying to restore?
Issue about restoring schema into a differenct DC setting: #4049.
Issue about restoring schema into a differenct DC setting: #4049.
So currently the user is supposed to do the schema restore manually
@mikliapko so I'll say we should at least skip the nemesis if the region of the snapshots doesn't match.
At least until it would be implemented on the test end or manager end.
It's not a new issue, mostly a usability issue. @mikliapko I think the original issue is assigned to you, are you planning to change SCT so it will change the DC name while trying to restore?
I don't remember we have an issue for that. Created the new one for me to correctly handle the case when the region of the snapshots doesn't match. https://github.com/scylladb/scylla-manager/issues/4052
@mikliapko - IMO we can plan for a workaround, depends when this issue will be fixed from Manager side. @karol-kokoszka , @Michal-Leszczynski - please discuss this in the next Manager refinement meeting. If it's not going to be handled soon, @mikliapko will create a WA in the test for it.
It's not a new issue, mostly a usability issue. @mikliapko I think the original issue is assigned to you, are you planning to change SCT so it will change the DC name while trying to restore?
I don't remember we have an issue for that. Created the new one for me to correctly handle the case when the region of the snapshots doesn't match. #4052
there was an issue about this, long long ago: https://github.com/scylladb/qa-tasks/issues/1477
I don't know if anything was done to try to apply any workaround.
Packages
Scylla version:
2024.2.0~rc2-20240904.4c26004e5311
with build-ida8549197de3c826053f88ddfd045b365b9cd8692
Kernel Version:
5.15.0-1068-aws
Issue description
The backup restore failed with error:
The restore task was started like:
then failed:
Describe your issue in detail and steps it took to produce it.
Impact
Describe the impact this issue causes to the user.
How frequently does it reproduce?
Describe the frequency with how this issue can be reproduced.
Installation details
Cluster size: 4 nodes (i4i.4xlarge)
Scylla Nodes used in this run:
OS / Image:
ami-0555cb82c50d0d5f1
(aws: undefined_region)Test:
longevity-alternator-1h-scan-12h-ttl-no-lwt-2h-grace-4loaders-sisyphus-test
Test id:4afc0c3a-7457-4d8b-a69a-8ee387d26369
Test name:enterprise-2024.2/alternator_tablets/longevity-alternator-1h-scan-12h-ttl-no-lwt-2h-grace-4loaders-sisyphus-test
Test method:longevity_test.LongevityTest.test_custom_time
Test config file(s):Logs and commands
- Restore Monitor Stack command: `$ hydra investigate show-monitor 4afc0c3a-7457-4d8b-a69a-8ee387d26369` - Restore monitor on AWS instance using [Jenkins job](https://jenkins.scylladb.com/view/QA/job/QA-tools/job/hydra-show-monitor/parambuild/?test_id=4afc0c3a-7457-4d8b-a69a-8ee387d26369) - Show all stored logs command: `$ hydra investigate show-logs 4afc0c3a-7457-4d8b-a69a-8ee387d26369` ## Logs: - **alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-5** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_105715/alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-5-4afc0c3a.tar.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_105715/alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-5-4afc0c3a.tar.gz) - **alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-6** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_105715/alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-6-4afc0c3a.tar.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_105715/alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-6-4afc0c3a.tar.gz) - **db-cluster-4afc0c3a.tar.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/db-cluster-4afc0c3a.tar.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/db-cluster-4afc0c3a.tar.gz) - **sct-runner-events-4afc0c3a.tar.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/sct-runner-events-4afc0c3a.tar.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/sct-runner-events-4afc0c3a.tar.gz) - **2024_09_19__10_57_16_766.sct-4afc0c3a.log.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__10_57_16_766.sct-4afc0c3a.log.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__10_57_16_766.sct-4afc0c3a.log.gz) - **2024_09_19__16_16_55_387.sct-4afc0c3a.log.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_16_55_387.sct-4afc0c3a.log.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_16_55_387.sct-4afc0c3a.log.gz) - **2024_09_19__16_25_22_374.sct-4afc0c3a.log.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_25_22_374.sct-4afc0c3a.log.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_25_22_374.sct-4afc0c3a.log.gz) - **2024_09_19__16_33_50_995.sct-4afc0c3a.log.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_33_50_995.sct-4afc0c3a.log.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_33_50_995.sct-4afc0c3a.log.gz) - **2024_09_19__16_42_17_873.sct-4afc0c3a.log.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_42_17_873.sct-4afc0c3a.log.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_42_17_873.sct-4afc0c3a.log.gz) - **2024_09_19__16_50_45_800.sct-4afc0c3a.log.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_50_45_800.sct-4afc0c3a.log.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/2024_09_19__16_50_45_800.sct-4afc0c3a.log.gz) - **loader-set-4afc0c3a.tar.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/loader-set-4afc0c3a.tar.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/loader-set-4afc0c3a.tar.gz) - **monitor-set-4afc0c3a.tar.gz** - [https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/monitor-set-4afc0c3a.tar.gz](https://cloudius-jenkins-test.s3.amazonaws.com/4afc0c3a-7457-4d8b-a69a-8ee387d26369/20240919_165951/monitor-set-4afc0c3a.tar.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-3-2024-09-19_16-42-50.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16312.1726763829000000/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16312.1726763829000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16312.1726763829000000/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16312.1726763829000000.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-3-2024-09-19_16-46-15.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16648.1726764141000000/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16648.1726764141000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16648.1726764141000000/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16648.1726764141000000.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-2-2024-09-19_16-47-09.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.16354.1726763992000000/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.16354.1726763992000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.16354.1726763992000000/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.16354.1726763992000000.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-1-2024-09-19_16-49-59.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8d725cf960c64aa2882b3fa0d034537c.17956.1726764362000000/core.scylla.112.8d725cf960c64aa2882b3fa0d034537c.17956.1726764362000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8d725cf960c64aa2882b3fa0d034537c.17956.1726764362000000/core.scylla.112.8d725cf960c64aa2882b3fa0d034537c.17956.1726764362000000.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-3-2024-09-19_16-51-03.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16850.1726764281000000/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16850.1726764281000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16850.1726764281000000/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.16850.1726764281000000.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-2-2024-09-19_16-51-18.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.16915.1726764444000000/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.16915.1726764444000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.16915.1726764444000000/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.16915.1726764444000000.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-1-2024-09-19_16-54-13.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8d725cf960c64aa2882b3fa0d034537c.18246.1726764508000000/core.scylla.112.8d725cf960c64aa2882b3fa0d034537c.18246.1726764508000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8d725cf960c64aa2882b3fa0d034537c.18246.1726764508000000/core.scylla.112.8d725cf960c64aa2882b3fa0d034537c.18246.1726764508000000.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-3-2024-09-19_16-55-19.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.17151.1726764570000000/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.17151.1726764570000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.17151.1726764570000000/core.scylla.112.94ffa6175da846e8b9d94ef2912250f7.17151.1726764570000000.gz) - **core.scylla-alternator-ttl-4-loaders-no-lwt-sis-db-node-4afc0c3a-2-2024-09-19_16-56-12.gz** - [https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.17296.1726764733000000/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.17296.1726764733000000.gz](https://storage.cloud.google.com/upload.scylladb.com/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.17296.1726764733000000/core.scylla.112.8c56b36cbe334b329c8f7143d02bba54.17296.1726764733000000.gz) [Jenkins job URL](https://jenkins.scylladb.com/job/enterprise-2024.2/job/alternator_tablets/job/longevity-alternator-1h-scan-12h-ttl-no-lwt-2h-grace-4loaders-sisyphus-test/3/) [Argus](https://argus.scylladb.com/test/cc3a6940-a949-4765-b703-d1e31fa5b208/runs?additionalRuns[]=4afc0c3a-7457-4d8b-a69a-8ee387d26369)