percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00539
[Bug 365101] Re: debian vs ha_innodb.so
** Description changed:
Hello
in newest debian build contains a "little" error. When i try to use innodb, i receive error message : Warning | 1286 | Unknown table engine 'InnoDB'
in my error log, contains these lines:
- 090422 13:09:19 [ERROR] Plugin 'InnoDB' init function returned error.
- 090422 13:09:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
+
+ InnoDB: The InnoDB memory heap is disabled
+ InnoDB: Mutexes and rw_locks use GCC atomic builtins.
+ InnoDB: Error: log file /var/lib/mysql/ib_logfile1 is of different size 0 0 bytes
+ InnoDB: than specified in the .cnf file 0 536870912 bytes!
+ 090424 9:30:50 [ERROR] Plugin 'InnoDB' init function returned error.
+ 090424 9:30:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
+
+ mysql> show engines;
+ +------------+---------+----------------------------------------------------------------+--------------+------+------------+
+ | Engine | Support | Comment | Transactions | XA | Savepoints |
+ +------------+---------+----------------------------------------------------------------+--------------+------+------------+
+ | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+ | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
+ | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
+ | CSV | YES | CSV storage engine | NO | NO | NO |
+ | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+ | FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
+ | ARCHIVE | YES | Archive storage engine | NO | NO | NO |
+ +------------+---------+----------------------------------------------------------------+--------------+------+------------+
+ 7 rows in set (0.00 sec)
+
+ mysql> create database hehe; use hehe;CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;
+ Query OK, 1 row affected (0.00 sec)
+
+ Database changed
+ Query OK, 0 rows affected, 2 warnings (0.01 sec)
+
+ mysql> show warnings;
+ +---------+------+---------------------------------------------------+
+ | Level | Code | Message |
+ +---------+------+---------------------------------------------------+
+ | Warning | 1286 | Unknown table engine 'InnoDB' |
+ | Warning | 1266 | Using storage engine MyISAM for table 'customers' |
+ +---------+------+---------------------------------------------------+
+ 2 rows in set (0.00 sec)
+
+ mysql>
debian@2.6.26-2-amd64
dw2:/tmp# dpkg --list |grep mysql
ii libdbd-mysql-perl 4.007-1 A Perl5 database interface to the MySQL data
ii libmysqlclient-dev 5.1.33-xtradb4 MySQL database development files
ii libmysqlclient15-dev 5.1.33-xtradb4 MySQL database development files - empty tra
ii libmysqlclient15off 5.0.51a-24 MySQL database client library
ii libmysqlclient16 5.1.33-xtradb4 MySQL database client library
ii mysql-client-5.1 5.1.33-xtradb4 MySQL database client binaries
ii mysql-common 5.1.33-xtradb4 MySQL database common files (e.g. /etc/mysql
rc mysql-server-5.0 5.0.51a-24 MySQL database server binaries
ii mysql-server-5.1 5.1.33-xtradb4 MySQL database server binaries
ii php5-mysql 5.2.6.dfsg.1-1+lenny2 MySQL module for php5
- dw2:/tmp#
+
+ dw2:#ls /usr/lib/mysql/plugin/
+ ha_innodb.so libdaemon_example.a libdaemon_example.so.0.0.0 mypluglib.so.0
+ ha_innodb.so.0 libdaemon_example.la mypluglib.a mypluglib.so.0.0.0
+ ha_innodb.so.0.0.0 libdaemon_example.so mypluglib.la
+ install_innodb_plugins.sql libdaemon_example.so.0 mypluglib.so
** Description changed:
Hello
in newest debian build contains a "little" error. When i try to use innodb, i receive error message : Warning | 1286 | Unknown table engine 'InnoDB'
in my error log, contains these lines:
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins.
InnoDB: Error: log file /var/lib/mysql/ib_logfile1 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 536870912 bytes!
090424 9:30:50 [ERROR] Plugin 'InnoDB' init function returned error.
090424 9:30:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
7 rows in set (0.00 sec)
mysql> create database hehe; use hehe;CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;
Query OK, 1 row affected (0.00 sec)
Database changed
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> show warnings;
+---------+------+---------------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------------+
| Warning | 1286 | Unknown table engine 'InnoDB' |
| Warning | 1266 | Using storage engine MyISAM for table 'customers' |
+---------+------+---------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
debian@2.6.26-2-amd64
dw2:/tmp# dpkg --list |grep mysql
ii libdbd-mysql-perl 4.007-1 A Perl5 database interface to the MySQL data
ii libmysqlclient-dev 5.1.33-xtradb4 MySQL database development files
ii libmysqlclient15-dev 5.1.33-xtradb4 MySQL database development files - empty tra
ii libmysqlclient15off 5.0.51a-24 MySQL database client library
ii libmysqlclient16 5.1.33-xtradb4 MySQL database client library
ii mysql-client-5.1 5.1.33-xtradb4 MySQL database client binaries
ii mysql-common 5.1.33-xtradb4 MySQL database common files (e.g. /etc/mysql
rc mysql-server-5.0 5.0.51a-24 MySQL database server binaries
ii mysql-server-5.1 5.1.33-xtradb4 MySQL database server binaries
ii php5-mysql 5.2.6.dfsg.1-1+lenny2 MySQL module for php5
dw2:#ls /usr/lib/mysql/plugin/
ha_innodb.so libdaemon_example.a libdaemon_example.so.0.0.0 mypluglib.so.0
ha_innodb.so.0 libdaemon_example.la mypluglib.a mypluglib.so.0.0.0
ha_innodb.so.0.0.0 libdaemon_example.so mypluglib.la
install_innodb_plugins.sql libdaemon_example.so.0 mypluglib.so
+
+ mysql> show plugins;+--------------------------------+----------+--------------------+---------+---------+
+ | Name | Status | Type | Library | License |
+ +--------------------------------+----------+--------------------+---------+---------+
+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
+ | partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
+ | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
+ | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
+ | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
+ | FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |
+ | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
+ | INNODB_RSEG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_BUFFER_POOL_PAGES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_BUFFER_POOL_PAGES_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_BUFFER_POOL_PAGES_BLOB | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | XTRADB_ENHANCEMENTS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
+ | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
+ | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
+ +--------------------------------+----------+--------------------+---------+---------+
+ 21 rows in set (0.00 sec)
+
+ mysql>
--
debian vs ha_innodb.so
https://bugs.launchpad.net/bugs/365101
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona-XtraDB.
Status in Percona XtraDB Storage Engine for MySQL: New
Status in Ubuntu: New
Status in Debian GNU/Linux: New
Bug description:
Hello
in newest debian build contains a "little" error. When i try to use innodb, i receive error message : Warning | 1286 | Unknown table engine 'InnoDB'
in my error log, contains these lines:
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins.
InnoDB: Error: log file /var/lib/mysql/ib_logfile1 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 536870912 bytes!
090424 9:30:50 [ERROR] Plugin 'InnoDB' init function returned error.
090424 9:30:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
7 rows in set (0.00 sec)
mysql> create database hehe; use hehe;CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;
Query OK, 1 row affected (0.00 sec)
Database changed
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> show warnings;
+---------+------+---------------------------------------------------+
| Level | Code | Message |
+---------+------+---------------------------------------------------+
| Warning | 1286 | Unknown table engine 'InnoDB' |
| Warning | 1266 | Using storage engine MyISAM for table 'customers' |
+---------+------+---------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
debian@2.6.26-2-amd64
dw2:/tmp# dpkg --list |grep mysql
ii libdbd-mysql-perl 4.007-1 A Perl5 database interface to the MySQL data
ii libmysqlclient-dev 5.1.33-xtradb4 MySQL database development files
ii libmysqlclient15-dev 5.1.33-xtradb4 MySQL database development files - empty tra
ii libmysqlclient15off 5.0.51a-24 MySQL database client library
ii libmysqlclient16 5.1.33-xtradb4 MySQL database client library
ii mysql-client-5.1 5.1.33-xtradb4 MySQL database client binaries
ii mysql-common 5.1.33-xtradb4 MySQL database common files (e.g. /etc/mysql
rc mysql-server-5.0 5.0.51a-24 MySQL database server binaries
ii mysql-server-5.1 5.1.33-xtradb4 MySQL database server binaries
ii php5-mysql 5.2.6.dfsg.1-1+lenny2 MySQL module for php5
dw2:#ls /usr/lib/mysql/plugin/
ha_innodb.so libdaemon_example.a libdaemon_example.so.0.0.0 mypluglib.so.0
ha_innodb.so.0 libdaemon_example.la mypluglib.a mypluglib.so.0.0.0
ha_innodb.so.0.0.0 libdaemon_example.so mypluglib.la
install_innodb_plugins.sql libdaemon_example.so.0 mypluglib.so
mysql> show plugins;+--------------------------------+----------+--------------------+---------+---------+
| Name | Status | Type | Library | License |
+--------------------------------+----------+--------------------+---------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| INNODB_RSEG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_POOL_PAGES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_POOL_PAGES_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_POOL_PAGES_BLOB | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| XTRADB_ENHANCEMENTS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
+--------------------------------+----------+--------------------+---------+---------+
21 rows in set (0.00 sec)
mysql>
References