Yes it is unstable as I mentioned in the original post, and has been unstable since install day over a year ago. Any breakage I've run into before was easy to work through but this time the package just refuses to move either way..
I will have to look into apt-listbugs to see what that is...
I killed the process because the stop script won't work.
Tried to remove it
Killed the process again because attempting to remove it restarted it ?? wierd..
Tried to re-install it
Still no go
Can't see pinning it to testing and downgrading when the partially installed packages refuses to move either way due to whatever is wrong with it. just curious how that would fix he issue. isn't the uninstall script part of the curently installed package ? no matter what package, stable testing or unstable I try to install it's still going to use it's own uninstall script no ?
so I tried synaptic, selected the package mysql-server-5.0 told it to remove all and hit apply
Synaptic tried to remove the package, failed and threw an error telling me to run dpkg --configure -a
I ran this command and the system finished installing the rest of the packages from my 'upgrade'
apt-cache policy mysql-server-5.0 showed the following
so theres been another release since last week when I attempted the upgrade I guess..
I did the following
and told it to go ahead and install the 138 packages listed..
apparently whatever the issue was has been fixed as the upgrade ran without a hitch apt-cache policy now shows
the mysqld start and stop scripts work again, so it looks like I'm back in good shape.
Thanks for the pointers. running synaptic, even though it couldn't fix the problem, provided the dpkg command to allow me to break the deadlock. I guess my assumption on the uninstall scripts was incorrect.