Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.2.5
-
None
Description
Customer trying to remove a pm and a dbroot from their system and getting the error that dbroot is not empty even though they did a redistributedata start remove 3.
Maybe the procedure on how Im having them do it is incorrect.
here is the full process i ran. it seems to still have failed even though it allowed me to remove the module it says the dbroot has data.
mcsadmin> suspendDatabaseWrites
suspenddatabasewrites Fri Dec 20 16:32:34 2019
This command suspends the DDL/DML writes to the MariaDB ColumnStore Database
Do you want to proceed: (y or n) [n]: y
Suspend MariaDB Columnstore Database Writes Request successfully completed
mcsadmin> redistributedata start remove 3
redistributedata Fri Dec 20 16:32:47 2019
redistributeData START
Source dbroots: 1 2 3
Destination dbroots: 1 2 3
WriteEngineServer returned status 1: Cleared.
WriteEngineServer returned status 2: Redistribute is started.
mcsadmin> redistributedata status
redistributedata Fri Dec 20 16:32:55 2019
WriteEngineServer returned status 3: Redistribute is finished.
0 success, 0 skipped, 0 failed.
Total time: 3 seconds.
mcsadmin> resumeDatabaseWrites
resumedatabasewrites Fri Dec 20 16:33:37 2019
This command resumes the DDL/DML writes to the MariaDB ColumnStore Database
Do you want to proceed: (y or n) [n]: y
Resume MariaDB ColumnStore Database Writes Request successfully completed
mcsadmin> stopsystem y
stopsystem Fri Dec 20 16:33:42 2019
This command stops the processing of applications on all Modules within the MariaDB ColumnStore System
Checking for active transactions
System being stopped now...
Successful stop of System
mcsadmin> unassignDbrootPmConfig 3 pm3
unassigndbrootpmconfig Fri Dec 20 16:34:19 2019
DBRoot IDs assigned to 'pm3' = 3
Changes being applied...
DBRoot IDs unassigned from 'pm3' = 3
DBRoot IDs assigned to 'pm3' =
Successfully Unassigned DBRoots
mcsadmin> removemodule pm3
removemodule Fri Dec 20 16:34:27 2019
!!!!! DESTRUCTIVE COMMAND !!!!!
This command removes module(s) from the MariaDB ColumnStore System
Do you want to proceed: (y or n) [n]: y
Removing Module(s) pm3, please wait...
Remove Module successfully completed
mcsadmin> startsystem
startsystem Fri Dec 20 16:34:39 2019
System being started, please wait...
Successful start of System
mcsadmin> removedbroot 3
removedbroot Fri Dec 20 16:35:50 2019
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
BRMShmImpl::BRMShmImpl(): retrying on size==0
No such file or directory
ERROR: isDBRootEmpty API error, dbroot #3 :No such file or directory
ERROR: Failed remove, dbroot #3 is not empty
-
-
-
- removeDbroot Failed: API Failure return in removeDbroot API
-
-
Error logs
==> mcsadmin.log <==
Fri Dec 20 16:35:50 2019: removedbroot 3
==> crit.log <==
Dec 20 16:35:55 ip-172-22-0-100 controllernode[28064]: 55.974902 |0|0|0| C 29 CAL0000: BRMShmImpl::BRMShmImpl(): retrying on size==0
==> debug.log <==
Dec 20 16:35:55 ip-172-22-0-100 controllernode[28064]: 55.974902 |0|0|0| C 29 CAL0000: BRMShmImpl::BRMShmImpl(): retrying on size==0
==> err.log <==
Dec 20 16:35:55 ip-172-22-0-100 controllernode[28064]: 55.974902 |0|0|0| C 29 CAL0000: BRMShmImpl::BRMShmImpl(): retrying on size==0
==> info.log <==
Dec 20 16:35:55 ip-172-22-0-100 controllernode[28064]: 55.974902 |0|0|0| C 29 CAL0000: BRMShmImpl::BRMShmImpl(): retrying on size==0
==> warning.log <==
Dec 20 16:35:55 ip-172-22-0-100 controllernode[28064]: 55.974902 |0|0|0| C 29 CAL0000: BRMShmImpl::BRMShmImpl(): retrying on size==0