Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-3171

LP #1353289: Spam in error log if server run without permission to set nice 0

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 14-03-2016 07:45:40

      If server is started in environment where setting nice to 0 is not allowed (e.g. non-root with mysqld niced to priority lower to 0), the error log will have

      2014-08-04 15:15:06 28999 [Warning] InnoDB: Setting thread 29686 nice to 0 failed, current nice 10, errno 13
      2014-08-04 15:15:06 28999 [Warning] InnoDB: Setting thread 29685 nice to 0 failed, current nice 10, errno 13
      2014-08-04 15:15:06 28999 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.19-67.0 started; log sequence number 5547985478636
      2014-08-04 15:15:06 28999 [Warning] InnoDB: Setting thread 29687 nice to 0 failed, current nice 10, errno 13
      2014-08-04 15:15:06 28999 [Warning] InnoDB: Setting thread 29688 nice to 0 failed, current nice 10, errno 13

      These messages are benign and caused by the thread scheduling priority implementation that attempts to nice every worker thread on startup. If no innodb_sched_priority_cleaner etc option is specified, the default value is 0, which is attempted to nice to here.

      A fix would be to add another value to innodb_sched_priority_* options that means"do not attempt to nice" and will be the new default.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: