The web application does not connect to the database on VDS (0.5 RAM, 1 core CPU). I can’t understand the reason. I do not know what to do please tell me.
This is mysql configuration my.cnf. I included there innodb_buffer_pool_size = 250M
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
max_connections=25
max_user_connections=20
wait_timeout=10
interactive_timeout=50
long_query_time=5
#log-queries-not-using-indexes
#log-slow-queries=/var/log/mysql/log-slow-queries.log
bind-address=185.231.154.57
#key_buffer = 16M
myisam_sort_buffer_size = 32M
join_buffer_size=1M
read_buffer_size=1M
sort_buffer_size=2M
#table_cache=1024
thread_cache_size=286
interactive_timeout=25
connect_timeout=5
max_allowed_packet=1M
max_connect_errors=1000
#query_cache_limit=1M
#query_cache_size=8M
#query_cache_type=1
tmp_table_size=16M
#innodb_use_native_aio = 0
innodb_buffer_pool_size = 250M
innodb_file_per_table
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
logs:
root@v101877:/home/servers/apache-tomee-plume-8.0.0-M1/binsystemctl status mysql
* mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Sun 2019-01-13 10:04:17 MSK; 10min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 681 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 642 ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 681 (code=exited, status=1/FAILURE)
Status: "SERVER_BOOTING"
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru mysqld[681]: 2019-01-13T07:04:17.608676Z 0 [ERROR] [MY-012681] [InnoDB] mmap(137428992 bytes) failed; errno 12
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru mysqld[681]: 2019-01-13T07:04:17.610517Z 1 [ERROR] [MY-012956] [InnoDB] Cannot allocate memory for the buffer pool
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru mysqld[681]: 2019-01-13T07:04:17.610553Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru mysqld[681]: 2019-01-13T07:04:17.611113Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru mysqld[681]: 2019-01-13T07:04:17.612755Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru mysqld[681]: 2019-01-13T07:04:17.613398Z 0 [ERROR] [MY-010119] [Server] Aborting
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru mysqld[681]: 2019-01-13T07:04:17.626404Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru systemd[1]: mysql.service: Failed with result 'exit-code'.
Jan 13 10:04:17 v101877.hosted-by-vdsina.ru systemd[1]: Failed to start MySQL Community Server.
asked Jan 13, 2019 at 9:12
0
Suggestions to consider for your my.cnf [mysqld] section
# join_buffer_size=1M
# read_buffer_size=1M
# sort_buffer_size=2M
# table_cache=1024
# thread_cache_size=286
innodb_buffer_pool_size=10M
until you can get started. Yes, DISABLE all 5 of these lines so the DEFAULTS will allow you to get running.
If you have .5 G of RAM, expect FRUSTRATION. Very few people use less than 4 G of RAM at this point in time.
answered Jan 13, 2019 at 17:41
Wilson HauckWilson Hauck
1,9811 gold badge11 silver badges18 bronze badges
1
I’m using Vagrant with libvirt and I stumbled upon this error.
After hours of struggling, the problem has turned out to be the Vagrant configuration, instead of the mysql/mysqld one.
In the Vagrantfile I uncommented the option to customize the virtual machine’s virtual RAM. The default was 512MB, with the 1024 value is working fine now:
config.vm.provider "libvirt" do |vb|
# # Display the VirtualBox GUI when booting the machine
# vb.gui = true
#
# Customize the amount of memory on the VM:
vb.memory = "1024"
end
I hope it helps someone, I never had this error using Virtualbox, maybe it comes with a different default memory value out of the box.
answered Feb 18, 2022 at 17:46
antzioantzio
931 silver badge7 bronze badges
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and
privacy statement. We’ll occasionally send you account related emails.
Already on GitHub?
Sign in
to your account
Closed
otaroo opened this issue
Dec 29, 2016
· 1 comment
Comments
| 2016-12-29T15:17:43.788366Z 0 [Note] mysqld (mysqld 5.7.17) starting as process 1 …
db_1 | 2016-12-29T15:17:43.828795Z 0 [Note] InnoDB: PUNCH HOLE support available
db_1 | 2016-12-29T15:17:43.829157Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1 | 2016-12-29T15:17:43.829561Z 0 [Note] InnoDB: Uses event mutexes
db_1 | 2016-12-29T15:17:43.829880Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
db_1 | 2016-12-29T15:17:43.830462Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
db_1 | 2016-12-29T15:17:43.830593Z 0 [Note] InnoDB: Using Linux native AIO
db_1 | 2016-12-29T15:17:43.833323Z 0 [Note] InnoDB: Number of pools: 1
db_1 | 2016-12-29T15:17:43.838835Z 0 [Note] InnoDB: Using CPU crc32 instructions
db_1 | 2016-12-29T15:17:43.851010Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
db_1 | 2016-12-29T15:17:43.851927Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
db_1 | 2016-12-29T15:17:43.852152Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
db_1 | 2016-12-29T15:17:43.852458Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
db_1 | 2016-12-29T15:17:43.852561Z 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
db_1 | 2016-12-29T15:17:43.852657Z 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
db_1 | 2016-12-29T15:17:43.852745Z 0 [ERROR] Failed to initialize plugins.
db_1 | 2016-12-29T15:17:43.852838Z 0 [ERROR] Aborting
db_1 |
db_1 | 2016-12-29T15:17:43.856389Z 0 [Note] Binlog end
db_1 | 2016-12-29T15:17:43.857391Z 0 [Note] Shutting down plugin ‘MyISAM’
db_1 | 2016-12-29T15:17:43.857947Z 0 [Note] Shutting down plugin ‘CSV’
db_1 | 2016-12-29T15:17:43.860146Z 0 [Note] mysqld: Shutdown complete
2016-12-29 16:22 GMT+01:00 otaroo <notifications@github.com>:
db_1 | 2016-12-29T15:17:43.851927Z 0 [ERROR] InnoDB: mmap(137428992 bytes)
failed; errno 12
Seems your innodb_buffer_pool_size is bigger than the —memory allowed.
Peace,
R.
[[email protected]_0_7_centos /]# systemctl start mysqld.service
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.MySQL на сервере Linux начинает ошибку, и эта ошибка была выпущена ранее, потому что она не была решена для всего более позднего MySQL. Но эта ошибка появилась снова после переустановки, это немного проблематично. Я нашел много информации и просматриваю журналы MySQL следующим образом:
2019-07-09T01:23:01.592678Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26) starting as process 28148 ...
2019-07-09T01:23:01.723338Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-07-09T01:23:01.723400Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-09T01:23:01.723406Z 0 [Note] InnoDB: Uses event mutexes
2019-07-09T01:23:01.723410Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-07-09T01:23:01.723413Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-09T01:23:01.723419Z 0 [Note] InnoDB: Using Linux native AIO
2019-07-09T01:23:01.750346Z 0 [Note] InnoDB: Number of pools: 1
2019-07-09T01:23:01.750538Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-07-09T01:23:01.770716Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-09T01:23:01.770839Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2019-07-09T01:23:01.770856Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
2019-07-09T01:23:01.770866Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-07-09T01:23:01.770880Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-07-09T01:23:01.770887Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-07-09T01:23:01.782124Z 0 [ERROR] Failed to initialize builtin plugins.
2019-07-09T01:23:01.782151Z 0 [ERROR] Aborting
При поиске проблемы в соответствии с разделом сообщения об ошибке, Интернет в основном изменяет файл конфигурации my.cnf, такой как изменение размера innodb_buffer_pool_size, но это не влияет. После копирования всего поиска сообщения об ошибке позже было найдено правильное решение. Бесплатная инструкция для просмотра памяти:
[[email protected]_0_7_centos /]# free
total used free shared buff/cache available
Mem: 1016516 722544 70124 108428 223848 37380
Swap: 0 0 0
Сервер не настраивает раздел SWAP.Перегородка обмена), Я знаю источник текущей задачи и настроить размер 1G раздела SWAP для машины. Для установки размера раздела SWAP, пожалуйста, см.Размер обмена Linux и отношения памяти
[[email protected]_0_7_centos /]# sudo dd if=/dev/zero of=/swapfile bs=1M count=1024
1024+0 records in
1024+0 records out
1073741824 bytes (1.1 GB) copied, 33.4362 s, 32.1 MB/s
[[email protected]_0_7_centos /]#
[[email protected]_0_7_centos /]# sudo mkswap /swapfile
Setting up swapspace version 1, size = 1048572 KiB
no label, UUID=8b3622a0-b64d-479a-a93a-75f0ba430e32
[[email protected]_0_7_centos /]#
[[email protected]_0_7_centos /]# sudo swapon /swapfile
swapon: /swapfile: insecure permissions 0644, 0600 suggested.
[[email protected]_0_7_centos /]#
[[email protected]_0_7_centos /]# free
total used free shared buff/cache available
Mem: 1016516 757720 67688 41652 191108 52000
Swap: 1048572 66752 981820
[[email protected]_0_7_centos /]#
[[email protected]_0_7_centos /]# systemctl start mysqld.service
[[email protected]_0_7_centos /]#
задача решена!
Спасибо, эта статья:https://blog.csdn.net/qq_42262444/article/details/88524472
И оригинальная статья:https://www.cnblogs.com/olinux/p/5144205.html
Since mysql.event is empty you can use one of the following two options:
1- use —skip-events to skip events from backup.
2- try to recreate the table (firs you need to drop it):
DROP TABLE IF EXISTS `mysql`.`event`;
if you are using MySQL 5.7
CREATE TABLE `mysql`.`event` (
`db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`name` char(64) NOT NULL DEFAULT »,
`body` longblob NOT NULL,
`definer` char(93) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`execute_at` datetime DEFAULT NULL,
`interval_value` int(11) DEFAULT NULL,
`interval_field` enum(‘YEAR’,’QUARTER’,’MONTH’,’DAY’,’HOUR’,’MINUTE’,’WEEK’,’SECOND’,’MICROSECOND’,’YEAR_MONTH’,’DAY_HOUR’,’DAY_MINUTE’,’DAY_SECOND’,’HOUR_MINUTE’,’HOUR_SECOND’,’MINUTE_SECOND’,’DAY_MICROSECOND’,’HOUR_MICROSECOND’,’MINUTE_MICROSECOND’,’SECOND_MICROSECOND’) DEFAULT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`modified` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
`last_executed` datetime DEFAULT NULL,
`starts` datetime DEFAULT NULL,
`ends` datetime DEFAULT NULL,
`status` enum(‘ENABLED’,’DISABLED’,’SLAVESIDE_DISABLED’) NOT NULL DEFAULT ‘ENABLED’,
`on_completion` enum(‘DROP’,’PRESERVE’) NOT NULL DEFAULT ‘DROP’,
`sql_mode` set(‘REAL_AS_FLOAT’,’PIPES_AS_CONCAT’,’ANSI_QUOTES’,’IGNORE_SPACE’,’NOT_USED’,’ONLY_FULL_GROUP_BY’,’NO_UNSIGNED_SUBTRACTION’,’NO_DIR_IN_CREATE’,’POSTGRESQL’,’ORACLE’,’MSSQL’,’DB2′,’MAXDB’,’NO_KEY_OPTIONS’,’NO_TABLE_OPTIONS’,’NO_FIELD_OPTIONS’,’MYSQL323′,’MYSQL40′,’ANSI’,’NO_AUTO_VALUE_ON_ZERO’,’NO_BACKSLASH_ESCAPES’,’STRICT_TRANS_TABLES’,’STRICT_ALL_TABLES’,’NO_ZERO_IN_DATE’,’NO_ZERO_DATE’,’INVALID_DATES’,’ERROR_FOR_DIVISION_BY_ZERO’,’TRADITIONAL’,’NO_AUTO_CREATE_USER’,’HIGH_NOT_PRECEDENCE’,’NO_ENGINE_SUBSTITUTION’,’PAD_CHAR_TO_FULL_LENGTH’) NOT NULL DEFAULT »,
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`originator` int(10) unsigned NOT NULL,
`time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT ‘SYSTEM’,
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`body_utf8` longblob,
PRIMARY KEY (`db`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=’Events’;
MySQL 5.1
Compared to MySQL 5.7, the definer field is smaller.
CREATE TABLE `mysql`.`event` (
`db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`name` char(64) NOT NULL DEFAULT »,
`body` longblob NOT NULL,
`definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`execute_at` datetime DEFAULT NULL,
`interval_value` int(11) DEFAULT NULL,
`interval_field` enum(‘YEAR’,’QUARTER’,’MONTH’,’DAY’,’HOUR’,’MINUTE’,’WEEK’,’SECOND’,’MICROSECOND’,’YEAR_MONTH’,’DAY_HOUR’,’DAY_MINUTE’,’DAY_SECOND’,’HOUR_MINUTE’,’HOUR_SECOND’,’MINUTE_SECOND’,’DAY_MICROSECOND’,’HOUR_MICROSECOND’,’MINUTE_MICROSECOND’,’SECOND_MICROSECOND’) DEFAULT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`modified` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
`last_executed` datetime DEFAULT NULL,
`starts` datetime DEFAULT NULL,
`ends` datetime DEFAULT NULL,
`status` enum(‘ENABLED’,’DISABLED’,’SLAVESIDE_DISABLED’) NOT NULL DEFAULT ‘ENABLED’,
`on_completion` enum(‘DROP’,’PRESERVE’) NOT NULL DEFAULT ‘DROP’,
`sql_mode` set(‘REAL_AS_FLOAT’,’PIPES_AS_CONCAT’,’ANSI_QUOTES’,’IGNORE_SPACE’,’NOT_USED’,’ONLY_FULL_GROUP_BY’,’NO_UNSIGNED_SUBTRACTION’,’NO_DIR_IN_CREATE’,’POSTGRESQL’,’ORACLE’,’MSSQL’,’DB2′,’MAXDB’,’NO_KEY_OPTIONS’,’NO_TABLE_OPTIONS’,’NO_FIELD_OPTIONS’,’MYSQL323′,’MYSQL40′,’ANSI’,’NO_AUTO_VALUE_ON_ZERO’,’NO_BACKSLASH_ESCAPES’,’STRICT_TRANS_TABLES’,’STRICT_ALL_TABLES’,’NO_ZERO_IN_DATE’,’NO_ZERO_DATE’,’INVALID_DATES’,’ERROR_FOR_DIVISION_BY_ZERO’,’TRADITIONAL’,’NO_AUTO_CREATE_USER’,’HIGH_NOT_PRECEDENCE’,’NO_ENGINE_SUBSTITUTION’,’PAD_CHAR_TO_FULL_LENGTH’) NOT NULL DEFAULT »,
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`originator` int(10) unsigned NOT NULL,
`time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT ‘SYSTEM’,
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`body_utf8` longblob,
PRIMARY KEY (`db`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=’Events’;
MariaDB 5.5
Compared to MySQL 5.1 the NOT_USED under sql_mode changes to IGNORE_BAD_TABLE_OPTIONS.
CREATE TABLE `mysql`.`event` (
`db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`name` char(64) NOT NULL DEFAULT »,
`body` longblob NOT NULL,
`definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`execute_at` datetime DEFAULT NULL,
`interval_value` int(11) DEFAULT NULL,
`interval_field` enum(‘YEAR’,’QUARTER’,’MONTH’,’DAY’,’HOUR’,’MINUTE’,’WEEK’,’SECOND’,’MICROSECOND’,’YEAR_MONTH’,’DAY_HOUR’,’DAY_MINUTE’,’DAY_SECOND’,’HOUR_MINUTE’,’HOUR_SECOND’,’MINUTE_SECOND’,’DAY_MICROSECOND’,’HOUR_MICROSECOND’,’MINUTE_MICROSECOND’,’SECOND_MICROSECOND’) DEFAULT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`modified` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
`last_executed` datetime DEFAULT NULL,
`starts` datetime DEFAULT NULL,
`ends` datetime DEFAULT NULL,
`status` enum(‘ENABLED’,’DISABLED’,’SLAVESIDE_DISABLED’) NOT NULL DEFAULT ‘ENABLED’,
`on_completion` enum(‘DROP’,’PRESERVE’) NOT NULL DEFAULT ‘DROP’,
`sql_mode` set(‘REAL_AS_FLOAT’,’PIPES_AS_CONCAT’,’ANSI_QUOTES’,’IGNORE_SPACE’,’IGNORE_BAD_TABLE_OPTIONS’,’ONLY_FULL_GROUP_BY’,’NO_UNSIGNED_SUBTRACTION’,’NO_DIR_IN_CREATE’,’POSTGRESQL’,’ORACLE’,’MSSQL’,’DB2′,’MAXDB’,’NO_KEY_OPTIONS’,’NO_TABLE_OPTIONS’,’NO_FIELD_OPTIONS’,’MYSQL323′,’MYSQL40′,’ANSI’,’NO_AUTO_VALUE_ON_ZERO’,’NO_BACKSLASH_ESCAPES’,’STRICT_TRANS_TABLES’,’STRICT_ALL_TABLES’,’NO_ZERO_IN_DATE’,’NO_ZERO_DATE’,’INVALID_DATES’,’ERROR_FOR_DIVISION_BY_ZERO’,’TRADITIONAL’,’NO_AUTO_CREATE_USER’,’HIGH_NOT_PRECEDENCE’,’NO_ENGINE_SUBSTITUTION’,’PAD_CHAR_TO_FULL_LENGTH’) NOT NULL DEFAULT »,
`comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT »,
`originator` int(10) unsigned NOT NULL,
`time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT ‘SYSTEM’,
`character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`body_utf8` longblob,
PRIMARY KEY (`db`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=’Events’;