[Bug 670541] [NEW] Upgrade mysql5.0 -> 5.1 fails due to error on postrm script.

[Mark - Syminet]

Public bug reported:

Binary package hint: mysql-server-5.1


Hardy -> Lucid upgrade, after which phpmyadmin warns about mysql-server5.0 whereas
the php library is 5.1 and thus conflicts.  OK, lets upgrade - but mysql upgrade fails due to 
what looks like a typo in the postrm script: 

===                                                    
Preconfiguring packages ...
(Reading database ... 40610 files and directories currently installed.)
Removing mysql-server-5.0 ...
 * Stopping MySQL database server mysqld
   ...done.
/var/lib/dpkg/info/mysql-server-5.0.postrm: line 38: syntax error near unexpected token `fi'
dpkg: error processing mysql-server-5.0 (--remove):
 subprocess installed post-removal script returned error exit status 2
Removing mysql-client-5.0 ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...
ureadahead will be reprofiled on next reboot
Errors were encountered while processing:
 mysql-server-5.0
E: Sub-process /usr/bin/dpkg returned an error code (1)
root at 28r6s1:/etc/apache#  
=== 

For me, the quick fix was to edit /var/lib/dpkg/info/mysql-server-5.0.postrm 
shellscript and simply make this the first line: 

exit 0;

...hopefully this didn't cause some sort of breakage that will bite us at 
some indeterminable point in the future.  But it at least got the critical 
mysql service running again on that server.

** Affects: mysql-5.1 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
Upgrade mysql5.0 -> 5.1 fails due to error on postrm script.  
https://bugs.launchpad.net/bugs/670541
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in ubuntu.