Announcement

Collapse
No announcement yet.

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

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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?

    #2
    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:

    Code:
    dpkg -l | grep libsqlite
    
    apt-cache policy libsqlite3-0:amd64
    
    apt-cache policy libsqlite3-0:i386

    Comment


      #3
      Originally posted by SteveRiley View Post
      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:

      Code:
      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:

      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.

      Comment


        #4
        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:
        Code:
        apt-get download libsqlite3-0:amd64
        2. Download the 32-bit version:
        Code:
        apt-get download libsqlite3-0:i386
        3. Forcibly remove the existing 64-bit version:
        Code:
        sudo dpkg --force-depends --purge libsqlite3-0:amd64
        4. Forcibly remove the existing 32-bit version:
        Code:
        sudo dpkg --force-depends --purge libsqlite3-0:i386
        5. Manually install the 64-bit version:
        Code:
        sudo dpkg --install libsqlite3-0*amd64.deb
        6. Manually install the 32-bit version:
        Code:
        sudo dpkg --install libsqlite3-0*i386.deb

        Comment


          #5
          Dear Steve,

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

          Thanks.

          Comment


            #6
            Glad it's working for you.

            Comment


              #7
              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

              Code:
              % /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
              %
              Last edited by SteveRiley; Oct 08, 2012, 04:53 PM. Reason: wrapped output in CODE tags

              Comment


                #8
                This...
                Code:
                % /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:
                Code:
                apt-cache policy libsqlite3-0:amd64

                Comment


                  #9
                  Hi,
                  I get the similar error while installing sqlite3 on Ubuntu 12.04 x64.
                  Code:
                  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?

                  Comment


                    #10
                    What are you trying to install that requires sqlite3?

                    Comment


                      #11
                      Originally posted by SteveRiley View Post
                      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.

                      Comment


                        #12
                        Please show the output of:
                        Code:
                        apt-cache policy sqlite3
                        
                        apt-cache policy libsqlite3-0

                        Comment


                          #13
                          Here it is:
                          Code:
                          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

                          Comment


                            #14
                            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:
                            Code:
                            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.

                            Comment


                              #15
                              Code:
                              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.

                              Comment

                              Working...
                              X