percona-discussion team mailing list archive

[Mártha Csaba <csy@xxxxxxxxx>]

Hello

I debugging the error, and i think, these lines causes in config:

#innodb_data_file_path           =ibdata1:2000M:autoextend;ibdata2:1000M:autoextend
#innodb_log_group_home_dir       = /var/lib/mysql/
#innodb_additional_mem_pool_size = 128M
#innodb_log_file_size            = 512M
#innodb_log_buffer_size          = 8M
#innodb_data_home_dir            = /var/lib/mysql/ 

if i commented out, the innodb engine works perfect.

Best Regards

-- 
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>