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

Lost all columnstore tables after reboot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Not a Bug
    • 1.1.2
    • Icebox
    • ProcMgr
    • None
    • 2 UM and 2 PM in Vmware environment with NFS

    Description

      Hi all,
      after execute RestartSystem, all tables with Engine Columnstore are lost (only data),but in the PM storage the data exist (extent level):
      [root@dwh-cstore02 dbrm]# df -h
      Filesystem Size Used Avail Use% Mounted on
      /dev/mapper/vg_mysql-mysql_us_data 197G 33G 155G 18% /usr/local/mariadb/columnstore/mysql/db
      172.16.30.215:/vol/vol_cstore01 300G 204G 97G 68% /usr/local/mariadb/columnstore/data1

      In the debug.log i see this query:
      Start SQL statement: select objectid,columnname from syscolumn where schema='c6msg' and tablename='c6_messaggio_in' --columnRIDs/FE; ||

      But the table syscolumn not exist in the all databases (mysql,information_schema and infini_vtable).
      it would seem that the catalog that relates the tables of type columnstore has been lost and consequently I can not find more data.
      Table names are found but without data.

      I've upload the support report.
      Thanks.
      Regards.
      Nicola

      Attachments

        Activity

          People

            Unassigned Unassigned
            nbattista89 Nicola
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.