[#MCOL-1064] Multi server upgrade ERROR in replication setup when idbrep user exists

During multi-server system upgrade from InfiniDB 4.x to MariaDB ColumnStore 1.1.2 the postConfigure step

Run MariaDB ColumnStore Replication Setup..

fails with

ERROR: Error return in running the MariaDB ColumnStore Master replication, check /tmp/master-rep*.logs on pm1

 MariaDB ColumnStore Replication Setup Failed, check logs

 IMPORTANT: Once issue has been resolved, rerun postConfigure

The /tmp/master-rep-status-172.18.0.2.log has:

Create Replication User idbrep for node 172.18.0.2

CREATE USER IF NOT EXISTS 'idbrep'@'172.18.0.2' IDENTIFIED BY 'Calpont1';

GRANT REPLICATION SLAVE ON *.* TO 'idbrep'@'172.18.0.2';

Grant table access for idbrep for node 172.18.0.2

use mysql

grant all on *.* to 'idbrep'@'172.18.0.2' identified by 'Calpont1';

grant REPLICATION SLAVE on *.* to 'idbrep'@'172.18.0.2' identified by 'Calpont1';

ERROR 1045 (28000) at line 2: Access denied for user 'root'@'localhost' (using password: NO)

After replacing two lines:

grant all on *.* to '$repUser'@'$hostipaddr' identified by 'Calpont1';

grant REPLICATION SLAVE on *.* to '$repUser'@'$hostipaddr' identified by 'Calpont1';

grant all on infinidb_vtable to '$repUser'@'$hostipaddr' identified by 'Calpont1';

In a clean install (not upgrade), the script creates the replication user successfully:

 show grants for `idbrep`@`172.18.0.5`;

+----------------------------------------------------------------------------------+

| Grants for idbrep@172.18.0.5                                                     |

+----------------------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'idbrep'@'172.18.0.5' IDENTIFIED BY PASSWORD '*x' |

+----------------------------------------------------------------------------------+

Does the MariaDB ColumnsStore replication user needs such broad privileges?

[MCOL-1064] Multi server upgrade ERROR in replication setup when idbrep user exists Created: 2017-11-30 Updated: 2022-11-05 Resolved: 2022-11-05
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	installation
Affects Version/s:	1.1.2
Fix Version/s:	Icebox