web stats
Connection reset by peer: socket write error Query: - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2011, 04:36 AM
Dagan Dagan is offline
OBX.2 Kenobi
 
Join Date: Jun 2009
Posts: 60
Dagan is on a distinguished road
Default Connection reset by peer: socket write error Query:

hi all:
I am facing a problem in two diferent mirths installed in different environments. Sometimes, I have not found a pattern, I have an error message in one of the channels that have a Database Reader source . I'm using MIRTH 1.8.2 and database SqlServer.
The error is:

Connection reset by peer: socket write error Query:

As I said at the beggining, this is happening in two completely different environments in two centers in diffents phisic location. In fact, the channels are completely different and both are giving the same error. The net connections are correct and we don't have any issues with another applications that are connecting to the same database. We have made lots of tests and we are a little lost.
The situation is complicated, overall, with one of the channels that is executed one time a day at 6:30am. If this execution fails, we have a important problem with an application, and the las two weeks has happened, unless two times.
I know it seems a connection problem, but I don't know what more things I can look at.
Has anyone had this problem?? Do you know what can I do to have more information of this on the Mirth way?
Reply With Quote
  #2  
Old 03-01-2011, 09:08 AM
Dagan Dagan is offline
OBX.2 Kenobi
 
Join Date: Jun 2009
Posts: 60
Dagan is on a distinguished road
Default

Does anyone have an idea about this?
Reply With Quote
  #3  
Old 09-26-2011, 09:47 AM
ISpdxdc ISpdxdc is offline
OBX.1 Kenobi
 
Join Date: Mar 2011
Location: Dallas, Tx
Posts: 48
ISpdxdc is on a distinguished road
Default

I am having the exact same problem. I am going to try and add logintimeout and sockettimeout to my connection string and see if it helps.

jdbc:jtds:sqlserver://serverort/db;instance=name;ssl=request;loginTimeout=30;socke tTimeout=180

Last edited by ISpdxdc; 09-26-2011 at 02:51 PM.
Reply With Quote
  #4  
Old 09-27-2011, 03:11 AM
Dagan Dagan is offline
OBX.2 Kenobi
 
Join Date: Jun 2009
Posts: 60
Dagan is on a distinguished road
Default

Hi ISpdxdc, I hope you can tell me this finally will help.

thanks a lot.
Reply With Quote
  #5  
Old 10-07-2011, 11:55 AM
ISpdxdc ISpdxdc is offline
OBX.1 Kenobi
 
Join Date: Mar 2011
Location: Dallas, Tx
Posts: 48
ISpdxdc is on a distinguished road
Default

It fixed my issue. Haven't had a hiccup since.
Reply With Quote
  #6  
Old 10-13-2011, 12:28 AM
Dagan Dagan is offline
OBX.2 Kenobi
 
Join Date: Jun 2009
Posts: 60
Dagan is on a distinguished road
Default

Thanks a lot, I'll try it too
Reply With Quote
  #7  
Old 11-23-2011, 04:29 AM
Dagan Dagan is offline
OBX.2 Kenobi
 
Join Date: Jun 2009
Posts: 60
Dagan is on a distinguished road
Default

Well, I have made a lot of changes on my instalation and I am facing the same problem.
I changed my environment to the 2.1 Mirth version and I added the line ISpdxdc wrote on my sql conections and I am still having problems with this.

I'm a little lost on this and I don't know how to solve it.
Reply With Quote
  #8  
Old 11-23-2011, 07:05 AM
Bostad Bostad is offline
Level 85 Channel Wizard
 
Join Date: Mar 2009
Location: Stratford Ontario
Posts: 712
Bostad is an unknown quantity at this point
Default

This sounds like its a problem between Mirth and the receiving system.

The only thing you can do is set a long ACK timeout.

Have you turned on Persistant Queuing? That will hold your messages and try resending them if you run into a problem. (I always turn on rotate messages in queue also).
__________________
I can be reached through gmail and Google Talk using davidrothbauer at gmail dot com
http://www.linkedin.com/pub/david-rothbauer/5/923/518
codeismydrug.wordpress.com
hl7coders.wordpress.com

Test all my code suggestions prior to implementation
Reply With Quote
  #9  
Old 11-23-2011, 08:23 AM
Dagan Dagan is offline
OBX.2 Kenobi
 
Join Date: Jun 2009
Posts: 60
Dagan is on a distinguished road
Default

Thanks for your fast reply, the problem is that this error is given when the database source query is sent, not in the destinations.
Some of the channels are executed once a day and if they fail they are not excuted again.
Reply With Quote
  #10  
Old 11-28-2011, 12:35 AM
Dagan Dagan is offline
OBX.2 Kenobi
 
Join Date: Jun 2009
Posts: 60
Dagan is on a distinguished road
Default

Is there any kind of configuration of the database number of conections? I think something is closing database connections, better said, is not allowing to open new ones.

I have this problem with two different servers that are connecting to different databases.

I write here the complete trace:

java.sql.SQLException: I/O Error: Connection reset Query: select rtrim(username) as usuario
from table
where enabled=1
and realname ='' Parameters: []
at org.apache.commons.dbutils.QueryRunner.rethrow(Que ryRunner.java:542)
at org.apache.commons.dbutils.QueryRunner.query(Query Runner.java:399)
at com.mirth.connect.connectors.jdbc.JdbcMessageRecei ver.getMessages(JdbcMessageReceiver.java:266)
at org.mule.providers.TransactedPollingMessageReceive r$1.doInTransaction(TransactedPollingMessageReceiv er.java:91)
at org.mule.transaction.TransactionTemplate.execute(T ransactionTemplate.java:72)
at org.mule.providers.TransactedPollingMessageReceive r.poll(TransactedPollingMessageReceiver.java:104)
at org.mule.providers.PollingMessageReceiver.run(Poll ingMessageReceiver.java:97)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor.runWorker(ThreadPoolExecutor.java: 1061)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :575)
at java.lang.Thread.run(Unknown Source)

Last edited by Dagan; 11-28-2011 at 01:11 AM.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 04:50 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation