MySQL Server 5.1 fails to start after install

Bug #917629 reported by Manson Thomas
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql-5.1 (Ubuntu)
Invalid
Medium
Unassigned

Bug Description

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)

Revision history for this message
Manson Thomas (dev-mansonthomas) wrote :
Dave Walker (davewalker)
Changed in mysql-5.1 (Ubuntu):
importance: Undecided → Medium
Revision history for this message
Bryan Quigley (bryanquigley) wrote :

Thank you for reporting this bug to Ubuntu. We are sorry that we do not always have the capacity to look at all reported bugs in a timely manner.

This bug is for a very old release and this looks like it's been fixed on a newer release.

Changed in mysql-5.1 (Ubuntu):
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.