piktostest
Posts: 5
Joined: Sat Nov 07, 2015 1:33 pm

apt-get install sqlite3 problem

Sat Nov 07, 2015 1:46 pm

I'm tring to install sqlite but there is a problem.
Please help

Code: Select all

sudo apt-get install sqlite3

Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 sqlite3 : Depends: libsqlite3-0 (= 3.7.13-1+deb7u2) but 3.8.7.1-1+deb8u1 is to be installed
E: Unable to correct problems, you have held broken packages.

Code: Select all

sudo apt-cache policy sqlite3
sqlite3:
  Installed: (none)
  Candidate: 3.7.13-1+deb7u2
  Version table:
     3.7.13-1+deb7u2 0
        500 http://mirrordirector.raspbian.org/raspbian/ wheezy/main armhf Packages
My sources.list file

Code: Select all

# Original mirror
deb http://mirrordirector.raspbian.org/raspbian/ wheezy main contrib non-free rpi

piktostest
Posts: 5
Joined: Sat Nov 07, 2015 1:33 pm

Re: apt-get install sqlite3 problem

Sat Nov 07, 2015 7:34 pm

Please tell me, have you got the same problem as me , during installation SQLite ? Could You try it ?

sudo apt-get install sqlite3


>>The following packages have unmet dependencies:
>> sqlite3 : Depends: libsqlite3-0 (= 3.7.13-1+deb7u2) but 3.8.7.1-1+deb8u1 is to be installed

stderr
Posts: 2178
Joined: Sat Dec 01, 2012 11:29 pm

Re: apt-get install sqlite3 problem

Sat Nov 07, 2015 10:06 pm

piktostest wrote:Please tell me, have you got the same problem as me , during installation SQLite ? Could You try it ?
Installed without complaint on Wheezy original RPi for me.

User avatar
DougieLawson
Posts: 39158
Joined: Sun Jun 16, 2013 11:19 pm
Location: A small cave in deepest darkest Basingstoke, UK
Contact: Website Twitter

Re: apt-get install sqlite3 problem

Sun Nov 08, 2015 9:58 am

stderr wrote:
piktostest wrote:Please tell me, have you got the same problem as me , during installation SQLite ? Could You try it ?
Installed without complaint on Wheezy original RPi for me.
If you say that you should explain how your system is different to the OP's system so he/she can make the changes needed to fix his. Just saying "I've got one here that works." is useless.

Both you and the OP need to look at /etc/apt/sources.list and the files in /etc/apt/sources.list.d and compare them. Because otherwise I'm going to have to build a Wheezy system to discover what's wrong with the OP's system.
Note: Any requirement to use a crystal ball or mind reading will result in me ignoring your question.

Criticising any questions is banned on this forum.

Any DMs sent on Twitter will be answered next month.
All non-medical doctors are on my foes list.

stderr
Posts: 2178
Joined: Sat Dec 01, 2012 11:29 pm

Re: apt-get install sqlite3 problem

Sun Nov 08, 2015 4:25 pm

DougieLawson wrote:If you say that you should explain how your system is different to the OP's system so he/she can make the changes needed to fix his. Just saying "I've got one here that works." is useless.
I don't have access to his system. He said, "Could you try it?" I tried it and it installed as far as I could tell without complaint. There's nothing special about my configuration that I know of so there wasn't much more I could say.
Both you and the OP need to look at /etc/apt/sources.list and the files in /etc/apt/sources.list.d and compare them. Because otherwise I'm going to have to build a Wheezy system to discover what's wrong with the OP's system.
My sources.list says: deb http://mirrordirector.raspbian.org/raspbian/ wheezy main contrib non-free rpi . The sources.list.d dir has a file called raspi.list which has deb http://archive.raspberrypi.org/debian/ wheezy main in it. I'm pretty sure that sqlite3 is in the standard repositories so an install attempt should just work.

User avatar
rpdom
Posts: 17184
Joined: Sun May 06, 2012 5:17 am
Location: Chelmsford, Essex, UK

Re: apt-get install sqlite3 problem

Sun Nov 08, 2015 5:46 pm

The sources.list file isn't the only file that has entries for repositories. There are also files in /etc/apt/sources.list.d/ as well.

What may be helpful is if you and the OP both post the output of the "apt-cache policy" command (sudo not required) on your respective machines and compare the results.

piktostest
Posts: 5
Joined: Sat Nov 07, 2015 1:33 pm

Re: apt-get install sqlite3 problem

Mon Nov 09, 2015 6:20 am

Maybe I have wrong entries in sources.list / raspi.list files ? or maybe there is a problem in repository ?

sources.list
deb http://mirrordirector.raspbian.org/raspbian/ wheezy main contrib non-free rpi
# Uncomment line below then 'apt-get update' to enable 'apt-get source'

raspi.list

deb http://archive.raspberrypi.org/debian/ jessie main ui
# Uncomment line below then 'apt-get update' to enable 'apt-get source'
deb-src http://archive.raspberrypi.org/debian/ jessie main ui


apt-cache policy

Package files:
100 /var/lib/dpkg/status
release a=now
500 http://archive.raspberrypi.org/debian/ jessie/ui armhf Packages
release o=Raspberry Pi Foundation,a=stable,n=jessie,l=Raspberry Pi Foundation,c=ui
origin archive.raspberrypi.org
500 http://archive.raspberrypi.org/debian/ jessie/main armhf Packages
release o=Raspberry Pi Foundation,a=stable,n=jessie,l=Raspberry Pi Foundation,c=main
origin archive.raspberrypi.org
500 http://mirrordirector.raspbian.org/raspbian/ wheezy/rpi armhf Packages
release v=7.0,o=Raspbian,a=oldstable,n=wheezy,l=Raspbian,c=rpi
origin mirrordirector.raspbian.org
500 http://mirrordirector.raspbian.org/raspbian/ wheezy/non-free armhf Packages
release v=7.0,o=Raspbian,a=oldstable,n=wheezy,l=Raspbian,c=non-free
origin mirrordirector.raspbian.org
500 http://mirrordirector.raspbian.org/raspbian/ wheezy/contrib armhf Packages
release v=7.0,o=Raspbian,a=oldstable,n=wheezy,l=Raspbian,c=contrib
origin mirrordirector.raspbian.org
500 http://mirrordirector.raspbian.org/raspbian/ wheezy/main armhf Packages
release v=7.0,o=Raspbian,a=oldstable,n=wheezy,l=Raspbian,c=main
origin mirrordirector.raspbian.org
Pinned packages:


sudo apt-get install sqlite3

Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
sqlite3 : Depends: libsqlite3-0 (= 3.7.13-1+deb7u2) but 3.8.7.1-1+deb8u1 is to be installed
E: Unable to correct problems, you have held broken packages.

User avatar
rpdom
Posts: 17184
Joined: Sun May 06, 2012 5:17 am
Location: Chelmsford, Essex, UK

Re: apt-get install sqlite3 problem

Mon Nov 09, 2015 11:57 am

You have an odd mix of wheezy and jessie sources there, although I don't think that is causing the issue.

apt seems to be picking up the sqlite3 version from wheezy, but then finding the libsqlite3-0 from jessie, which doesn't match.

Perhaps you had jessie configured at one time and changed it back to wheezy?

Did you run "sudo apt-get update" before trying the install?

Could you run "apt-cache policy sqlite3 libsqlite3-0" to see where it is getting those versions from. This is what it shows on one of my jessie systems.

Code: Select all

rpdom@raspi4:~$ apt-cache policy sqlite3 libsqlite3-0
sqlite3:
  Installed: (none)
  Candidate: 3.8.7.1-1+deb8u1
  Version table:
     3.8.7.1-1+deb8u1 0
        500 http://mirrordirector.raspbian.org/raspbian/ jessie/main armhf Packages
libsqlite3-0:
  Installed: 3.8.7.1-1+deb8u1
  Candidate: 3.8.7.1-1+deb8u1
  Version table:
 *** 3.8.7.1-1+deb8u1 0
        500 http://mirrordirector.raspbian.org/raspbian/ jessie/main armhf Packages
        100 /var/lib/dpkg/status

fruitoftheloom
Posts: 23382
Joined: Tue Mar 25, 2014 12:40 pm
Location: Delightful Dorset

Re: apt-get install sqlite3 problem

Mon Nov 09, 2015 12:33 pm

Rather then trying to patch up various incompatibilities, maybe it would be easier to start with a fresh install of Raspbian Jessie ;)
Rather than negativity think outside the box !
RPi 4B 4GB (SSD Boot)..
Asus ChromeBox 3 Celeron is my other computer...

piktostest
Posts: 5
Joined: Sat Nov 07, 2015 1:33 pm

Re: apt-get install sqlite3 problem

Mon Nov 09, 2015 3:19 pm

Of Course, i use sudo apt-get update every time and even reboot device.

sudo apt-cache policy sqlite3 libsqlite3-0
sqlite3:
Installed: (none)
Candidate: 3.7.13-1+deb7u2
Version table:
3.7.13-1+deb7u2 0
500 http://mirrordirector.raspbian.org/raspbian/ wheezy/main armhf Packages
libsqlite3-0:
Installed: 3.8.7.1-1+deb8u1
Candidate: 3.8.7.1-1+deb8u1
Version table:
*** 3.8.7.1-1+deb8u1 0
100 /var/lib/dpkg/status
3.7.13-1+deb7u2 0
500 http://mirrordirector.raspbian.org/raspbian/ wheezy/main armhf Packages
Last edited by piktostest on Mon Nov 09, 2015 3:37 pm, edited 2 times in total.

User avatar
rpdom
Posts: 17184
Joined: Sun May 06, 2012 5:17 am
Location: Chelmsford, Essex, UK

Re: apt-get install sqlite3 problem

Mon Nov 09, 2015 3:24 pm

As I suspected, you have at least partially done an upgrade to jessie at some point, and the jessie version of libsqlite3-0 (3.8.7.1-1+deb8u1) is already installed.

Your options are:

a) force a downgrade of libsqlite3-0 to the wheezy version (3.7.13-1+deb7u2), which could be messy and will probably break your system.

b) change to the sources.list entries to jessie and upgrade various bits. This may break your system (it works for me because of how I've got my systems set up).

or c) reinstall either wheezy, or jessie from scratch as fruity suggested. This is the safest option.

piktostest
Posts: 5
Joined: Sat Nov 07, 2015 1:33 pm

Re: apt-get install sqlite3 problem

Mon Nov 09, 2015 3:45 pm

b) change to the sources.list entries to jessie and upgrade various bits. This may break your system (it works for me because of how I've got my systems set up).

Thank you very much for all help. It's finally working.

Return to “General discussion”