{question}
Why do we get the below highlighted message "database attachments will be modified on resume" during the resume operation in a workspace?
{question}
{answer}
In this article, we are going to discuss why we receive the "database attachment will be modified on resume" message when we try to resume a workspace,
Reason: If databases were connected to a workspace as RW before suspend and then if we attach the same database as RW to some other workspace. Later when we try to resume the suspended workspace, it shows that message. Because before suspending the DBs were attached as RW to it, and now while resuming it can't attach as RW as it is already attached as RW to some other workspace.
Note: Database can be attached as read/write to one workspace only.
Here is an example to understand the behaviour,
Example Workspace Topology:
- We have 2 workspaces below (
workspace-1
andworkspace-2
). - 4 databases (
database_1
,database_2
,database_3
,database_4
). - All 4 databases are attached as RW to
workspace-1
.
Step 1: Suspended the workspace-1
Note to remember: All databases were attached as RW to workspace-1
before suspending.
Step 2: Now attach all 4 databases as RW to the workspace-2
,
Step 3: Now we are going to resume workspace-1
, Once you click on the resume of workspace-1
, We will get the below pop-up,
The message is "4 of 4 database attachments will be modified on resume." now the databases cannot be attached as RW to workspace-1
since we already attached the databases as RW workspace-2
(In Step 2) when the workspace-1
was in a suspended state.
Basically, the system preserves the last state of the database attachment information before suspending, so when you resume it will try to attach to the same state but it found that it cannot do that in this case (database cannot be attached as RW to more than one workspace). So it falls back to tell us if we resume it will be attached as RO (New Attachment State).
Now If you wanted to get databases attached as RW on your Resume of workspace-1
, Then close the above pop-up,
Step 4: Reattach the databases as RO to workspace-2
,
Step 5: Now click on the Resume of workspace-1
,
Now you will not get the message and also the notes column is empty,
So clicking on the resume will bring the workspace-1
up and attach databases as RW.
click here to learn about Workspaces.
In case of any further questions or issues please reach out to SingleStore Support,
{answer}