package mysql-server-5.0 5.0.51a-3ubuntu5 failed to install/upgrade: subprocess post-installation script returned error exit status 1

[CIS_Student87]

When I tried : "sudo apt-get install mysql-server" in the terminal, I got the following output back:

===
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0B of additional disk space will be used.
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5) ...
 * Stopping MySQL database server mysqld [ OK ]
Reloading AppArmor profiles : done.
 * Starting MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
 subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.0; however:
  Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

===

ProblemType: Package
Architecture: i386
Date: Wed Apr 2 15:30:13 2008
DistroRelease: Ubuntu 8.04
ErrorMessage: subprocess post-installation script returned error exit status 1
Package: mysql-server-5.0 5.0.51a-3ubuntu5
PackageArchitecture: i386
SourcePackage: mysql-dfsg-5.0
Title: package mysql-server-5.0 5.0.51a-3ubuntu5 failed to install/upgrade: subprocess post-installation script returned error exit status 1
Uname: Linux 2.6.24-12-generic i686

[Nicolas Valcarcel (nvalcarcel)]

Well, as i can see it is a problem starting mysql, which is run from the postint, so it can be an error with the config files, can you please restart mysql and check if it works?

[Mathias Gug (mathiaz)]

On Wed, Apr 02, 2008 at 01:35:56PM -0000, CIS_Student87 wrote:
> Setting up mysql-server-5.0 (5.0.51a-3ubuntu5) ...
> * Stopping MySQL database server mysqld [ OK ]
> Reloading AppArmor profiles : done.
> * Starting MySQL database server mysqld [fail]

You should be able to find more information about the failure in
/var/log/daemon.log.

Is your loopback interface set correctly ?

  status incomplete

--
Mathias Gug
Ubuntu Developer http://www.ubuntu.com

[DutchSherpa (riemer-thalen)]

This install reported an error in Gutsy and it does so in Hardy. Tried to reinstall, but to no avail.

[phi1ipp (phi1ipp)]

Full apt-get output below:

Preparing to replace mysql-server-5.0 5.0.51a-3ubuntu5 (using .../mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb) ...
 * Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: warning - old pre-removal script returned error exit status 1
dpkg - trying script from the new package instead ...
 * Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb (--unpack):
 subprocess new pre-removal script returned error exit status 1
 * Stopping MySQL database server mysqld [fail]
invoke-rc.d: initscript mysql, action "stop" failed.
 * Starting MySQL database server mysqld [ OK ]
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

[Mathias Gug (mathiaz)]

@samsara: look at bug 153868.

[Brazeiro (brazeiro63)]

The problem occours after a tried to copy a database InnoDB from other place to the new installation, that qhere working fine.
Something were wrong!!! System shutdown.

The following lines were wrote at the log file next time I tried to startup:
Aug 21 17:12:28 brazeiro-laptop mysqld[4887]: 080821 17:12:28 [Warning] Can't create test file /home/mysql/mysql/brazeiro-laptop.lower-test
Aug 21 17:12:28 brazeiro-laptop mysqld[4887]: 080821 17:12:28 [Warning] Can't create test file /home/mysql/mysql/brazeiro-laptop.lower-test
Aug 21 17:12:29 brazeiro-laptop mysqld[4887]: 080821 17:12:29 InnoDB: Operating system error number 13 in a file operation.
Aug 21 17:12:29 brazeiro-laptop mysqld[4887]: InnoDB: The error means mysqld does not have the access rights to
Aug 21 17:12:29 brazeiro-laptop mysqld[4887]: InnoDB: the directory.
Aug 21 17:12:29 brazeiro-laptop mysqld[4887]: InnoDB: File name ./ibdata1
Aug 21 17:12:29 brazeiro-laptop mysqld[4887]: InnoDB: File operation call: 'open'.
Aug 21 17:12:29 brazeiro-laptop mysqld[4887]: InnoDB: Cannot continue operation.
Aug 21 17:12:29 brazeiro-laptop mysqld_safe[4893]: ended

Since this mysql didn´t work at all.

I'd try to remove and reinstall it. The error reported occoured when I tried to reinstall.

[Mathias Gug (mathiaz)]

@Brazeiro: which version of ubuntu are you running ?

On hardy, mysql is protected by an apparmor profile that doesn't allow mysqld to read files in /home/mysql/mysql/. Check in /var/log/messages to see if there apparmor messages.

See https://wiki.ubuntu.com/DebuggingApparmor for more information about updating mysqld profile to allow access to /home/mysql/.

[Brazeiro (brazeiro63)]

Hi, Mathias,

Now I'm running Ubuntu 8.04. The problem occurred after I updated to
that version and when I was installing the MySQL-Server.
I think I have fixed the problem om my system, by setting manually the
privileges of the folders use by mysqld. It seems to be just an
workaround but, just worked.

Thanks by your attention,

Brazeiro

Mathias Gug wrote:
> @Brazeiro: which version of ubuntu are you running ?
>
> On hardy, mysql is protected by an apparmor profile that doesn't allow
> mysqld to read files in /home/mysql/mysql/. Check in /var/log/messages
> to see if there apparmor messages.
>
> See https://wiki.ubuntu.com/DebuggingApparmor for more information about
> updating mysqld profile to allow access to /home/mysql/.
>
> ** Changed in: mysql-dfsg-5.0 (Ubuntu)
> Status: New => Incomplete
>
>

[Sergio Barjola (sbarjola)]

I had the same problem after an update because the bind-address in my.cnf config file wasn't set correctly.

[Szentes Ferenc (szentesferenc)]

Hello Sergio,

I am not a guru in linux I want only to try at home to create a little local
net, with database. After this failure installed again the linux (like a
windows) and after it the install was succesfull.

Best regards

Szentes Ferenc

2008/10/6 Sergio Barjola <email address hidden>

> I had the same problem after an update because the bind-address in
> my.cnf config file wasn't set correctly.
>
> --
> package mysql-server-5.0 5.0.51a-3ubuntu5 failed to install/upgrade:
> subprocess post-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/210813
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in "mysql-dfsg-5.0" source package in Ubuntu: Incomplete
>
> Bug description:
> When I tried : "sudo apt-get install mysql-server" in the terminal, I got
> the following output back:
>
> ===
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> mysql-server is already the newest version.
> 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
> 2 not fully installed or removed.
> After this operation, 0B of additional disk space will be used.
> Setting up mysql-server-5.0 (5.0.51a-3ubuntu5) ...
> * Stopping MySQL database server mysqld
> [ OK ]
> Reloading AppArmor profiles : done.
> * Starting MySQL database server mysqld
> [fail]
> invoke-rc.d: initscript mysql, action "start" failed.
> dpkg: error processing mysql-server-5.0 (--configure):
> subprocess post-installation script returned error exit status 1
> dpkg: dependency problems prevent configuration of mysql-server:
> mysql-server depends on mysql-server-5.0; however:
> Package mysql-server-5.0 is not configured yet.
> dpkg: error processing mysql-server (--configure):
> dependency problems - leaving unconfigured
> Errors were encountered while processing:
> mysql-server-5.0
> mysql-server
> E: Sub-process /usr/bin/dpkg returned an error code (1)
>
> ===
>
> ProblemType: Package
> Architecture: i386
> Date: Wed Apr 2 15:30:13 2008
> DistroRelease: Ubuntu 8.04
> ErrorMessage: subprocess post-installation script returned error exit
> status 1
> Package: mysql-server-5.0 5.0.51a-3ubuntu5
> PackageArchitecture: i386
> SourcePackage: mysql-dfsg-5.0
> Title: package mysql-server-5.0 5.0.51a-3ubuntu5 failed to install/upgrade:
> subprocess post-installation script returned error exit status 1
> Uname: Linux 2.6.24-12-generic i686
>

[José Roberto (tickbrown)]

Configurando mysql-server-5.0 (5.0.67-0ubuntu6) ...
 * Stopping MySQL database server mysqld [ OK ]
ERROR: 1146 Table 'mysql.user' doesn't exist
081213 7:59:42 [ERROR] Aborting

081213 7:59:42 [Note] /usr/sbin/mysqld: Shutdown complete

Reloading AppArmor profiles : done.
 * /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: erro processando mysql-server-5.0 (--configure):
 sub-processo post-installation script retornou estado de saída de erro 1
dpkg: problemas de dependência impedem a configuração de mysql-server:
 mysql-server depende de mysql-server-5.0; porém:
  Pacote mysql-server-5.0 não está configurado ainda.
dpkg: erro processando mysql-server (--configure):
 problemas de dependência - deixando desconfigurado
Nenhum relatório do apport gravado porque a mensagem de erro indica é o seguimento de um erro de uma falha anterior.
                                    Erros foram encontrados durante o processamento de:
 mysql-server-5.0
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

[Mathias Gug (mathiaz)]

On Sat, Dec 13, 2008 at 10:03:59AM -0000, Tick BRown wrote:
> Configurando mysql-server-5.0 (5.0.67-0ubuntu6) ...
> * Stopping MySQL database server mysqld [ OK ]
> ERROR: 1146 Table 'mysql.user' doesn't exist
> 081213 7:59:42 [ERROR] Aborting
>
> 081213 7:59:42 [Note] /usr/sbin/mysqld: Shutdown complete
>
> Reloading AppArmor profiles : done.
> * /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full!

Could you check if there is some disk space available?

--
Mathias Gug
Ubuntu Developer http://www.ubuntu.com

[Mathias Gug (mathiaz)]

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Thanks again!

[indigene (indigene2007)]

Mathias - Yes, please. Thanks -Sid

On Tue, Sep 8, 2009 at 10:08 AM, Mathias Gug <email address hidden> wrote:

> We are closing this bug report because it lacks the information we need
> to investigate the problem, as described in the previous comments.
> Please reopen it if you can give us the missing information, and don't
> hesitate to submit bug reports in the future. To reopen the bug report
> you can click on the current status, under the Status column, and change
> the Status back to "New". Thanks again!
>
> ** Changed in: mysql-dfsg-5.0 (Ubuntu)
> Status: Incomplete => Invalid
>
> --
> package mysql-server-5.0 5.0.51a-3ubuntu5 failed to install/upgrade:
> subprocess post-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/210813
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.0” package in Ubuntu: Invalid
>
> Bug description:
> When I tried : "sudo apt-get install mysql-server" in the terminal, I got
> the following output back:
>
> ===
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> mysql-server is already the newest version.
> 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
> 2 not fully installed or removed.
> After this operation, 0B of additional disk space will be used.
> Setting up mysql-server-5.0 (5.0.51a-3ubuntu5) ...
> * Stopping MySQL database server mysqld
> [ OK ]
> Reloading AppArmor profiles : done.
> * Starting MySQL database server mysqld
> [fail]
> invoke-rc.d: initscript mysql, action "start" failed.
> dpkg: error processing mysql-server-5.0 (--configure):
> subprocess post-installation script returned error exit status 1
> dpkg: dependency problems prevent configuration of mysql-server:
> mysql-server depends on mysql-server-5.0; however:
> Package mysql-server-5.0 is not configured yet.
> dpkg: error processing mysql-server (--configure):
> dependency problems - leaving unconfigured
> Errors were encountered while processing:
> mysql-server-5.0
> mysql-server
> E: Sub-process /usr/bin/dpkg returned an error code (1)
>
> ===
>
> ProblemType: Package
> Architecture: i386
> Date: Wed Apr 2 15:30:13 2008
> DistroRelease: Ubuntu 8.04
> ErrorMessage: subprocess post-installation script returned error exit
> status 1
> Package: mysql-server-5.0 5.0.51a-3ubuntu5
> PackageArchitecture: i386
> SourcePackage: mysql-dfsg-5.0
> Title: package mysql-server-5.0 5.0.51a-3ubuntu5 failed to install/upgrade:
> subprocess post-installation script returned error exit status 1
> Uname: Linux 2.6.24-12-generic i686
>