Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-340

Logging fails totally after removing the log files

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.0.3
    • Icebox
    • ?
    • None
    • Centos7.2

    Description

      After removing the log files: debug.log warning.log err.log info.log I can't get the logging to work again. Even after creating the files again.

      Before I did anything:

      [root@tgw-qxdr3 columnstore]# pwd
      /var/log/mariadb/columnstore

      [root@tgw-qxdr3 columnstore]# ls -la debug.log warning.log err.log info.log
      total 6112
      drwxr-xr-x 5 root root 4096 Sep 30 03:30 .
      drwxr-x---. 3 mysql mysql 4096 Sep 27 07:54 ..
      -rwxr-xr-x 1 root root 2076488 Sep 30 05:08 debug.log
      -rwxr-xr-x 1 root root 0 Sep 30 03:30 err.log
      -rwxr-xr-x 1 root root 2073658 Sep 30 05:08 info.log
      -rwxr-xr-x 1 root root 2072205 Sep 30 05:08 warning.log

      Then I removed the files:
      [root@tgw-qxdr3 columnstore]# rm -f debug.log warning.log err.log info.log

      And restarted columnstore:
      [root@tgw-qxdr3 columnstore]# mcsadmin restartSystem y
      restartsystem Fri Sep 30 05:56:25 2016

      System being restarted now ...
      Successful restart of System

      Here you would think that the removed log files should have been created again, but that never happened.

      [root@tgw-qxdr3 columnstore]# ls -la debug.log warning.log err.log info.log
      ls: cannot access debug.log: No such file or directory
      ls: cannot access warning.log: No such file or directory
      ls: cannot access err.log: No such file or directory
      ls: cannot access info.log: No such file or directory

      Here's the log configuration:

      mscadmin> getLogConfig
      getlogconfig Fri Sep 30 05:38:30 2016
      MariaDB Columnstore System Log Configuration Data
      System Logging Configuration File being used: /etc/rsyslog.d/49-columnstore.conf
      Module Configured Log Levels
      ------ ---------------------------------------
      pm1 Critical Error Warning Info Debug

      [root@tgw-qxdr3 columnstore]# cat /etc/rsyslog.d/49-columnstore.conf

      1. MariaDb Columnstore Database Platform Logging
        local1.crit -/var/log/mariadb/columnstore/crit.log
        local1.err -/var/log/mariadb/columnstore/err.log
        local1.warning -/var/log/mariadb/columnstore/warning.log
        local1.info -/var/log/mariadb/columnstore/info.log
        local1.debug -/var/log/mariadb/columnstore/debug.log

      And even after creating the files manually and a restartSystem, no logging occurs:

      [root@tgw-qxdr3 columnstore]# touch err.log warning.log debug.log info.log
      [root@tgw-qxdr3 columnstore]# chmod 755 err.log warning.log debug.log info.log

      [root@tgw-qxdr3 columnstore]# mcsadmin restartSystem y
      restartsystem Fri Sep 30 06:05:02 2016

      System being restarted now .............
      Successful restart of System

      [root@tgw-qxdr3 columnstore]# ls -la debug.log warning.log err.log info.log
      -rwxr-xr-x 1 root root 0 Sep 30 06:02 debug.log
      -rwxr-xr-x 1 root root 0 Sep 30 06:01 err.log
      -rwxr-xr-x 1 root root 0 Sep 30 06:01 info.log
      -rwxr-xr-x 1 root root 0 Sep 30 06:01 warning.log

      Attachments

        Activity

          People

            dthompson David Thompson (Inactive)
            daniel.wikman@polystar.com Daniel Wikman
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.