Can't install anything, bad libsqlite3-0:amd64

[asf100]

Hi,
I'm already tryed cleaning all the way but this error continue:

asf100@mj-117105:~$ LANG=C;sudo apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
libsqlite3-0:i386
The following packages will be upgraded:
libsqlite3-0:i386
1 upgraded, 0 newly installed, 0 to remove and 290 not upgraded.
2 not fully installed or removed.
Need to get 354 kB of archives.
After this operation, 0 B of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://br.archive.ubuntu.com/ubuntu/ precise-updates/main libsqlite3-0 i386 3.7.9-2ubuntu1.1 [354 kB]
Fetched 354 kB in 0s (467 kB/s)
dpkg: error processing libsqlite3-0:i386 (--configure):
libsqlite3-0:i386 3.7.9-2ubuntu1 cannot be configured because libsqlite3-0:amd64 is in a different version (3.7.9-2ubuntu1.1)
dpkg: error processing libsqlite3-0 (--configure):
libsqlite3-0:amd64 3.7.9-2ubuntu1.1 cannot be configured because libsqlite3-0:i386 is in a different version (3.7.9-2ubuntu1)
Errors were encountered while processing:
libsqlite3-0:i386
libsqlite3-0
E: Sub-process /usr/bin/dpkg returned an error code (1)
asf100@mj-117105:~$ LANG=C;sudo apt-get --fix-missing install
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these.
The following packages have unmet dependencies:
libsqlite3-0 : Breaks: libsqlite3-0:i386 (!= 3.7.9-2ubuntu1.1) but 3.7.9-2ubuntu1 is installed
libsqlite3-0:i386 : Breaks: libsqlite3-0 (!= 3.7.9-2ubuntu1) but 3.7.9-2ubuntu1.1 is installed
E: Unmet dependencies. Try using -f.

Anyone knows what is?

[SteveRiley]

Hm, somehow there's a version mismatch between the 32-bit and 64-bit libraries currently installed on your machine. There are some brute-force ways to clean this up. But first, I'd like a closer look at what you have. Please show the output of these three commands:

dpkg -l | grep libsqlite

apt-cache policy libsqlite3-0:amd64

apt-cache policy libsqlite3-0:i386

[asf100]

Hm, somehow there's a version mismatch between the 32-bit and 64-bit libraries currently installed on your machine. There are some brute-force ways to clean this up. But first, I'd like a closer look at what you have. Please show the output of these three commands:

dpkg -l | grep libsqlite

apt-cache policy libsqlite3-0:amd64

apt-cache policy libsqlite3-0:i386

Hi Steve, grateful for your concern. Here is the code:

 
asf100@mj-117105:~$ dpkg -l | grep libsqlite
iU  libsqlite3-0                          3.7.9-2ubuntu1.1                        SQLite 3 shared library
iF  libsqlite3-0:i386                     3.7.9-2ubuntu1                          SQLite 3 shared library
asf100@mj-117105:~$ apt-cache policy libsqlite3-0:amd64
libsqlite3-0:
  Instalado: 3.7.9-2ubuntu1.1
  Candidato: 3.7.9-2ubuntu1.1
  Tabela de versão:
 *** 3.7.9-2ubuntu1.1 0
        500 http://archive.ubuntu.com/ubuntu/ precise-updates/main amd64 Packages
        100 /var/lib/dpkg/status
     3.7.9-2ubuntu1 0
        500 http://archive.ubuntu.com/ubuntu/ precise/main amd64 Packages
asf100@mj-117105:~$ LANG=C;apt-cache policy libsqlite3-0:amd64
libsqlite3-0:
  Installed: 3.7.9-2ubuntu1.1
  Candidate: 3.7.9-2ubuntu1.1
  Version table:
 *** 3.7.9-2ubuntu1.1 0
        500 http://archive.ubuntu.com/ubuntu/ precise-updates/main amd64 Packages
        100 /var/lib/dpkg/status
     3.7.9-2ubuntu1 0
        500 http://archive.ubuntu.com/ubuntu/ precise/main amd64 Packages
asf100@mj-117105:~$ LANG=C;apt-cache policy libsqlite3-0:i386
libsqlite3-0:i386:
  Installed: 3.7.9-2ubuntu1
  Candidate: 3.7.9-2ubuntu1.1
  Version table:
     3.7.9-2ubuntu1.1 0
        500 http://archive.ubuntu.com/ubuntu/ precise-updates/main i386 Packages
 *** 3.7.9-2ubuntu1 0
        500 http://archive.ubuntu.com/ubuntu/ precise/main i386 Packages
        100 /var/lib/dpkg/status
asf100@mj-117105:~$

Thanks.

[SteveRiley]

OK, that's what I suspected. I'm not able to precisely recreate your situation to test, but here's a procedure that I suspect will get you going. We'll manually download and install each package. I'll explain each step.

1. Download the 64-bit version:

apt-get download libsqlite3-0:amd64

2. Download the 32-bit version:

apt-get download libsqlite3-0:i386

3. Forcibly remove the existing 64-bit version:

sudo dpkg --force-depends --purge libsqlite3-0:amd64

4. Forcibly remove the existing 32-bit version:

sudo dpkg --force-depends --purge libsqlite3-0:i386

5. Manually install the 64-bit version:

sudo dpkg --install libsqlite3-0*amd64.deb

6. Manually install the 32-bit version:

sudo dpkg --install libsqlite3-0*i386.deb

[asf100]

Dear Steve,

You are the master of the universe. Everything is working now, even the system update are OK.

Thanks.

[SteveRiley]

Glad it's working for you.

[Chelmite]

I tried your solution, and was not successful. It complains that libsqlite3-0:amd64 3.7.13-1~bpo60+1 cannot be configured because libsqlite3-0:i386 is in a different version (3.7.9-2ubuntu1.1)

Any help would be appreciated.
Thanks,
Steve

% /usr/bin/sudo apt-get download libsqlite3-0:amd64
Get:1 Downloading libsqlite3-0 3.7.13-1~bpo60+1 [453 kB]
Fetched 453 kB in 0s (942 kB/s)      
% /usr/bin/sudo apt-get download libsqlite3-0:i386
Get:1 Downloading libsqlite3-0 3.7.9-2ubuntu1.1 [354 kB]
Fetched 354 kB in 0s (394 kB/s)       
% /usr/bin/sudo dpkg --force-depends --purge libsqlite3-0:amd64
dpkg: libsqlite3-0: dependency problems, but removing anyway as you requested:
 libmono-sqlite2.0-cil depends on libsqlite3-0 (>= 3.6.13).
 libsqlite3-dev depends on libsqlite3-0 (= 3.7.9-2ubuntu1.1).
 unity-lens-music depends on libsqlite3-0 (>= 3.5.9).
 libpackagekit-glib2-14 depends on libsqlite3-0 (>= 3.5.9).
 libnss3 depends on libsqlite3-0 (>= 3.5.9).
 libkrb5-26-heimdal depends on libsqlite3-0 (>= 3.5.9).
 f-spot depends on libsqlite3-0.
 telepathy-salut depends on libsqlite3-0 (>= 3.5.9); however:
  Package libsqlite3-0 is to be removed.
 libcamel-1.2-29 depends on libsqlite3-0 (>= 3.6.0).
 libmono-sqlite4.0-cil depends on libsqlite3-0 (>= 3.6.13).
 libedata-book-1.2-11 depends on libsqlite3-0 (>= 3.5.9).
 libsunpinyin3 depends on libsqlite3-0 (>= 3.5.9).
 libqtwebkit4 depends on libsqlite3-0 (>= 3.5.9).
 libebackend-1.2-1 depends on libsqlite3-0 (>= 3.6.0).
 python2.7-dbg depends on libsqlite3-0 (>= 3.5.9).
 libyelp0 depends on libsqlite3-0 (>= 3.5.9).
 libdbd-sqlite3 depends on libsqlite3-0 (>= 3.5.9).
 python2.7 depends on libsqlite3-0 (>= 3.5.9).
 libsvn1 depends on libsqlite3-0 (>= 3.6.22).
 ibus-pinyin depends on libsqlite3-0 (>= 3.6.11); however:
  Package libsqlite3-0 is to be removed.
 xmms2-core depends on libsqlite3-0 (>= 3.5.9).
 libaprutil1-dbd-sqlite3 depends on libsqlite3-0 (>= 3.5.9).
 libwebkitgtk-3.0-0 depends on libsqlite3-0 (>= 3.5.9).
 telepathy-gabble depends on libsqlite3-0 (>= 3.5.9); however:
  Package libsqlite3-0 is to be removed.
 indicator-appmenu depends on libsqlite3-0 (>= 3.5.9).
 zeitgeist-core depends on libsqlite3-0 (>= 3.5.9).
 libsasl2-modules-sql depends on libsqlite3-0 (>= 3.5.9).
 libgpod4 depends on libsqlite3-0 (>= 3.5.9).
 libtelepathy-logger2 depends on libsqlite3-0 (>= 3.5.9).
 sqlite3 depends on libsqlite3-0 (= 3.7.9-2ubuntu1.1).
 libqt4-sql-sqlite depends on libsqlite3-0 (>= 3.5.9).
 colord depends on libsqlite3-0 (>= 3.5.9).
 libsoup-gnome2.4-1 depends on libsqlite3-0 (>= 3.5.9).
 libwebkitgtk-1.0-0 depends on libsqlite3-0 (>= 3.5.9).
 shotwell depends on libsqlite3-0 (>= 3.5.9).
(Reading database ... 419084 files and directories currently installed.)
Removing libsqlite3-0 ...
Purging configuration files for libsqlite3-0 ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
% /usr/bin/sudo dpkg --force-depends --purge libsqlite3-0:i386
dpkg: libsqlite3-0:i386: dependency problems, but removing anyway as you requested:
 libkrb5-26-heimdal:i386 depends on libsqlite3-0 (>= 3.5.9).
(Reading database ... 419080 files and directories currently installed.)
Removing libsqlite3-0:i386 ...
Purging configuration files for libsqlite3-0:i386 ...
dpkg: warning: while removing libsqlite3-0:i386, directory '/usr/share/doc/libsqlite3-0' not empty so not removed.
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
% /usr/bin/sudo dpkg --install libsqlite3-0*amd64.deb
Selecting previously unselected package libsqlite3-0.
(Reading database ... 419075 files and directories currently installed.)
Unpacking libsqlite3-0 (from libsqlite3-0_3.7.13-1~bpo60+1_amd64.deb) ...
Setting up libsqlite3-0 (3.7.13-1~bpo60+1) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
% /usr/bin/sudo dpkg --install libsqlite3-0*i386.deb
Selecting previously unselected package libsqlite3-0:i386.
(Reading database ... 419083 files and directories currently installed.)
Unpacking libsqlite3-0:i386 (from libsqlite3-0_3.7.9-2ubuntu1.1_i386.deb) ...
De-configuring libsqlite3-0 ...
dpkg: error processing libsqlite3-0:i386 (--install):
 libsqlite3-0:i386 3.7.9-2ubuntu1.1 cannot be configured because libsqlite3-0:amd64 is in a different version (3.7.13-1~bpo60+1)
dpkg: error processing libsqlite3-0 (--install):
 libsqlite3-0:amd64 3.7.13-1~bpo60+1 cannot be configured because libsqlite3-0:i386 is in a different version (3.7.9-2ubuntu1.1)
Errors were encountered while processing:
 libsqlite3-0:i386
 libsqlite3-0
%

[SteveRiley]

This...

% /usr/bin/sudo apt-get download libsqlite3-0:amd64
Get:1 Downloading [B]libsqlite3-0 3.7.13-1~bpo60+1[/B] [453 kB]
Fetched 453 kB in 0s (942 kB/s)
% /usr/bin/sudo apt-get download libsqlite3-0:i386
Get:1 Downloading [B]libsqlite3-0 3.7.9-2ubuntu1.1[/B] [354 kB]
Fetched 354 kB in 0s (394 kB/s)

...is why. Notice that the version numbers are different. It should be 3.7.9-2ubuntu1.1 for both 64-bit and 32-bit, but for some reason your package manager is pulling in a newer version of the 64-bit library. Let's find out where from. Please run:

apt-cache policy libsqlite3-0:amd64

[alatar]

Hi,
I get the similar error while installing sqlite3 on Ubuntu 12.04 x64.

The following packages have unmet dependencies:
 sqlite3 : Depends: libsqlite3-0 (= 3.7.9-2ubuntu1) but 3.7.9-2ubuntu1.1 is to be installed

In my case there is no mismatch between x86 and x64 libsqlite3-0 version.
I tried to force version 3.7.9-2ubuntu1 instead of 3.7.9-2ubuntu1.1 using synaptic but it requries removing few packages like skype, amarok... So I don't think that's a good way to do it.

Could you give me a hand?

[SteveRiley]

What are you trying to install that requires sqlite3?

[alatar]

What are you trying to install that requires sqlite3?

I need it to open database in terminal which is not working with older version. Temporarily I am using a firefox addon SQLite Manager.

[SteveRiley]

Please show the output of:

apt-cache policy sqlite3

apt-cache policy libsqlite3-0

[alatar]

Here it is:

alatar:~$ apt-cache policy sqlite3
sqlite3:
  Installed: (none)
  Candidate: 3.7.9-2ubuntu1
  Version table:
     3.7.9-2ubuntu1 0
        500 pl_archive_ubuntu_com/ubuntu/ precise/main amd64 Packages
alatar:~$ apt-cache policy libsqlite3-0
libsqlite3-0:
  Installed: 3.7.9-2ubuntu1.1
  Candidate: 3.7.9-2ubuntu1.1
  Version table:
 *** 3.7.9-2ubuntu1.1 0
        100 /var/lib/dpkg/status
     3.7.9-2ubuntu1 0
        500 pl_archive_ubuntu_com/ubuntu/ precise/main amd64 Packages

[SteveRiley]

Somehow, you managed to get version 1.1 of libsqlite3-0 on your machine, but not from any repository -- the second apt-cache policy command tells me this. When you try to install the sqlite3 package, because your machine only knows about version 1 (but not version 1.1), it wants to install version 1 of the library. But since you already have version 1.1 installed, APT will not downgrade to satisfy a dependency, and therefore the installation fails.

Version 1.1 of both of these packages is available in the Precise Updates repository. Normally, this is enabled. Let's check yours:

cat /etc/apt/sources.list | grep update

This command displays all lines in your sources.list file that contain the word "update." It will let us know whether the repository has been enabled on your computer. I'm walking you step-by-step through this process because knowing how to do these kinds of things at the command line is a good skill to possess.

[alatar]

alatar:~$ cat /etc/apt/sources. list | grep update
## Major bug fix updates produced after the final release of the
## review or updates from the Ubuntu security team.
## multiverse WILL NOT receive any review or updates from the Ubuntu
## or updates from the Ubuntu security team.
deb pl_archive_ubuntu_com/ubuntu/ precise-updates restricted main multiverse universe

EDIT: Problem solved. I've just realised that I tried to install sqlite3 yesterday when optional updates from precise-updates repository were turned off for a moment. So I installed all optional updates and refreshed repo db and then sqlite3 installation worked successfuly.

For the future issues - what should I do if I had similar problem? Is there any safety way to downgrade the package?

Thank you SteveRiley. I really appreciate your help.