** 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>
deb...@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>
deb...@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 Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
