Possible trouble with certificates and database malformation on update / upgrade

I have an issue here that is possibly fixable through removal of a certificate, maybe I am wrong. I want a second perspective to see what I am looking at when I get the error because I have no clue how it turns into a database malformation, dnf ends up saying error over and over again. There are several other problems I notice from selinux that trouble me when I am in cockpit addressing my system for practical purposes.

It would appear that you may have installed the nvidia drivers from nvidia.com.

If so then I strongly suggest that you remove those drivers and install the current drivers from the rpmfusion repo. Users of the nvidia drivers seldom have issues and I have heard of no issues with doing updates when the drivers are installed from rpmfusion.

1 Like

OK I am showing here the NVIDIA drivers I loaded in and there is also a SQL lock and I don’t understand anything about unlocking the db at this point.

Since you are posting as images and not text it is difficult to qupte parts of your post.

Please consider that the best and preferred way to post is to use text, copied & pasted from your screen, while using the preformatted text tags available with the </> button on the toolbar, or by using this format
paste your text here

What I see so far is this and it does not appear to be from the rpmfusion repos.

What I have is this.

$ dnf list installed \*nvidia\*
Installed Packages
akmod-nvidia.x86_64                                            3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
kmod-nvidia-6.7.10-200.fc39.x86_64.x86_64                      3:550.67-1.fc39                      @@commandline                   
kmod-nvidia-6.7.11-200.fc39.x86_64.x86_64                      3:550.67-1.fc39                      @@commandline                   
kmod-nvidia-6.7.9-200.fc39.x86_64.x86_64                       3:550.67-1.fc39                      @@commandline                   
nvidia-gpu-firmware.noarch                                     20240312-1.fc39                      @updates                        
nvidia-modprobe.x86_64                                         3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
nvidia-persistenced.x86_64                                     3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
nvidia-settings.x86_64                                         3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
xorg-x11-drv-nvidia.x86_64                                     3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
xorg-x11-drv-nvidia-cuda.x86_64                                3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
xorg-x11-drv-nvidia-cuda-libs.i686                             3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
xorg-x11-drv-nvidia-cuda-libs.x86_64                           3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
xorg-x11-drv-nvidia-kmodsrc.x86_64                             3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
xorg-x11-drv-nvidia-libs.i686                                  3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
xorg-x11-drv-nvidia-libs.x86_64                                3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver
xorg-x11-drv-nvidia-power.x86_64                               3:550.67-1.fc39                      @rpmfusion-nonfree-nvidia-driver

Once again, I encourage you to remove the currently installed drivers.
Then reinstall them from rpmfusion as follows

  1. dnf repolist to check that the rpmfusion-nonfree-nvidia-driver repo is in that list
  2. sudo dnf install akmod-nvidia xorg-x11-drv-nvidia-cuda to install all the required packages for the nvidia drivers.
  3. Wait at least 5 minutes after step 2 completes then reboot.

This should result in the nvidia drivers loading properly
Once this is completed then try the upgrade again. The sql error appears to be the result of the error with the currently installed nvidia drivers and the invalid certificate that is associated with them.

I’ll have to keep this in one in mind. I wish I would have looked into how to remove a repository earlier too, but some how I found that documentation. Which is great, this is a helpful community. Thank you very much @computersavvy