Jump to content
Sign in to follow this  
Agnes Riley

Ghost users (?)

Recommended Posts

I have a script sequence running in an FMS11 hosting environment. The script successfully finishes and logs its times. The server has now ghosts users with (?) logged into the DB and they cannot even disconnect them, the server has to be restarted to get rid of them.

Has anyone seen this before?

Thanks,

Agi

Share this post


Link to post
Share on other sites

Hi, Agi.

Are they running the Server 11.0v3 updater? There were issues with ghost users in Server 10 and early Server 11 versions. Anything from the Access Logs on the Server as a user connecting and disconnecting for running the script?

Steven

Share this post


Link to post
Share on other sites

We (the Company i work for) have been having this problem since v10 with FMP server. Randomly and periodically we get a slew of "ghosts" that causes the entire stack of served files to become unresponsive. Only fix is to do the three finger salute and reboot the server. My colleague in CA has worked with several insiders at FMP and can not get a resolution. We are hoping that 12 server will correct this issue but we are not yet at the point of trying to deploy 12 because of the many performance issues and bugs

Share this post


Link to post
Share on other sites

one thing i have noted is that if you have multiple interface (wifi and Ethernet) a user was able to connect to the database twice on different interfaces leaving one 'ghost' record - and in one case constant "can't modify this record because <same person> is" message - i think it was because the method logged in. - I turned off wifi and they accessed via ethernet and it did subside.

this may or not be related - just an observation.

Share this post


Link to post
Share on other sites

Hi Steven,

Yes, they have server 11.0v3. I made the scripts significantly faster by changing the process. We'll see if they will still see ghosts. :-) I asked them previously to use "fmserver" as a user to run the schedule with but I think they just did that. The log didn't show me anything in particular.

Best,

Agi

Share this post


Link to post
Share on other sites

Thanks, Steve! Since we don't even have a name for the ghost user, can you imagine a regular user being connected twice and only once they would show up with their regular user name and as a question mark for the second occurrence?

I'd like to think it's the server that's connecting to run the scripts, but I will have more info after tonight hopefully.

Cheers,

Agi

Share this post


Link to post
Share on other sites

I was talking to someone at devcon who was having this ghost user issue and the way they found to clear them was to simply run a database integrity verification on the databases on server, for some reason this flushed whatever cache of users that FMS keeps on the files. Could be an easier alternative to restarting the server.

Share this post


Link to post
Share on other sites

I'll let them know if we see the ghosts again. The DB is clean, I checked that.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.