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

Columnstore table doesnt exist after upgrade from 1.2 to 1.5

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.5.2
    • Fix Version/s: None
    • Component/s: installation
    • Labels:
      None
    • Environment:
      centos 7 single server Amazon EC2 instance

      Description

      I performed an upgrade from 1.2.5 to 1.5.2 after creating a table in 1.2.5 and after the upgrade was completed, got an error saying table doesnt exist.

      MariaDB [david]> select * from tmp;
      ERROR 1815 (HY000): Internal error: IDB-2006: 'david.tmp' does not exist in Columnstore.
      MariaDB [david]>

      Followed this document

      https://mariadb.com/docs/deploy/upgrade-from-12-community-single-columnstore-cs105-centos7/#upgrade-from-12-community-single-columnstore-col15-cs105-centos7

      Complete process

      [root@ip-172-30-0-153 bin]# mcsmysql
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 10
      Server version: 10.3.16-MariaDB-log Columnstore 1.2.5-1

      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]> create database david;
      Query OK, 1 row affected (0.000 sec)

      MariaDB [(none)]> use david;
      Database changed
      MariaDB [david]> create table tmp ( c1 int) engine=columnstore;
      Query OK, 0 rows affected (0.622 sec)

      MariaDB [david]> insert into tmp values (1);
      Query OK, 1 row affected (0.126 sec)

      MariaDB [david]> select * tmp;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'tmp' at line 1
      MariaDB [david]> select * from tmp;
      ------

      c1

      ------

      1

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

      MariaDB [david]> exit
      Bye
      [root@ip-172-30-0-153 bin]#
      [root@ip-172-30-0-153 bin]#
      [root@ip-172-30-0-153 bin]#
      [root@ip-172-30-0-153 bin]#
      [root@ip-172-30-0-153 bin]#
      [root@ip-172-30-0-153 bin]#
      [root@ip-172-30-0-153 bin]# mcsmysql
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 11
      Server version: 10.3.16-MariaDB-log Columnstore 1.2.5-1

      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]> UNINSTALL PLUGIN infinidb;
      Query OK, 0 rows affected (0.000 sec)

      MariaDB [(none)]> UNINSTALL PLUGIN columnstore_tables;
      Query OK, 0 rows affected (0.000 sec)

      MariaDB [(none)]> UNINSTALL PLUGIN columnstore_columns;
      Query OK, 0 rows affected (0.000 sec)

      MariaDB [(none)]> UNINSTALL PLUGIN columnstore_extents;
      Query OK, 0 rows affected (0.000 sec)

      MariaDB [(none)]> UNINSTALL PLUGIN columnstore_files;
      Query OK, 0 rows affected (0.000 sec)

      MariaDB [(none)]> UNINSTALL PLUGIN columnstore;
      Query OK, 0 rows affected, 1 warning (0.000 sec)

      MariaDB [(none)]> exit
      Bye
      [root@ip-172-30-0-153 bin]# ma shutd y
      shutdownsystem Thu Jun 25 19:13:45 2020

      This command stops the processing of applications on all Modules within the MariaDB ColumnStore System

      Checking for active transactions

      Stopping System...
      Successful stop of System

      Shutting Down System...
      Successful shutdown of System

      [root@ip-172-30-0-153 bin]# sudo yum remove "mariadb-columnstore-*"
      Loaded plugins: fastestmirror
      Resolving Dependencies
      --> Running transaction check
      ---> Package mariadb-columnstore-client.x86_64 0:1.2.5-1.el7 will be erased
      ---> Package mariadb-columnstore-common.x86_64 0:1.2.5-1.el7 will be erased
      ---> Package mariadb-columnstore-gssapi-server.x86_64 0:1.2.5-1.el7 will be erased
      ---> Package mariadb-columnstore-libs.x86_64 0:1.2.5-1 will be erased
      ---> Package mariadb-columnstore-platform.x86_64 0:1.2.5-1 will be erased
      ---> Package mariadb-columnstore-rocksdb-engine.x86_64 0:1.2.5-1.el7 will be erased
      ---> Package mariadb-columnstore-server.x86_64 0:1.2.5-1.el7 will be erased
      ---> Package mariadb-columnstore-shared.x86_64 0:1.2.5-1.el7 will be erased
      ---> Package mariadb-columnstore-storage-engine.x86_64 0:1.2.5-1 will be erased
      ---> Package mariadb-columnstore-tokudb-engine.x86_64 0:1.2.5-1.el7 will be erased
      --> Finished Dependency Resolution

      Dependencies Resolved

      ===============================================================================================================================
      Package Arch Version Repository Size
      ===============================================================================================================================
      Removing:
      mariadb-columnstore-client x86_64 1.2.5-1.el7 installed 64 M
      mariadb-columnstore-common x86_64 1.2.5-1.el7 installed 703 k
      mariadb-columnstore-gssapi-server x86_64 1.2.5-1.el7 installed 48 k
      mariadb-columnstore-libs x86_64 1.2.5-1 installed 240 M
      mariadb-columnstore-platform x86_64 1.2.5-1 installed 113 M
      mariadb-columnstore-rocksdb-engine x86_64 1.2.5-1.el7 installed 297 M
      mariadb-columnstore-server x86_64 1.2.5-1.el7 installed 344 M
      mariadb-columnstore-shared x86_64 1.2.5-1.el7 installed 1.2 M
      mariadb-columnstore-storage-engine x86_64 1.2.5-1 installed 34 M
      mariadb-columnstore-tokudb-engine x86_64 1.2.5-1.el7 installed 19 M

      Transaction Summary
      ===============================================================================================================================
      Remove 10 Packages

      Installed size: 1.1 G
      Is this ok [y/N]: y
      Downloading packages:
      Running transaction check
      Running transaction test
      Transaction test succeeded
      Running transaction
      Warning: RPMDB altered outside of yum.
      Erasing : mariadb-columnstore-gssapi-server-1.2.5-1.el7.x86_64 1/10
      Erasing : mariadb-columnstore-tokudb-engine-1.2.5-1.el7.x86_64 2/10
      Erasing : mariadb-columnstore-rocksdb-engine-1.2.5-1.el7.x86_64 3/10

      Mariab Columnstore uninstall completed
      Erasing : mariadb-columnstore-platform-1.2.5-1.x86_64 4/10
      Erasing : mariadb-columnstore-server-1.2.5-1.el7.x86_64 5/10
      Erasing : mariadb-columnstore-client-1.2.5-1.el7.x86_64 6/10
      Erasing : mariadb-columnstore-shared-1.2.5-1.el7.x86_64 7/10
      Erasing : mariadb-columnstore-storage-engine-1.2.5-1.x86_64 8/10
      Erasing : mariadb-columnstore-common-1.2.5-1.el7.x86_64 9/10
      Erasing : mariadb-columnstore-libs-1.2.5-1.x86_64 10/10
      Verifying : mariadb-columnstore-rocksdb-engine-1.2.5-1.el7.x86_64 1/10
      Verifying : mariadb-columnstore-server-1.2.5-1.el7.x86_64 2/10
      Verifying : mariadb-columnstore-platform-1.2.5-1.x86_64 3/10
      Verifying : mariadb-columnstore-tokudb-engine-1.2.5-1.el7.x86_64 4/10
      Verifying : mariadb-columnstore-storage-engine-1.2.5-1.x86_64 5/10
      Verifying : mariadb-columnstore-common-1.2.5-1.el7.x86_64 6/10
      Verifying : mariadb-columnstore-shared-1.2.5-1.el7.x86_64 7/10
      Verifying : mariadb-columnstore-client-1.2.5-1.el7.x86_64 8/10
      Verifying : mariadb-columnstore-gssapi-server-1.2.5-1.el7.x86_64 9/10
      Verifying : mariadb-columnstore-libs-1.2.5-1.x86_64 10/10

      Removed:
      mariadb-columnstore-client.x86_64 0:1.2.5-1.el7 mariadb-columnstore-common.x86_64 0:1.2.5-1.el7
      mariadb-columnstore-gssapi-server.x86_64 0:1.2.5-1.el7 mariadb-columnstore-libs.x86_64 0:1.2.5-1
      mariadb-columnstore-platform.x86_64 0:1.2.5-1 mariadb-columnstore-rocksdb-engine.x86_64 0:1.2.5-1.el7
      mariadb-columnstore-server.x86_64 0:1.2.5-1.el7 mariadb-columnstore-shared.x86_64 0:1.2.5-1.el7
      mariadb-columnstore-storage-engine.x86_64 0:1.2.5-1 mariadb-columnstore-tokudb-engine.x86_64 0:1.2.5-1.el7

      Complete!
      [root@ip-172-30-0-153 bin]# rpm --query --all | grep -i -E "mariadb-columnstore"
      [root@ip-172-30-0-153 bin]# sudo yum install wget
      Loaded plugins: fastestmirror
      Determining fastest mirrors
      epel/x86_64/metalink | 16 kB 00:00:00

      • epel: dl.fedoraproject.org
        epel | 4.7 kB 00:00:00
        ultra-centos-7.4-base | 3.4 kB 00:00:00
        ultra-centos-7.4-extras | 3.3 kB 00:00:00
        ultra-centos-7.4-updates | 3.4 kB 00:00:00
        ultra-centos-7.x-glusterfs | 2.9 kB 00:00:00
        ultra-centos-7.x-java | 2.9 kB 00:00:00
        ultra-centos-7.x-newrelic-infra | 2.9 kB 00:00:00
        ultra-centos-7.x-newrelic-java | 2.9 kB 00:00:00
        ultra-centos-7.x-newrelic-monitoring | 2.9 kB 00:00:00
        ultra-centos-7.x-ultrarepo | 2.9 kB 00:00:00
        (1/7): epel/x86_64/group_gz | 95 kB 00:00:00
        (2/7): epel/x86_64/updateinfo | 1.0 MB 00:00:00
        (3/7): epel/x86_64/primary_db | 6.8 MB 00:00:00
        (4/7): ultra-centos-7.x-newrelic-monitoring/primary_db | 5.9 kB 00:00:01
        (5/7): ultra-centos-7.x-ultrarepo/primary_db | 8.6 kB 00:00:01
        (6/7): ultra-centos-7.x-newrelic-java/primary_db | 1.6 kB 00:00:01
        (7/7): ultra-centos-7.x-newrelic-infra/primary_db | 111 kB 00:00:01
        Package wget-1.14-15.el7_4.1.x86_64 already installed and latest version
        Nothing to do
        [root@ip-172-30-0-153 bin]# wget https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
        -2020-06-25 19:15:16- https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
        Resolving downloads.mariadb.com (downloads.mariadb.com)... 104.20.68.208, 172.67.32.229, 104.20.67.208, ...
        Connecting to downloads.mariadb.com (downloads.mariadb.com)|104.20.68.208|:443... connected.
        HTTP request sent, awaiting response... 200 OK
        Length: 19519 (19K) [application/octet-stream]
        Saving to: ‘mariadb_repo_setup’

      100%[=====================================================================================>] 19,519 --.-K/s in 0s

      2020-06-25 19:15:16 (90.2 MB/s) - ‘mariadb_repo_setup’ saved [19519/19519]

      [root@ip-172-30-0-153 bin]# echo "2de6253842f230bc554d3f5ab0c0dbf717caffbf45ae6893740707961c8407b7 mariadb_repo_setup" \
      > | sha256sum -c -
      mariadb_repo_setup: OK
      [root@ip-172-30-0-153 bin]# chmod +x mariadb_repo_setup
      [root@ip-172-30-0-153 bin]# sudo ./mariadb_repo_setup \
      > --mariadb-server-version="mariadb-10.5"
      [info] Repository file successfully written to /etc/yum.repos.d/mariadb.repo
      [info] Adding trusted package signing keys...
      [info] Successfully added trusted package signing keys
      [root@ip-172-30-0-153 bin]# sudo yum install MariaDB-server \
      > MariaDB-columnstore-engine
      Loaded plugins: fastestmirror
      Loading mirror speeds from cached hostfile

      • epel: dl.fedoraproject.org
        mariadb-main | 2.9 kB 00:00:00
        mariadb-maxscale | 2.4 kB 00:00:00
        mariadb-tools | 2.9 kB 00:00:00
        (1/3): mariadb-tools/7/x86_64/primary_db | 14 kB 00:00:00
        (2/3): mariadb-maxscale/7/x86_64/primary_db | 6.9 kB 00:00:00
        (3/3): mariadb-main/7/x86_64/primary_db | 62 kB 00:00:00
        Resolving Dependencies
        --> Running transaction check
        ---> Package MariaDB-columnstore-engine.x86_64 0:10.5.4-1.el7.centos will be installed
        --> Processing Dependency: libmariadb.so.3()(64bit) for package: MariaDB-columnstore-engine-10.5.4-1.el7.centos.x86_64
        ---> Package MariaDB-server.x86_64 0:10.5.4-1.el7.centos will be installed
        --> Processing Dependency: lsof for package: MariaDB-server-10.5.4-1.el7.centos.x86_64
        --> Processing Dependency: galera-4 for package: MariaDB-server-10.5.4-1.el7.centos.x86_64
        --> Processing Dependency: MariaDB-common for package: MariaDB-server-10.5.4-1.el7.centos.x86_64
        --> Processing Dependency: MariaDB-client for package: MariaDB-server-10.5.4-1.el7.centos.x86_64
        --> Processing Dependency: libpcre2-8.so.0()(64bit) for package: MariaDB-server-10.5.4-1.el7.centos.x86_64
        --> Running transaction check
        ---> Package MariaDB-client.x86_64 0:10.5.4-1.el7.centos will be installed
        ---> Package MariaDB-common.x86_64 0:10.5.4-1.el7.centos will be installed
        --> Processing Dependency: MariaDB-compat for package: MariaDB-common-10.5.4-1.el7.centos.x86_64
        ---> Package MariaDB-shared.x86_64 0:10.5.4-1.el7.centos will be installed
        ---> Package galera-4.x86_64 0:26.4.5-1.el7.centos will be installed
        --> Processing Dependency: socat for package: galera-4-26.4.5-1.el7.centos.x86_64
        ---> Package lsof.x86_64 0:4.87-4.el7 will be installed
        ---> Package pcre2.x86_64 0:10.23-2.el7 will be installed
        --> Running transaction check
        ---> Package MariaDB-compat.x86_64 0:10.5.4-1.el7.centos will be obsoleting
        ---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be obsoleted
        ---> Package socat.x86_64 0:1.7.3.2-2.el7 will be installed
        --> Finished Dependency Resolution

      Dependencies Resolved

      ===============================================================================================================================
      Package Arch Version Repository Size
      ===============================================================================================================================
      Installing:
      MariaDB-columnstore-engine x86_64 10.5.4-1.el7.centos mariadb-main 6.8 M
      MariaDB-compat x86_64 10.5.4-1.el7.centos mariadb-main 2.2 M
      replacing mariadb-libs.x86_64 1:5.5.56-2.el7
      MariaDB-server x86_64 10.5.4-1.el7.centos mariadb-main 26 M
      Installing for dependencies:
      MariaDB-client x86_64 10.5.4-1.el7.centos mariadb-main 13 M
      MariaDB-common x86_64 10.5.4-1.el7.centos mariadb-main 81 k
      MariaDB-shared x86_64 10.5.4-1.el7.centos mariadb-main 113 k
      galera-4 x86_64 26.4.5-1.el7.centos mariadb-main 9.5 M
      lsof x86_64 4.87-4.el7 ultra-centos-7.4-base 331 k
      pcre2 x86_64 10.23-2.el7 ultra-centos-7.4-base 201 k
      socat x86_64 1.7.3.2-2.el7 ultra-centos-7.4-base 290 k

      Transaction Summary
      ===============================================================================================================================
      Install 3 Packages (+7 Dependent packages)

      Total download size: 58 M
      Is this ok [y/d/N]: y
      Downloading packages:
      (1/10): MariaDB-client-10.5.4-1.el7.centos.x86_64.rpm | 13 MB 00:00:04
      (2/10): MariaDB-common-10.5.4-1.el7.centos.x86_64.rpm | 81 kB 00:00:00
      (3/10): MariaDB-columnstore-engine-10.5.4-1.el7.centos.x86_64.rpm | 6.8 MB 00:00:04
      (4/10): MariaDB-compat-10.5.4-1.el7.centos.x86_64.rpm | 2.2 MB 00:00:00
      (5/10): MariaDB-shared-10.5.4-1.el7.centos.x86_64.rpm | 113 kB 00:00:00
      (6/10): lsof-4.87-4.el7.x86_64.rpm | 331 kB 00:00:01
      (7/10): galera-4-26.4.5-1.el7.centos.x86_64.rpm | 9.5 MB 00:00:02
      (8/10): socat-1.7.3.2-2.el7.x86_64.rpm | 290 kB 00:00:00
      (9/10): MariaDB-server-10.5.4-1.el7.centos.x86_64.rpm | 26 MB 00:00:06
      (10/10): pcre2-10.23-2.el7.x86_64.rpm | 201 kB 00:00:05
      -------------------------------------------------------------------------------------------------------------------------------
      Total 5.0 MB/s | 58 MB 00:00:11
      Running transaction check
      Running transaction test
      Transaction test succeeded
      Running transaction
      Installing : pcre2-10.23-2.el7.x86_64 1/11
      Installing : lsof-4.87-4.el7.x86_64 2/11
      Installing : MariaDB-common-10.5.4-1.el7.centos.x86_64 3/11
      Installing : MariaDB-compat-10.5.4-1.el7.centos.x86_64 4/11
      Installing : MariaDB-client-10.5.4-1.el7.centos.x86_64 5/11
      Installing : MariaDB-shared-10.5.4-1.el7.centos.x86_64 6/11
      Installing : socat-1.7.3.2-2.el7.x86_64 7/11
      Installing : galera-4-26.4.5-1.el7.centos.x86_64 8/11
      Installing : MariaDB-server-10.5.4-1.el7.centos.x86_64 9/11

      Two all-privilege accounts were created.
      One is root@localhost, it has no password, but you need to
      be system 'root' user to connect. Use, for example, sudo mysql
      The second is mysql@localhost, it has no password either, but
      you need to be the system 'mysql' user to connect.
      After connecting you can set the password, if you would need to be
      able to connect as any of these users with a password and without sudo

      See the MariaDB Knowledgebase at https://mariadb.com/kb or the
      MySQL manual for more instructions.

      Please report any problems at https://mariadb.org/jira

      The latest information about MariaDB is available at https://mariadb.org/.
      You can find additional information about the MySQL part at:
      https://dev.mysql.com
      Consider joining MariaDB's strong and vibrant community:
      https://mariadb.org/get-involved/

      Installing : MariaDB-columnstore-engine-10.5.4-1.el7.centos.x86_64 10/11
      checking for engine columnstore...
      columnstore exists
      Populating the engine initial system catalog.
      Erasing : 1:mariadb-libs-5.5.56-2.el7.x86_64 11/11
      Verifying : MariaDB-client-10.5.4-1.el7.centos.x86_64 1/11
      Verifying : lsof-4.87-4.el7.x86_64 2/11
      Verifying : MariaDB-server-10.5.4-1.el7.centos.x86_64 3/11
      Verifying : pcre2-10.23-2.el7.x86_64 4/11
      Verifying : MariaDB-columnstore-engine-10.5.4-1.el7.centos.x86_64 5/11
      Verifying : MariaDB-shared-10.5.4-1.el7.centos.x86_64 6/11
      Verifying : MariaDB-compat-10.5.4-1.el7.centos.x86_64 7/11
      Verifying : galera-4-26.4.5-1.el7.centos.x86_64 8/11
      Verifying : socat-1.7.3.2-2.el7.x86_64 9/11
      Verifying : MariaDB-common-10.5.4-1.el7.centos.x86_64 10/11
      Verifying : 1:mariadb-libs-5.5.56-2.el7.x86_64 11/11

      Installed:
      MariaDB-columnstore-engine.x86_64 0:10.5.4-1.el7.centos MariaDB-compat.x86_64 0:10.5.4-1.el7.centos
      MariaDB-server.x86_64 0:10.5.4-1.el7.centos

      Dependency Installed:
      MariaDB-client.x86_64 0:10.5.4-1.el7.centos MariaDB-common.x86_64 0:10.5.4-1.el7.centos
      MariaDB-shared.x86_64 0:10.5.4-1.el7.centos galera-4.x86_64 0:26.4.5-1.el7.centos
      lsof.x86_64 0:4.87-4.el7 pcre2.x86_64 0:10.23-2.el7
      socat.x86_64 0:1.7.3.2-2.el7

      Replaced:
      mariadb-libs.x86_64 1:5.5.56-2.el7

      Complete!
      [root@ip-172-30-0-153 bin]# sudo mcsSetConfig CrossEngineSupport Host 127.0.0.1
      [root@ip-172-30-0-153 bin]# sudo mv /etc/my.cnf.d/server.cnf /etc/my.cnf.d/server.cnf.original
      [root@ip-172-30-0-153 bin]# sudo mv /etc/my.cnf.d/server.cnf.rpmsave /etc/my.cnf.d/server.cnf
      mv: cannot stat ‘/etc/my.cnf.d/server.cnf.rpmsave’: No such file or directory
      [root@ip-172-30-0-153 bin]#
      [root@ip-172-30-0-153 bin]#
      [root@ip-172-30-0-153 bin]# sudo mv /var/lib/mysql /var/lib/mysql_default
      [root@ip-172-30-0-153 bin]# sudo mv /usr/local/mariadb/columnstore/mysql/db /var/lib/mysql
      [root@ip-172-30-0-153 bin]# sudo ls /usr/local/mariadb/columnstore | grep "data[0-9]+"
      [root@ip-172-30-0-153 bin]# sudo ls /usr/local/mariadb/columnstore | grep "data[0-9]+" data1
      grep: data1: No such file or directory
      [root@ip-172-30-0-153 bin]# sudo ls /usr/local/mariadb/columnstore | grep "data[0-9]+"
      [root@ip-172-30-0-153 bin]# sudo mv /usr/local/mariadb/columnstore/data1 /var/lib/columnstore/data1
      [root@ip-172-30-0-153 bin]# cd
      [root@ip-172-30-0-153 ~]# cat .bash_
      .bash_history .bash_logout .bash_profile
      [root@ip-172-30-0-153 ~]# cat .bash_profile

      1. .bash_profile
      1. Get the aliases and functions
        if [ -f ~/.bashrc ]; then
        . ~/.bashrc
        fi
      1. User specific environment and startup programs

      PATH=$PATH:$HOME/bin

      export PATH
      [root@ip-172-30-0-153 ~]# cat /etc/profile.d/
      256term.csh colorgrep.sh columnstoreAlias.sh lang.sh sh.local which2.csh
      256term.sh colorls.csh csh.local less.csh vim.csh which2.sh
      colorgrep.csh colorls.sh lang.csh less.sh vim.sh
      [root@ip-172-30-0-153 ~]# rm -f /etc/profile.d/columnstoreAlias.sh
      [root@ip-172-30-0-153 ~]#
      [root@ip-172-30-0-153 ~]# sudo systemctl start mariadb-columnstore
      [root@ip-172-30-0-153 ~]# sudo systemctl start mariadb
      [root@ip-172-30-0-153 ~]# sudo systemctl enable mariadb-columnstore
      [root@ip-172-30-0-153 ~]# sudo systemctl enable mariadb
      Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
      [root@ip-172-30-0-153 ~]# sudo mariadb-upgrade
      Phase 1/7: Checking and upgrading mysql database
      Processing databases
      mysql
      mysql.column_stats OK
      mysql.columns_priv OK
      mysql.db OK
      mysql.event OK
      mysql.func OK
      mysql.gtid_slave_pos OK
      mysql.help_category OK
      mysql.help_keyword OK
      mysql.help_relation OK
      mysql.help_topic OK
      mysql.host OK
      mysql.index_stats OK
      mysql.innodb_index_stats OK
      mysql.innodb_table_stats OK
      mysql.plugin OK
      mysql.proc OK
      mysql.procs_priv OK
      mysql.proxies_priv OK
      mysql.roles_mapping OK
      mysql.servers OK
      mysql.table_stats OK
      mysql.tables_priv OK
      mysql.time_zone OK
      mysql.time_zone_leap_second OK
      mysql.time_zone_name OK
      mysql.time_zone_transition OK
      mysql.time_zone_transition_type OK
      mysql.transaction_registry OK
      mysql.user OK
      Phase 2/7: Installing used storage engines... Skipped
      Phase 3/7: Fixing views
      Phase 4/7: Running 'mysql_fix_privilege_tables'
      Phase 5/7: Fixing table and database names
      Phase 6/7: Checking and upgrading tables
      Processing databases
      calpontsys
      calpontsys.syscolumn
      Error : Unknown storage engine 'InfiniDB'
      error : Corrupt
      calpontsys.systable
      Error : Unknown storage engine 'InfiniDB'
      error : Corrupt
      columnstore_info
      david
      david.tmp OK
      infinidb_querystats
      infinidb_querystats.priority OK
      infinidb_querystats.querystats OK
      infinidb_querystats.user_priority OK
      infinidb_vtable
      information_schema
      performance_schema
      test

      Repairing tables
      calpontsys.syscolumn
      Error : Unknown storage engine 'InfiniDB'
      error : Corrupt
      calpontsys.systable
      Error : Unknown storage engine 'InfiniDB'
      error : Corrupt
      Phase 7/7: Running 'FLUSH PRIVILEGES'
      OK
      [root@ip-172-30-0-153 ~]# sudo systemctl status mariadb-columnstore.service
      ● mariadb-columnstore.service - mariadb-columnstore
      Loaded: loaded (/usr/lib/systemd/system/mariadb-columnstore.service; enabled; vendor preset: disabled)
      Active: active (exited) since Thu 2020-06-25 19:17:00 UTC; 6min ago
      Main PID: 8311 (code=exited, status=0/SUCCESS)
      Memory: 0B
      CGroup: /system.slice/mariadb-columnstore.service

      Jun 25 19:16:53 ip-172-30-0-153.ec2.internal systemd[1]: Starting mariadb-columnstore...
      Jun 25 19:16:53 ip-172-30-0-153.ec2.internal mariadb-columnstore-start.sh[8311]: Job for mcs-storagemanager.service failed...s.
      Jun 25 19:17:00 ip-172-30-0-153.ec2.internal systemd[1]: Started mariadb-columnstore.
      Hint: Some lines were ellipsized, use -l to show in full.
      [root@ip-172-30-0-153 ~]# mariadb
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 17
      Server version: 10.5.4-MariaDB MariaDB Server

      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]> show databases;
      ---------------------

      Database

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

      calpontsys
      columnstore_info
      david
      infinidb_querystats
      infinidb_vtable
      information_schema
      mysql
      performance_schema
      test

      ---------------------
      9 rows in set (0.000 sec)

      MariaDB [(none)]> use david
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A

      Database changed
      MariaDB [david]> show tables;
      -----------------

      Tables_in_david

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

      tmp

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

      MariaDB [david]> select * from tmp;
      ERROR 1815 (HY000): Internal error: IDB-2006: 'david.tmp' does not exist in Columnstore.
      MariaDB [david]>
      MariaDB [david]> exit
      Bye
      [root@ip-172-30-0-153 ~]# ll /var/lib/mysql
      total 123084
      rw-rw--- 1 mysql mysql 73728 Jun 25 19:22 aria_log.00000001
      rw-rw--- 1 mysql mysql 52 Jun 25 19:13 aria_log_control
      drwx------ 2 mysql mysql 61 Jun 25 19:09 calpontsys
      drwx------ 2 mysql mysql 20 Jun 25 19:09 columnstore_info
      drwx------ 2 mysql mysql 35 Jun 25 19:13 david
      rw-rw--- 1 mysql mysql 1066 Jun 25 19:13 ib_buffer_pool
      rw-rw--- 1 mysql mysql 12582912 Jun 25 19:22 ibdata1
      rw-rw--- 1 mysql mysql 100663296 Jun 25 19:22 ib_logfile0
      rw-rw--- 1 mysql mysql 12582912 Jun 25 19:22 ibtmp1
      drwx------ 2 mysql mysql 154 Jun 25 19:09 infinidb_querystats
      drwx------ 2 mysql mysql 20 Jun 25 19:09 infinidb_vtable
      rw-rw--- 1 mysql mysql 9138 Jun 25 19:13 ip-172-30-0-153.ec2.internal.err
      rw-rw--- 1 mysql mysql 5 Jun 25 19:22 ip-172-30-0-153.pid
      rw-rw--- 1 mysql mysql 0 Jun 25 19:09 multi-master.info
      drwx-x-x 2 mysql mysql 4096 Jun 25 19:22 mysql
      rw-rw--- 1 mysql mysql 22920 Jun 25 19:09 mysql-bin.000001
      rw-rw--- 1 mysql mysql 365 Jun 25 19:11 mysql-bin.000002
      rw-rw--- 1 mysql mysql 1076 Jun 25 19:13 mysql-bin.000003
      rw-rw--- 1 mysql mysql 171 Jun 25 19:12 mysql-bin.index
      rw-rw--- 1 mysql mysql 7 Jun 25 19:13 mysql-bin.state
      srwxrwxrwx 1 mysql mysql 0 Jun 25 19:22 mysql.sock
      rw-rr- 1 root root 15 Jun 25 19:22 mysql_upgrade_info
      drwx------ 2 mysql mysql 20 Jun 25 19:22 performance_schema
      drwxr-xr-x 2 mysql mysql 6 Jun 25 19:09 test
      [root@ip-172-30-0-153 ~]# ll /var/lib/columnstore/data1
      total 0
      drwxr-xr-x 3 root root 21 Jun 25 19:17 000.dir
      drwxr-xr-x 4 root root 65 Jun 25 19:14 data1
      drwxr-xr-t 3 root root 18 Jun 25 19:16 systemFiles
      [root@ip-172-30-0-153 ~]#

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            hill David Hill
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: