MySQL Server 5.1 fails to start after install
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
ProcVersionSign
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=
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)
Changed in mysql-5.1 (Ubuntu): | |
importance: | Undecided → Medium |
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.