Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10809

Logrotates flush-logs process never ends

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.1.17
    • Fix Version/s: 10.1.30
    • Component/s: Galera, Replication
    • Labels:
      None
    • Environment:
      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

            Activity

              People

              • Assignee:
                sachin.setiya.007 Sachin Setiya
                Reporter:
                monotek André Bauer
              • Votes:
                0 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: