CDR Tickets

Issue Number 5006
Summary Multiple Instances of the CDR ?
Created 2021-07-14 11:06:29
Issue Type Inquiry
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2022-01-25 16:02:38
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.294092
Description

I just discovered by accident that I am able to log into multiple instances of the CDR. I was switching from DEV to QA while testing a few issues and forgot to close DEV before logging onto QA (I will normally see an error message when I tried to log into a second instance without closing the first instance). I realized both windows were active and I could check out documents from both DEV and QA almost at the same time. I know we have not been able to do this since the Bastion Host days so I am a little puzzled but also just a little bit excited since this could be a bug. Maybe a  good bug? 😃

Comment entered 2021-07-14 11:38:14 by Kline, Bob (NIH/NCI) [C]

I don't think this falls under the category of "good bug" because it would mean you could be using (for example) the wrong DTDs for local validation. We need to ensure that this can't happen. 😛

Comment entered 2021-07-16 08:40:41 by Kline, Bob (NIH/NCI) [C]

The solution is to add the following code to the loader program:
 

CreateMutexA(0, FALSE, "Local\\$cdrloader$");
if(GetLastError() == ERROR_ALREADY_EXISTS) {
    // display message and exit
}
Comment entered 2021-07-16 09:08:21 by Kline, Bob (NIH/NCI) [C]

Hmm, it's not as simple as that. The problem is that the loader process exits after XMetaL is launched, which would remove the mutex it created, allowing another instance of the loader to launch a second XMetaL process. Creating a more permanent lock runs the risk that code to clean up that lock when XMetaL is closed might never run (for example, if XMetaL crashes, or the user has to kill the process forcibly), leaving the machine in a state where XMetaL can't be run until the lock is removed by some other mechanism. We could build a separate tool which the user could execute for that purpose, but that's a clumsy solution. A better approach might be to have the DLL create a lock which the loader checks. If the lock is already in place, the loader refuses to proceed. The lock would have to be a mechanism which the operating system removes no matter how the XMetaL process terminates (I believe a mutex satisfies this requirement). The flaw in this approach is that there is a small window of time between when the loader checks for the existence of the lock and when the XMetaL and the DLL are launched, during which a second instance of the loader could check the lock, find that it doesn't (yet) exist, and proceed to launch a second XMetaL process. This window would be so small that it seems safe to say that it could only happen if the user intentionally tried to launch two loaders as close to simultaneously as possible. This approach may be the best we can do, and I don't really think we need to worry too much about mischievous users trying to get around the lock. 😉

Comment entered 2022-01-07 13:30:29 by Kline, Bob (NIH/NCI) [C]

is reviewing the described approach, and will confirm that he understands it and believes that it is worth the LOE to implement.

Comment entered 2022-01-07 15:15:24 by Osei-Poku, William (NIH/NCI) [C]

Yes, this is fine and you're right about no user would intentionally try to go around the lock. However, I would like to ask again to see if compared this approach you suggested, making it possible for users to safely log into multiple instances would be a better approach or at least compared to the current approach perhaps it wouldn't make it too expensive?

Comment entered 2022-01-12 17:06:42 by Dugan, Amy (NIH/NCI) [C]

Hi  and  - Let's discuss this more in a CDR meeting. This sounds like a very high LOE. Am I misunderstanding that?

I want to understand more about the use case and how common it would be, any risks involved for unintended impacts, and the overall benefits. Thanks!

Comment entered 2022-01-13 14:27:11 by Kline, Bob (NIH/NCI) [C]

It was decided in the status meeting to fix the bug, preventing users from running more than one XMetaL process at the same time (assuming it's possible to do so).

Comment entered 2022-01-25 16:02:38 by Kline, Bob (NIH/NCI) [C]

Implemented and installed on CDR DEV.

Comment entered 2022-02-01 16:58:39 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. When on DEV, I am not able to log into another session of DEV (or PROD). However, I am able to log into another instance of (QA and/or STAGE), in addition to being logged into DEV. I assume that once the changes are copied to the upper tiers, it will prevent these logging into different tiers.

Comment entered 2022-02-01 17:39:55 by Kline, Bob (NIH/NCI) [C]

That's correct. As things stand right now, when you log into QA the loader installed on that tier is installed on your computer (we haven't yet promoted Ohm to QA). That loader doesn't know it's supposed to prevent you from running two simultaneous instances of XMetaL. So the software is behaving the way we would expect it to at this juncture.

Comment entered 2022-02-01 18:37:36 by Osei-Poku, William (NIH/NCI) [C]

Ok. Got it. Thanks!

Comment entered 2022-06-21 20:41:14 by Osei-Poku, William (NIH/NCI) [C]

I am running into a some issues when testing this out. While logged into QA, I am able to see the new TemporaryLink attribute on the DrugReference block. Then, when I try to log into PROD (while still logged into QA), I get several error messages that tell me that there is a mismatch and and as expected, I am not logged a second time into the CDR on a different tier. However, after this happens, I go back to look at a DIS to see if the TemporaryLink attribute is still available and I don't find the attribute in any new document I retrieve after that incident. It does look like when attempting to log into the CDR a second time, there is some type of refresh that causes the TemporaryLink changes to disappear. I think it would better to demo this to you. I will try and do that during the standup tomorrow.

Comment entered 2022-06-21 22:45:32 by Kline, Bob (NIH/NCI) [C]

Well, let's see how long Cynthia's agenda item takes. Remember, the standup is only 15 minutes. We may need to pick a different time for the demonstration of this issue.

Comment entered 2022-06-22 10:40:25 by Kline, Bob (NIH/NCI) [C]

We might not have anything to discuss. I have moved the check to make sure there isn't already another instance of XMetaL running earlier, avoiding the client file refresh (and therefore, I assume, the problems you reported above). Change installed on DEV and QA. Please test and verify that this eliminates those problems.

Comment entered 2022-06-22 12:39:50 by Osei-Poku, William (NIH/NCI) [C]

It looks resolved now. Thanks!

Comment entered 2022-06-22 12:40:16 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Elapsed: 0:00:00.001531