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

calshowpartitions no reporting any partition

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.1.6
    • Icebox
    • N/A
    • None

    Description

      Customer report:

      calshowpartitions no reporting any partition

      We have right now an issue with our MariaDB Columnstore installation.

      System doesn't report any partition with any table (although almost all tables have millions of records). Response is always empty:

      For instance:
      MariaDB [(none)]> select calshowpartitions('cable','amp', 'fecha');
      ------------------------------------------------------------------------------

      calshowpartitions('cable','amp', 'fecha')

      ------------------------------------------------------------------------------

      Part# Min Max Status

      ------------------------------------------------------------------------------
      1 row in set (0.17 sec)

      We use this information to check with partitions we can drop (the oldest ones) so we currently we are not dropping any partition for any table, Right now, our data filesystem is completely full and we can't add any data to our DB.

      As additional information, in case it is related, recently we had an issue derived from "umask" configuration. Administrators change this value and DB could not start because file "Columstore.xml" was owned by "root" with no read permission to other users (mysql in this case). Umask is correct right now as required.

      We think it must be related (perhaps another file with no permissions to "mysql" user), but we don't know.

      Attachments

        Activity

          People

            Unassigned Unassigned
            hill David Hill (Inactive)
            Votes:
            0 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.