Your message dated Sun, 13 Feb 2011 15:17:08 +0000
with message-id <e1podhe-0001b1...@franck.debian.org>
and subject line Bug#611820: fixed in dbconfig-common 1.8.47
has caused the Debian Bug report #611820,
regarding dbconfig-common doesn't work properly when the version of the 
database script for upgrade is greather than 1.10, 1.10.1, 1.10.2, 1.10.3, 
1.11, 1.12
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)


-- 
611820: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=611820
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: dbconfig-common
Version: 1.8.38ubuntu1
Severity: major

  When I upgrade my package version from 1.5.5 --> 1.12, with mysql's script
for upgrade named : 1.6, 1.7, 1.7.1, 1.7.2, 1.7.3, 1.7.4, 1.7.5, 1.7.6, 1.8,
1.9, 1.10,
  1.10.1, 1.10.2, 1.10.3, 1.10.4 1.11 and 1.12

To have a transcript, you can use the /usr/share/doc/dbconfig-
common/examples/db-test-mysql-2.1

1. Rename the package:
/usr/share/doc/dbconfig-common/examples/db-test-mysql-2.1 to
/usr/share/doc/dbconfig-common/examples/db-test-mysql-1.5.5
don't forget to update your changelog
2. install the first package (dpkg -i your_package_name_1.5.5_all.deb).

3. Create a new package db-test-mysql-1.12 with mysql upgrade's files from:
mysql-upgrade_1.6, mysql-upgrade_1.7, mysql-upgrade_1.7.1,
mysql-upgrade_1.7.2,
mysql-upgrade_1.7.3, ... mysql-upgrade_1.10.1, mysql-upgrade_1.10.2,
mysql-upgrade_1.10.3, mysql-upgrade_1.11, mysql-upgrade_1.12 with a script
to upgrade the version
of the database: update mytable set version='1.10.1' for example for
mysql-upgrade_1.10.1;

4. Generate your package

5. Upgrade your package (dpkg -i your_package_name_1.12_all.deb)

The result is:

    applying upgrade sql for 1.5.5 -> 1.6.
    applying upgrade sql for 1.5.5 -> 1.7.
    applying upgrade sql for 1.5.5 -> 1.7.1.
    applying upgrade sql for 1.5.5 -> 1.7.2.
    applying upgrade sql for 1.5.5 -> 1.7.3.
    applying upgrade sql for 1.5.5 -> 1.7.4.
    applying upgrade sql for 1.5.5 -> 1.7.5.
    applying upgrade sql for 1.5.5 -> 1.7.6.
    applying upgrade sql for 1.5.5 -> 1.8.
    applying upgrade sql for 1.5.5 -> 1.9.
    applying upgrade sql for 1.5.5 -> 1.10.

Some scripts (1.10.1, 1.10.2, 1.10.3, 1.10.4 1.11 and 1.12) are not applied.


I suggest that the function dbc_find_upgrades() that sort files and return
the list of the files sorted, in /usr/share/dbconfig-common/dpkg/postinst,
be corrected.

Specially replace this script:
from line 248 to 258:

    # if we haven't already placed it
    if [ ! "$placed" ]; then
        # if the this version is less than the next sorted one
        if dpkg --compare-versions $f lt $s; then
            # insert it here
            tlist="$tlist $f $s"
            placed="yes"
        else
            # it's not less, so append the sorted one and continue
            tlist="$tlist $s"
        fi
    fi

with:
    # if we haven't already placed it
        if [ ! "$placed" ]; then
            # if the this version is less than the next sorted one
            if dpkg --compare-versions $f lt $s; then
                # insert it here
                tlist="$tlist $f"
                placed="yes"
            fi
        fi
        tlist="$tlist $s"

  I am using Ubuntu GNU/Linux 8.04 LTS, kernel 2.6.24-23-server and libc6
Version: 2.7-10ubuntu5

-- 
*Ghislain Mokolomboka*

*Dvidea
Paris Innovation Massena - Hall B - 7ème étage
15, rue Jean-Baptiste Berlier
75013 Paris
www.dvidea.com
Tel: +33 1 55 43 79 04
Fax: +33 1 55 43 75 01*

--- End Message ---
--- Begin Message ---
Source: dbconfig-common
Source-Version: 1.8.47

We believe that the bug you reported is fixed in the latest version of
dbconfig-common, which is due to be installed in the Debian FTP archive:

dbconfig-common_1.8.47.dsc
  to main/d/dbconfig-common/dbconfig-common_1.8.47.dsc
dbconfig-common_1.8.47.tar.gz
  to main/d/dbconfig-common/dbconfig-common_1.8.47.tar.gz
dbconfig-common_1.8.47_all.deb
  to main/d/dbconfig-common/dbconfig-common_1.8.47_all.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 611...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Sean Finney <sean...@debian.org> (supplier of updated dbconfig-common package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.8
Date: Sun, 13 Feb 2011 13:48:57 +0000
Source: dbconfig-common
Binary: dbconfig-common
Architecture: source all
Version: 1.8.47
Distribution: unstable
Urgency: low
Maintainer: Sean Finney <sean...@debian.org>
Changed-By: Sean Finney <sean...@debian.org>
Description: 
 dbconfig-common - common framework for packaging database applications
Closes: 475417 576533 591849 599374 608500 611820
Changes: 
 dbconfig-common (1.8.47) unstable; urgency=low
 .
   * make _dbc_find_upgrades set -u safe
   * Fix version sorting logic bug on upgrade files in postinst.
     Thanks to Ghislain Mokolomboka <mghisl...@dvidea.com> (Closes: #611820)
   * Use defaults-file instead of defaults-extra-file when calling mysql.
     Thanks to Glennie Vignarajah <glen...@glennie.fr> (Closes: #576533)
   * Source dpkg/common (conditionally) in preinst before calling dbc_logline.
     Thanks to Klaus Zerwes <kzer...@web.de> (Closes: #608500)
   * Fix for dbc_mysql_createdb_encoding is missing.
     Thanks to Jérémy Lal <kapo...@melix.org> (Closes: #599374)
   * updates to (fi) debconf translations.
     Thanks to Esko Arajärvi <e...@iki.fi> (Closes: #475417)
   * updates to (de) debconf translations.
     Thanks to Raphael Bossek <boss...@debian.org> (Closes: #591849)
Checksums-Sha1: 
 576eda5e163732fc81f7de22c947fdb94f1ccd5b 999 dbconfig-common_1.8.47.dsc
 e473bb86ffc748ad5530e8c0d6ee3aac7771e145 364476 dbconfig-common_1.8.47.tar.gz
 b83718f5c94642a5360170488de011887be70aa6 473862 dbconfig-common_1.8.47_all.deb
Checksums-Sha256: 
 4cd5e65a4b241dde1a7615d86d2bf3e263f867871605bef84b1f9ca641028c22 999 
dbconfig-common_1.8.47.dsc
 de4d944508f2de5de7425483489b9213d1be5dad9e048fda0fe3935c67b8b225 364476 
dbconfig-common_1.8.47.tar.gz
 309ab77780ee0c34819fba291577b248d0a0a87ebf119842b4fa3366685b657d 473862 
dbconfig-common_1.8.47_all.deb
Files: 
 08c8e9e06a82dd25a5792cc832300ae9 999 admin optional dbconfig-common_1.8.47.dsc
 1ec86559fe8db342b07a80c684161931 364476 admin optional 
dbconfig-common_1.8.47.tar.gz
 397c83b981031c2e72c05c3bf5c699df 473862 admin optional 
dbconfig-common_1.8.47_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAk1X8DEACgkQynjLPm522B0fHgCaAuge8r1OSSUZdni3wirI02C9
2HYAoIlAxUcsarsKdeZQzF0FzgWHW8WZ
=25iK
-----END PGP SIGNATURE-----



--- End Message ---

Reply via email to