[Bug 917629] [NEW] MySQL Server 5.1 fails to start after install

[Manson Thomas]

Public bug reported:

On a fresh an newly installed server, ubuntu 11.10 x64,

I install mysql server with the following command as root :

aptitue update
aptitude full-upgrade
... (update last available package)

aptitude install mysql-server-5.1

Install ask for root password, the complete.

MySQL starts, create the system database and fails due to a syntax error and then shutdown.
Next startup fails also as it says the table plugin already exists.

Regards,
Thomas


120117 13:56:50 [Note] Plugin 'FEDERATED' is disabled.
120117 13:56:50  InnoDB: Initializing buffer pool, size = 8.0M
120117 13:56:50  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
120117 13:56:50  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120117 13:56:50  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...
120117 13:56:50  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
120117 13:56:50  InnoDB: Started; log sequence number 0 0
120117 13:56:50  InnoDB: Starting shutdown...
120117 13:56:56  InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:56:56 [Note] Plugin 'FEDERATED' is disabled.
120117 13:56:56  InnoDB: Initializing buffer pool, size = 8.0M
120117 13:56:56  InnoDB: Completed initialization of buffer pool
120117 13:56:56  InnoDB: Started; log sequence number 0 44233
120117 13:56:56  InnoDB: Starting shutdown...
120117 13:57:01  InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:57:01 [Note] Plugin 'FEDERATED' is disabled.
120117 13:57:01  InnoDB: Initializing buffer pool, size = 8.0M
120117 13:57:01  InnoDB: Completed initialization of buffer pool
120117 13:57:01  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
120117 13:57:01 [ERROR] Aborting

120117 13:57:01  InnoDB: Starting shutdown...
120117 13:57:06  InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:57:06 [Note] /usr/sbin/mysqld: Shutdown complete

120117 13:57:06 [Note] Plugin 'FEDERATED' is disabled.
120117 13:57:06  InnoDB: Initializing buffer pool, size = 8.0M
120117 13:57:06  InnoDB: Completed initialization of buffer pool
120117 13:57:06  InnoDB: Started; log sequence number 0 44233
120117 13:57:06  InnoDB: Starting shutdown...
120117 13:57:11  InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:57:11 [Note] Plugin 'FEDERATED' is disabled.
120117 13:57:11  InnoDB: Initializing buffer pool, size = 8.0M
120117 13:57:11  InnoDB: Completed initialization of buffer pool
120117 13:57:11  InnoDB: Started; log sequence number 0 44233
ERROR: 1050  Table 'plugin' already exists
120117 13:57:11 [ERROR] Aborting

120117 13:57:11  InnoDB: Starting shutdown...
120117 13:57:17  InnoDB: Shutdown completed; log sequence number 0 44233
120117 13:57:17 [Note] /usr/sbin/mysqld: Shutdown complete

120117 13:57:17 [Note] Plugin 'FEDERATED' is disabled.
120117 13:57:17  InnoDB: Initializing buffer pool, size = 8.0M
120117 13:57:17  InnoDB: Completed initialization of buffer pool
120117 13:57:17  InnoDB: Started; log sequence number 0 44233
120117 13:57:17 [Note] Event Scheduler: Loaded 0 events

ProblemType: Bug
DistroRelease: Ubuntu 11.10
Package: mysql-server-5.1 5.1.58-1ubuntu1
ProcVersionSignature: Ubuntu 3.0.0-12.20-server 3.0.4
Uname: Linux 3.0.0-12-server x86_64
ApportVersion: 1.23-0ubuntu4
Architecture: amd64
Date: Tue Jan 17 14:01:12 2012
ProcEnviron:
 LANGUAGE=en_US:en:en_GB:en
 PATH=(custom, no user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: mysql-5.1
UpgradeStatus: Upgraded to oneiric on 2011-11-07 (70 days ago)

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


** Tags: amd64 apport-bug oneiric

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/917629

Title:
  MySQL Server 5.1 fails to start after install

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/917629/+subscriptions