[MCOL-1141] command not found logged during install_calpont_mysql.sh Created: 2018-01-05  Updated: 2021-01-15

Status: Closed
Project: MariaDB ColumnStore
Component/s: installation
Affects Version/s: 1.1.3
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Sasha V Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Ubuntu16 repo install


Attachments: File calpont_mysql.sql     File install_calpont_mysql.sh    
Issue Links:
Duplicate
is duplicated by MCOL-1654 Querystats table is broken Closed

 Description   

During new server install from the Ubuntu16 repository, the /tmp/mysql_install.log has line

/usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh: line 27: rows: command not found

This is because /usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh has line

`rows` bigint,

https://github.com/mariadb-corporation/mariadb-columnstore-engine/blob/1.1-merge-up/dbcon/mysql/install_calpont_mysql.sh#L99



 Comments   
Comment by David Hill (Inactive) [ 2018-01-05 ]

I think this error happens when a MariaDB server library is installed on the server. so check to see if this package is installed and if so, You will need to remove before installing and configuring Columnstore

mariadb-libs

Comment by Sasha V [ 2018-01-15 ]

This error happens during fresh install of the new server. I verified that the error also affected 1.1.1 server install. As a result of this bug, the infinidb_querystats.querystats table is missing:

Server version: 10.2.10-MariaDB-log Columnstore 1.1.1-1
 
MariaDB [infinidb_querystats]> show tables;
+-------------------------------+
| Tables_in_infinidb_querystats |
+-------------------------------+
| priority                      |
| user_priority                 |
+-------------------------------+

This is because of the use of the --force switch on the line

$installdir/mysql/bin/mysql --defaults-extra-file=$df --force --user=root mysql 2>/tmp/mysql_install.log <<EOD

https://github.com/mariadb-corporation/mariadb-columnstore-engine/blob/1.1-merge-up/dbcon/mysql/install_calpont_mysql.sh#L27

To create the querystats table, I placed the CREATE TABLE command (that must have the backquoted `rows` line) into a querystats.sql file that was executed from the modified script install_calpont_mysql.sh.

Comment by Damon [ 2018-02-20 ]

Happening on a fresh install of 1.1.2-1. Loaded from the full version tar - Centos 7
Can someone post their work-around?

Comment by Sasha V [ 2018-02-21 ]

I replaced in-place the file /usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh with two attached files:

/usr/local/mariadb/columnstore/mysql/install_calpont_mysql.sh
/usr/local/mariadb/columnstore/mysql/calpont_mysql.sql

then, re-run the postConfigure.

Comment by Zdravelina Sokolovska (Inactive) [ 2019-01-22 ]

the problem seems to be fixed on dev 1.1.7

Generated at Thu Feb 08 02:26:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.