[MCOL-475] Error in script /usr/local/mariadb/columnstore/bin/rsync.sh Created: 2016-12-20  Updated: 2017-01-20  Resolved: 2017-01-20

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

Type: Bug Priority: Major
Reporter: Zeng Chun Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS release 6.5

Issue Links:
Relates
relates to MCOL-467 replication setup issues when adding ... Closed
Sprint: 2016-25, 2017-01, 2017-2

 Description   

Recently, I upgraded the MariaDB Columnstore from 1.0.5 to 1.0.6. It is failed at the step of setting the Replication configuration between UM1 and UM2. I found an error in the script /usr/local/mariadb/columnstore/bin/rsync.sh. I removed the line 25 and the line 57 from the original script so that the postConfigure finished successfully. Thanks.

In addition, the setting of AllowVarbinary of WriteEngine in the Columnstore.xml.rpmsave disappeared in the upgraded Columnstore.xml. Please help investigate this issue. Thanks.

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

It appears that you must use the alter table column syntax which is accepted and updates the comment but doesn't reset the sequence counter:

create table t1(i int not null, c char(4)) engine=columnstore comment='autoincrement=i';

create text file with values:
1|ABC
2|DEF

cpimport test t1 data1.txt

alter table t1 change i i int comment 'autoincrement=i,3';

insert into t1 values (0, 'XYZ') will result in i value of 1 not 3.

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

fixed in repo 1.0.6.1

commit 3844b1e26afc55fd72f0d1669b197eee55252176
Author: David Hill <david.hill@mariadb.com>
Date: Wed Dec 21 10:18:48 2016 -0600

MCOL-475 - remove set username on ssh

oam/install_scripts/rsync.sh | 1 -

Comment by David Hill (Inactive) [ 2017-01-09 ]

pull request done

Comment by Ben Thompson (Inactive) [ 2017-01-11 ]

Reviewed and merged

Comment by David Hill (Inactive) [ 2017-01-16 ]

no sure mysql replication works on root user and non-root user install, rsych script will be the first script that runs. check for errors on the pm1 log file

Comment by Daniel Lee (Inactive) [ 2017-01-18 ]

Build tested: Github source build

[root@localhost mariadb-columnstore-server]# git show
commit 83b0e5c54a644bc31461752cf73f0e1140586d39
Merge: b975814 93c1c7e
Author: david hill <david.hill@mariadb.com>
Date: Thu Jan 12 09:27:28 2017 -0600

Merge pull request #26 from mariadb-corporation/MCOL-500

Update README.md

[root@localhost mariadb-columnstore-server]# cd mariadb-columnstore-engine/
[root@localhost mariadb-columnstore-engine]# git show
commit dec640a6ac791093b978b4e914d5d66e4ce35f33
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jan 18 15:11:01 2017 +0000

Update README.md for 1.0.7

Line 57 in the original rsync.sh was not removed. That is an extra "}" character.

Comment by Daniel Lee (Inactive) [ 2017-01-20 ]

Build verified: 1.0.7-1

mcsadmin> getsoft
getsoftwareinfo Fri Jan 20 23:45:07 2017

Name : mariadb-columnstore-platform
Version : 1.0.7
Release : 1
Architecture: x86_64
Install Date: Fri 20 Jan 2017 10:44:15 PM UTC
Group : Applications/Databases
Size : 10001348
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.0.7-1.src.rpm

Verified the last extra } has been removed.

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