web stats
Killing a lock in the Derby Database - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 05-24-2011, 05:44 AM
klundell klundell is offline
OBX.3 Kenobi
 
Join Date: Sep 2010
Posts: 154
klundell is on a distinguished road
Default Killing a lock in the Derby Database

How do I clean up the Derby Database? How do I get rid of dead locks.
I am getting the following error. How do I resolve it?

[2011-05-24 00:23:18,212] ERROR (com.webreach.mirth.server.controllers.DefaultMess ageObjectController:268): could not log message: id=a5284e5a-4d91-4e55-91be-d9ca9ae6d385
com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred in derby/derby-message.xml.
--- The error occurred while executing update.
--- Check the

INSERT INTO

MESSAGE (ID, SERVER_ID, CHANNEL_ID, SOURCE, TYPE, DATE_CREATED, VERSION, IS_ENCRYPTED, STATUS, RAW_DATA, RAW_DATA_PROTOCOL, TRANSFORMED_DATA, TRANSFORMED_DATA_PROTOCOL, ENCODED_DATA, ENCODED_DATA_PROTOCOL, CONNECTOR_NAME, ERRORS, CORRELATION_ID, CONNECTOR_MAP, CHANNEL_MAP, RESPONSE_MAP, ATTACHMENT)

VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
.
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
Lock : ROW, SYSCONGLOMERATES, (5,16)
Waiting XID : {2365196244, S} , APP,
Reply With Quote
  #2  
Old 05-24-2011, 10:06 AM
jacobb jacobb is offline
Mirth Employee
 
Join Date: Aug 2006
Location: Irvine, CA
Posts: 1,218
jacobb is an unknown quantity at this point
Default

I'm not sure of a way to resolve it, but this is usually the reason we recommend against using derby except for development and testing.
__________________
Jacob Brauer
Director, Software Development
NextGen Healthcare

Reply With Quote
  #3  
Old 05-24-2011, 10:50 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
Default

This is normally a volume related issue caused by a insufficiently tuned/powerful backend database server. I would also not recommend using derby for production. We had to even go through an extensive performance review and improvement process (included in 2.1) to get Mirth to run against a SQL server backend successfully and not cause similar deadlock issues.

We now have over 150 channels process tens of thousands of messages total per day on a virtual machine with a separate SQL Server database without ever hitting any bottlenecks. The UI is also always responsive and it does not cause issues for the backend process even with more that 5 millions archived records and fairly generic searches.

Thanks,
Frans
__________________
Frans de Wet
Uber Operations LLC
uberops.com
Phone: (850) 445-7696
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 10:47 AM.


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