Cannot finish transacttions due to alsa-lib hardlink

[wizardlink]

Host system details

State: idle
Deployments:
● fedora:fedora/37/x86_64/silverblue
                  Version: 37.20221107.n.0 (2022-11-07T07:56:30Z)
               BaseCommit: 4ee0def25f687c435bbc948aab8d35b08f2830dbf57632ff79bb931a159a3cb9
             GPGSignature: Valid signature by ACB5EE4E831C74BB7C168D27F55AD3FB5323552A
          LayeredPackages: alsa-lib.i686 bpytop dbus-x11 duf ffmpeg-free fish gdk-pixbuf2-modules.i686 gdk-pixbuf2.i686 glib2.i686 grimshot gtk2.i686 gtk3.i686 libdbusmenu-gtk3 libsoup3.i686 libtracker-sparql.i686 mako mangohud steam
                           sway waybar
            LocalPackages: rpmfusion-free-release-37-0.2.noarch rpmfusion-nonfree-release-37-0.2.noarch wezterm-20220905_102802_7d4b8249-1.fedora36.x86_64

  fedora:fedora/37/x86_64/silverblue
                  Version: 37.20221107.n.0 (2022-11-07T07:56:30Z)
               BaseCommit: 4ee0def25f687c435bbc948aab8d35b08f2830dbf57632ff79bb931a159a3cb9
             GPGSignature: Valid signature by ACB5EE4E831C74BB7C168D27F55AD3FB5323552A
          LayeredPackages: bpytop dbus-x11 duf ffmpeg-free fish gdk-pixbuf2-modules.i686 gdk-pixbuf2.i686 glib2.i686 grimshot gtk2.i686 gtk3.i686 libdbusmenu-gtk3 libsoup3.i686 libtracker-sparql.i686 mako mangohud steam sway waybar
            LocalPackages: rpmfusion-free-release-37-0.2.noarch rpmfusion-nonfree-release-37-0.2.noarch wezterm-20220905_102802_7d4b8249-1.fedora36.x86_64

  fedora:fedora/36/x86_64/silverblue
                  Version: 36.20221030.0 (2022-10-30T20:23:04Z)
               BaseCommit: e44ce7c32fb5ecccd3c6d89f89fee4a97e4c67bd0aa285cf9c4a4482a89487b4
             GPGSignature: Valid signature by 53DED2CB922D8B8D9E63FD18999F7CBF38AB71F4
      RemovedBasePackages: firefox 106.0.1-1.fc36
          LayeredPackages: bpytop dbus-x11 duf ffmpeg fish grimshot mako mangohud steam sway waybar
            LocalPackages: rpmfusion-free-release-36-1.noarch rpmfusion-nonfree-release-36-1.noarch wezterm-20220905_102802_7d4b8249-1.fedora36.x86_64

Expected vs actual behavior

# rpm-ostree override reset -a
Checking out tree 4ee0def... done
Resolving dependencies... done
Checking out packages... done
error: Checkout alsa-lib-1.2.8-1.fc36.i686: Hardlinking e0/d56527b99f76823884002e72d7533aa24b58521c314a784ccbf678d549952c.file to USB-Audio.conf: File exists

Expected:

# rpm-ostree override reset -a
...
Success!

Steps to reproduce it

Not sure how to reproduce this, I've had this issue since I freshly installed Fedora 36 Silveerblue 29 days ago and from day one I had hardlink issues with alsa-lib-1.2.8-1.fc36.i686 and a different issue with dbus when upgrading fedora's flatpak packages, which even after installing dbus-x11, dbus would now be found but have issues running.

The dependency hell that I created in my layered packages is due to the fact that when running rpm-ostree upgrade I'd get a ton of errors that originated from steam requiring a package that couldn't be installed because it's dependency of it's dependency couldn't have two versions installed at once; after installing all packages that were producing errors, I've got stuck in this particular error:
error: Checkout glib2-2.74.0-3.fc37.i686: Hardlinking db/3ee032c02d261348d12924f1c8bafc3feff95eda54eca6e37e47e95e309f4b.file to NEWS: File exists

This is possibly related to #4116 but I thought I'd leave this in a different issue since I'm not sure how deep their rabbit hole goes in comparison to mine.

Would you like to work on the issue?

I would love to if I knew how, but, I don't even know where to begin now.

[wizardlink]

This has been gone since the release now, though I still had to rebase back to 36 and then to 37.