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

mysqladmin flush commands not working

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.32
    • N/A
    • Scripts & Clients
    • None

    Description

      I noticed that:

      mysqladmin --flush-logs
      mysqladmin --flush-error-log
      mysqladmin --refresh
      mysql -e "FLUSH LOGS"

      Don't flush the error log and:

      mysqladmin --flush-binary-log

      Doesn't rotate the binary logs

      While FLUSH LOGS; run interactively does rotate logs(error and binary).

      This is confirmed also by strace.

      To reproduce it's simple:

      $ mv error.log error.log.1
      $ mysqladmin flush-error-log # or any other of the above commands

      error.log is not re-created

      You can confirm it with strace by:

       $ strace -f -e trace=%file -p `pidof mysqld` -o mysqld.strace 

      After running the commands mysqld.strace file will be empty:

       $ more mysqld.strace 

      If you do the same using:

       $ mysql -e "FLUSH LOGS;" 

      Then the strace file will contain the proper system calls.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              claudio.nanni Claudio Nanni
              Votes:
              1 Vote for this issue
              Watchers:
              3 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.