demote sqlite, or remove it from the archive

Bug #747325 reported by Matthias Klose
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
libdbi-drivers (Ubuntu)
Fix Released
High
Unassigned
Natty
Invalid
Undecided
Unassigned
Oneiric
Fix Released
High
Unassigned
qt4-x11 (Ubuntu)
Fix Released
Medium
Didier Roche
Natty
Won't Fix
Undecided
Unassigned
Oneiric
Fix Released
Medium
Didier Roche
sqlite (Ubuntu)
Fix Released
High
Unassigned
Natty
Won't Fix
Undecided
Unassigned
Oneiric
Fix Released
High
Unassigned

Bug Description

Binary package hint: sqlite

we had this discussion before the 10.04 release, and did decide to wait until after the release. Just seen that we are still suck with this historic version.

please feel free to retarget the report to a later milestone.

Tags: ftbfs oneiric
Matthias Klose (doko)
Changed in sqlite (Ubuntu Natty):
milestone: none → ubuntu-11.04-beta-2
Revision history for this message
Colin Watson (cjwatson) wrote :
Download full text (4.0 KiB)

Current reverse-dependencies:

-- natty/main amd64 deps on libsqlite0:
libmono-sqlite1.0-cil
libmono-sqlite2.0-cil
libqt4-sql-sqlite2
libsasl2-modules-sql
php5-sqlite
-- natty/main i386 deps on libsqlite0:
libmono-sqlite1.0-cil
libmono-sqlite2.0-cil
libqt4-sql-sqlite2
libsasl2-modules-sql
php5-sqlite
-- natty/main armel deps on libsqlite0:
libmono-sqlite1.0-cil
libmono-sqlite2.0-cil
libqt4-sql-sqlite2
libsasl2-modules-sql
php5-sqlite
-- natty/main powerpc deps on libsqlite0:
libmono-sqlite1.0-cil
libmono-sqlite2.0-cil
libqt4-sql-sqlite2
libsasl2-modules-sql
php5-sqlite
-- natty/main build deps on libsqlite0-dev:
bacula
cyrus-sasl2
libdbi-drivers
php5
qt4-x11
-- natty/universe amd64 deps on libsqlite0:
asterisk
csync2
gambas2-gb-db-sqlite2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
kannel-extras
libcontactsdb0
libdbd-sqlite
libeventdb2
libgpepimc0
libgpeschedule0
libgpevtype1
libqof2-backend-sqlite
libsqliteodbc
libtododb0
mnogosearch-sqlite
pdns-backend-sqlite
prismstumbler
python-sqlite
python-sqlite-dbg
qsf
sqlrelay-sqlite
teleport
-- natty/universe i386 deps on libsqlite0:
asterisk
csync2
gambas2-gb-db-sqlite2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
kannel-extras
libcontactsdb0
libdbd-sqlite
libeventdb2
libgpepimc0
libgpeschedule0
libgpevtype1
libqof2-backend-sqlite
libsqliteodbc
libtododb0
mnogosearch-sqlite
pdns-backend-sqlite
prismstumbler
python-sqlite
python-sqlite-dbg
qsf
sqlrelay-sqlite
teleport
-- natty/universe armel deps on libsqlite0:
asterisk
csync2
gambas2-gb-db-sqlite2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
kannel-extras
libcontactsdb0
libdbd-sqlite
libeventdb2
libgpepimc0
libgpeschedule0
libgpevtype1
libqof2-backend-sqlite
libsqliteodbc
libtododb0
mnogosearch-sqlite
pdns-backend-sqlite
prismstumbler
python-sqlite
python-sqlite-dbg
qsf
sqlrelay-sqlite
teleport
-- natty/universe powerpc deps on libsqlite0:
asterisk
csync2
gambas2-gb-db-sqlite2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
kannel-extras
libcontactsdb0
libdbd-sqlite
libeventdb2
libgpepimc0
libgpeschedule0
libgpevtype1
libqof2-backend-sqlite
libsqliteodbc
libtododb0
mnogosearch-sqlite
pdns-backend-sqlite
prismstumbler
python-sqlite
python-sqlite-dbg
qsf
sqlrelay-sqlite
teleport
-- natty/universe build deps on libsqlite0-dev:
asterisk
csync2
cyrus-sasl2-heimdal
gambas2
gpe-announce
gpe-bluetooth
gpe-calendar
gpe-confd
gpe-contacts
gpe-timesheet
gpe-todo
gpesyncd
kannel
libeventdb
libgpepimc
libgpeschedule
libgpevtype
libtododb
mnogosearch
pdns
python-sqlite
qof
qsf
sqlrelay
teleport
-- natty/universe amd64 deps on libsqlite0-dev:
cl-sql-sqlite
kannel-dev
-- natty/universe i386 deps on libsqlite0-dev:
cl-sql-sqlite
kannel-dev
-- natty/universe armel deps on libsqlite0-dev:
cl-sql-sqlite
kannel-dev
-- natty/universe powerpc deps on libsqlite0-dev:
cl-sql-sqlite
kannel-dev
-- natty/universe build deps on sqlite:
kannel
-- natty/universe amd64 deps on sqlite:
ansel1
bacula-director-sqlite
beancounter
imms-common
movabletype-opensour...

Read more...

Revision history for this message
Stéphane Graber (stgraber) wrote :
Download full text (5.6 KiB)

Doh, should have refreshed that bug before looking at it :)
Anyway, here's the same thing as Colin but with some notes attached to it.

General feeling is that it'll be quite hard to remove it from the archive. Demoting should be a lot easier, though php is probably not that much fun.

Binary packages: sqlite, sqlite-doc, libsqlite0, libsqlite0-dev, libsqlite0-tcl

stgraber@castiana:~$ apt-cache rdepends sqlite
sqlite
Reverse Depends:
  sympa # OK: Recommends both sqlite and sqlite3
  serendipity # NOT OK: Depends on mysql-client | postgresql-client | sqlite. Should be changed to sqlite3 once php5-sqlite only supports sqlite3 (currently uses both sqlite and sqlite3) (0 rdepends)
  roundcube-sqlite # NOT OK: Depends on sqlite. Should be changed to sqlite3 once php5-sqlite only support sqlite3 (currently uses both sqlite and sqlite3) (2 rdepends)
  qsf # OK: sqlite is only a suggestion
  phpbb3 # NOT OK: Depends on mysql-client | postgresql-client | sqlite. Should be changed to sqlite3 once php5-sqlite only supports sqlite3 (currently uses both sqlite and sqlite3) (2 rdepends)
  pdns-backend-sqlite # NOT OK: Depends on sqlite. Should probably be dropped too as pdns-backend-sqlite3 already exists. (0 rdepends)
 |movabletype-opensource # NOT OK: Depends on sqlite | mysql-client | postgresql-client, should be changed to sqlite3 (uses libdbd-sqlite3-perl) (0 rdepends)
  lire # OK: Suggests both sqlite and sqlite3
  imms-common # OK: Recommends both sqlite and sqlite3
  csync2 # OK: Suggests sqlite
  beancounter # OK: Depends on either sqlite3 and sqlite
  bacula-director-sqlite # NOT OK: Depends on either sqlite3 and sqlite (0 rdepends)
 |ansel1 # OK: Recommends and sqlite3 is an alternative
  sqlite-doc # OK: Build from sqlite

stgraber@castiana:~$ apt-cache rdepends libsqlite0
libsqlite0
Reverse Depends:
  gentle # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (1 rdepends)
  teleport # NOT OK: Depends on libsqlite0 (0 rdepends)
  sqlrelay-sqlite # NOT OK: Depends on libsqlite0 (0 rdepends)
  qsf # NOT OK: Depends on libsqlite0 (0 rdepends)
  python-sqlite-dbg # NOT OK: Depends on libsqlite0 (1 rdepends)
  python-sqlite # NOT OK: Depends on libsqlite0 (14 rdepends)
  prismstumbler # NOT OK: Depends on libsqlite0 (0 rdepends)
  pdns-backend-sqlite # NOT OK: Depends on libsqlite0 (0 rdepends)
  mnogosearch-sqlite # NOT OK: Depends on libsqlite0 (0 rdepends)
  libtododb0 # NOT OK: Depends on libsqlite0 (6 rdepends)
  libsqliteodbc # NOT OK: Depends on both libsqlite0 and libsqlite3-0 (2 rdepends)
  libsqlite-tcl # OK: Build from sqlite (see below for rdepends)
  libqof2-backend-sqlite # NOT OK: Depends on libsqlite0 (1 rdepends)
  libgpevtype1 # NOT OK: Depends on libsqlite0...

Read more...

Revision history for this message
Stéphane Graber (stgraber) wrote :

Apparently LP didn't like that copy/paste so much, attaching the output instead.

Colin Watson (cjwatson)
Changed in sqlite (Ubuntu Natty):
milestone: ubuntu-11.04-beta-2 → ubuntu-11.04
Changed in sqlite (Ubuntu Natty):
status: New → Won't Fix
Changed in sqlite (Ubuntu Oneiric):
importance: Undecided → Medium
Changed in sqlite (Ubuntu Natty):
milestone: ubuntu-11.04 → none
Changed in sqlite (Ubuntu Oneiric):
milestone: none → oneiric-alpha-2
Revision history for this message
Martin Pitt (pitti) wrote :

Oneiric's mono migrated away from it, so in main the reverse dependencies are down to

libqt4-sql-sqlite2 : Just a binding without reverse dependencies, also builds libqt4-sql-sqlite (against sqlite3); can be dropped from package
libsasl2-modules-sql
php5-sqlite

reverse build deps:
bacula
libdbi-drivers
php5
qt4-x11

libqt4-sql-sqlite2 is just a binding without reverse dependencies, also builds libqt4-sql-sqlite (against sqlite3); it can be dropped from the source package.

Changed in sqlite (Ubuntu Oneiric):
milestone: oneiric-alpha-2 → oneiric-alpha-3
Changed in qt4-x11 (Ubuntu Natty):
status: New → Won't Fix
Revision history for this message
Martin Pitt (pitti) wrote :

Didier, can you please drop the -sqlite2 binary package from Qt?

Changed in qt4-x11 (Ubuntu Oneiric):
assignee: nobody → Didier Roche (didrocks)
importance: Undecided → Medium
status: New → Triaged
Changed in sqlite (Ubuntu Oneiric):
status: New → Triaged
Changed in qt4-x11 (Ubuntu Oneiric):
milestone: none → oneiric-alpha-3
Revision history for this message
Didier Roche (didrocks) wrote :

seems easy enough, after some investigation, seems that only kubuntu-full dep on the sqlite2 version, so we can drop the dep there and rebuild qt-x11 without sqlite2 support. Will do that just after alpha2

Revision history for this message
Martin Pitt (pitti) wrote :

I dropped libqt4-sql-sqlite2 from the Kubuntu seeds.

Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package qt4-x11 - 4:4.7.3-4ubuntu2

---------------
qt4-x11 (4:4.7.3-4ubuntu2) oneiric; urgency=low

  [ Scott Kitterman ]
  * Remove no longer used debian/patches/kubuntu_22_thumb2_support.diff

  [ Didier Roche ]
  * debian/patches/a11y_qt_and_qml_backport.diff:
    - refreshed from 11/06/28
  * debian/control:
    - refresh Vcs-* with new location
  * debian/libqt4-sql-sqlite2.install, debian/rules, debian/control:
    - don't build anymore the sqlite2 flavor. Only have libqt4-sql-sqlite with
      sqlite 3 support. (LP: #747325)
  * kubuntu_26_dbusconnection_pointer.diff:
    - readd wrongly removed upstream patch (will only be there for 4.8 and is
      needed for the dconf binding)
 -- Didier Roche <email address hidden> Thu, 07 Jul 2011 09:01:08 +0200

Changed in qt4-x11 (Ubuntu Oneiric):
status: Triaged → Fix Released
Revision history for this message
Matthias Klose (doko) wrote :
Changed in sqlite (Ubuntu Oneiric):
importance: Medium → High
milestone: oneiric-alpha-3 → ubuntu-11.10-beta-1
tags: added: ftbfs oneiric
Revision history for this message
Martin Pitt (pitti) wrote :

Steve/Matthias fixed php5 (FTBFS on amd64, though) and I fixed balula yesterday, so the only remaining rdepends is now libdbi-drivers. We could drop the build dep and the binary libdbd-sqlite package; the only reverse dependency of it is

Package: interchange-cat-standard
Depends: debconf (>= 0.5) | debconf-2.0, libwww-perl, interchange (>= 5.3.0), interchange-ui (>= 5.3.0), libdbd-sqlite | libdbd-mysql-perl | libdbd-pg-perl, dbconfig-common

so we would not even break this by removing libdbd-sqlite.

Changed in sqlite (Ubuntu Oneiric):
milestone: ubuntu-11.10-beta-1 → ubuntu-11.10-beta-2
Changed in libdbi-drivers (Ubuntu Natty):
status: New → Invalid
Changed in libdbi-drivers (Ubuntu Oneiric):
status: New → Triaged
assignee: nobody → Martin Pitt (pitti)
milestone: none → ubuntu-11.10-beta-2
Revision history for this message
Martin Pitt (pitti) wrote :

I uploaded a libdbi-drivers version which drops sqlite, sitting in unapproved now.

Changed in libdbi-drivers (Ubuntu Oneiric):
assignee: Martin Pitt (pitti) → nobody
importance: Undecided → High
status: Triaged → Fix Committed
milestone: ubuntu-11.10-beta-2 → ubuntu-11.10-beta-1
Changed in sqlite (Ubuntu Oneiric):
milestone: ubuntu-11.10-beta-2 → ubuntu-11.10-beta-1
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package libdbi-drivers - 0.8.3-1-0ubuntu5

---------------
libdbi-drivers (0.8.3-1-0ubuntu5) oneiric; urgency=low

  * debian/control: Drop libdbi-sqlite package, it has no reverse dependencies
    any more. Drop libsqlite0-dev build dependency, so that the old sqlite can
    finally drop out of main. (LP: #747325)
  * debian/rules: Drop --with-sqlite.
 -- Martin Pitt <email address hidden> Fri, 26 Aug 2011 10:03:42 +0200

Changed in libdbi-drivers (Ubuntu Oneiric):
status: Fix Committed → Fix Released
Revision history for this message
Martin Pitt (pitti) wrote :

Demoted to universe. Yohoo!

Changed in sqlite (Ubuntu Oneiric):
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers