top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Socket error - Connection reset by peer

0 votes
1,043 views

I have a simple housekeeping session that deletes data prior to one month from teradata tables.This is done using SQL transformation.The mapping has logic such that it handles 3 types of files (daily , monthly first week ,monthly -last week).logic for all 3 types is same.Deleting data prior to 1 month.Router is used to handle this.

The session executes properly for low volume of data(daily file) but when the table has higher volume of data in production , it gives below error :

TRANSF_1_1_1> pmsql_50065 [ERROR] ODL error: FnName: Close -- [Teradata][Unix system error] Socket error - Connection reset by peer FnName: Execute Direct -- [Teradata][Unix system error] 104 Socket error - Connection reset by peer ODBC call to SQLError failed. . TRANSF_1_1_1> CMN_1761 Timestamp Event: [Fri Aug 08 09:45:01 2014]

We have tried re-executing the session but no luck. Weird part is the delete command is being executed in database as we could see data deleted as required but the session is failing.

Please let me know what is the issue here and also the solution.Thank you.

posted Aug 18, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Can you check the QueryLog for the exact error? In worst case your session gets automatically killed by some workload management rule using too much resources.

answer Aug 19, 2014 by Shweta Singh
Similar Questions
0 votes
How to raise a socket "104 connection reset by peer error" in Python

For testing purposes I want my code to raise a socket "connection reset by peer" error, so that I can test how I handle it, but I am not sure how to raise the error.

0 votes
Error in MongoDB "An existing connection forcibly closed by remote host"

I got the error when I was try to import the .csv file in collection, file size was about 4 gb. The error was: "An existing connection forcibly closed by remote host."

What is the probable reason and how can I increase the connection time in MongoDb?

+1 vote
In what scenarios, a diameter node maintains two connection with peer ?

I went through an article of diameter, it mentions " Diameter standard advises that a diameter node to maintain two connection primary and secondary connection". Diameter node uses first connection in normal conditions and go for second one if primary connection is abrupted or not available. How far it is correct and where it is used exactly ?

...