Beatmaps star ratings recalculating every launch

[shrublet]

Type

Game behaviour

Bug description

Game requires the same set of beatmaps to be recalculated every launch, degrading performance until it's done. I believe these maps all previously had local diffs that I've since deleted and were previously labeled local. Let me know anything additional I should attach.

Screenshots or videos

No response

Version

2024.1009.01

Logs

compressed-logs.zip

[bdach]

Please attach client.realm from game files.

[shrublet]

Sorry, late reply. Drive link since it's pretty large - https://drive.google.com/file/d/19YHCAI7HCefZ402rzRrBYHY8d4XC7jcm/view

[bdach]

I'm not sure how this happened, but this database looks corrupted.

There are several BeatmapInfo objects with star rating missing:

These would presumably be some sort of practice difficulties, I guess. The rows with null beatmap set are weird but ultimately not that interesting; what is more worrying is the rows where the beatmap set is present. Examining any one of them by going back to the beatmap set, and then examining the set of backlinks from beatmaps yields this:

Or, in other words, the beatmap set object is reachable from the beatmap objects, but the beatmap objects are not reachable from the beatmap set object. That's not how foreign key relationships are supposed to ever work. Not sure what the remediation steps are.

@shrublet You can try replacing your client.realm with https://drive.google.com/file/d/1ahYwQ2KPb75Z118hNFLWNj55I92zgzkG/view?usp=drive_link to fix this (probably back up your existing one before, to make sure I haven't screwed up anything too bad when manually fixing). You might lose some difficulties though.

[shrublet]

Thank you! This fixed it. I'm really not sure what happened to my db, but I had previous issues with the same install #24301 (since migrated a few times) idk if it's related at all. The only info I can give which you've already gleaned is that all the sets previously had local diffs which I had since deleted before the recent sr reprocessing iirc. I believe a lot of the diffs were imported from stable and then deleted in lazer, if that helps at all. Hope this info could be of use, else can just close this issue as a non-issue.

[bdach]

I'll just tentatively close this as a one-off and hope I never see anything like this again...