Announcement

Collapse

Mirth Connect 4.1.0 Released!

Mirth Connect 4.1.0 is now available as an appliance update and on our GitHub page. Mirth Connect 4.1.0 includes new features such as new event log messages, additional fields to the Welcome to Mirth Connect screen, new information included in alerts as well as many smaller changes, updates, and improvements. This release also contains several improvements to commercial extensions. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Error polling psql db and freeze

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • pacmano
    replied
    That is a problem of database reachability.

    You can try shelling Into the container and use traditional network tools to attempt to debug connectivity.

    Leave a comment:


  • jacopo_deluca
    started a topic Error polling psql db and freeze

    Error polling psql db and freeze

    Hello everyone,

    I'm Jacopo and I'm testing Mirth functionalities.

    In last months I've been trying to poll data from cloud PostgreSQL db and produce DICOM in order to generate worklist.
    I'm using Docker image nextgenhealthcare/connect:3.9.0-jdk.

    All works fine for weeks, but sometimes the database reader fails with next error and remains freezed in polling until container restarting (I cannot restart/stop/halt only the channel):

    ERROR (com.mirth.connect.connectors.jdbc.DatabaseReceive rQuery:207): An error occurred while polling for messages, retrying after 10000 ms...
    org.postgresql.util.PSQLException: The connection attempt failed.
    at org.postgresql.core.v3.ConnectionFactoryImpl.openC onnectionImpl(ConnectionFactoryImpl.java:272)
    at org.postgresql.core.ConnectionFactory.openConnecti on(ConnectionFactory.java:52)
    at org.postgresql.jdbc.PgConnection.<init>(PgConnecti on.java:216)
    at org.postgresql.Driver.makeConnection(Driver.java:4 04)
    at org.postgresql.Driver.connect(Driver.java:272)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager .java:677)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager .java:228)
    at com.mirth.connect.connectors.jdbc.DatabaseReceiver Query.initSelectConnection(DatabaseReceiverQuery.j ava:340)
    at com.mirth.connect.connectors.jdbc.DatabaseReceiver Query.poll(DatabaseReceiverQuery.java:171)
    at com.mirth.connect.connectors.jdbc.DatabaseReceiver .poll(DatabaseReceiver.java:134)
    at com.mirth.connect.donkey.server.channel.PollConnec torJob.execute(PollConnectorJob.java:49)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:2 13)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run (SimpleThreadPool.java:557)Caused by: java.net.SocketTimeoutException: connect timed out
    at java.base/java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.base/java.net.AbstractPlainSocketImpl.doConnect(Abstrac tPlainSocketImpl.java:399)
    at java.base/java.net.AbstractPlainSocketImpl.connectToAddress( AbstractPlainSocketImpl.java:242)
    at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractP lainSocketImpl.java:224)
    at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava:403)
    at java.base/java.net.Socket.connect(Socket.java:609)
    at org.postgresql.core.PGStream.<init>(PGStream.java: 61)
    at org.postgresql.core.v3.ConnectionFactoryImpl.openC onnectionImpl(ConnectionFactoryImpl.java:144)
    ... 12 more


    Now, I'm avoiding retries, since channel works periodically.
    I don’t think it is a problem of db reachability because other services continue to work, at least I would like to avoid the polling freeze after fails.

    Has this happened to anyone yet?
    Hoping someone can help me to find the reason.

    Thank you so much

    Jacopo
Working...
X