sqlite3.DatabaseError: database disk image is malformed

[carltonh]

During the past two days, anytime I try to run Spritz, It has the problem below:

Code: Select all

(1/1) Fetching: media-sound/sound-juicer-2.22.0-r1
Package checksum matches.
(1/1) Installing: media-sound/sound-juicer-2.22.0-r1
 Ebuild: pkg_prerm()
 Ebuild: pkg_postrm()
Unpacking package: media-sound:sound-juicer-2.22.0-r1~0.tbz2
 Ebuild: pkg_preinst()
Installing package: media-sound/sound-juicer-2.22.0-r1
Updating database: media-sound/sound-juicer-2.22.0-r1
Traceback (most recent call last):
  File "/usr/lib/entropy/spritz/spritz.py", line 755, in on_queueProcess_clicked
    rc = self.processPackageQueue(self.queue.packages)
  File "/usr/lib/entropy/spritz/spritz.py", line 1621, in processPackageQueue
    e,i = controller.run(install_queue[:], removal_queue[:], do_purge_cache)
  File "/usr/lib/entropy/spritz/entropyapi.py", line 174, in run
    rc = Package.run()
  File "/usr/lib/entropy/libraries/entropy.py", line 5085, in run
    rc = self.run_stepper(xterm_header)
  File "/usr/lib/entropy/libraries/entropy.py", line 5015, in run_stepper
    rc = self.install_step()
  File "/usr/lib/entropy/libraries/entropy.py", line 4796, in install_step
    rc = self.__install_package()
  File "/usr/lib/entropy/libraries/entropy.py", line 4188, in __install_package
    newidpackage = self._install_package_into_database()
  File "/usr/lib/entropy/libraries/entropy.py", line 4373, in _install_package_into_database
    idpk, rev, x = self.Entropy.clientDbconn.handlePackage(etpData = data, forcedRevision = data['revision'])
  File "/usr/lib/entropy/libraries/entropy.py", line 20421, in handlePackage
    return self.addPackage(etpData, revision = forcedRevision)
  File "/usr/lib/entropy/libraries/entropy.py", line 20482, in addPackage
    self.removePackage(pkg)
  File "/usr/lib/entropy/libraries/entropy.py", line 20791, in removePackage
    self.doCleanups()
  File "/usr/lib/entropy/libraries/entropy.py", line 21258, in doCleanups
    self.cleanupUseflags()
  File "/usr/lib/entropy/libraries/entropy.py", line 21266, in cleanupUseflags
    self.cursor.execute('delete from useflagsreference where idflag IN (select idflag from useflagsreference where idflag NOT in (select idflag from useflags))')
sqlite3.DatabaseError: database disk image is malformed


I must note that when I run memtest86+ that I get about 400 errors on this laptop, and they still appear when I switch memory chips, so my guess is I have a cache memory problem on the motherboard and the primary problem is not with Spritz/Entropy.

However, when Spritz has this problem, it no longer responds to anything, although the laptop still runs ok (I'm typing this from it). So my only solution is to close down Spritz. When I open it again later, it tells me about the remaining packages AFTER the package that failed to install successfully, so it thinks that it successfully installed that updated package when it appears that it did not.

[xlnagla]

You can use the bugzilla for bug reports - and while that is a bug in Spritz, your computer is much, much buggier - Spritz won't be able to install anything because your database in memory is corrupting during the time it takes for you to install a package. So it is doubtful the forums will prove terribly useful to you. After all, one of the first things we do when an error is mentioned is see if it's replicatable for somebody else (usually taken care of from personal experience), and without breaking something rather important your error can't be replicated.

~xlnagla

[maxmojo]

I am getting the same error, however my memory tests fine. Any suggestions? I will file a bug report (as soon as I figure out how).

max

[xlnagla]

That's not good

what version of spritz/equo/entropy?
bugs.sabayonlinux.org is for bug reports - your forum account will be of no use there, you'll need to create a new one.

~xlnagla

[dkasak]

I had the same error message, which I solved by running 'equo database resurrect', which complained about a broken database, but this time gave the full path ( /var/lib/entropy/something ). I renamed the file it was complaining about, and reran 'equo database resurrect' and now it's working.

[xlnagla]

if you're pre-0.22.1 and upgrading to 0.22.1 then be sure to run

rm -rf /var/lib/entropy/client/database/*/*/standard/*

before an equo update to fix that.

~xlnalga

[lxnay]

When you get this error, it's usually because you don't have a SANE hardware (bad RAM on top).

[lorebett]

it happened the same problem to me: I was running an update with spritz when the electric supply went off... after a roboot I kept on getting this error...

"equo database resurrect" did not help (I kept on getting this error during the resurrect)

so I did

Code: Select all

rm -rf /var/lib/entropy/client/database/*/*/standard/*

and after that

Code: Select all

equo update
equo database generate
equo update

but after this, an attempt to update world results in trying to update every single package...

can this be avoided?

thanks in advance
Lore

[lxnay]

With the introduction of Entropy 0.23, there are two new features you may like: the first one is called "Safe mode", the ability to run Entropy even without a valid local database (to allow users to fix it). The other one is a set of backup tools accessible through Equo and Spritz (equo database backup, equo database restore / Db backup under the Spritz preferences menu), a single backup will take around 25Mb, big deal

Also, I fixed some stuff on the database resurrect function, which works better now. If your db was completely in sync with Portage, you can choose a faster way: equo database generate.