FIFO size exceeds physical memory limit
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Galera |
Fix Released
|
Medium
|
Alex Yurchenko |
Bug Description
CONFIGURATION
****************
Ubuntu 10.2 32-bit
Percona 5.5 xtra DB Cluster
ISSUE
*****
The node fails to restart because of FIFO size exceeds physical memory limit error.
Here are the logs :
130517 06:33:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130517 06:33:39 mysqld_safe WSREP: Running position recovery with --log_error=
130517 06:33:45 mysqld_safe WSREP: Recovered position 36033c88-
130517 6:33:45 [Note] WSREP: wsrep_start_
130517 6:33:45 [Note] WSREP: Read nil XID from storage engines, skipping position init
130517 6:33:45 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/
130517 6:33:45 [Note] WSREP: wsrep_load(): Galera 2.5(r150) by Codership Oy <email address hidden> loaded succesfully.
130517 6:33:45 [Note] WSREP: Found saved state: 36033c88-
130517 6:33:45 [Note] WSREP: Reusing existing '/var/lib/
130517 6:33:45 [ERROR] WSREP: galerautils/
130517 6:33:45 [ERROR] WSREP: gcs/src/
130517 6:33:45 [ERROR] WSREP: gcs/src/
130517 6:33:45 [Note] WSREP: Passing config to GCS: base_host = 192.168.0.11; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.
130517 6:33:45 [Note] WSREP: Flushing memory map to disk...
130517 6:33:46 [ERROR] WSREP: could not create gcs connection (FATAL)
at galera/
130517 6:33:46 [ERROR] WSREP: wsrep::init() failed: 6, must shutdown
130517 6:33:46 [ERROR] Aborting
130517 6:33:46 [Note] /usr/sbin/mysqld: Shutdown complete
130517 06:33:46 mysqld_safe mysqld from pid file /var/lib/
SOLUTION
*********
The physical memory indicated (1001381888) is wrong. I have 5GB. Here is the result of getconf :
ubuntu@
PAGESIZE 4096
PAGE_SIZE 4096
_AVPHYS_PAGES 778690
_PHYS_PAGES 1293054
See gu_fifo.c code :
mem_limit = GU_PHYS_PAGES * GU_PAGE_SIZE;
The value is wrong because an arithmetic overfow for 32-bit system :
5296349184 (max memory of my system) - 4294967295 (maximum representable value of 32bits number limit) = 1001381889 (physical limit indicated by Galera)
Thanks,
Yannick Robin
Changed in galera: | |
assignee: | nobody → Alex Yurchenko (ayurchen) |
importance: | Undecided → Medium |
status: | New → In Progress |
Changed in galera: | |
status: | Fix Committed → Fix Released |
hi,
i am experiencing the same issue on a similar server. is there any way to fix it or at least get the sql back online?
regards