Was able to track down the query causing the deadlock. Apparently has nothing to do with quickShipEntireOrder:
SELECT CURRENT_PASSWORD, PASSWORD_HINT, IS_SYSTEM, ENABLED, HAS_LOGGED_OUT, REQUIRE_PASSWORD_CHANGE, LAST_CURRENCY_UOM, LAST_LOCALE, LAST_TIME_ZONE, DISABLED_DATE_TIME, SUCCESSIVE_FAILED_LOGINS, EXTERNAL_AUTH_ID, USER_LDAP_DN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, PARTY_ID FROM dbo.USER_LOGIN WHERE USER_LOGIN_ID= When I schedule the job I am logged in as myself. Also, I am not doing anything in my simple method to specify a logged in user. I've seen other instances in the code where system user is explicitly set as the "logged in user". Should I be doing this? Vince Clark www.globalera.com vcl...@globalera.com (303) 493-6723 office (303) 523-4843 cell ----- Original Message ----- From: "BJ Freeman" <bjf...@free-man.net> To: user@ofbiz.apache.org Sent: Monday, August 3, 2009 8:35:44 PM GMT -07:00 US/Canada Mountain Subject: Re: database deadlocks goes to show how far behind I am. thanks for the update Scott Gray sent the following on 8/3/2009 7:25 PM: > They aren't temporary stored procedures on MS unless you're talking 10 > years ago: http://msdn.microsoft.com/en-us/library/aa197533(SQL.80).aspx > And Postgresql makes no mention of functions: > http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html > In both cases they just compile and cache the statement which is what > people call prepared statements. > > Regards > Scott > > On 4/08/2009, at 2:03 PM, BJ Freeman wrote: > >> I meant storeproceedure that are temporary from MS side anyway. >> you may mean the prepared statements that create stored proceedures >> for MS. >> they are Functions for postgresql. >> >> Scott Gray sent the following on 8/3/2009 4:18 PM: >>> I think you meant prepared statements rather than stored procedures >>> there. >>> >>> Regards >>> Scott >>> >>> On 4/08/2009, at 10:59 AM, BJ Freeman wrote: >>> >>>> since ofbiz creates and send a Stored procedure see if it creating more >>>> than one for the same operation. >>> >> >> -- >> BJ Freeman >> http://www.businessesnetwork.com/automation >> http://bjfreeman.elance.com >> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >> >> Systems Integrator. >> > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
