package mysql-server-5.1 5.1.37-1ubuntu4 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1

[Khairul Aizat Kamarudzzaman]

Preconfiguring packages ...
(Reading database ... 187184 files and directories currently installed.)
Preparing to replace mysql-server-5.1 5.1.37-1ubuntu4 (using .../mysql-server-5.1_5.1.37-1ubuntu4_i386.deb) ...
 * Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: warning: old pre-removal script returned error exit status 1
dpkg - trying script from the new package instead ...
 * Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.37-1ubuntu4_i386.deb (--unpack):
 subprocess new pre-removal script returned error exit status 1
 * Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
Preparing to replace mysql-server-core-5.1 5.1.37-1ubuntu4 (using .../mysql-server-core-5.1_5.1.37-1ubuntu4_i386.deb) ...
Unpacking replacement mysql-server-core-5.1 ...
Processing triggers for man-db ...
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.1_5.1.37-1ubuntu4_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

ProblemType: Package
AptOrdering:
 mysql-server-5.1: Install
 mysql-server-core-5.1: Install
 mysql-server-5.1: Configure
 mysql-server-core-5.1: Configure
Architecture: i386
Date: Sat Sep 26 11:16:41 2009
DistroRelease: Ubuntu 9.10
ErrorMessage: subprocess new pre-removal script returned error exit status 1
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['ibdata1', 'osdcmy', 'avantfax', 'pp4m', 'mysql', 'phpbb3', 'ib_logfile0', 'ib_logfile1', 'test', 'debian-5.1.flag', 'osdc', 'amarokdb', 'treehill', 'mysql_upgrade_info', 'ndoutils']
Package: mysql-server-5.1 5.1.37-1ubuntu4
ProcVersionSignature: Ubuntu 2.6.31-11.36-generic
SourcePackage: mysql-dfsg-5.1
Title: package mysql-server-5.1 5.1.37-1ubuntu4 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
Uname: Linux 2.6.31-11-generic i686

[Chuck Short (zulcss)]

Relevant error:

Sep 21 23:11:04 thinkbuntu mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Sep 21 23:11:05 thinkbuntu mysqld: 090921 23:11:05 [Note] Plugin 'FEDERATED' is disabled.
Sep 21 23:11:07 thinkbuntu mysqld: 090921 23:11:07 InnoDB: Started; log sequence number 0 797423
Sep 21 23:11:08 thinkbuntu mysqld: 090921 23:11:08 [Note] Event Scheduler: Loaded 0 events
Sep 21 23:11:08 thinkbuntu mysqld: 090921 23:11:08 [Note] /usr/sbin/mysqld: ready for connections.
Sep 21 23:11:08 thinkbuntu mysqld: Version: '5.1.37-1ubuntu4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

Are you still having this problem?

Regards
chuck

[Khairul Aizat Kamarudzzaman (fenris)]

fenris@thinkbuntu:~$ sudo /etc/init.d/mysql start
[sudo] password for fenris:
 * Starting MySQL database server mysqld [ OK ]
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
fenris@thinkbuntu:~$ ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
sudo /etc/init.d/mysql restart
 * Stopping MySQL database server mysqld [fail]
 * Starting MySQL database server mysqld

[Khairul Aizat Kamarudzzaman (fenris)]

i think after i reset my debian-sys-maint password with the one at /etc/mysql/debian.cnf ; here are the result:

fenris@thinkbuntu:~$ sudo /etc/init.d/mysql restart
 * Stopping MySQL database server mysqld [ OK ]
 * Starting MySQL database server mysqld [ OK ]
 * Checking for corrupt, not cleanly closed and upgrade needing tables.

[Khairul Aizat Kamarudzzaman (fenris)]

after upgrade to mysql-server-5.1 (5.1.37-1ubuntu5) also i have no problem after i change password according to /etc/mysql/debian.cnf.

its fixed .. thanks