Bug #365872 “Failed to start MySQL database server mysqld on ins...” : Bugs : mysql-dfsg-5.0 package : Ubuntu

Revision history for this message

Nigel Banks (nigelbanks35-deactivatedaccount) wrote on 2009-04-24:

#1

Dependencies.txt Edit (1.2 KiB, text/plain; charset="utf-8")
DpkgTerminalLog.txt Edit (393.0 KiB, text/plain; charset="utf-8")

Revision history for this message

Andreas Olsson (andol) wrote on 2009-04-24:

#2

Are there any entries in /var/log/daemon.log regarding mysql?

Changed in mysql-dfsg-5.0 (Ubuntu):
status:	New → Incomplete

Revision history for this message

Nigel Banks (nigelbanks35-deactivatedaccount) wrote on 2009-04-24: Re: [Bug 365872] Re: Failed to start MySQL database server mysqld on install

#3

Download full text (12.7 KiB)

Yes,
$ grep mysql /var/log/daemon.log

Apr 24 01:51:59 HAL mysqld_safe[20541]: PLEASE REMEMBER TO SET A PASSWORD
FOR THE MySQL root USER !
Apr 24 01:51:59 HAL mysqld_safe[20541]: To do so, start the server, then
issue the following commands:
Apr 24 01:51:59 HAL mysqld_safe[20541]: /usr/bin/mysqladmin -u root password
'new-password'
Apr 24 01:51:59 HAL mysqld_safe[20541]: /usr/bin/mysqladmin -u root -h HAL
password 'new-password'
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: Alternatively you can run:
Apr 24 01:51:59 HAL mysqld_safe[20541]: /usr/bin/mysql_secure_installation
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: which will also give you the option
of removing the test
Apr 24 01:51:59 HAL mysqld_safe[20541]: databases and anonymous user created
by default. This is
Apr 24 01:51:59 HAL mysqld_safe[20541]: strongly recommended for production
servers.
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: See the manual for more
instructions.
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: Please report any problems with the
/usr/bin/mysqlbug script!
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: The latest information about MySQL
is available on the web at
Apr 24 01:51:59 HAL mysqld_safe[20541]: http://www.mysql.com
Apr 24 01:51:59 HAL mysqld_safe[20541]: Support MySQL by buying
support/licenses at http://shop.mysql.com
Apr 24 01:52:11 HAL mysqld_safe[20660]: ERROR: 1046 No database selected
Apr 24 01:52:11 HAL mysqld_safe[20660]: 090424 1:52:11 [ERROR] Aborting
Apr 24 01:52:11 HAL mysqld_safe[20660]:
Apr 24 01:52:11 HAL mysqld_safe[20660]: 090424 1:52:11 [Note]
/usr/sbin/mysqld: Shutdown complete
Apr 24 01:52:11 HAL mysqld_safe[20660]:
Apr 24 01:52:19 HAL mysqld_safe[20838]: started
Apr 24 01:52:19 HAL mysqld[20841]: InnoDB: The first specified data file
./ibdata1 did not exist:
Apr 24 01:52:19 HAL mysqld[20841]: InnoDB: a new database to be created!
Apr 24 01:52:19 HAL mysqld[20841]: 090424 1:52:19 InnoDB: Setting file
./ibdata1 size to 10 MB
Apr 24 01:52:19 HAL mysqld[20841]: InnoDB: Database physically writes the
file full: wait...
Apr 24 01:52:24 HAL mysqld[20841]: 090424 1:52:24 InnoDB: Log file
./ib_logfile0 did not exist: new to be created
Apr 24 01:52:24 HAL mysqld[20841]: InnoDB: Setting log file ./ib_logfile0
size to 5 MB
Apr 24 01:52:24 HAL mysqld[20841]: InnoDB: Database physically writes the
file full: wait...
Apr 24 01:52:29 HAL mysqld[20841]: 090424 1:52:29 InnoDB: Log file
./ib_logfile1 did not exist: new to be created
Apr 24 01:52:29 HAL mysqld[20841]: InnoDB: Setting log file ./ib_logfile1
size to 5 MB
Apr 24 01:52:29 HAL mysqld[20841]: InnoDB: Database physically writes the
file full: wait...
Apr 24 01:52:33 HAL /etc/init.d/mysql[21014]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Apr 24 01:52:36 HAL /etc/init.d/mysql[21014]: ^G/usr/bin/mysqladmin: connect
to server at 'localhost' failed
Apr 24 01:52:36 HAL /etc/init.d/mysql[21014]: error: 'Can't connect to local
MySQL server through socket '/var/run/...

Yes,
$ grep mysql /var/log/daemon.log

Apr 24 01:51:59 HAL mysqld_safe[20541]: PLEASE REMEMBER TO SET A PASSWORD
FOR THE MySQL root USER !
Apr 24 01:51:59 HAL mysqld_safe[20541]: To do so, start the server, then
issue the following commands:
Apr 24 01:51:59 HAL mysqld_safe[20541]: /usr/bin/mysqladmin -u root password
'new-password'
Apr 24 01:51:59 HAL mysqld_safe[20541]: /usr/bin/mysqladmin -u root -h HAL
password 'new-password'
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: Alternatively you can run:
Apr 24 01:51:59 HAL mysqld_safe[20541]: /usr/bin/mysql_secure_installation
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: which will also give you the option
of removing the test
Apr 24 01:51:59 HAL mysqld_safe[20541]: databases and anonymous user created
by default.  This is
Apr 24 01:51:59 HAL mysqld_safe[20541]: strongly recommended for production
servers.
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: See the manual for more
instructions.
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: Please report any problems with the
/usr/bin/mysqlbug script!
Apr 24 01:51:59 HAL mysqld_safe[20541]:
Apr 24 01:51:59 HAL mysqld_safe[20541]: The latest information about MySQL
is available on the web at
Apr 24 01:51:59 HAL mysqld_safe[20541]: http://www.mysql.com
Apr 24 01:51:59 HAL mysqld_safe[20541]: Support MySQL by buying
support/licenses at http://shop.mysql.com
Apr 24 01:52:11 HAL mysqld_safe[20660]: ERROR: 1046  No database selected
Apr 24 01:52:11 HAL mysqld_safe[20660]: 090424  1:52:11 [ERROR] Aborting
Apr 24 01:52:11 HAL mysqld_safe[20660]:
Apr 24 01:52:11 HAL mysqld_safe[20660]: 090424  1:52:11 [Note]
/usr/sbin/mysqld: Shutdown complete
Apr 24 01:52:11 HAL mysqld_safe[20660]:
Apr 24 01:52:19 HAL mysqld_safe[20838]: started
Apr 24 01:52:19 HAL mysqld[20841]: InnoDB: The first specified data file
./ibdata1 did not exist:
Apr 24 01:52:19 HAL mysqld[20841]: InnoDB: a new database to be created!
Apr 24 01:52:19 HAL mysqld[20841]: 090424  1:52:19  InnoDB: Setting file
./ibdata1 size to 10 MB
Apr 24 01:52:19 HAL mysqld[20841]: InnoDB: Database physically writes the
file full: wait...
Apr 24 01:52:24 HAL mysqld[20841]: 090424  1:52:24  InnoDB: Log file
./ib_logfile0 did not exist: new to be created
Apr 24 01:52:24 HAL mysqld[20841]: InnoDB: Setting log file ./ib_logfile0
size to 5 MB
Apr 24 01:52:24 HAL mysqld[20841]: InnoDB: Database physically writes the
file full: wait...
Apr 24 01:52:29 HAL mysqld[20841]: 090424  1:52:29  InnoDB: Log file
./ib_logfile1 did not exist: new to be created
Apr 24 01:52:29 HAL mysqld[20841]: InnoDB: Setting log file ./ib_logfile1
size to 5 MB
Apr 24 01:52:29 HAL mysqld[20841]: InnoDB: Database physically writes the
file full: wait...
Apr 24 01:52:33 HAL /etc/init.d/mysql[21014]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Apr 24 01:52:36 HAL /etc/init.d/mysql[21014]: ^G/usr/bin/mysqladmin: connect
to server at 'localhost' failed
Apr 24 01:52:36 HAL /etc/init.d/mysql[21014]: error: 'Can't connect to local
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Apr 24 01:52:36 HAL /etc/init.d/mysql[21014]: Check that mysqld is running
and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Apr 24 01:52:36 HAL /etc/init.d/mysql[21014]:
Apr 24 01:53:03 HAL mysqld[20841]: InnoDB: Doublewrite buffer not found:
creating new
Apr 24 01:53:11 HAL mysqld[20841]: InnoDB: Doublewrite buffer created
Apr 24 01:53:11 HAL mysqld[20841]: InnoDB: Creating foreign key constraint
system tables
Apr 24 01:53:13 HAL mysqld[20841]: InnoDB: Foreign key constraint system
tables created
Apr 24 01:53:13 HAL mysqld[20841]: 090424  1:53:13  InnoDB: Started; log
sequence number 0 0
Apr 24 01:53:14 HAL mysqld[20841]: 090424  1:53:14 [Note] /usr/sbin/mysqld:
ready for connections.
Apr 24 01:53:14 HAL mysqld[20841]: Version: '5.0.75-0ubuntu10'  socket:
'/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: Status information:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: Current dir: /var/lib/mysql/
Apr 24 02:26:34 HAL mysqld[20841]: Running threads: 0  Stack size: 131072
Apr 24 02:26:34 HAL mysqld[20841]: Current locks:
Apr 24 02:26:34 HAL mysqld[20841]: lock: 0x919fa10:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: lock: 0x919a560:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: lock: 0x9195c58:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: lock: 0x91890c8:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: lock: 0x9185878:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: lock: 0x91808e8:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: Key caches:
Apr 24 02:26:34 HAL mysqld[20841]: default
Apr 24 02:26:34 HAL mysqld[20841]: Buffer_size:      16777216
Apr 24 02:26:34 HAL mysqld[20841]: Block_size:           1024
Apr 24 02:26:34 HAL mysqld[20841]: Division_limit:        100
Apr 24 02:26:34 HAL mysqld[20841]: Age_limit:             300
Apr 24 02:26:34 HAL mysqld[20841]: blocks used:             0
Apr 24 02:26:34 HAL mysqld[20841]: not flushed:             0
Apr 24 02:26:34 HAL mysqld[20841]: w_requests:              0
Apr 24 02:26:34 HAL mysqld[20841]: writes:                  0
Apr 24 02:26:34 HAL mysqld[20841]: r_requests:              0
Apr 24 02:26:34 HAL mysqld[20841]: reads:                   0
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: handler status:
Apr 24 02:26:34 HAL mysqld[20841]: read_key:            0
Apr 24 02:26:34 HAL mysqld[20841]: read_next:           0
Apr 24 02:26:34 HAL mysqld[20841]: read_rnd             0
Apr 24 02:26:34 HAL mysqld[20841]: read_first:          3
Apr 24 02:26:34 HAL mysqld[20841]: write:               0
Apr 24 02:26:34 HAL mysqld[20841]: delete               0
Apr 24 02:26:34 HAL mysqld[20841]: update:              0
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: Table status:
Apr 24 02:26:34 HAL mysqld[20841]: Opened tables:         12
Apr 24 02:26:34 HAL mysqld[20841]: Open tables:            6
Apr 24 02:26:34 HAL mysqld[20841]: Open files:            12
Apr 24 02:26:34 HAL mysqld[20841]: Open streams:           0
Apr 24 02:26:34 HAL mysqld[20841]:
Apr 24 02:26:34 HAL mysqld[20841]: Alarm status:
Apr 24 02:26:34 HAL mysqld[20841]: Active alarms:   0
Apr 24 02:26:34 HAL mysqld[20841]: Max used alarms: 0
Apr 24 02:26:34 HAL mysqld[20841]: Next alarm time: 0
Apr 24 02:26:36 HAL mysqld[20841]: 090424  2:26:36 [Note] /usr/sbin/mysqld:
Normal shutdown
Apr 24 02:26:36 HAL mysqld[20841]:
Apr 24 02:26:36 HAL mysqld[20841]: 090424  2:26:36  InnoDB: Starting
shutdown...
Apr 24 02:26:38 HAL mysqld[20841]: 090424  2:26:38  InnoDB: Shutdown
completed; log sequence number 0 43655
Apr 24 02:26:38 HAL mysqld[20841]: 090424  2:26:38 [Note] /usr/sbin/mysqld:
Shutdown complete
Apr 24 02:26:38 HAL mysqld[20841]:
Apr 24 02:26:38 HAL mysqld[20841]:
Apr 24 02:26:38 HAL mysqld[20841]: Memory status:
Apr 24 02:26:38 HAL mysqld[20841]: Non-mmapped space allocated from system:
4399104
Apr 24 02:26:38 HAL mysqld[20841]: Number of free chunks:^I^I^I 10
Apr 24 02:26:38 HAL mysqld[20841]: Number of fastbin blocks:^I^I 0
Apr 24 02:26:38 HAL mysqld[20841]: Number of mmapped regions:^I^I 11
Apr 24 02:26:38 HAL mysqld[20841]: Space in mmapped regions:^I^I 47280128
Apr 24 02:26:38 HAL mysqld[20841]: Maximum total allocated space:^I^I 0
Apr 24 02:26:38 HAL mysqld[20841]: Space available in freed fastbin blocks:
0
Apr 24 02:26:38 HAL mysqld[20841]: Total allocated space:^I^I^I 4252304
Apr 24 02:26:38 HAL mysqld[20841]: Total free space:^I^I^I 146800
Apr 24 02:26:38 HAL mysqld[20841]: Top-most, releasable space:^I^I 131216
Apr 24 02:26:38 HAL mysqld[20841]: Estimated memory (with thread stack):
51679232
Apr 24 02:26:38 HAL mysqld[20841]:
Apr 24 02:26:38 HAL mysqld_safe[23235]: ended
Apr 24 02:26:40 HAL mysqld_safe[23262]: PLEASE REMEMBER TO SET A PASSWORD
FOR THE MySQL root USER !
Apr 24 02:26:40 HAL mysqld_safe[23262]: To do so, start the server, then
issue the following commands:
Apr 24 02:26:40 HAL mysqld_safe[23262]: /usr/bin/mysqladmin -u root password
'new-password'
Apr 24 02:26:40 HAL mysqld_safe[23262]: /usr/bin/mysqladmin -u root -h HAL
password 'new-password'
Apr 24 02:26:40 HAL mysqld_safe[23262]:
Apr 24 02:26:40 HAL mysqld_safe[23262]: Alternatively you can run:
Apr 24 02:26:40 HAL mysqld_safe[23262]: /usr/bin/mysql_secure_installation
Apr 24 02:26:40 HAL mysqld_safe[23262]:
Apr 24 02:26:40 HAL mysqld_safe[23262]: which will also give you the option
of removing the test
Apr 24 02:26:40 HAL mysqld_safe[23262]: databases and anonymous user created
by default.  This is
Apr 24 02:26:40 HAL mysqld_safe[23262]: strongly recommended for production
servers.
Apr 24 02:26:40 HAL mysqld_safe[23262]:
Apr 24 02:26:40 HAL mysqld_safe[23262]: See the manual for more
instructions.
Apr 24 02:26:40 HAL mysqld_safe[23262]:
Apr 24 02:26:40 HAL mysqld_safe[23262]: Please report any problems with the
/usr/bin/mysqlbug script!
Apr 24 02:26:40 HAL mysqld_safe[23262]:
Apr 24 02:26:40 HAL mysqld_safe[23262]: The latest information about MySQL
is available on the web at
Apr 24 02:26:40 HAL mysqld_safe[23262]: http://www.mysql.com
Apr 24 02:26:40 HAL mysqld_safe[23262]: Support MySQL by buying
support/licenses at http://shop.mysql.com
Apr 24 02:26:41 HAL mysqld_safe[23334]: ERROR: 1046  No database selected
Apr 24 02:26:41 HAL mysqld_safe[23334]: 090424  2:26:41 [ERROR] Aborting
Apr 24 02:26:41 HAL mysqld_safe[23334]:
Apr 24 02:26:41 HAL mysqld_safe[23334]: 090424  2:26:41 [Note]
/usr/sbin/mysqld: Shutdown complete
Apr 24 02:26:41 HAL mysqld_safe[23334]:
Apr 24 02:26:43 HAL mysqld_safe[23510]: started
Apr 24 02:26:43 HAL mysqld[23513]: 090424  2:26:43  InnoDB: Started; log
sequence number 0 43655
Apr 24 02:26:43 HAL mysqld[23513]: 090424  2:26:43 [Note] /usr/sbin/mysqld:
ready for connections.
Apr 24 02:26:43 HAL mysqld[23513]: Version: '5.0.75-0ubuntu10'  socket:
'/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Apr 24 02:26:44 HAL /etc/mysql/debian-start[23552]: Upgrading MySQL tables
if necessary.
Apr 24 02:26:45 HAL mysqld_safe[23578]: Number of processes running now: 1
Apr 24 02:26:45 HAL mysqld_safe[23586]: mysqld process hanging, pid 23512 -
killed
Apr 24 02:26:45 HAL mysqld_safe[23589]: restarted
Apr 24 02:26:45 HAL mysqld[23592]: 090424  2:26:45  InnoDB: Started; log
sequence number 0 43655
Apr 24 02:26:45 HAL mysqld[23592]: 090424  2:26:45 [Note] /usr/sbin/mysqld:
ready for connections.
Apr 24 02:26:45 HAL mysqld[23592]: Version: '5.0.75-0ubuntu10'  socket:
'/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

On Fri, Apr 24, 2009 at 2:51 AM, Andreas Olsson <andreas@arrakis.se> wrote:

> Are there any entries in /var/log/daemon.log regarding mysql?
>
> ** Changed in: mysql-dfsg-5.0 (Ubuntu)
>       Status: New => Incomplete
>
> --
> Failed to start MySQL database server mysqld on install
> https://bugs.launchpad.net/bugs/365872
> 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:
> Binary package hint: mysql-server-5.0
>
> Occured while using Synaptic Package Manager on Ubuntu 9.04 i386 machine to
> install mysql server and client.
>
> apt-cache policy mysql-server-5.0
> mysql-server-5.0:
>  Installed: 5.1.30really5.0.75-0ubuntu10
>  Candidate: 5.1.30really5.0.75-0ubuntu10
>  Version table:
>  *** 5.1.30really5.0.75-0ubuntu10 0
>        500 http://ca.archive.ubuntu.com jaunty/main Packages
>        100 /var/lib/dpkg/status
>
>
> errors below
>
> ---------------------------------------------------------
>
> Setting up mysql-server-5.0
>
> *Stopping mysql database server mysqld
> ...done
> *Reloading AppArmor profiles
> ...done
> *Starting MySQL database server mysqld
> ...fail!
>
> invoke-rc.d initscript mysql, action "start" failed.
> dpkg: error processing my sql-server-5.0 (--configure)
> subprocess post-installation script killed by signal (interrupt)
>
> E: mysql-server-5.0: subprocess post-installation script killed by signal
> (Interrupt)
> E: mysql-server: dependency problems - leaving unconfigured
>
> ProblemType: Package
> Architecture: i386
> DistroRelease: Ubuntu 9.04
> ErrorMessage: subprocess post-installation script killed by signal
> (Interrupt)
> MediaBuild: Ubuntu 9.04 "Jaunty Jackalope" - Release i386 (20090420.1)
> Package: mysql-server-5.0 5.1.30really5.0.75-0ubuntu10
> SourcePackage: mysql-dfsg-5.0
> Title: package mysql-server-5.0 5.1.30really5.0.75-0ubuntu10 failed to
> install/upgrade: subprocess post-installation script killed by signal
> (Interrupt)
> Uname: Linux 2.6.28-11-generic i686
>

Revision history for this message

Andreas Olsson (andol) wrote on 2009-04-26:

#4

I'm wondering if this might be a duplicate of bug #251160. While the versions differs, the symptoms does look a lot alike...

ignasi (ignasigimeno) on 2009-05-05

tags:	added: amd64
description:	updated

Revision history for this message

Vish (vish) wrote on 2010-06-29:

#5

Thank you for taking the time to report this bug and helping to make Ubuntu better. You reported this bug a while ago and there hasn't been any activity in it recently. We were wondering if this is still an issue for you. Can you try with the latest Ubuntu release? Thanks in advance.

Revision history for this message

Launchpad Janitor (janitor) wrote on 2010-12-09:

#6

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

Changed in mysql-dfsg-5.0 (Ubuntu):
status:	Incomplete → Expired

Ubuntu
mysql-dfsg-5.0 package

Failed to start MySQL database server mysqld on install

Bug Description

Other bug subscribers

Bug attachments

Remote bug watches

Ubuntumysql-dfsg-5.0 package

Failed to start MySQL database server mysqld on install

Bug Description

Other bug subscribers

Bug attachments

Remote bug watches

Ubuntu
mysql-dfsg-5.0 package