Broken packages installing libsqlite3-dev

gonvaled · 2012-06-21 06:03:50

I am using Crunchbang Linux Statler for development. I am running in the following problem:

sudo apt-get --reinstall install libsqlite3-dev
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:
libsqlite3-dev : Depends: libsqlite3-0 (= 3.7.3-1) but 3.7.12.1-1~bpo60+1 is to be installed
E: Broken packages

What can I do?
Thanks and regards,
Daniel

ivanovnegro · 2012-06-21 16:02:13

Welcome to the #! community.

In your case I would try maybe this:

apt-get -t squeeze-backports install libsqlite3-0

gonvaled · 2012-06-21 18:24:05

Thanks but no luck:

sudo apt-get -t squeeze-backports install libsqlite3-0
Reading package lists... Done
Building dependency tree       
Reading state information... Done
libsqlite3-0 is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 145 not upgraded.

ivanovnegro wrote:

Welcome to the #! community.
In your case I would try maybe this:
apt-get -t squeeze-backports install libsqlite3-0

ivanovnegro · 2012-06-22 16:04:41

Sorry, to come late to you again.

Post output of:

apt-cache policy libsqlite3-0

gonvaled · 2012-06-27 13:38:16

Sorry for the late reply. This is the output that you requested:

libsqlite3-0:
  Installed: 3.7.12.1-1~bpo60+1
  Candidate: 3.7.12.1-1~bpo60+1
  Version table:
 *** 3.7.12.1-1~bpo60+1 0
        100 http://backports.debian.org/debian-backports/ squeeze-backports/main i386 Packages
        100 /var/lib/dpkg/status
     3.7.10-1~bpo60+1 0
        100 http://packages.crunchbang.org/statler-mozilla/ squeeze-backports/iceweasel-release i386 Packages
     3.7.3-1 0
        500 http://ftp.debian.org/debian/ squeeze/main i386 Packages

xaos52 · 2012-06-27 14:09:40

(1) purge version from stable
(2) install version from backports

sudo apt-get purge libsqlite3-dev 
sudo apt-get -t squeeze-backports install libsqlite3-dev

Last edited by xaos52 (2012-06-27 14:10:02)

gonvaled · 2012-06-27 14:53:29

I can not purge libsqlite3-dev. It is not even installed yet.
What I need to purge is libsqlite3-0. But this would break my whole system:

sudo apt-get purge libsqlite3-0
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libplist1 libcommons-collections3-java libstlport4.6ldbl kompozer-data libqt4-opengl vim-addon-manager libbase-java-openoffice.org libcolamd2.7.1 lp-solve libarchive1 libqt4-assistant
  libgphoto2-port0 libboost-regex1.42.0 libopenraw1 usbmuxd libbabl-0.0-0 libgegl-0.0-0 obex-data-server ttf-sil-gentium librdf0 libosp5 geany-plugin-codenav fortunes-min libsp1c2 libqt4-test
  geany-plugin-extrasel libhyphen0 libglew1.5 libcommons-compress-java libregexp-java libsource-highlight-common geany-plugin-vc libfftw3-3 mesa-common-dev geany-plugin-doc sp
  libpulse-mainloop-glib0 gnumeric-common jadetex fortune-mod liblucene2-java libserializer-java-openoffice.org librasqal2 bluez libgphoto2-2 geany-plugin-updatechecker libgnome-bluetooth7
  openjade libsource-highlight3 geany-plugin-lua ruby1.8 geany-plugin-spellcheck libctpl2 libsexy2 libqt4-xmlpatterns geany-plugin-treebrowser librecode0 libdmx1 geany-plugin-prj libqt4-help
  geany-plugin-prettyprinter ruby sgmlspl uno-libs3 libcdio-cdda0 libglu1-mesa-dev libtiff-tools ttf-sil-gentium-basic obexd-client qt4-qmake libunique-1.0-0 libimobiledevice1 libostyle1c2
  geany-plugin-insertnum libbluetooth3 libtextcat-data-utf8 geany-plugins-common geany-plugin-lipsum libqt4-svg libcommons-beanutils-java libphonon4 geany-plugin-gendoc libpkcs11-helper1
  libdb-je-java ure fonts-opensymbol libgimp2.0 ttf-dejavu libqt4-multimedia libcap-ng0 libusbmuxd1 libperl5.10 libgl1-mesa-dev libsgmls-perl libcdio-paranoia0 xserver-xephyr libdb4.7-java
  gdbserver libcommons-digester-java geany-plugin-sendmail libjtidy-java libhsqldb-java libconfig-inifiles-perl libraptor1 libservlet2.5-java geany-plugin-latex libicu4j-java libgtkspell0
  docbook-utils docbook-dsssl xfonts-mathml libruby1.8 geany-plugin-shiftcolumn libqt4-scripttools gimp-data libgtkglext1 source-highlight libopenobex1 geany-plugin-addons
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  iceape-browser lesstif2 libaprutil1-dbd-mysql libutempter0 poppler-data python3 python3-minimal python3.1 python3.1-minimal xbitmaps xpdf xterm
Suggested packages:
  iceape-mailnews xul-ext-dom-inspector libcanberra0 python3-doc python3-tk python3-profiler python3.1-doc python3.1-profiler binfmt-support xfonts-cyrillic
The following packages will be REMOVED:
  apt-xapian-index* aptitude* asciidoc* bzr* bzrtools* catfish* crunchbang-bin-scripts* cython* dblatex* dput* evince* feynmf* file-roller* gcalctool* gcj-4.4-jre-lib* gconf2* gdb* gdebi*
  gdebi-core* gdm* gdm-themes* geany-plugin-gdb* geany-plugin-webhelper* geany-plugins* gimp* gimp-gmic* gimp-plugin-registry* gksu* gnome-bluetooth* gnome-doc-utils* gnome-keyring*
  gnome-user-guide* gnumeric* google-chrome-stable* gvfs-backends* iceweasel* kompozer* libaprutil1-dbd-sqlite3* libbonoboui2-0* libdb4.7-java-gcj* libgcj-bc* libgcj-common* libgcj10*
  libgksu2-0* libgnome2-0* libgnome2-common* libgnome2-perl* libgnome2-vfs-perl* libgnomeui-0* libgnomevfs2-0* libgnomevfs2-common* libgnomevfs2-extra* libjaxp1.3-java-gcj* libpython2.6*
  libqt4-dev* libqt4-opengl-dev* libqt4-webkit* libreoffice* libreoffice-base* libreoffice-base-core* libreoffice-calc* libreoffice-common* libreoffice-core* libreoffice-draw*
  libreoffice-emailmerge* libreoffice-filter-binfilter* libreoffice-filter-mobiledev* libreoffice-gtk* libreoffice-impress* libreoffice-java-common* libreoffice-math*
  libreoffice-report-builder-bin* libreoffice-style-galaxy* libreoffice-style-tango* libreoffice-writer* librpm1* librpmio1* libsoup-gnome2.4-1* libsvn-perl* libsvn1* libwebkit-1.0-2*
  libxalan2-java-gcj* libxerces2-java-gcj* lsb-release* mercurial* mercurial-common* network-manager-gnome* network-manager-openvpn* network-manager-openvpn-gnome* obapps* obmenu*
  openjdk-6-jdk* openjdk-6-jre* openjdk-6-jre-headless* openjdk-6-jre-lib* openssl-blacklist* openvpn* openvpn-blacklist* python* python-all* python-all-dev* python-apt* python-apt-common*
  python-cairo* python-central* python-chardet* python-configobj* python-crypto* python-dbus* python-debian* python-dev* python-gconf* python-glade2* python-gnome2* python-gnupginterface*
  python-gobject* python-gtk2* python-hulahop* python-keybinder* python-libxml2* python-notify* python-numpy* python-paramiko* python-pyorbit* python-software-properties* python-subversion*
  python-support* python-uno* python-vte* python-wxgtk2.8* python-wxtools* python-wxversion* python-xapian* python-xdg* python-xlib* python-xpcom* python2.5* python2.5-dev* python2.6*
  python2.6-dev* rpl* rpm2cpio* software-properties-gtk* sqlite3* subversion* subversion-tools* tasksel* tasksel-data* terminator* texlive-extra-utils* unattended-upgrades* xchat* xchat-common*
  xulrunner-1.9.1* xulrunner-11.0* yelp*
The following NEW packages will be installed:
  iceape-browser lesstif2 libaprutil1-dbd-mysql libutempter0 poppler-data python3 python3-minimal python3.1 python3.1-minimal xbitmaps xpdf xterm
0 upgraded, 12 newly installed, 156 to remove and 0 not upgraded.
Need to get 21.5 MB of archives.
After this operation, 1,010 MB disk space will be freed.
Do you want to continue [Y/n]?

According to the dependencies for libsqlite3-dev:
libsqlite3-dev : Depends: libsqlite3-0 (= 3.7.3-1) but 3.7.12.1-1~bpo60+1 is to be installed

That is, I need 3.7.3-1, but I have 3.7.12.1-1~bpo60+1.
That should be ok. Actually, the dependency for libsqlite3-dev should be >= 3.7.3-1, not only = 3.7.3-1.
Is it possible to change this?

gonvaled · 2012-06-27 15:15:30

These are the dependecies for libsqlite3-dev. I wonder if I could change that locally, in order to force an install.

apt-cache showpkg libsqlite3-dev 
Package: libsqlite3-dev
Versions: 
3.7.3-1 (/var/lib/apt/lists/ftp.debian.org_debian_dists_squeeze_main_binary-i386_Packages)
 Description Language: 
                 File: /var/lib/apt/lists/ftp.debian.org_debian_dists_squeeze_main_binary-i386_Packages
                  MD5: 6387c6fc4f6fed646a1e0a793253786e


Reverse Depends: 
  libspatialite-dev,libsqlite3-dev 3.3.6
  librpm-dev,libsqlite3-dev
  librdf0-dev,libsqlite3-dev
  libqt4-dev,libsqlite3-dev
  libqgis-dev,libsqlite3-dev
  libopensync0-dev,libsqlite3-dev
  libsqlite3-ocaml-dev,libsqlite3-dev
  libmapnik-dev,libsqlite3-dev
  libvalhalla-dev,libsqlite3-dev
  libopkele-dev,libsqlite3-dev
  libkaya-sqlite3-dev,libsqlite3-dev
  kannel-dev,libsqlite3-dev
  libghc6-hdbc-sqlite3-dev,libsqlite3-dev 3.3
  libghc6-hsql-sqlite3-dev,libsqlite3-dev
  libgnadesqlite3-1-dev,libsqlite3-dev
  libgdal1-dev,libsqlite3-dev
  libcamel1.2-dev,libsqlite3-dev 3.5
  cl-sql-sqlite3,libsqlite3-dev
  libaprutil1-dev,libsqlite3-dev
Dependencies: 
3.7.3-1 - libsqlite3-0 (5 3.7.3-1) libc6-dev (0 (null)) sqlite3-doc (0 (null)) 
Provides: 
3.7.3-1 - 
Reverse Provides:

xaos52 · 2012-06-27 15:31:23

They are all -dev pakages. purge them all.
New versions will come with the new version of libsqlite3-dev

gonvaled · 2012-06-27 15:41:18

xaos52 wrote:

They are all -dev pakages. purge them all.
New versions will come with the new version of libsqlite3-dev

That feels scary. I went a different route:

sudo dpkg --purge --force-depends libsqlite3-0
sudo apt-get install libsqlite3-0
sudo apt-get install -f
sudo apt-get install libsqlite3-dev

And now I can achieve my original goal:

pip install pysqlite

xaos52 · 2012-06-27 15:43:46

The effect is the same, I think. It is certainly shorter smile
The last command should include '-target squeeze-backports', unless you install from backports by default, which is not a good idea.

Last edited by xaos52 (2012-06-27 15:45:54)

VWGTi#! · 2012-09-07 14:43:27

Thank you for this thread. I'm attempting to install BugZilla on #! and been working through getting the Perl Modules installed. The required ones installed without issue, the optional ones went smooth except for the last two mod_perl2 and Apache2::SizeLimit. I got mod_perl2 to install by installing the libapache2-mod-perl2 package instead of the Perl module itself. Apache2::SizeLimit looks for apxs when installing and the default install of LAMP in #! didn't have it. So, trying to install apache2-prefork-dev lead to the same issues encountered in this thread. After getting apache2-prefork-dev installed, I was able to get Apache2::SizeLimit to install.
Thank you again! big_smile

CrunchBang Linux

SEARCH

#1 2012-06-21 06:03:50

Broken packages installing libsqlite3-dev

#2 2012-06-21 16:02:13

Re: Broken packages installing libsqlite3-dev

#3 2012-06-21 18:24:05

Re: Broken packages installing libsqlite3-dev

#4 2012-06-22 16:04:41

Re: Broken packages installing libsqlite3-dev

#5 2012-06-27 13:38:16

Re: Broken packages installing libsqlite3-dev

#6 2012-06-27 14:09:40

Re: Broken packages installing libsqlite3-dev

#7 2012-06-27 14:53:29

Re: Broken packages installing libsqlite3-dev

#8 2012-06-27 15:15:30

Re: Broken packages installing libsqlite3-dev

#9 2012-06-27 15:31:23

Re: Broken packages installing libsqlite3-dev

#10 2012-06-27 15:41:18

Re: Broken packages installing libsqlite3-dev

#11 2012-06-27 15:43:46

Re: Broken packages installing libsqlite3-dev

#12 2012-09-07 14:43:27

Re: Broken packages installing libsqlite3-dev

Board footer