Page 1 of 1
InnoDB error
Posted: Tue Jul 30, 2019 4:25 pm
by cbeattie-unitrends
Hello,
I see InnoDB errors when I look in /var/log/mariadb/mariadb.log on my Fusion server:
[root@den-fusion ~]# tail /var/log/mariadb/mariadb.log
190730 21:12:24 InnoDB: ERROR: the age of the last checkpoint is 9440306,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
190730 21:18:28 InnoDB: ERROR: the age of the last checkpoint is 9440864,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.
What can I do to fix that?
Re: InnoDB error
Posted: Tue Jul 30, 2019 4:39 pm
by lmiltchev
What is the version of Nagios Fusion that you are currently using?
Can you show us the output of the following command?
Re: InnoDB error
Posted: Wed Jul 31, 2019 8:45 am
by cbeattie-unitrends
Fusion is version 4.1.7, and it's running on CentOS 7.6.1810. Fusion appears to be running okay. I discovered this almost by accident.
We have 7 fused Nagios instances, 1 Core and 6 XI monitoring 3K+ hosts and 82K+ services.
my.cnf looks like this:
[root@den-fusion ~]# cat /etc/my.cnf
[mysqld]
innodb_file_per_table = 1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in
http://fedoraproject.org/wiki/Systemd
# Added by Nagios 2017-08-18 08:06:58
max_allowed_packet = 32M
# Added by Nagios 2017-08-18 08:06:58
query_cache_size = 16M
# Added by Nagios 2017-08-18 08:06:58
query_cache_limit = 4M
# Added by Nagios 2017-08-18 08:06:58
tmp_table_size = 64M
# Added by Nagios 2017-08-18 08:06:58
max_heap_table_size = 64M
# Added by Nagios 2017-08-18 08:06:58
key_buffer_size = 32M
# Added by Nagios 2017-08-18 08:06:58
table_open_cache = 32
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[root@den-fusion ~]#
Re: InnoDB error
Posted: Wed Jul 31, 2019 9:27 am
by lmiltchev
OK, try the following:
1. Add these three lines to the /etc/my.cnf file under the [mysqld] section:
Code: Select all
innodb_log_buffer_size = 32M
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M
Save, and exit.
2. Stop mariadb.
3. Remove the ib_logfile0 and ib_logfile1 log files. Don't worry - they will be rebuild on starting mariadb.
Note: If you wanted to play safe, you could move the files to /tmp.
Code: Select all
mv /var/lib/mysql/ib_logfile* /tmp
4. Start mariadb.
Let us know if this helped.
Re: InnoDB error
Posted: Thu Aug 01, 2019 7:56 am
by cbeattie-unitrends
Prior to your suggested fixes, there'd be a new error message in the log every few minutes. It's been more than half a day and the log file has no complaints.
Feel free to close and lock this thread.
Thanks!
Re: InnoDB error
Posted: Thu Aug 01, 2019 9:08 am
by mbellerue
Glad to hear it's working! Closing thread.