Page 1 of 1

[SOLVED] Cannot open RPM DB

PostPosted: Oct 11th, '24, 21:19
by dbg
A few days ago I installed nextcloud on my apache server. I decided I didn't like it so I uninstalled. I don't use PHP so I used RPMdrake to remove all the PHP modules that were required to install nextcloud.

user.log-error.txt
user.log showing files I uninstalled
(5.24 KiB) Downloaded 287 times


Now when I try to update using urpmi --auto-update I get this:
Code: Select all
[root@noob ~]# urpmi --auto-update
...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: aria2 failed: exited with 9

...retrieving failed: wget failed: exited with 3

error: sqlite failure: CREATE TABLE IF NOT EXISTS 'Packages' (hnum INTEGER PRIMARY KEY AUTOINCREMENT,blob BLOB NOT NULL): disk I/O error
error: cannot open Packages index using sqlite - No such file or directory (2)
error: cannot open Packages database in /var/lib/rpm
unable to open rpmdb


Apparently there is some PHP package needed to use sqlite to open the RPM DB. I'm not sure what I need to reinstall to get the RPM DB working and how do I install it if the RPM DB cannot be opened? The mgaapplet on the panel now has a red round circle with a question mark. I have never seen that before.

Re: Cannot open RPM DB

PostPosted: Oct 12th, '24, 10:40
by doktor5000
dbg wrote:error: sqlite failure: CREATE TABLE IF NOT EXISTS 'Packages' (hnum INTEGER PRIMARY KEY AUTOINCREMENT,blob BLOB NOT NULL): disk I/O error
error: cannot open Packages index using sqlite - No such file or directory (2)
error: cannot open Packages database in /var/lib/rpm
unable to open rpmdb

You should first check why you had a disk error and fix that before you start fixing anything else.

When that is fixed you'd need to run at least rpm --rebuilddb to rebuild the RPM database.

Solved Re: Cannot open RPM DB

PostPosted: Oct 13th, '24, 16:50
by dbg
I didn't notice the I/O error. Once the drive problem was fixed it was all better. Did not even have to do the RPM rebuild. Thanks!

Re: Cannot open RPM DB

PostPosted: Oct 13th, '24, 17:05
by Germ
Would you please mark your topic as [SOLVED]

Thanks

Re: Cannot open RPM DB

PostPosted: Oct 13th, '24, 19:17
by morgano
If Nextcloud was misbehaving while there was disk error, then that may have been a reason you did not like it...?

BTW what method did you use to install Nextcloud?
Our packages are behind... :/
I believe the manual method is the way to go.
https://wiki.mageia.org/en/Nextcloud