[MCOL-460] upgrade with root pwd does not create columnstore_info database and upgrade info_schema Created: 2016-12-11  Updated: 2016-12-13  Resolved: 2016-12-13

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

Type: Bug Priority: Critical
Reporter: David Thompson (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2016-24

 Description   

Installled 1.0.4 and set a root password. Performed upgrade to 1.0.6 using guidelines in 1.0.5 upgrade to upgrade with root password set. I suspect this will be the same with or without root password but just in case mentioning it.

After upgrade to 1.0.6, the new IS stored procedures don't run because there is no columnstore_info database created.

 Comments   
Comment by David Thompson (Inactive) [ 2016-12-11 ]

Running mysql/columnstore_info.sql to create the db also fails because the changes in information_schema are also missing.

Comment by David Thompson (Inactive) [ 2016-12-11 ]

this was tested on single server centos 7 rpm install.

Comment by David Thompson (Inactive) [ 2016-12-11 ]

Also behaves this way with 105 -> 106 when root password set for root@localhost in 105. Upgrade with no root pwd from 105 to 106 is ok.

Comment by Andrew Hutchings (Inactive) [ 2016-12-12 ]

Hill to review pull request as I suspect he knows that code best.

Once merged we should document in the upgrade instructions to use "postConfigure -mp PASSWORD" if the root password has changed.

Comment by David Hill (Inactive) [ 2016-12-12 ]

fix to postConfigure -mp was backed up.. Fixed in post-mysq-install script, it wasnt recalling the mysql_calpont_install script when a password existed in .my.cnf

commit f88164ed640aba795d66d0933045189a62fb0d6c
Author: David Hill <david.hill@mariadb.com>
Date: Mon Dec 12 10:26:29 2016 -0600

MCOL-460 - fix issue where the ./my/cnf password wasnt being used in retry

oam/install_scripts/post-mysql-install | 1 +
1 file changed, 1 insertion

Comment by David Hill (Inactive) [ 2016-12-12 ]

testing

single and multi-node server upgrade test for 1.0.4 and 1.0.5 to 1.0.6

make sure DB columnstire_info exist

Comment by David Hill (Inactive) [ 2016-12-12 ]

passed my testing of single-server and multi-node

Comment by David Hill (Inactive) [ 2016-12-13 ]

tested on single and multi-node

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