Re: mysql-server-5.1 installation problems

[Erez Zarum <erez@icinga.org.il>]

On 09/22/2010 01:05 AM, Jordan Metzmeier wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> On 09/21/2010 06:32 PM, Erez Zarum wrote:
> > After upgrading the mysql-server-5.1 (5.1.49) i'm having problems with
> > apt-get trying to run invoke-rc.d:
> >
> > Setting up mysql-server-5.1 (5.1.49-1~bpo50+1) ...
> > Stopping MySQL database server: mysqld.
> > Starting MySQL database server: mysqld ..
> > invoke-rc.d: initscript mysql, action "start" failed.
> > dpkg: error processing mysql-server-5.1 (--configure):
> >   subprocess post-installation script returned error exit status 1
> > Errors were encountered while processing:
> >   mysql-server-5.1
> > E: Sub-process /usr/bin/dpkg returned an error code (1)
> >
> > although it fails, the server runs, then evertime i use apt-get i keep
> > getting a server restart, anything i can do about it?
>
> My guess is that it is failing to configure because mysqld was still
> running the entire time (--configure calls "start" on the init script as
> shown in the error). What does /var/log/daemon.log have to say about it?
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iQIcBAEBCAAGBQJMmTpKAAoJEKj/C3qNthmTjKYQAImTGOjLLENbyRvOl0tgnB1x
> m0bW0+PgQh+7WITmT6U1ak++u4u6ayh9Llf0gRSZpugMdewQVrsh49dbSTWLyW1u
> 6NLob2KLj4yLUgNZeZDgS4hJW5qpD2iEBGOeyZnHZM8MBdjUK8Po0BeozDZ7uvBj
> IDjhKlZGEssP4VZJjHbOyph5Mh5H2OpawBpJ/HMWMc3uSQAD4XhaxyKESFOASnV+
> C9kYHluSbEp1FIysuU/I3wjjUX48B8vfLywAFoTf7bzJcfFQBp8Z/cdfkiHcaUFs
> XFIDpdWXF/MXkpMACKOzXRpl9wGcFAKRF3QwMdsmWvYWqY5OCwOL98HtNZB6HUAN
> po59whxUHHmwbdtXN58lkOssucYdlWf0KQnrGbY3BFq8k1g2pRni8luWoKMz7w3g
> DTPyoG1abuueeaAwglhO8V8MibUvoXNkBG7u9sEjNw12j9Qwm/OARx+mz4Rq0gDs
> lbW9L5xQvDca4HQUfsgfOUPbMt7xjAkPy7D1ctt5tmv/MJ7PY6Oge4w3O+hhkoI8
> /TSusnXDCNpjajd4teLYHZ+OT/gABcNPFz/9h/isrWmcPeuq59Cm4A6C9FGZ3xKL
> ttzveytlH/sUe0mp2cPiKvhbT4fHZkomoUGmqq3OCajgILrYx/KqWbORWNaRhevd
> ylyF4Xd5MlVJf2GNVRU5
> =JLq6
> -----END PGP SIGNATURE-----

Well, i figured it out, tried with mysqld down as well, tried many ways, 
none.

i do have a weird error now:

Sep 21 15:58:49 hostname mysqld_safe[10112]: ERROR: 1050  Table 'plugin' 
already exists
Sep 21 15:58:49 hostname mysqld_safe[10112]: 100921 15:58:49 [ERROR] 
Aborting

also had this:
mysqld_safe[10082]: ERROR: 1064  You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'ALTER TABLE user ADD column Show_view_priv 
enum('N','Y') CHARACTER SET utf8 NOT ' at line 1