[Bug 598476] [NEW] MySQL server fails to load on boot

[Scott Evans]

Public bug reported:

The MySQL server fails to load from upstart job thus there is no service
running after boot

Starting Nmap 5.00 ( http://nmap.org ) at 2010-06-25 22:14 EST
Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1.
Interesting ports on localhost (127.0.0.1):
Not shown: 994 closed ports
PORT     STATE SERVICE
21/tcp   open  ftp
22/tcp   open  ssh
80/tcp   open  http
631/tcp  open  ipp
9418/tcp open  unknown

But after manually starting service with "sudo service mysql start" it
will start without error.

There is no error being logged as to why the service fails to start...

100625 21:55:07 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100625 21:55:07  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100625 21:55:07  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100625 21:55:07  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100625 21:55:08  InnoDB: Started; log sequence number 0 0
100625 21:55:08  InnoDB: Starting shutdown...
100625 21:55:13  InnoDB: Shutdown completed; log sequence number 0 44233
100625 21:55:13 [Note] Plugin 'FEDERATED' is disabled.
100625 21:55:13  InnoDB: Started; log sequence number 0 44233
100625 21:55:13  InnoDB: Starting shutdown...
100625 21:55:18  InnoDB: Shutdown completed; log sequence number 0 44233
100625 21:55:18 [Note] Plugin 'FEDERATED' is disabled.
100625 21:55:18  InnoDB: Started; log sequence number 0 44233
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
100625 21:55:18 [ERROR] Aborting

100625 21:55:18  InnoDB: Starting shutdown...
100625 21:55:24  InnoDB: Shutdown completed; log sequence number 0 44233
100625 21:55:24 [Note] /usr/sbin/mysqld: Shutdown complete

100625 21:55:24 [Note] Plugin 'FEDERATED' is disabled.
100625 21:55:24  InnoDB: Started; log sequence number 0 44233
100625 21:55:24  InnoDB: Starting shutdown...
100625 21:55:29  InnoDB: Shutdown completed; log sequence number 0 44233
100625 21:55:29 [Note] Plugin 'FEDERATED' is disabled.
100625 21:55:29  InnoDB: Started; log sequence number 0 44233
ERROR: 1050  Table 'plugin' already exists
100625 21:55:29 [ERROR] Aborting

100625 21:55:29  InnoDB: Starting shutdown...
100625 21:55:35  InnoDB: Shutdown completed; log sequence number 0 44233
100625 21:55:35 [Note] /usr/sbin/mysqld: Shutdown complete

100625 21:55:35 [Note] Plugin 'FEDERATED' is disabled.
100625 21:55:35  InnoDB: Started; log sequence number 0 44233
100625 21:55:35 [Note] Event Scheduler: Loaded 0 events
100625 21:55:35 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.48-1ubuntu1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
100625 21:57:20 [Note] /usr/sbin/mysqld: Normal shutdown

100625 21:57:20 [Note] Event Scheduler: Purging the queue. 0 events
100625 21:57:20  InnoDB: Starting shutdown...
100625 21:57:21  InnoDB: Shutdown completed; log sequence number 0 44233
100625 21:57:21 [Note] /usr/sbin/mysqld: Shutdown complete

100625 22:02:51 [Note] Plugin 'FEDERATED' is disabled.
100625 22:02:51  InnoDB: Started; log sequence number 0 44233
100625 22:02:51 [Note] Event Scheduler: Loaded 0 events
100625 22:02:51 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.48-1ubuntu1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)


Please advise on how to provide further info...

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: mysql-server 5.1.48-1ubuntu1
ProcVersionSignature: Ubuntu 2.6.35-5.6-generic 2.6.35-rc3
Uname: Linux 2.6.35-5-generic x86_64
Architecture: amd64
Date: Fri Jun 25 22:12:19 2010
InstallationMedia: Kubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100427)
PackageArchitecture: all
ProcEnviron:
 SHELL=/bin/bash
 LANG=en_AU.utf8
SourcePackage: mysql-5.1

** Affects: mysql-5.1 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug maverick

-- 
MySQL server fails to load on boot
https://bugs.launchpad.net/bugs/598476
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in ubuntu.