package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade:

[RaGGa]

claudio@srvclaudio:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 9.10
Release: 9.10
Codename: karmic
claudio@srvclaudio:~$ uname -a
Linux srvclaudio 2.6.31-19-generic #56-Ubuntu SMP Thu Jan 28 01:26:53 UTC 2010 i686 GNU/Linux
claudio@srvclaudio:~$ apt-cache policy mysql-common
mysql-common:
  Instalados: 5.1.37-1ubuntu5.1
  Candidato: 5.1.37-1ubuntu5.1
  Tabla de versión:
 *** 5.1.37-1ubuntu5.1 0
        500 http://cl.archive.ubuntu.com karmic-updates/main Packages
        500 http://cl.archive.ubuntu.com karmic-security/main Packages
        100 /var/lib/dpkg/status
     5.1.37-1ubuntu5 0
        500 http://cl.archive.ubuntu.com karmic/main Packages
     5.0.51a-3ubuntu5 0
        500 http://archive.ubuntu.com hardy/main Packages

ProblemType: Package
Architecture: i386
Date: Thu Feb 25 08:45:53 2010
DistroRelease: Ubuntu 9.10
ErrorMessage:
 ErrorMessage: el subproceso script pre-removal nuevo devolvió el código de salida de error 1
InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release i386 (20091028.5)
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['ib_logfile0', 'fanta', 'css', 'debian-5.1.flag', 'ibdata1', 'CodigoBarras', 'GeneradorPHP', 'ib_logfile1', 'mysql', 'fantaPrueba', 'ldconstructora', 'rmbxlocal', 'clientes', 'fantaPrevio', 'phpmyadmin', 'mysql_upgrade_info']
NonfreeKernelModules: nvidia
Package: mysql-server-5.1 5.1.37-1ubuntu5
ProcVersionSignature: Ubuntu 2.6.31-19.56-generic
SourcePackage: mysql-dfsg-5.1
Title: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade:
Uname: Linux 2.6.31-19-generic i686

[Chuck Short (zulcss)]

It looks like you have corrupted tables:

Feb 23 13:12:35 srvclaudio mysqld: 100223 13:12:35 InnoDB: Started; log sequence number 0 82929788
Feb 23 13:12:35 srvclaudio mysqld: 100223 13:12:35 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. The table is probably corrupted
Feb 23 13:12:35 srvclaudio mysqld: 100223 13:12:35 [ERROR] mysql.user has no `Event_priv` column at position 29
Feb 23 13:12:35 srvclaudio mysqld: 100223 13:12:35 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
Feb 23 13:12:35 srvclaudio mysqld: 100223 13:12:35 [Note] /usr/sbin/mysqld: ready for connections.

Regards
chuck