Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error reading file, and can't get exclusive lock in TS e
Message
De
08/02/2012 16:47:40
 
 
À
08/02/2012 16:23:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01534888
Message ID:
01534916
Vues:
56
>>>regarding the categories for OS, Network - it's really 2008 server r2 for both, VFP on terminal server.
>>>
>>>We have two separate errors in two separate terminal server environments:
>>>
>>>1) On an app that hasn't changed in a really long time, nor the OS or terminal server. Upon opening a form we got
>>>'Error reading file'. If we went into any terminal server session from any desktop or thin client, and tried to open the same form in the app, we got the error. But if we went into the app from a regular desktop non/TS environment, the form opened fine.
>>>
>>>I kicked everyone off the TS and restarted it, and the problem went away. Any ideas? Any MS updates affecting TS environment?
>>>
>>>
>>>2) On another Terminal Server environment, we just setup a new vmware virtual machine as a TS - windows 2008 server r2
>>>file server for the vfp app is also win2008 r2. There is a weekly batch routine that one user needs to run - close orders - requires that everyone be off the system - and needs to gain exclusive access to a table. All users exit - for all intents and purposes it looks like there are no open files anywhere on the system. When the user tries to close from within a TS session, it tell him the file is in use by another (I think that's the message - that's what I was told - in any event the lock can't be obtained) However, the same as #1 above, if the user starts the VFP app from a regular desktop non/TS environment, he is able to get the lock and proceed.
>>>
>>>This environment (item #2) was just migrated to a new VMWare environment and new TS. However, this problem with the exclusive lock is longstanding - had it in the previous environment - not vmware, but still 2008 server r2.
>>>
>>>A year and a half ago, in this non vm environment, wary of 'SMB2' issues, I had disabled SMB2 and did a bunch of other stuff supposedly related to potential issues - but the exclusive lock issue still remained. In the new TS environment, I haven't disabled SMB2.
>>
>>I don't have any answers, but if you can't obtain a lock, that implies the OS thinks someone else has the file open, with or without a lock. Have you checked to see who has the file(s) open when the problem occurs? http://www.techrepublic.com/blog/datacenter/server-2008-manage-open-files-with-share-and-storage-management/315
>
>Al, that's the maddening thing. share and storage management shows no open files no user sessions. And it works fine if the user attempts the same operation from a regular desktop machine. So I think that somehow the TS is not keeping track of file handles properly? Back in about 2002, in ts/citrix win 2000 environment we had a huge problem with ts/citrix losing track of file handles - forget how that one was solved - but I thought these problems were long gone. In that case we got repeated error reading file errors and repeated index corruption.

I should have thought of this earlier, but is antivirus present on the TS? If so, can you disable real-time scanning and/or configure it to not scan the file(s) in question (and temp files folders)?

Just for grins, does NET FILE show anything e.g. http://www.windowsnetworking.com/kbase/WindowsTips/WindowsNT/AdminTips/Miscellaneous/FindandRemovefilelocks.html ?

I believe there are "unlocker" utilities that can force unlock/close files on a server. ISTR being involved in a thread here about that some time ago, I think Victor Anderson offered a link to one such utility.

I wonder if opportunistic locking ("oplocks") on Server 2008 is causing what you're seeing. If you Google [server 2008 oplocks] there's a bunch of hits, maybe you can get some ideas there.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform