package mysql-server 5.1.30really5.0.75-0ubuntu10.2 failed to install/upgrade: subprocess pre-installation script returned error exit status 1

[Stephane Chaudy]

system : Ubuntu 9.04 - Jaunty Jackalope -

Préconfiguration des paquets...
(Lecture de la base de données... 179094 fichiers et répertoires déjà installés.)
Préparation du remplacement de mysql-server 5.1.30really5.0.75-0ubuntu10.2 (en utilisant .../mysql-server_5.1.30really5.0.75-0ubuntu10.3_all.deb) ...
 * Stopping MySQL database server mysqld
   ...fail!
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 1
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg : erreur de traitement de /var/cache/apt/archives/mysql-server_5.1.30really5.0.75-0ubuntu10.3_all.deb (--unpack) :
 le sous-processus pre-installation script a retourné une erreur de sortie d'état 1
Des erreurs ont été rencontrées pendant l'exécution :
 /var/cache/apt/archives/mysql-server_5.1.30really5.0.75-0ubuntu10.3_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Un paquet n'a pas pu être installé.

ProblemType: Package
Architecture: i386
DistroRelease: Ubuntu 9.04
ErrorMessage: subprocess pre-installation script returned error exit status 1
Package: mysql-server 5.1.30really5.0.75-0ubuntu10.2
PackageArchitecture: all
SourcePackage: mysql-dfsg-5.0
Title: package mysql-server 5.1.30really5.0.75-0ubuntu10.2 failed to install/upgrade: subprocess pre-installation script returned error exit status 1
Uname: Linux 2.6.28-18-generic i686

[Jean-Baptiste Lallement (jibel)]

Thanks for your report.

could you please open a terminal run the following command:
$ grep mysqld /var/log/daemon.log > /tmp/var.log.daemon.log

And attach the file tmp/var.log.daemon.log to this report.

Thanks.

[Scaler (balaton22)]

Same bug here with:
Ubuntu 9.10 (amd64)
Linux Kernel 2.6.31-19

Préconfiguration des paquets...
(Lecture de la base de données... 217186 fichiers et répertoires déjà installés.)
Préparation du remplacement de mysql-server-5.1 5.1.37-1ubuntu5 (en utilisant .../mysql-server-5.1_5.1.37-1ubuntu5.1_amd64.deb) ...
 * Stopping MySQL database server mysqld
   ...fail!
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg : avertissement : ancien script pre-removal a retourné une erreur de sortie d'état 1
dpkg - tentative d'exécution du script du nouveau paquet à la place ...
 * Stopping MySQL database server mysqld
   ...fail!
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg : erreur de traitement de /var/cache/apt/archives/mysql-server-5.1_5.1.37-1ubuntu5.1_amd64.deb (--unpack) :
 le sous-processus nouveau script pre-removal a retourné une erreur de sortie d'état 1
 * Stopping MySQL database server mysqld
   ...fail!
invoke-rc.d: initscript mysql, action "stop" failed.
 * Starting MySQL database server mysqld
   ...done.
Des erreurs ont été rencontrées pendant l'exécution :
 /var/cache/apt/archives/mysql-server-5.1_5.1.37-1ubuntu5.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
Échec de l'installation d'un paquet. Tentative de récupération :

[Stephane Chaudy (stephane-chaudy)]

Jean-Baptiste Lallement a écrit :
>
> Thanks for your report.
>
> could you please open a terminal run the following command:
> $ grep mysqld /var/log/daemon.log > /tmp/var.log.daemon.log
>
> And attach the file tmp/var.log.daemon.log to this report.
>
> Thanks.
>
>
> ** Changed in: mysql-dfsg-5.0 (Ubuntu)
> Status: New => Incomplete
>

[Jean-Baptiste Lallement (jibel)]

Stephane, it is the same symptom but not the same cause.

From your log
Feb 11 10:04:22 C-3PO mysqld: 100211 10:04:22 [ERROR] /usr/sbin/mysqld: Table './bdd_ogspy4/ogspy_config' is marked as crashed and should be repaired
Feb 11 10:04:22 C-3PO mysqld: 100211 10:04:22 [Warning] Checking table: './bdd_ogspy4/ogspy_config'
Feb 11 10:04:22 C-3PO mysqld: 100211 10:04:22 [ERROR] /usr/sbin/mysqld: Table './bdd_ogspy4/ogspy_user' is marked as crashed and should be repaired
Feb 11 10:04:22 C-3PO mysqld: 100211 10:04:22 [Warning] Checking table: './bdd_ogspy4/ogspy_user'
Feb 11 10:04:22 C-3PO mysqld: 100211 10:04:22 [ERROR] /usr/sbin/mysqld: Table './bdd_ogspy4/ogspy_user_ressources' is marked as crashed and should be repaired
Feb 11 10:04:22 C-3PO mysqld: 100211 10:04:22 [Warning] Checking table: './bdd_ogspy4/ogspy_user_ressources'

your database is corrupted. Please repair it before proceeding with the upgrade of the package.

[Scaler (balaton22)]

That was mine...

I have repaired the incriminated tables, although their status was marked as OK in phpMyAdmin.
Rebooted then upgraded the package, and I get the same error.

(Attach file is the log file since reboot)

[Stephane Chaudy (stephane-chaudy)]

the user debian-sys-maint has lost his password !
I repair it :

# grep password /etc/mysql/debian.cnf

# mysql -u root -p
mysql> SET PASSWORD FOR 'debian-sys-maint'@'localhost' = PASSWORD('LE_MOT_DE_PASSE_ICI');
mysql> FLUSH PRIVILEGES;
mysql> exit;

All is ok now !

http://www.cooldev.net/article-244-mysql-jai-perdu-mon-mot-de-passe-debian-sys-maint.html

[Jean-Baptiste Lallement (jibel)]

Thanks for following up. I'm closing this report due to your last comment.
Don't hesitate to submit any new bug.