Ghost users (?)

[Agnes Riley]

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

[Steven H. Blackwell]

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

[Kris M]

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

[Ocean West]

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.

[Agnes Riley]

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

[Agnes Riley]

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

[Daniel Wood]

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.

[Agnes Riley]

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