mysql server fails to start in postinst on package upgrade

[robersonfox]

In a AMD64

ProblemType: Package
Architecture: amd64
DistroRelease: Ubuntu 9.04
ErrorMessage: sub-processo post-installation script retornou estado de saída de erro 1
NonfreeKernelModules: nvidia ath_hal
Package: mysql-server-5.1 5.1.31-1ubuntu2
SourcePackage: mysql-dfsg-5.1
Title: package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade: sub-processo post-installation script retornou estado de saída de erro 1
Uname: Linux 2.6.28-11-generic x86_64

[Andreas Olsson (andol)]

Are there any /var/log/daemon.log entries from that time regarding mysql? Have you had a version of mysql-server installed before? Perhaps mysql-server-5.0?

[robersonfox (robersonfox)]

yes, I had the directories of an old installation.

2009/4/26 Andreas Olsson <email address hidden>

> Are there any /var/log/daemon.log entries from that time regarding
> mysql? Have you had a version of mysql-server installed before? Perhaps
> mysql-server-5.0?
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu)
> Status: New => Incomplete
>
> --
> package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de sa?da de erro 1
> https://bugs.launchpad.net/bugs/354585
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” source package in Ubuntu: Incomplete
>
> Bug description:
> In a AMD64
>
> ProblemType: Package
> Architecture: amd64
> DistroRelease: Ubuntu 9.04
> ErrorMessage: sub-processo post-installation script retornou estado de
> saída de erro 1
> NonfreeKernelModules: nvidia ath_hal
> Package: mysql-server-5.1 5.1.31-1ubuntu2
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de saída de erro 1
> Uname: Linux 2.6.28-11-generic x86_64
>

--
Carl Roberson
Genova Engine C&S
www.genovaengine.com
Av. Avelino Pinheiro - 596 - Jaçanã - Ibirité
31 3521.0069

[Andreas Olsson (andol)]

Ok, taken a bit of a closer look at the logs now. Just figured out how to translate the error messages :)

Can you post the result of the follow two commands

ls -ld /var/lib/mysql/
ls -ld /

(Actually it is primarily the first one I believe is irrelevant. But once we're at it, I did see something else in the logs which didn't seem right.)

[robersonfox (robersonfox)]

No, i removed the instalation.

2009/4/27 Andreas Olsson <email address hidden>

> Ok, taken a bit of a closer look at the logs now. Just figured out how
> to translate the error messages :)
>
> Can you post the result of the follow two commands
>
> ls -ld /var/lib/mysql/
> ls -ld /
>
> (Actually it is primarily the first one I believe is irrelevant. But
> once we're at it, I did see something else in the logs which didn't seem
> right.)
>
> --
> package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de sa?da de erro 1
> https://bugs.launchpad.net/bugs/354585
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” source package in Ubuntu: Incomplete
>
> Bug description:
> In a AMD64
>
> ProblemType: Package
> Architecture: amd64
> DistroRelease: Ubuntu 9.04
> ErrorMessage: sub-processo post-installation script retornou estado de
> saída de erro 1
> NonfreeKernelModules: nvidia ath_hal
> Package: mysql-server-5.1 5.1.31-1ubuntu2
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de saída de erro 1
> Uname: Linux 2.6.28-11-generic x86_64
>

--
Carl Roberson
Genova Engine C&S
www.genovaengine.com
Av. Avelino Pinheiro - 596 - Jaçanã - Ibirité
31 3521.0069

[Andreas Olsson (andol)]

Well, based on the logs I'd say it seems like the error was caused by /var/lib/mysql/ being owned by a non-mysql user. But without any remains of the folder I'm not sure if there is anything we can do to figure out the root cause of these permission problems.

[robersonfox (robersonfox)]

Yes, /var/lib/mysql was owned by root, not mysql user,
before i removed the instalation i see it.

May be the instalation process do a: chown -R mysql mysql /var/lib/mysql

2009/4/27 Andreas Olsson <email address hidden>

> Well, based on the logs I'd say it seems like the error was caused by
> /var/lib/mysql/ being owned by a non-mysql user. But without any remains
> of the folder I'm not sure if there is anything we can do to figure out
> the root cause of these permission problems.
>
> --
> package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de sa?da de erro 1
> https://bugs.launchpad.net/bugs/354585
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” source package in Ubuntu: Incomplete
>
> Bug description:
> In a AMD64
>
> ProblemType: Package
> Architecture: amd64
> DistroRelease: Ubuntu 9.04
> ErrorMessage: sub-processo post-installation script retornou estado de
> saída de erro 1
> NonfreeKernelModules: nvidia ath_hal
> Package: mysql-server-5.1 5.1.31-1ubuntu2
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de saída de erro 1
> Uname: Linux 2.6.28-11-generic x86_64
>

--
Carl Roberson
Genova Engine C&S
www.genovaengine.com
Av. Avelino Pinheiro - 596 - Jaçanã - Ibirité
31 3521.0069

[robersonfox (robersonfox)]

Yes, /var/lib/mysql was owned by root, not mysql user,
before I removed the instalation i see it.

Maybe the instalation process do a: chown -R mysql mysql /var/lib/mysql

2009/4/27 Andreas Olsson <email address hidden>

> Well, based on the logs I'd say it seems like the error was caused by
> /var/lib/mysql/ being owned by a non-mysql user. But without any remains
> of the folder I'm not sure if there is anything we can do to figure out
> the root cause of these permission problems.
>
> --
> package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de sa?da de erro 1
> https://bugs.launchpad.net/bugs/354585
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” source package in Ubuntu: Incomplete
>
> Bug description:
> In a AMD64
>
> ProblemType: Package
> Architecture: amd64
> DistroRelease: Ubuntu 9.04
> ErrorMessage: sub-processo post-installation script retornou estado de
> saída de erro 1
> NonfreeKernelModules: nvidia ath_hal
> Package: mysql-server-5.1 5.1.31-1ubuntu2
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de saída de erro 1
> Uname: Linux 2.6.28-11-generic x86_64
>

--
Carl Roberson
Genova Engine C&S
www.genovaengine.com
Av. Avelino Pinheiro - 596 - Jaçanã - Ibirité
31 3521.0069

[Andreas Olsson (andol)]

@Carl: Just to make sure if there is an actual bug here or not; is the root ownership of /var/lib/mysql the result of something you did, or do you believe the package manager somehow created that situation?

[robersonfox (robersonfox)]

No, the root was the owner of /var/lib/mysql, kept the files after a
reinstall of ubuntu, this directory (/var/lib/ mysql) saved on my Pendrive
(backup), then moved them to this directory (again) after the reinstall,
then tried to install mysql and got this error.

2009/4/30 Andreas Olsson <email address hidden>

> @Carl: Just to make sure if there is an actual bug here or not; is the
> root ownership of /var/lib/mysql the result of something you did, or do
> you believe the package manager somehow created that situation?
>
> --
> package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de sa?da de erro 1
> https://bugs.launchpad.net/bugs/354585
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” source package in Ubuntu: Incomplete
>
> Bug description:
> In a AMD64
>
> ProblemType: Package
> Architecture: amd64
> DistroRelease: Ubuntu 9.04
> ErrorMessage: sub-processo post-installation script retornou estado de
> saída de erro 1
> NonfreeKernelModules: nvidia ath_hal
> Package: mysql-server-5.1 5.1.31-1ubuntu2
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.31-1ubuntu2 failed to install/upgrade:
> sub-processo post-installation script retornou estado de saída de erro 1
> Uname: Linux 2.6.28-11-generic x86_64
>

--
Carl Roberson
Genova Engine C&S
www.genovaengine.com
Av. Avelino Pinheiro - 596 - Jaçanã - Ibirité
31 3521.0069

[Jeremy Wilkins (wjeremy)]

I am having the same error, but my installation went poorly. Currently on Karmic with version 5.1.31.

[Jeremy Wilkins (wjeremy)]

My error, I posted too quickly. My problem was that a program was trying to access the mysql database during install.

[robersonfox (robersonfox)]

I solved the problem by giving permission to read and write in the /var/lib/ mysql to mysql user
(chown-R mysql.mysql /var/lib/mysql),
I suggested that this be implemented in the package, unfortunately no.

[mayroncachina (mayroncachina)]

Even taking a cue from Carl, I could not install the package.

[Mathias Gug (mathiaz)]

I guess that Carl's problem comes from the fact that when the /var/lib/mysql/ directory was restored from the backup media ownership was not restored correctly.

[Mathias Gug (mathiaz)]

The maintainer scripts should have fixed the ownership of the /var/lib/mysql/.

According to the apt terminal log the error is:

Configurando mysql-server-5.1 (5.1.31-1ubuntu2) ...

 * Stopping MySQL database server mysqld [ OK ]

 * Starting MySQL database server mysqld [fail]

Do you still have the content of /var/log/daemon.log at the time of the upgrade to help figure out why mysqld failed to start?

[Chuck Short (zulcss)]

We'd like to figure out what's causing this bug for you, but we haven't heard back from you in a while. Could you please provide the requested information? Thanks!

[Launchpad Janitor (janitor)]

[Expired for mysql-dfsg-5.1 (Ubuntu) because there has been no activity for 60 days.]