web stats
JDBC Connector error. Deadlock victim - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 07-30-2008, 01:06 PM
aingram aingram is offline
Mirth Newb
 
Join Date: Mar 2008
Location: North Carolina
Posts: 12
aingram
Default JDBC Connector error. Deadlock victim

Has anyone seen this issue before? I am not receiving this error every time I am updating the database. But, it is happening enough it is causing problems. The backend is 2005 SQL Server. It is just a simple Insert with some transforms associated with it. Any help would be appreciated.


ERROR-406: JDBC Connector error
ERROR MESSAGE: Error writing to database:
java.sql.SQLException: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Reply With Quote
  #2  
Old 07-30-2008, 01:37 PM
jbartels jbartels is offline
Mirth Employee
 
Join Date: Oct 2006
Posts: 708
jbartels is on a distinguished road
Default Re:JDBC Connector error. Deadlock victim

aingram wrote:
Quote:
Has anyone seen this issue before? I am not receiving this error every time I am updating the database. But, it is happening enough it is causing problems. The backend is 2005 SQL Server. It is just a simple Insert with some transforms associated with it. Any help would be appreciated.


ERROR-406: JDBC Connector error
ERROR MESSAGE: Error writing to database:
java.sql.SQLException: Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I've seen it before. Its a concurrency issue between your query and some other query that wants a lock on a table.

Google for "Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction" and it should turn up some specific SQL Server hints that will prevent the issue.

As far as coping with this in Mirth goes you can run your query in JavaScript and catch the exception that is thrown from executing the query. If that execption is of this type then wait a moment and rerun the query. That is just a coping mechanism though, the real solution is to tweak the query to not deadlock.
__________________
Jon Bartels

Former user assimilated into the company.
Reply With Quote
  #3  
Old 08-21-2008, 11:34 PM
Nabeel Nabeel is offline
What's HL7?
 
Join Date: Aug 2008
Posts: 1
Nabeel
Default Re:JDBC Connector error. Deadlock victim

Hello aingram !
Did you find your solution. I am getting the same exception. Can you tell me wtas the solution
nabeelkhan132 at gmail dot com
Reply With Quote
  #4  
Old 08-22-2008, 05:15 AM
jbartels jbartels is offline
Mirth Employee
 
Join Date: Oct 2006
Posts: 708
jbartels is on a distinguished road
Default Re:JDBC Connector error. Deadlock victim

Nabeel wrote:
Quote:
Hello aingram !
Did you find your solution. I am getting the same exception. Can you tell me wtas the solution
nabeelkhan132 at gmail dot com
Did you follow the suggestions that I posted?
__________________
Jon Bartels

Former user assimilated into the company.
Reply With Quote
  #5  
Old 10-20-2008, 01:59 PM
aingram aingram is offline
Mirth Newb
 
Join Date: Mar 2008
Location: North Carolina
Posts: 12
aingram
Default Re:JDBC Connector error. Deadlock victim

I did. But we still had issues. So, we added another DNS on the server and referenced that instead for certain sql statements. That seemed to work. I am still testing it out though. Thanks for your reply.
Reply With Quote
  #6  
Old 10-21-2008, 07:49 AM
nshaik nshaik is offline
Mirth Guru
 
Join Date: Sep 2006
Posts: 302
nshaik
Default Re:JDBC Connector error. Deadlock victim

Check the logs / Activity Monitor to see "Blocked By" and "Blocking" process

SQL Server 2005 Management Studio / Your Server / Management / SQL Server Logs

SQL Server 2005 Management Studio / Your Server / Management / Activity Monitor

Make sure the database tables have required indexes. Refer following articles on performance tuning.
Have You Tried the SQL Server Profiler 2005 Blocked Process Report?
http://sql-server-performance.com/Co...ss-report.aspx

Tuning Up SQL Server 2005 Databases
http://www.developer.com/db/article.php/3607186

Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/pro.../tsprfprb.mspx

Hope this helps!
Reply With Quote
  #7  
Old 12-23-2010, 08:52 AM
fransdw fransdw is offline
OBX.1 Kenobi
 
Join Date: Feb 2007
Location: Tallahassee, FL
Posts: 43
fransdw is an unknown quantity at this point
Send a message via Skype™ to fransdw
Arrow Possible fix ....

See this post - http://www.mirthcorp.com/community/f...7211#post17211 - it may point you in the the right direction for a solution.

Thanks,
Frans
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
JDBC Connection Error larryw Support 1 02-08-2008 01:49 PM
puzzling jdbc connector error (file2file works) fruscica Support 1 01-22-2008 03:10 PM
JDBC SQL error tomjosif Support 3 09-10-2007 11:57 PM
JDBC Connector error and Error writing to databas thinhvn Support 1 06-21-2007 08:50 PM
JDBC Connector Error, Error Writing to Database coffde Support 2 04-25-2007 08:57 AM


All times are GMT -7. The time now is 11:14 AM.


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