Multi User Pc Setup

0 views
Skip to first unread message

Giovanni Sealy

unread,
Aug 3, 2024, 10:43:55 AM8/3/24
to boatietilre

Multi-user software is computer software that allows access by multiple users of a computer.[1] Time-sharing systems are multi-user systems. Most batch processing systems for mainframe computers may also be considered "multi-user", to avoid leaving the CPU idle while it waits for I/O operations to complete. However, the term "multitasking" is more common in this context.

The complementary term, single-user, is most commonly used when talking about an operating system being usable only by one person at a time, or in reference to a single-user software license agreement. Multi-user operating systems such as Unix sometimes have a single user mode or runlevel available for emergency maintenance. Examples of single-user operating systems include MS-DOS, OS/2 and Classic Mac OS.

Can you please point me to documentation or explain how this works? Running a single Syncthing instance on my NAS for my wife/I (and in future children) just for syncing important files/docs, etc, would be ideal. Looking at the configuration options I would have to muck around with ports if I have to run multiple instances. A single instance would be ideal

Simply implementing separate partitions will not cover this requirement, and separate partitions are still accessible so there is nothing preventing my younger kid to mess with my eldest homework, or my kids messing my administrative documents (apart from implementing password restricted access, encryption, but it will quickly turn out that once you have implemented these functionalities, you are actually very close to multi-user support).

Simply implementing separate partitions will not cover this requirement, and separate partitions are still accessible so there is nothing preventing my younger kid to mess with my eldest homework, or my kids messing my administrative documents

The best way is not share PC at all and let each user have separate physical PC. Cheap laptops are available on the market so it should be not a problem. Especially work PC should be separate from home PC for security reasons, for many companies this is mandatory requirement.

Depends of the usage.
I use my pc for machine learning (personal projects), and the eldest kid for gaming. Buying powerful PCs for everyone in the household is simply not an option (at least not for me).
If use case is simply browsing and document editing I agree that cheap machines can be considered.

It is precisely because there are different use cases that I cannot see how we can do without multiuser support, although multiuser requrement may not be for the majority (but at the same time may not be marginal).

On the topic of multi-user and security, it would be really nice if drive encryption would be included, stable and support dmcrypt (LUKS). Axel developed driveencryption ages ago, it may still work on beta3 but I have not tried it.

how many people contributing for the vote? i assume one of the ways to do this is by deploying in a small group of 3. Odd number for the majority vote. Ai need absolute value as validation. Then user profiling. Maybe one has to gather all three participant before deploying into the group. This is fascinating stuff but not many are into this concept.

As Open AI team statement the progress from API is not up to their par. I think they should narrow down packages and standardize AI with proper guideline to follow, and they need to make it accessible to everyone as in a group.

Some of the locks may be expected, especially if they are related or in the same feature dataset.. Here is some additional information related to locks: -app/latest/help/data/geodatabases/manage-file-gdb/file-geodatabases-an...

You're asking for a world of pain. File geodatabases are not designed to be used like that. Either split the feature classes out to a unique geodatabase per user then recombine post edits, or as George suggests look at an enterprise solution.

Thank you, for the responses. We have tried each feature class in its own file geodatabase and a single geodatabase with multiple feature classes. However, ArcGIS Pro seems to lock all the layers once editing begins, and secondary users cannot edit different feature classes. Is there a global edit setting that can be adjusted? Or is there a patch or bug fix that resolves this?

Editing workflows on one machine should not lock out other editors on a different machine as long as the data is in a different feature dataset. If the data resides in different File Geodatabases, I especially would not expect any conflicts.

Sorry, I don't think perhaps I was clear. So once again File Geodatabases are not designed to enable multi-user editing. It's not a bug or something that requires a patch. When you are editing within a geodatabase you have edit locks on all the feature classes by design as there are edit functions where you can interact with more than one feature class at once.

How would you reconcile the changes if two users changed the same thing at the same time? That is what the lock is there to prevent. In a past life I worked in an organisation that refused to accept this and all it did was leave us with lots of corrupt data and edits "going missing" etc. which were a painf for the GIS team.

My suggested workaround was to have a single master geodatabase that nobody edits directly into, then each user has their own local geodatabase. When they want to edit some data, copy out the feature class to their local gdb, (deleting the copy from the master) perform their edits then paste it back when they're done. This requires some level of communication amongst the team and some oversight by you as a data manager. It also prevents anybody from viewing the data whilst it's being edited.

If what you actually want is the ability for one user to view data and another to be editing at the same time, your only seamless (and correct) option is to go down the Enterprise GDB route

Hi Richard, thank you for taking the time to reply and provide some valuable feedback. I really appreciate it! This helps, as now we can explore a different workflow that will meet our needs and / or begin justifying our upgrade to an Enterprise solution.

As a follow-up to this topic, we are testing a workaround with the edit settings in ArcGIS Pro. Below is a snapshot of the edit options dialog box, and the yellow highlights are the two settings we have changed (single workspace edit session and make newly added layers editing by default - off. This appears to allow multiple users to edit and save different feature classes, which are in different geodatabases. Is anyone aware of negative impacts of working this way?

As I said to you before, this isn't what this is designed for, and I would make it standard practice at your peril. This simply replicates the old behaviour or ArcMap in requiring the need to "start" an editing session.

When I used to warn people off multi-user editing in a shared file geodatabase they would often say "But it lets me do it"...my analogy was always that a small family car would probably drive off-road for a while and you could get so far, but it's not what it's designed for, and when it does breakdown or get stuck you can't really have any complaints.

1. Initially I wanted to use a database that I restored in NAV 2017 Development Environment CU61 (Cumulative Update) in let say Server A, but it failed and asked the database to be converted first before using. I suspect it was due to the database was originally backup and restored from a database that used to open in older CU for NAV 2017.

2. Usually from what I have seen, it will prompt a message to tell the user like "The database will be converted before using, are you sure you want to proceed" or something like that. If this message is prompted, I would have let it converted automatically by the system and proceed to use the database.


4. Upon checking via the "Activity Monitor" on my SQL server, let say server B, I was the only user connecting to this database and using the process. I tried to manually kill the process but to no avail.


5. I found some article stating to try and change the mode from Multi-User mode to Single User Mode. For testing purpose, I tried it out, once I figured out its not working, I am planning to switch it back, but it won't let me switch it back to multi user mode. It keeps stating that a user is connected to it.

Hi Javier,
Thank you so much for the suggestion, much appreciated. However, I wanted to clarify something if you don't mind. Based on the SQL script that you have suggested, is it a must to use "master" instead of my actual database name? I am worried that if I used the "master" database, it will affect all the database that are in the SSMS as well. Will it cause that kind of issue?

For you information, I tried using my actual database name and I got the error as shown below.

Msg 924, Level 14, State 1, Line 1
Database '[ACTUAL_DATABASE_NAME] is already open and can only have one user at a time.
Msg 1205, Level 13, State 68, Line 3
Transaction (Process ID 74) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Msg 5069, Level 16, State 1, Line 3
ALTER DATABASE statement failed.

Can I also know the role of this "master" if possible, I am still new to SQL, SSMS and so on. Much thanks and have a good day.

c80f0f1006
Reply all
Reply to author
Forward
0 new messages