topic Re: EOFError: [Errno 10054] An existing connection was forcibly closed by the remote in Transportation Questions

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

Anonymous User — Fri, 10 Dec 2021 22:26:05 GMT

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

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

Anonymous User — Mon, 08 Jul 2013 11:40:18 GMT

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?

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

JamesCrandall — Mon, 08 Jul 2013 12:03:53 GMT

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

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

Anonymous User — Mon, 08 Jul 2013 12:09:03 GMT

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.

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

JamesCrandall — Mon, 08 Jul 2013 12:09:41 GMT

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?

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

Anonymous User — Mon, 08 Jul 2013 12:10:47 GMT

Original User: jemkeith

Is your SDE running on SQL Server?

It is SQL server. I think it's 2008.

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

JamesCrandall — Mon, 08 Jul 2013 12:13:13 GMT

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

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

Anonymous User — Mon, 08 Jul 2013 12:16:56 GMT

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!

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

JasonMills — Mon, 08 Jul 2013 13:08:25 GMT

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!

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

Anonymous User — Mon, 08 Jul 2013 13:21:06 GMT

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!