web stats
Error connecting to database mirth. Oracle - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 12-14-2015, 07:44 AM
josalc josalc is offline
What's HL7?
 
Join Date: Oct 2014
Posts: 1
josalc is on a distinguished road
Default Error connecting to database mirth. Oracle

Hi,

I've been using mirth connect from about a year ago in various environments with a very satisfactory result .
But now I've found a very worrying problem, I comment...
We have several mirth servers running, each connected to your DB, on another IP (external).

Configuration:
mirth Server : Suse Linux E 11
mirth version: 3.1.1.7461
db : Oracle 10.2.0.5 ( external)
java: 1.7.0.67
channels: several ...ftp reader and tcd Sender ,http listener..

The problem occurs when one of the channels is working ( collect or send messages ) and a loss of communication occurs,
preventing access to the database of mirth .
At this time, the mirth begins to generate an error message " java.sql.SQLRecoverableException : error E / S ... "
per channel running .... normal...
But when communication with the database is restored, the mirth is not able to recover.
It is locked, the Web client does not respond or the console. You can only kill the process .
On the other hand when the connection loss occurs only in the channel usually it recovers when communication is restored


Can you implement some mechanism of reconnection with mirth DB error if communication with database ?

Here are some types of error in the trace:

"com.mirth.connect.donkey.server.channel.ChannelEx ception: com.mirth.connect.donkey.server.data.DonkeyDaoExce ption: java.sql.SQLRecoverableException: Error de E/S: ..."
"com.mirth.connect.connectors.file.FileReceive r: Unable to dispatch message to channel a3ace4c2-e50c-473a-9b61-1bd62e6585b6: com.mirth.connect.donkey.server.message.batch.Batc hMessageException:..."
"com.mirth.connect.server.controllers.DonkeyEngineC ontroller: Error retrieving channel revisions
com.mirth.connect.server.controllers.ControllerExc eption...
"
"com.mirth.connect.donkey.server.data.jdbc.JdbcDao: Failed to close JDBC statement
java.sql.SQLRecoverableException:...
"

Two error trace attached.

Thank you
Attached Files
File Type: txt log_1.txt (11.3 KB, 8 views)
File Type: txt log_2.txt (37.7 KB, 1 views)
Reply With Quote
Reply

Tags
donkeyenginecontroller, error, jdbc, oracle, sqlrecoverableexception

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 11:04 PM.


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