Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Do
-
1.1.2
-
None
-
docker Ubuntu 16
Description
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';
|
in the script:
https://github.com/mariadb-corporation/mariadb-columnstore-engine/blob/master/oam/install_scripts/master-rep-infinidb.sh#L68
with line:
grant all on infinidb_vtable to '$repUser'@'$hostipaddr' identified by 'Calpont1';
|
from
https://github.com/infinidb/infinidb/blob/master/oam/install_scripts/master-rep-infinidb.sh#L68
the postConfigure completed successfully, with master-slave replication up and running.
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?
Attachments
Issue Links
- relates to
-
-
- Closed
-