EOFError: [Errno 10054] An existing connection was forcibly closed by the remote host

13720
9
07-05-2013 05:48 AM
by Anonymous User
Not applicable
Original User: jemkeith

I keep getting the above error in one of my scripts. The error happens randomly. The script will sometimes finish, sometimes get halfway done, sometimes just when it first starts.
I use a SDE database and a file geodatabase. The script loops through about 100 feature classes, unions them with a county feature class and a quad feature class then exports the table to a text file. The script usually takes about 6 - 8 hours to run.
I have no idea where to even start looking for the problem.

The script ran fine in 10.0.
I'm using 10.1, XP.

Here's the complete error message:
Traceback (most recent call last):
  File "<string>", line 73, in execInThread
  File "C:\Program Files\PyScripter\Lib\rpyc.zip\rpyc\core\netref.py", line 196, in __call__
  File "C:\Program Files\PyScripter\Lib\rpyc.zip\rpyc\core\netref.py", line 71, in syncreq
  File "C:\Program Files\PyScripter\Lib\rpyc.zip\rpyc\core\protocol.py", line 431, in sync_request
  File "C:\Program Files\PyScripter\Lib\rpyc.zip\rpyc\core\protocol.py", line 379, in serve
  File "C:\Program Files\PyScripter\Lib\rpyc.zip\rpyc\core\protocol.py", line 337, in _recv
  File "C:\Program Files\PyScripter\Lib\rpyc.zip\rpyc\core\channel.py", line 50, in recv
  File "C:\Program Files\PyScripter\Lib\rpyc.zip\rpyc\core\stream.py", line 166, in read
EOFError: [Errno 10054] An existing connection was forcibly closed by the remote host
0 Kudos
9 Replies
by Anonymous User
Not applicable
Original User: jemkeith

I get the same message in several different scripts.
Where do I start to look? Is it a firewall issue? A software issue? Server issue? SDE? Database?
0 Kudos
JamesCrandall
MVP Frequent Contributor
Is your SDE running on SQL Server?

Sounds more likely a problem related to network hiccup or updates/patches being applied overnite, maybe the workstation you are running this on is timed-out/logging-off/entering sleep mode during the run?

Is this run on a Citrix machine?  We have to adjust our session time-outs for long running batch processes otherwise the script will quit/fail when the session ends.

James
0 Kudos
by Anonymous User
Not applicable
Original User: jemkeith

It's not citrix, just a regular work station. I've ran the script while I've been sitting in front of the computer and have it error out 3 minutes in. I've also had it finish while it's been locked. It just seems so random.
I thought about it maybe a network or database issue.
I put in a support request today. I'll let you all know what I find out.
0 Kudos
JamesCrandall
MVP Frequent Contributor
It's not citrix, just a regular work station. I've ran the script while I've been sitting in front of the computer and have it error out 3 minutes in. I've also had it finish while it's been locked. It just seems so random.
I thought about it maybe a network or database issue.


Is your SDE running on SQL Server?
0 Kudos
by Anonymous User
Not applicable
Original User: jemkeith

Is your SDE running on SQL Server?


It is SQL server. I think it's 2008.
0 Kudos
JamesCrandall
MVP Frequent Contributor
It is SQL server. I think it's 2008.


I am not sure if this is the issue, just something you may want to follow up on or look into since it's SQL Server 2008...

http://msdn.microsoft.com/en-us/library/ms187005(v=sql.105).aspx

Good luck!
j
0 Kudos
by Anonymous User
Not applicable
Original User: jemkeith

I am not sure if this is the issue, just something you may want to follow up on or look into since it's SQL Server 2008...

http://msdn.microsoft.com/en-us/library/ms187005(v=sql.105).aspx

Good luck!
j

Thank you! I'll get with the DB and see if he's seeing anything. Thanks!
0 Kudos
JasonMills
New Contributor III
My SQL server native client was out of date. So far it's working but I'll have to run it several times to see if that was the problem. Thanks!
0 Kudos
by Anonymous User
Not applicable
Original User: jamesfreddyc

My SQL server native client was out of date. So far it's working but I'll have to run it several times to see if that was the problem. Thanks!


Excellent!
0 Kudos