database deadlocks

[Vince Clark <vc...@globalera.com>]

I am batch loading a few hundred orders at a time from a legacy system. I am using a custom simple method to read in the order data, create the order using the storeOrder service, and then quickShipEntireOrder. 

Creating the order is working great, but when I added quickShip into the code I started getting database deadlocks. The job eventually finishes but is quite a performance issue. 

Environment: 
Sun JDK 1.6 
CentOS with 2.6.18 kernel 
SQL Server 2005 (on another server obviously) 
JTDS JDBC driver 

I'm checking with the DBA to find out how SQL Server is configured. I know it has plenty of hardware but not sure how they have it configured for number of connections and that sort of thing. OFBiz is configured for 250 max db connections. Should be sufficient since my process is the only thing hitting it right now. 

Any advice on where to look from here would be helpful. 

Here is the error: 

Failure in findOne operation for entity [Shipment]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT SHIPMENT_TYPE_ID, STATUS_ID, PRIMARY_ORDER_ID, PRIMARY_RETURN_ID, PRIMARY_SHIP_GROUP_SEQ_ID, PICKLIST_BIN_ID, ESTIMATED_READY_DATE, ESTIMATED_SHIP_DATE, ESTIMATED_SHIP_WORK_EFF_ID, ESTIMATED_ARRIVAL_DATE, ESTIMATED_ARRIVAL_WORK_EFF_ID, LATEST_CANCEL_DATE, ESTIMATED_SHIP_COST, CURRENCY_UOM_ID, HANDLING_INSTRUCTIONS, ORIGIN_FACILITY_ID, DESTINATION_FACILITY_ID, ORIGIN_CONTACT_MECH_ID, ORIGIN_TELECOM_NUMBER_ID, DESTINATION_CONTACT_MECH_ID, DESTINATION_TELECOM_NUMBER_ID, PARTY_ID_TO, PARTY_ID_FROM, ADDITIONAL_SHIPPING_CHARGE, ADDTL_SHIPPING_CHARGE_DESC, CREATED_DATE, CREATED_BY_USER_LOGIN, LAST_MODIFIED_DATE, LAST_MODIFIED_BY_USER_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM dbo.SHIPMENT WHERE SHIPMENT_ID=? (Transaction (Process ID 72) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.). Rolling back transaction. 
Exception: org.ofbiz.entity.GenericDataSourceException 




Vince Clark 
www.globalera.com 
vclark@globalera.com 
(303) 493-6723 office 
(303) 523-4843 cell