The option "ignore-builtin-innodb" is invalid for Percona Server
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Critical
|
Rodrigo Gadea | ||
5.1 |
Fix Released
|
Critical
|
Laurynas Biveinis | ||
5.5 |
Fix Released
|
Critical
|
Rodrigo Gadea |
Bug Description
OS: Ubuntu 10.04 x86_64
Percona Server: 5.1.54-rel12.5 (Rev. 188)
Default options were altered with:
ignore-
plugin-
innodb_
While issuing SQL statement to create compressed InnoDB table mysql client throws the following error:
mysql> create table t1 (a varchar(20)) ENGINE=InnoDB ROW_FORMAT=
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1
Current database: test
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/
ERROR:
Can't connect to the server
mysql>
After specified statement mysql client is n more operable, after restarting mysql client (not the server) - it keeps working.
Please find relevant log entries from daemon logger below:
Jan 18 02:30:31 dev302 mysqld: Version: '5.1.54-rel12.5' socket: '/var/run/
Jan 18 02:30:39 dev302 mysqld: 110118 2:30:39 - mysqld got signal 11 ;
Jan 18 02:30:39 dev302 mysqld: This could be because you hit a bug. It is also possible that this binary
Jan 18 02:30:39 dev302 mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Jan 18 02:30:39 dev302 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Jan 18 02:30:39 dev302 mysqld: We will try our best to scrape up some info that will hopefully help diagnose
Jan 18 02:30:39 dev302 mysqld: the problem, but since we have already crashed, something is definitely wrong
Jan 18 02:30:39 dev302 mysqld: and this may fail.
Jan 18 02:30:39 dev302 mysqld:
Jan 18 02:30:39 dev302 mysqld: key_buffer_
Jan 18 02:30:39 dev302 mysqld: read_buffer_
Jan 18 02:30:39 dev302 mysqld: max_used_
Jan 18 02:30:39 dev302 mysqld: max_threads=151
Jan 18 02:30:39 dev302 mysqld: threads_connected=1
Jan 18 02:30:39 dev302 mysqld: It is possible that mysqld could use up to
Jan 18 02:30:39 dev302 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_
Jan 18 02:30:39 dev302 mysqld: bytes of memory
Jan 18 02:30:39 dev302 mysqld: Hope that's ok; if not, decrease some variables in the equation.
Jan 18 02:30:39 dev302 mysqld:
strace outputs are attached in tar archive. mysqld pid is 972
Related branches
- Stewart Smith (community): Approve
- Valentine Gostev: Pending requested
-
Diff: 54 lines (+47/-0)1 file modifiedinnodb_swap_builtin_plugin.patch (+47/-0)
Changed in percona-server: | |
status: | Invalid → Confirmed |
importance: | Undecided → Low |
Changed in percona-server: | |
milestone: | none → 5.1.58-12.9 |
summary: |
- Creation of compressed innodb table fails + The option "ignore-builtin-innodb" is invalid for Percona Server |
options builtin- innodb load=innodb= ha_innodb. so
ignore-
plugin-
are not supported in Percona Server and may give unpredictable result.
Percona Server comes with XtraDB ( advanced InnoDB-plugin by default).