problem in Synaptic package manager in UBUNTU 10.04

[aduaitpokhriyal]

Hi..
Whenever I start Synaptic package manager it shows some changes to apply and when I click apply it shows error E: /var/cache/apt/archives/mysql-server-5.1_5.1.41-3ubuntu12.3_i386.deb: subprocess new pre-removal script returned error exit status 1.
And then whole application exit.
Help

[devils casper]

Open Terminal and execute this

sudo apt-get clean all
sudo apt-get update

Post error message here, if any.

[aduaitpokhriyal]

aduait@aduait-laptop:~$ sudo apt-get clean all
aduait@aduait-laptop:~$ sudo apt-get update                                              
E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem. 
aduait@aduait-laptop:~$ sudo dpkg --configure -a
dpkg: error processing mysql-server-5.1 (--configure):
 Package is in a very bad inconsistent state - you should
 reinstall it before attempting configuration.
Errors were encountered while processing:
 mysql-server-5.1

[devils casper]

Execute this

sudo dpkg --configure -a

[aduaitpokhriyal]

Sir I have ran that command and its output was also error as you can see above in my previous reply.

[aduaitpokhriyal]

Also

aduait@aduait-laptop:~$ sudo apt-get autoremove 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be REMOVED:
  mysql-server-5.1
0 upgraded, 0 newly installed, 1 to remove and 92 not upgraded.
2 not fully installed or removed.
After this operation, 15.0MB disk space will be freed.
Do you want to continue [Y/n]? Y
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing mysql-server-5.1 (--remove):
 Package is in a very bad inconsistent state - you should
 reinstall it before attempting a removal.
Errors were encountered while processing:
 mysql-server-5.1
E: Sub-process /usr/bin/dpkg returned an error code (1)

[aduaitpokhriyal]

aduait@aduait-laptop:~$ sudo dpkg --configure -a
[sudo] password for aduait: 
Setting up man-db (2.5.7-2) ...
debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable
dpkg: error processing man-db (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: error processing mysql-server-5.1 (--configure):
 Package is in a very bad inconsistent state - you should
 reinstall it before attempting configuration.
Errors were encountered while processing:
 man-db
 mysql-server-5.1

[devils casper]

Check if mysql server process is running in the background. Kill/stop it and try to re-install mysql-server.
Last option is, delete its post install files. It not recommended to do that though but if nothing works, we have to do that only.

Let me know if re-install of mysql sort out problem or not.

[aduaitpokhriyal]

its showing error:

Reading package lists... Done
Building dependency tree       
Reading state information... Done
E: The package mysql-server-5.1 needs to be reinstalled, but I can't find an archive for it.

[devils casper]

How did you install mysql-server-5.1? Did you install it manually or through Package Manager?
Try these commands :

sudo apt-get --purge remove mysql-server
sudo apt-get update
sudo apt-get install mysql-server-5.1