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
4011
October 05, 2018 01:58AM
1155
October 05, 2018 09:40AM
968
October 05, 2018 10:40AM
851
October 05, 2018 11:50AM
974
October 05, 2018 12:23PM
821
October 05, 2018 02:30PM
1332
October 05, 2018 08:57PM
996
October 05, 2018 10:05PM
723
October 06, 2018 08:42AM
916
October 06, 2018 10:46PM
960
October 07, 2018 02:10AM
997
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.