main.percona_innodb_buffer_pool_shm fails on Debian and CentOS
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Critical
|
Stewart Smith | ||
5.5 |
Fix Released
|
Critical
|
Stewart Smith |
Bug Description
On Percona-Server 5.1.53-12.4 main.percona_
On debian:
$ less log/mysqld.1.err
CURRENT_TEST: main.percona_
101222 18:00:02 [Warning] '--default-
101222 18:00:02 [Note] Flashcache bypass: disabled
101222 18:00:02 [Note] Flashcache setup error is : open flash device failed
101222 18:00:02 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3.3
InnoDB: Warning: The innodb_
InnoDB: Do not change the following between restarts of the server while this option is being used:
InnoDB: * the mysqld executable between restarts of the server.
InnoDB: * the value of innodb_
InnoDB: * the value of innodb_page_size.
InnoDB: * datafiles created by InnoDB during this session.
InnoDB: Otherwise, data corruption in datafiles may result.
InnoDB: The shared memory segment containing the buffer pool is: key 0x1e240 (123456).
InnoDB: Warning: Failed to allocate 137789440 bytes. (new) errno 22
InnoDB: Fatal error: cannot allocate the memory for the buffer pool
101222 18:00:02 [ERROR] Plugin 'InnoDB' init function returned error.
101222 18:00:02 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
101222 18:00:02 [Warning] /var/lib/
101222 18:00:02 [Note] Event Scheduler: Loaded 0 events
101222 18:00:02 [Note] /var/lib/
On CentOS:
main.percona_
Test ended at 2010-12-21 09:07:53
CURRENT_TEST: main.percona_
--- /home/buildbot/
+++ /home/buildbot/
@@ -1,6 +1,8 @@
show variables like 'innodb_
Variable_name Value
+innodb_
innodb_
show variables like 'innodb_
Variable_name Value
+innodb_
innodb_
mysqltest: Result length mismatch
Related branches
- Stewart Smith (community): Disapprove
- Oleg Tsarev (community): Needs Fixing
- Yasufumi Kinoshita: Pending requested
-
Diff: 320 lines (+57/-53)2 files modifiedinnodb_buffer_pool_shm.patch (+56/-53)
mysql-test/percona_innodb_buffer_pool_shm.test (+1/-0)
Changed in percona-server: | |
milestone: | none → 5.1.53-12.4 |
Changed in percona-server: | |
assignee: | nobody → Aleksandr Kuzminsky (akuzminsky) |
Changed in percona-server: | |
status: | New → In Progress |
Changed in percona-server: | |
status: | In Progress → Fix Committed |
status: | Fix Committed → Confirmed |
The reason for the failure on Debian is likely a limit for shared memory size. Please check /proc/sys/ kernel/ shmmax and /proc/sys/ kernel/ shmall on that machine.
The CentOS failure is simple. innodb_ buffer_ pool_shm_ checksum was added recently, but the test case was not updated accordingly. On Debian it just fails before there are any results to be compared.