package update-manager 1:0.87.24 failed to install/upgrade: ErrorMessage: SystemError in cache.commit(): E:Sub-process /usr/bin/dpkg returned an error code (1)

[jjinco33]

Binary package hint: update-manager

Upgrading to Ubuntu 8.04 and crashed.

ProblemType: Package
Architecture: i386
Date: Sun May 4 05:10:04 2008
DistroRelease: Ubuntu 8.04
ErrorMessage: ErrorMessage: SystemError in cache.commit(): E:Sub-process /usr/bin/dpkg returned an error code (1)

Package: update-manager 1:0.87.24
PackageArchitecture: all
SourcePackage: update-manager
Title: package update-manager 1:0.87.24 failed to install/upgrade: ErrorMessage: SystemError in cache.commit(): E:Sub-process /usr/bin/dpkg returned an error code (1)
Uname: Linux 2.6.22-14-386 i686

[Michael Vogt (mvo)]

Thanks for your bugreport.

Please attach the files in /var/log/dist-upgrade to this bugreport.
 Thanks Michael

[jjinco33 (jedadiah-williams)]

Here are the files as requested (in tarball).

[Michael Vogt (mvo)]

Here is what causes the error, I reassign:

2008-05-04 04:52:47,275 ERROR got an error from dpkg for pkg: 'otrs2': 'subprocess post-installation script returned error exit status 1

Setting up otrs2 (2.2.4-1) ...
dbconfig-common: writing config to /etc/dbconfig-common/otrs2.conf
Replacing config file /etc/otrs/database.pm with new version
creating database backup in /var/cache/dbconfig-common/backups/otrs2_2.1.7-2.mysql.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2).
unable to connect to mysql server.
error encountered backing up the old database:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
dbconfig-common: otrs2 configure: retrying.
rogressbarstyle" is not supported and will be ignored.
/mysqld/mysqld.sock' (2)
dbconfig-common: otrs2 configure: trying again.
/mysqld/mysqld.sock' (2)
dbconfig-common: otrs2 configure: aborted.
dbconfig-common: flushing administrative password
ql.
dpkg: error processing otrs2 (--configure):
 subprocess post-installation script returned error exit status 1

[Michael Vogt (mvo)]

This crashes for me in a clean gutsy -> hardy too (also in a different way):

Setting up otrs2 (2.1.7-2) ...
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "en_DK.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
dbconfig-common: writing config to /etc/dbconfig-common/otrs2.conf
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "en_DK.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").

Creating config file /etc/dbconfig-common/otrs2.conf with new version
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "en_DK.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").

Creating config file /etc/otrs/database.pm with new version
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LANG = "en_DK.UTF-8"
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
warning: database package not installed?
dbconfig-common: otrs2 configure: aborted.
dbconfig-common: flushing administrative password
dpkg: error processing otrs2 (--configure):
 subprocess post-installation script returned error exit status 1

This should be investigated

[guillermo zetina (guillermo-zetina)]

Hi, I got the next errors in: Linux lechezilla 2.6.24-19-generic #1 SMP Wed Jun 4 16:35:01 UTC 2008 i686 GNU/Linux

epistemon@lechezilla:/var/www$ sudo dpkg --configure otrs2
Configurando otrs2 (2.2.4-1) ...
dbconfig-common: writing config to /etc/dbconfig-common/otrs2.conf
Replacing config file /etc/otrs/database.pm with new version
granting access to database otrs2 for otrs@localhost: already exists.
creating database otrs2: already exists.
populating database via sql... error encountered populating database:
mysql said: ERROR 1050 (42S01) at line 7: Table 'valid' already exists
dbconfig-common: otrs2 configure: ignoring errors from here forwards
done.
dbconfig-common: flushing administrative password
This module does not exist!
dpkg: error al procesar otrs2 (--configure):
 el subproceso post-installation script devolvió el código de salida de error 1
Se encontraron errores al procesar:
 otrs2
epistemon@lechezilla:/var/www$

[guillermo zetina (guillermo-zetina)]

up's my wrong was mod_perl.... sorry :-(

[Dickson S. Guedes (guediz)]

Try 'sudo apt-get install libapache2-mod-perl2-dev' before 'sudo apt-get install otrs2'

So the installation process works fine...

[techstop (josh-techstop)]

Thanks a bunch Dickson S. Guedes! Your fix worked for the same issue here.

So, does this mean that the otrs2 package doesn't check for dependencies adequately? This should be an easy bugfix then?

[Dickson S. Guedes (guediz)]

I think yes, techstop. It don't.

[UlfsBuntu (ukottig)]

hi,
the workaround "install 'libapache2-mod-perl2-dev' before 'otrs2' doesent work with my system. Both install routines ends with the otrs2 error:

Richte otrs2 ein (2.3.4-1) ...
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAAuto.pm
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAuto.pm
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAAuto.pm
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAuto.pm
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAAuto.pm
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAuto.pm
dbconfig-common: writing config to /etc/dbconfig-common/otrs2.conf
Replacing config file /etc/otrs/database.pm with new version
Module perl already enabled
Module rewrite already enabled
 * Reloading web server config apache2 [ OK ]
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAAuto.pm
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAuto.pm
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/share/otrs/Kernel/cpan-lib /usr/share/otrs /etc/perl /usr/local/lib/perl/5.10.0 /usr/local/share/perl/5.10.0 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at (eval 18) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Pg, Proxy, Sponge.
 at /usr/share/otrs/Kernel/System/DB.pm line 216
dpkg: Fehler beim Bearbeiten von otrs2 (--configure):
 Unterprozess installiertes post-installation-Skript gab den Fehlerwert 2 zurück
Fehler traten auf beim Bearbeiten von:
 otrs2
E: Sub-process /usr/bin/dpkg returned an error code (1)

regards
_ulf

[CatchesAStar (catchesastar)]

The same error above is shown when a user chooses to skip debconf's database configuration.

[Rolf Leggewie (r0lf)]

Hardy has seen the end of its life and is no longer receiving any updates. Marking the Hardy task for this ticket as "Won't Fix".