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

Logrotates flush-logs process never ends

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1.17
    • 10.1.30
    • Galera, Replication
    • 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

          Activity

            People

              sachin.setiya.007 Sachin Setiya (Inactive)
              monotek André Bauer
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.