MySQL 8.0: InnoDB: mmap failed; errno 12
Posted by:
Sujith S
Date: October 05, 2018 01:58AM
Hi,
I am Getting following error after modifying the innodb buffer pool size values.
2018-10-05T07:35:47.023697Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.
2018-10-05T07:36:43.909180Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.12) starting as process 127616
2018-10-05T07:36:52.962993Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:52.967840Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:52.969252Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:52.969845Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:53.038190Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:53.071308Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:53.071978Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:53.154088Z 0 [ERROR] [MY-012681] [InnoDB] InnoDB: mmap(137428992 bytes) failed; errno 12
2018-10-05T07:36:55.085538Z 1 [ERROR] [MY-012956] [InnoDB] InnoDB: Cannot allocate memory for the buffer pool
2018-10-05T07:36:55.085639Z 1 [ERROR] [MY-012930] [InnoDB] InnoDB: Plugin initialization aborted with error Generic error.
2018-10-05T07:36:55.085715Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2018-10-05T07:36:55.086358Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-10-05T07:36:55.086439Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-10-05T07:36:55.088807Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL.
137428992 is innodb_buffer_pool_chunk_size.
This started after following was added to my.cnf
innodb_buffer_pool_size=200G
innodb_buffer_pool_instances=40
Machine is having 256 GB RAM.
All the other values are default. mysql is started via systemctl. ulimit is unlimited.
What could be causing this?
Subject
Views
Written By
Posted
MySQL 8.0: InnoDB: mmap failed; errno 12
4030
October 05, 2018 01:58AM
1161
October 05, 2018 09:40AM
974
October 05, 2018 10:40AM
856
October 05, 2018 11:50AM
981
October 05, 2018 12:23PM
826
October 05, 2018 02:30PM
1343
October 05, 2018 08:57PM
1002
October 05, 2018 10:05PM
728
October 06, 2018 08:42AM
923
October 06, 2018 10:46PM
967
October 07, 2018 02:10AM
1005
October 07, 2018 12:02PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.