[SOLVED] Cannot open RPM DB

This forum is dedicated to basic help and support :

Ask here your questions about basic installation and usage of Mageia. For example you may post here all your questions about getting Mageia isos and installing it, configuring your printer, using your word processor etc.

Try to ask your questions in the right sub-forum with as much details as you can gather. the more precise the question will be, the more likely you are to get a useful answer

[SOLVED] Cannot open RPM DB

Postby dbg » Oct 11th, '24, 21:19

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.
Last edited by doktor5000 on Oct 13th, '24, 20:16, edited 1 time in total.
Reason: marked solved
dbg
 
Posts: 72
Joined: Mar 30th, '11, 22:28
Location: Grants Pass, Oregon

Re: Cannot open RPM DB

Postby doktor5000 » Oct 12th, '24, 10:40

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.
Cauldron is not for the faint of heart!
Caution: Hot, bubbling magic inside. May explode or cook your kittens!
----
Disclaimer: Beware of allergic reactions in answer to unconstructive complaint-type posts
User avatar
doktor5000
 
Posts: 18053
Joined: Jun 4th, '11, 10:10
Location: Leipzig, Germany

Solved Re: Cannot open RPM DB

Postby dbg » Oct 13th, '24, 16:50

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!
dbg
 
Posts: 72
Joined: Mar 30th, '11, 22:28
Location: Grants Pass, Oregon

Re: Cannot open RPM DB

Postby Germ » Oct 13th, '24, 17:05

Would you please mark your topic as [SOLVED]

Thanks
Starting in 1999: Mandrake > Mandriva > Mageia
Linux User #274693
User avatar
Germ
 
Posts: 724
Joined: Mar 30th, '11, 13:16
Location: Chelsea, Oklahoma USA

Re: Cannot open RPM DB

Postby morgano » Oct 13th, '24, 19:17

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
At home & work Mandriva since 2006, Mageia 2011. Thinkpad T40, T43, T60, T400, T510, Dell M4400, M6300, Acer Aspire 7. Workstation using LVM, LUKS, VirtualBox, BOINC
morgano
 
Posts: 1491
Joined: Jun 15th, '11, 17:51
Location: Kivik, Sweden


Return to Basic support

Who is online

Users browsing this forum: No registered users and 1 guest

cron