sorted by: recent | see :
popular
Content Tagged with load + Database
DBSlayer - Trac
load() vs get() in Hibernate. When to use Hibernate load()? When to use Hibernate get()? load and get compared.
MySQL 5.1.24, InnoDB plugin 1.0 failures, server crash
Looks like the InnoDB plugin is completely broken with MySQL-5.1.24; at least there is no luck for me so far to set it up right. First, the Makefile is broken. Second, I tried to do a static build of InnoDB plugin with MySQL server (–enable-innodb and –with-plugin-innobase) resulted in partial InnoDB plugins (Information schema) missing the main one as shown below:
1: mysql> show plugins;
2: +———————+——–+——————–+———+———+
3: | Name | Status | Type | Library | License |
4: +———————+——–+——————–+———+———+
5: | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
6: | partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
7: | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
8: | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
9: | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
10: | FEDERATED | ACTIVE | STORAGE ENGINE | NULL | GPL |
11: | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
12: | INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
13: | INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
14: | INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
15: | INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
16: | INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
17: | INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
18: | INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
19: | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
20: | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
21: +———————+——–+——————–+———+———+
22: 16 rows in set (0.00 sec)
As you can see the main InnoDB plugin is missing and rest of the InnoDB information schema plugins for compression and locks are present. So, I built a dynamically loadable plugin separately and tried to install it using INSTALL PLUGIN, but it fails.
1: mysql> INSTALL PLUGIN INNODB SONAME ‘ha_innodb.so’;
2: ERROR 1126 (HY000): Can‘t open shared library ‘/home/y/lib64/mysql/plugin/ha_innodb.so‘ (errno: 2
3: cannot open shared object file: No such file or directory)
4: mysql> INSTALL PLUGIN INNODB SONAME ‘ha_innodb.so‘;
5: ERROR 1123 (HY000): Can’t initialize function ‘INNODB’; Plugin initialization function failed.
You can see the plugin .so should be in lib/mysql/plugin directory as opposed to top lib/mysql directory. And when I tried to select Information_schema.InnoDB_locks on a fresh database, the server crashes..
1: mysql> select * from Information_schema.Innodb_locks;
2: ERROR 2013 (HY000): Lost connection to MySQL server during query
The backtrace looks like ..
/mysql/libexec64/mysqld(get_schema_tables_result(JOIN*, enum_schema_table_state)+0x142) [0x6e9d32]
/mysql/libexec64/mysqld(JOIN::exec()+0x760) [0x64b480] /mysql/libexec64/mysqld(mysql_select(THD*, Item***, TABLE_LIST*...) [0x64d267]
/mysql/libexec64/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x181) [0x64dab1] |
I decided not to file any bugs yet as InnoDB team looks like working on getting this to work with 5.1.24. Now, I started a new build with 5.1.23 to see how it goes.
