Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
1.5.2
-
None
-
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
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
- .bash_profile
- Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
- 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 ~]#