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

Improve error message: "Failed to open file: /var/lib/columnstore/data1/systemFiles/dbrm/tablelocks"

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.5.3
    • N/A
    • N/A
    • None

    Description

      I'm testing multi-node ColumnStore on Ubuntu 20.04 with MariaDB Enterprise Server 10.5.4-2 and ColumnStore 1.5.3.

      When I try to add a second node to the cluster, the syslog contains errors like this:

      Jul 30 23:07:47 mcs2 IDBFile[6621]: 47.659400 |0|0|0| D 35 CAL0002: Failed to open file: /var/lib/columnstore/data1/systemFiles/dbrm/tablelocks, exception: unable to open Buffered file  
      Jul 30 23:07:47 mcs2 controllernode[6621]: 47.659469 |0|0|0| D 29 CAL0000: TableLockServer::load(): could not open the save file/var/lib/columnstore/data1/systemFiles/dbrm/tablelocks
      

      It is true that this file does not exist:

      $ sudo ls -l /var/lib/columnstore/data1/systemFiles/dbrm/tablelocks
      ls: cannot access '/var/lib/columnstore/data1/systemFiles/dbrm/tablelocks': No such file or directory
      

      This error happens every time the mcs-controllernode process is started on a non-primary node:

      $ sudo systemctl restart mcs-controllernode
      $ sudo systemctl status mcs-controllernode
      ● mcs-controllernode.service - mcs-controllernode
           Loaded: loaded (/lib/systemd/system/mcs-controllernode.service; static; vendor preset: enabled)
           Active: active (running) since Mon 2020-08-03 22:15:07 UTC; 1s ago
         Main PID: 18879 (controllernode)
            Tasks: 2 (limit: 1074)
           Memory: 3.2M
           CGroup: /system.slice/mcs-controllernode.service
                   └─18879 /usr/bin/controllernode fg
       
      Aug 03 22:15:07 mcs-ubuntu2004-3 systemd[1]: Started mcs-controllernode.
      Aug 03 22:15:07 mcs-ubuntu2004-3 IDBFile[18879]: 07.994772 |0|0|0| D 35 CAL0002: Failed to open file: /var/lib/columnstore/data1/systemFiles/dbrm/tablelocks, exception: unable to open Buffered file
      Aug 03 22:15:07 mcs-ubuntu2004-3 controllernode[18879]: 07.995245 |0|0|0| D 29 CAL0000: TableLockServer::load(): could not open the save file/var/lib/columnstore/data1/systemFiles/dbrm/tablelocks
      

      I have been told that this is probably "normal" for a non-primary node. If so, then the error message should be improved to clarify that this error is not serious.

      If the mcs-controllernode process isn't supposed to run at all on non-primary nodes, then it might be best to avoid starting the process on those nodes in general. Why is ColumnStore starting a process that it doesn't need?

      Attachments

        Issue Links

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              GeoffMontee Geoff Montee (Inactive)
              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.