Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.1.17
-
None
-
Ubuntu 14.04 & 16.06
Galera Cluster
Description
Every day logrotate trys to flush the mariadb logs but the process never stops so that it just starts a new one the next day.
After some time your server would crash because of this. Only way to solve the problem is to restart mariadb server.
ps faux example:
root 1227 0.0 0.0 23648 896 ? Ss Aug30 0:01 cron |
root 24631 0.0 0.0 59632 1444 ? S Sep10 0:00 \_ CRON
|
root 24632 0.0 0.0 4440 648 ? Ss Sep10 0:00 | \_ /bin/sh -c test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ) |
root 24633 0.0 0.0 4332 612 ? S Sep10 0:00 | \_ run-parts --report /etc/cron.daily |
root 28256 0.0 0.0 4440 648 ? S Sep10 0:00 | \_ /bin/sh /etc/cron.daily/logrotate |
root 28261 0.0 0.0 35696 1316 ? S Sep10 0:00 | \_ /usr/sbin/logrotate /etc/logrotate.conf |
root 28265 0.0 0.0 4440 652 ? S Sep10 0:00 | \_ sh -c test -x /usr/bin/mysqladmin || exit 0 if [ -f `my_pri |
root 28269 0.0 0.0 36400 2544 ? S Sep10 0:00 | \_ mysqladmin --defaults-file=/etc/mysql/debian.cnf flush-logs |
root 948 0.0 0.0 59632 1448 ? S Sep11 0:00 \_ CRON
|
root 949 0.0 0.0 4440 648 ? Ss Sep11 0:00 | \_ /bin/sh -c test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ) |
root 950 0.0 0.0 4332 608 ? S Sep11 0:00 | \_ run-parts --report /etc/cron.daily |
root 3887 0.0 0.0 4440 652 ? S Sep11 0:00 | \_ /bin/sh /etc/cron.daily/logrotate |
root 3892 0.0 0.0 35696 1316 ? S Sep11 0:00 | \_ /usr/sbin/logrotate /etc/logrotate.conf |
root 3893 0.0 0.0 4440 652 ? S Sep11 0:00 | \_ sh -c test -x /usr/bin/mysqladmin || exit 0 if [ -f `my_pri |
root 3897 0.0 0.0 36400 2544 ? S Sep11 0:00 | \_ mysqladmin --defaults-file=/etc/mysql/debian.cnf flush-logs |
root 9959 0.0 0.0 59632 1448 ? S Sep12 0:00 \_ CRON
|
root 9960 0.0 0.0 4440 648 ? Ss Sep12 0:00 | \_ /bin/sh -c test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ) |
root 9961 0.0 0.0 4332 608 ? S Sep12 0:00 | \_ run-parts --report /etc/cron.daily |
root 12427 0.0 0.0 4440 652 ? S Sep12 0:00 | \_ /bin/sh /etc/cron.daily/logrotate |
root 12432 0.0 0.0 35696 1320 ? S Sep12 0:00 | \_ /usr/sbin/logrotate /etc/logrotate.conf |
root 12433 0.0 0.0 4440 652 ? S Sep12 0:00 | \_ sh -c test -x /usr/bin/mysqladmin || exit 0 if [ -f `my_pri |
root 12437 0.0 0.0 36400 2544 ? S Sep12 0:00 | \_ mysqladmin --defaults-file=/etc/mysql/debian.cnf flush-logs |
root 17501 0.0 0.0 59632 1448 ? S Sep13 0:00 \_ CRON
|
root 17502 0.0 0.0 4440 644 ? Ss Sep13 0:00 | \_ /bin/sh -c test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ) |
root 17503 0.0 0.0 4332 608 ? S Sep13 0:00 | \_ run-parts --report /etc/cron.daily |
root 19805 0.0 0.0 4440 648 ? S Sep13 0:00 | \_ /bin/sh /etc/cron.daily/logrotate |
root 19810 0.0 0.0 35696 1316 ? S Sep13 0:00 | \_ /usr/sbin/logrotate /etc/logrotate.conf |
root 19811 0.0 0.0 4440 648 ? S Sep13 0:00 | \_ sh -c test -x /usr/bin/mysqladmin || exit 0 if [ -f `my_pri |
root 19815 0.0 0.0 36400 2540 ? S Sep13 0:00 | \_ mysqladmin --defaults-file=/etc/mysql/debian.cnf flush-logs |
root 25774 0.0 0.0 59632 1448 ? S 06:25 0:00 \_ CRON
|
root 25775 0.0 0.0 4440 652 ? Ss 06:25 0:00 \_ /bin/sh -c test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ) |
root 25776 0.0 0.0 4332 608 ? S 06:25 0:00 \_ run-parts --report /etc/cron.daily |
root 29098 0.0 0.0 4440 648 ? S 06:51 0:00 \_ /bin/sh /etc/cron.daily/logrotate |
root 29103 0.0 0.0 35696 1316 ? S 06:51 0:00 \_ /usr/sbin/logrotate /etc/logrotate.conf |
root 29107 0.0 0.0 4440 652 ? S 06:51 0:00 \_ sh -c test -x /usr/bin/mysqladmin || exit 0 if [ -f `my_pri |
root 29111 0.0 0.0 36400 2540 ? S 06:51 0:00 \_ mysqladmin --defaults-file=/etc/mysql/debian.cnf flush-logs |
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
MDEV-11610 Logrotate to only FLUSH LOCAL ERROR LOGS, ENGINE LOGS, GENERAL LOGS
-
- Closed
-