Time Machine only showing backups for 6 days, and acting oddly
I've been using a 6TB Time Capsule (diy upgrade) for years without issue. It's been backing up fine and has allowed me to access backups for dates going back many many months, until today that is when my Time Capsule finally ran out of space. This surprised me as I thought T.M. erased older backups to make room for new ones, but that doesn't seem to be happening in my case.
So I entered Time Machine in order to delete some files from months back but discovered that I could only see the past 6 days of backups. All my previous years worth have vanished.
Whilst doing some investigating and testing I decided to force the T.M. to show me all mounted volumes (Shift + Command + C) and my 3 HD's were shown, but only on the the window relating to the backup created 6 days ago - which is impossible as I haven't connected my third external drive (HD3) since before Christmas last year.
In any case, I decided to try and free up some space by deleting all instances of 3 large files on HD3 (select file, press gear icon and select 'delete all backups relating to that file') and after inputting my password the files vanished. I left Time Machine and emptied the recycle bin (I don't think that was necessary, but I wanted to be sure) but the Time Capsule drive remains full and the 250GB of files I deleted from the Time Machine backup made no difference.
Then I mounted the Time Capsule drive as I had read that I should be able to click on the backup and see folders of each separately dated backup, but all I have is a single file named MacBook Pro (my computer name) that, when I double click on it, I get a window that says: 'The following disk images couldn't be opened: MacBook Pro.sparsebundle, and the Reason: Resource Temporarily Unavailable.
I've tried rebooting the Time Capsule and my Mac. I've looked at the Time Capsule through Airport and there's no errors or issues reported. I'm out of ideas and thinking I'm going to have to reformat the Time Capsule and start a brand new backup, but I'd prefer not to if there's any way of getting the current backup to work properly. I'd be very grateful for a fix if there is one?
MacBook Pro with Touch Bar