[Bug 365872] Re: Failed to start MySQL database server mysqld on install

Nigel Banks nigelbanks35 at gmail.com
Fri Apr 24 13:51:48 BST 2009 

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 at 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
>

-- 
Failed to start MySQL database server mysqld on install
https://bugs.launchpad.net/bugs/365872
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.

More information about the Ubuntu-server-bugs mailing list