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

Debian: mysqld_safe Can't log to error log and syslog at the same time

Details

    Description

      mariadb-server-10.0 depends on mysql-common.
      mariadb-server-10.0 provides /etc/mysql/conf.d/mysqld_safe_syslog.cnf, which has "syslog" option.
      mysql-common in debian repo provides /etc/mysql/my.cnf, which has "log_error=" option.
      mysql-common in mariadb repo provides /etc/mysql/my.cnf, which has no "log_error=" option.

      As a result default debian installation has both "log_error=" and "syslog" options, causing a warning and ignores intended "syslog".
      Default installation from mariadb repo works well though.

      There was an idea to add something like "disable_log_error" to mysqld_safe_syslog.cnf, but then how do we distinguish between default "log_error" and one specified by user?

      Attachments

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9140 log_error variable not used after upgrade from mysql 5.6

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Debian bug report

          Web Link Github revision

          Web Link Original commit

          Activity

            Ascending order - Click to sort in descending order
            svoj Sergey Vojtovich created issue -
            svoj Sergey Vojtovich made changes -
            Field Original Value New Value
            svoj Sergey Vojtovich made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            svoj Sergey Vojtovich made changes -
            Description mariadb-server-10.0 depends on mysql-common.
            mariadb-server-10.0 provides /etc/mysql/conf.d/mysqld_safe_syslog.cnf, which has "syslog" option.
            mysql-common in debian repo provides /etc/mysql/my.cnf, which has "log_error=" option.
            mysql-common in mariadb repo provides /etc/mysql/my.cnf, which has no "log_error=" option.

            As a result default debian installation has both "log_error=" and "syslog" options, causing a warning and logs to a file.
            svoj Sergey Vojtovich made changes -
            Description mariadb-server-10.0 depends on mysql-common.
            mariadb-server-10.0 provides /etc/mysql/conf.d/mysqld_safe_syslog.cnf, which has "syslog" option.
            mysql-common in debian repo provides /etc/mysql/my.cnf, which has "log_error=" option.
            mysql-common in mariadb repo provides /etc/mysql/my.cnf, which has no "log_error=" option.

            As a result default debian installation has both "log_error=" and "syslog" options, causing a warning and logs to a file.             		mariadb-server-10.0 depends on mysql-common.
            mariadb-server-10.0 provides /etc/mysql/conf.d/mysqld_safe_syslog.cnf, which has "syslog" option.
            mysql-common in debian repo provides /etc/mysql/my.cnf, which has "log_error=" option.
            mysql-common in mariadb repo provides /etc/mysql/my.cnf, which has no "log_error=" option.

            As a result default debian installation has both "log_error=" and "syslog" options, causing a warning and ignores intended "syslog".

            There was an idea to add something like "disable_log_error" to mysqld_safe_syslog.cnf, but then how do we distinguish between default "log_error" and one specified by user?
            svoj Sergey Vojtovich made changes -
            Description mariadb-server-10.0 depends on mysql-common.
            mariadb-server-10.0 provides /etc/mysql/conf.d/mysqld_safe_syslog.cnf, which has "syslog" option.
            mysql-common in debian repo provides /etc/mysql/my.cnf, which has "log_error=" option.
            mysql-common in mariadb repo provides /etc/mysql/my.cnf, which has no "log_error=" option.

            As a result default debian installation has both "log_error=" and "syslog" options, causing a warning and ignores intended "syslog".

            There was an idea to add something like "disable_log_error" to mysqld_safe_syslog.cnf, but then how do we distinguish between default "log_error" and one specified by user?             		mariadb-server-10.0 depends on mysql-common.
            mariadb-server-10.0 provides /etc/mysql/conf.d/mysqld_safe_syslog.cnf, which has "syslog" option.
            mysql-common in debian repo provides /etc/mysql/my.cnf, which has "log_error=" option.
            mysql-common in mariadb repo provides /etc/mysql/my.cnf, which has no "log_error=" option.

            As a result default debian installation has both "log_error=" and "syslog" options, causing a warning and ignores intended "syslog".
            Default installation from mariadb repo works well though.

            There was an idea to add something like "disable_log_error" to mysqld_safe_syslog.cnf, but then how do we distinguish between default "log_error" and one specified by user?
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ]
            svoj Sergey Vojtovich added a comment -

            monty, please review fix for this bug.

            svoj Sergey Vojtovich added a comment - monty , please review fix for this bug.
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ] Michael Widenius [ monty ]
            Status Open [ 1 ] In Review [ 10002 ]
            otto Otto Kekäläinen added a comment -

            svoj Can you please link the commit you made to this issue so that it is easy to track and review? Thanks

            otto Otto Kekäläinen added a comment - svoj Can you please link the commit you made to this issue so that it is easy to track and review? Thanks
            svoj Sergey Vojtovich made changes -
            svoj Sergey Vojtovich added a comment -

            Done.

            svoj Sergey Vojtovich added a comment - Done.
            monty Michael Widenius added a comment -

            Patch approved

            monty Michael Widenius added a comment - Patch approved
            monty Michael Widenius made changes -
            Assignee Michael Widenius [ monty ] Sergey Vojtovich [ svoj ]
            svoj Sergey Vojtovich made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            svoj Sergey Vojtovich made changes -
            svoj Sergey Vojtovich made changes -
            Component/s Platform Debian [ 10136 ]
            Component/s Scripts & Clients [ 11002 ]
            Fix Version/s 10.0.21 [ 19406 ]
            Fix Version/s 10.1.6 [ 19401 ]
            Fix Version/s 10.0 [ 16000 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            jkrauss Jonas Krauss made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 70322 ] MariaDB v4 [ 149301 ]

            People

              svoj Sergey Vojtovich
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.