Same here, but I was able to get around it. @j0rge will likely point out where I went wrong, but I was curious. It did fix it, though. 
Was on Version: latest-41.20250204
Like you, got a:
All the stuff before this below....then this error.
Running transaction
SQL statement evaluation failed: "
INSERT INTO
"trans" (
"dt_begin",
"dt_end",
"rpmdb_version_begin",
"rpmdb_version_end",
"releasever",
"user_id",
"description",
"comment",
"state_id",
"id"
)
VALUES
(1738845811, 0, 'ab7219bdb968f1b7c7547738457ba1e3cf1b75f050f9f321c72fa62d35d668f2', '', '41', 1000, '/usr/bin/dnf upgrade -y', '', (SELECT "id" FROM "trans_state" WHERE "name" = 'Started'), NULL)
": (8) - attempt to write a readonly database
System update failed:
0: Command failed: `/usr/bin/sudo /usr/bin/dnf upgrade -y`
1: `/usr/bin/sudo` failed: exit status: 1
Location:
src/steps/os/linux.rs:259
Retry? (y)es/(N)o/(s)hell/(q)uit
So just for giggles, I did one of these:
rpm-ostree reset
Then switched over to stable:
sudo bootc switch ghcr.io/ublue-os/bluefin:stable
Reboot.
Update there was smooth. So, being the daring sort, did this:
sudo bootc switch ghcr.io/ublue-os/bluefin:latest
Reboot.
This gave me the same errors again, but I allowed it to finish, rebooted.
Now on: latest-41.20250206
And now I am rocking:
ujust update
note: automatic updates (stage) are enabled
Pulling manifest: ostree-unverified-registry:ghcr.io/ublue-os/bluefin:latest
No upgrade available.
Looking for updates…
Info: runtime org.kde.Platform branch 6.6 is end-of-life, with reason:
We strongly recommend moving to the latest stable version of the Platform and SDK
Info: applications using this runtime:
com.obsproject.Studio
Info: (pinned) runtime org.gnome.Platform branch 45 is end-of-life, with reason:
The GNOME 45 runtime is no longer supported as of September 18, 2024. Please ask your application developer to migrate to a supported platform.
Nothing to do.
==> Updating Homebrew...
Already up-to-date.
Where I live now, currently:
sudo bootc status
â—Ź Booted image: ghcr.io/ublue-os/bluefin:latest
Digest: sha256:abbecbd26d0f47d1a85bdcfc8295fe543a0f02f18e9c5cc7650ef76c4d510014
Version: latest-41.20250206 (2025-02-06 05:02:24 UTC)
Rollback image: ghcr.io/ublue-os/bluefin:stable
Digest: sha256:12fefae335b0ba23ca0380a589cbf1de8ca1042e2fe7782829f1e84c892bbdd4
Version: 41.20250202.1 (2025-02-02 05:59:53 UTC)
I love that at no time, was my system non-bootable. It was a minor inconvenience, 5 minutes and resolved. Wild.
So it seems like my issue was with:
latest-41.20250204
and by jumping to stable, then back to latest, I was able to get to:
latest-41.20250206
My daily box lives on gts for a reason. I knew what I was doing by using latest.