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 -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs