Function 'innodb' already exists and other errors
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.6 (Ubuntu) |
Fix Released
|
Undecided
|
Lars Tangvald |
Bug Description
When running MySQL 5.6 I am getting the following errors in the log:
2015-06-24 05:24:20 893 [ERROR] Function 'innodb' already exists
2015-06-24 05:24:20 893 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
2015-06-24 05:24:20 893 [ERROR] Function 'federated' already exists
2015-06-24 05:24:20 893 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
2015-06-24 05:24:20 893 [ERROR] Function 'blackhole' already exists
2015-06-24 05:24:20 893 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
2015-06-24 05:24:20 893 [ERROR] Function 'archive' already exists
2015-06-24 05:24:20 893 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
The reason seems to be that postinit script adds those entries to the plugin table:
mysql> SELECT * FROM mysql.plugin;
+------
| name | dl |
+------
| innodb | ha_innodb.so |
| federated | ha_federated.so |
| blackhole | ha_blackhole.so |
| archive | ha_archive.so |
+------
But those files do not exist for MySQL 5.6. Search shows that they exist only for MairaDB.
mysql-server-5.6: 5.6.19-
Ubuntu 14.04.2 LTS
I would expect that there would be no errors when starting a clean installation of MySQL.
This was also reported here by another user: http://
Removing those rows from the plugin table makes the errors go away.
affects: | mysql-5.5 (Ubuntu) → mysql-5.6 (Ubuntu) |
Changed in mysql-5.6 (Ubuntu): | |
assignee: | nobody → Lars Tangvald (lars-tangvald) |
Changed in mysql-5.6 (Ubuntu): | |
status: | New → Triaged |
+1 Same issue here.
This might be ha_innodb.so and other files not exist in /usr/lib/ mysql/plugin/ , but mysql-server-5.5 contains these files.