Hi Alexander,
I have tried to invoke nodetool scurb
without any output and the table group is still broken.
Then I have restored the first working backup with the second backup for having a comparison of manifest (downloaded from s3 bucket) and the content of the folder highlighted.
here the results:
- contents of the folder group after restoring with first working backup
ls -lrt
total 40
-rw-r--r-- 1 cassandra cassandra 10 Sep 16 14:51 md-1-big-Digest.crc32
-rw-r--r-- 1 cassandra cassandra 5318 Sep 16 14:51 md-1-big-Statistics.db
-rw-r--r-- 1 cassandra cassandra 16 Sep 16 14:51 md-1-big-Filter.db
-rw-r--r-- 1 cassandra cassandra 43 Sep 16 14:51 md-1-big-CompressionInfo.db
-rw-r--r-- 1 cassandra cassandra 8 Sep 16 14:51 md-1-big-Index.db
-rw-r--r-- 1 cassandra cassandra 56 Sep 16 14:51 md-1-big-Summary.db
-rw-r--r-- 1 cassandra cassandra 240 Sep 16 14:51 md-1-big-Data.db
-rw-r--r-- 1 cassandra cassandra 92 Sep 16 14:51 md-1-big-TOC.txt
drwxr-sr-x 4 cassandra cassandra 4096 Sep 16 14:52 backups
- contents of the folder group after restoring with the second backup
ls -lrt
total 28
-rw-r--r-- 1 cassandra cassandra 5318 Sep 16 14:58 md-1-big-Statistics.db
-rw-r--r-- 1 cassandra cassandra 8 Sep 16 14:58 md-1-big-Index.db
-rw-r--r-- 1 cassandra cassandra 240 Sep 16 14:58 md-1-big-Data.db
-rw-r--r-- 1 cassandra cassandra 56 Sep 16 14:58 md-1-big-Summary.db
-rw-r--r-- 1 cassandra cassandra 16 Sep 16 14:58 md-1-big-Filter.db
drwxr-sr-x 4 cassandra cassandra 4096 Sep 16 14:58 backups
- manifest of the s3 object
diegomedusa/cassandra-dc1-rack1-sts-0/backup-202109152031/meta/manifest.json
(the working backup).
Manifest.json is too big for this message, I don’t know how to post it entirely, so I put here only the piece of json related to the group table.
[
{
"keyspace": "storage",
"columnfamily": "group-aaf22b70161311ec86eff3cf7293f36d",
"objects": [
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Digest.crc32",
"MD5": "0201fac48016752f1d0c24739110f905",
"size": 10
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Statistics.db",
"MD5": "b094f49b2c486ac7084203acd28a961d",
"size": 5318
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Filter.db",
"MD5": "88ddab33e4e473f24e75a466c5e82564",
"size": 16
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-CompressionInfo.db",
"MD5": "462ec6ed0d9364decf4e6893cebae161",
"size": 43
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Index.db",
"MD5": "3ce75d2f4e72ac8b61a5ae10c568a657",
"size": 8
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Summary.db",
"MD5": "a2df192a99f110cafacb1a020a01220b",
"size": 56
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Data.db",
"MD5": "3b34d1d75c2b29e4609ea0a8221274d7",
"size": 240
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-TOC.txt",
"MD5": "8387905cab87e3641f12e96d67945e2d",
"size": 92
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Digest.crc32",
"MD5": "bdb44b461031b9d363856d2281f8cf9d",
"size": 10
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Statistics.db",
"MD5": "dfd581431eff2e5d3b68cb0500c6b220",
"size": 4728
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Filter.db",
"MD5": "60e9a50415b0b2519d22470d8a9d93a6",
"size": 16
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-CompressionInfo.db",
"MD5": "39ccf7fae9675d58d3955ba47ed74431",
"size": 43
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Index.db",
"MD5": "6be11a6364c986aeb79504c82ec64ea8",
"size": 14
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Summary.db",
"MD5": "aaea18f0c62ba87912186b930ab05b1c",
"size": 74
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Data.db",
"MD5": "f160602440901e0ba14f335db514806a",
"size": 49
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-TOC.txt",
"MD5": "8387905cab87e3641f12e96d67945e2d",
"size": 92
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Digest.crc32",
"MD5": "636fd7fa87dc4bcdf76d98f265e7906a",
"size": 10
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Statistics.db",
"MD5": "6588d7c439f0379ec7f99e9ffe3db283",
"size": 4748
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Filter.db",
"MD5": "9f5e8f93a80eb8b0e716683eeb1e9469",
"size": 16
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-CompressionInfo.db",
"MD5": "229f64a90e3c8ba137db3b8bcdffb873",
"size": 43
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Index.db",
"MD5": "4e54dd65f91541a9a0db946df3486ec7",
"size": 23
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Summary.db",
"MD5": "cef0cd584866763706e1973773e88b89",
"size": 66
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Data.db",
"MD5": "1530e3c1669b0560e79a299b769a406f",
"size": 75
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-TOC.txt",
"MD5": "8387905cab87e3641f12e96d67945e2d",
"size": 92
}
]
},
- manifest of the s3 object
diegomedusa/cassandra-dc1-rack1-sts-0/backup-202109152034/meta/manifest.json
(the failing backup)
[
{
"keyspace": "storage",
"columnfamily": "group-aaf22b70161311ec86eff3cf7293f36d",
"objects": [
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Statistics.db",
"MD5": "b094f49b2c486ac7084203acd28a961d",
"size": 5318
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Index.db",
"MD5": "3ce75d2f4e72ac8b61a5ae10c568a657",
"size": 8
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Summary.db",
"MD5": "a2df192a99f110cafacb1a020a01220b",
"size": 56
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/md-1-big-Data.db",
"MD5": "3b34d1d75c2b29e4609ea0a8221274d7",
"size": 240
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Statistics.db",
"MD5": "dfd581431eff2e5d3b68cb0500c6b220",
"size": 4728
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Index.db",
"MD5": "6be11a6364c986aeb79504c82ec64ea8",
"size": 14
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Summary.db",
"MD5": "aaea18f0c62ba87912186b930ab05b1c",
"size": 74
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_ad_state_index/md-1-big-Data.db",
"MD5": "f160602440901e0ba14f335db514806a",
"size": 49
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Digest.crc32",
"MD5": "636fd7fa87dc4bcdf76d98f265e7906a",
"size": 10
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Filter.db",
"MD5": "9f5e8f93a80eb8b0e716683eeb1e9469",
"size": 16
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-CompressionInfo.db",
"MD5": "229f64a90e3c8ba137db3b8bcdffb873",
"size": 43
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-TOC.txt",
"MD5": "8387905cab87e3641f12e96d67945e2d",
"size": 92
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Digest.crc32",
"MD5": "636fd7fa87dc4bcdf76d98f265e7906a",
"size": 10
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Filter.db",
"MD5": "9f5e8f93a80eb8b0e716683eeb1e9469",
"size": 16
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-CompressionInfo.db",
"MD5": "229f64a90e3c8ba137db3b8bcdffb873",
"size": 43
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-TOC.txt",
"MD5": "8387905cab87e3641f12e96d67945e2d",
"size": 92
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Digest.crc32",
"MD5": "636fd7fa87dc4bcdf76d98f265e7906a",
"size": 10
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Statistics.db",
"MD5": "6588d7c439f0379ec7f99e9ffe3db283",
"size": 4748
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Filter.db",
"MD5": "9f5e8f93a80eb8b0e716683eeb1e9469",
"size": 16
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-CompressionInfo.db",
"MD5": "229f64a90e3c8ba137db3b8bcdffb873",
"size": 43
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Index.db",
"MD5": "4e54dd65f91541a9a0db946df3486ec7",
"size": 23
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Summary.db",
"MD5": "cef0cd584866763706e1973773e88b89",
"size": 66
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-Data.db",
"MD5": "1530e3c1669b0560e79a299b769a406f",
"size": 75
},
{
"path": "cassandra-dc1-rack1-sts-0/data/storage/group-aaf22b70161311ec86eff3cf7293f36d/.group_state_index/md-1-big-TOC.txt",
"MD5": "8387905cab87e3641f12e96d67945e2d",
"size": 92
}
]
},