High system load on temporarely unavailable network drive

[expired user #10254]'s profile image [expired user #10254] posted 7 years ago in General Permalink

Hi Ansgar,

I encountered some peculiar behavior when editing SQL Scripts which are stored on a shared Network drive:

  • Local machine is Win7 64 Bit, fileserver is Win Svr 2012R2 (so, expect filesharing is running on SMB2)
  • Starting HeidiSQL and loading a script in editor works as expected
  • When losing the connection to the network share (even for a short moment) system load on local machine increases to nearly 100%
  • Restoration of the network drive does not decrease the system load to a normal value
  • Only way to get the machine "workable" again, is stop and start of HeidiSQL and picking all parts of the current work from server again. :-(

(I know this behaviour for several years now, but it hasen't been relevant for me. Now, as I have to work through a VPN connection, it costs a lot of time.^^)

Thanks for reviewing this and best regards, Konrad

[expired user #10254]'s profile image [expired user #10254] posted 7 years ago Permalink

Hi Ansgar,

is there any News about this?

(fixed, wontfix, invalid, ...) :-D

Have a nice Weekend, Konrad

ansgar's profile image ansgar posted 7 years ago Permalink

I guess I won't be able to fix that, as this looks like an issue in the underlying Windows API routines for reading a file. However, a "fix" for a broken network share during a read operation would probably only return you a dialog which displays some error message. You cannot expect the read operation to proceed just because you fix the network connection some seconds later.

[expired user #10254]'s profile image [expired user #10254] posted 7 years ago Permalink

I expected this, as I know the very nice "The file was changed by another application in background" - message is generated by the filesystem. :-/

Maybe, it would be a good idea for me to switch to a SVN with a local working copy of the files. :-)

best regards, Konrad

Please login to leave a reply, or register at first.