Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
- Subject: Re: Exception: Deployment - FrontbasePlugIn - deadlock - WHY
- From: Jeff Schmitz <email@hidden>
- Date: Tue, 23 Mar 2010 22:24:36 -0500
The scenario was that the application was performing a long running
background process and I really didn't want to stop it. But anyway, I
survived and the fix worked a charm. I'm pretty sure I had added that
before at some point. not sure when it would have gotten removed, but
got a surprise when I started seeing it after kicking off the
background process.
On Mar 23, 2010, at 11:51 AM, Chuck Hill wrote:
On Mar 23, 2010, at 3:35 AM, Kieran Kelleher wrote:
If you mean a currently deployed app, the easiest way would be
(1) Set the prop as a launch argument in the WOMonitor settings
like this (launch arg props override Properties files)
-DdbConnectURLGLOBAL=jdbc:frontbase://localhost/netBrackets
Kieran meant:
-DdbConnectURLGLOBAL=jdbc:frontbase://localhost/netBrackets/
isolation=read_committed/locking=optimistic
(2) Launch a new instance
(3) Refuse Sessions or kill the old instance
HTH, Kieran
On Mar 23, 2010, at 2:35 AM, Jeff Schmitz wrote:
btw, any way to get a running app to re-read that prop?
On Mar 23, 2010, at 1:18 AM, Jeff Schmitz wrote:
and bingo. in the eomodel properties file...
#Connection Dictionary
dbConnectURLGLOBAL=jdbc:frontbase://localhost/netBrackets
thanks again!
On Mar 23, 2010, at 12:58 AM, Chuck Hill wrote:
Look at how the connection dictionary gets set in deployment: is
there a property file or arguments in JavaMonitor that override
what is in the model?
Chuck
On Mar 22, 2010, at 10:48 PM, Jeff Schmitz wrote:
I was seeing the same thing as below and it was very repeatable
on both my development and deployment machines. I made the
suggested change, and the error went away on my development
machine. However when I install the new build on my deployment
machine, I still get the error (very repeatably). Is there
something extra I need to do to make sure that kind of change
gets installed when you build and deploy your project? As a
note, my EOModel resides in a framework project that I build
and install separately from my main project. And yes, I have
installed both parts and still am seeing the error.
Thanks,
Jeff
On Jan 10, 2007, at 4:39 PM, Chuck Hill wrote:
On Jan 10, 2007, at 2:33 PM, Gaastra Dennis - WO Lists wrote:
Dear colleagues,
This exception just appeared at random during deployment.
Yes, there are multiple WO application instances and multiple
sessions per instance, but this never has caused a problem
before. We were just trying to insert an object into the
database. Any tips, pointers? Frontbase? WO?
You. :-) Add /isolation=read_committed/locking=optimistic
to your URL so that it looks like this:
JDBCUrl = "jdbc:FrontBase://localhost/GVCSiteMaker/
isolation=read_committed/locking=optimistic";
Chuck
EXCEPTION:
com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression failed:
<com.webobjects.jdbcadaptor.FrontbasePlugIn
$FrontbaseExpression: "INSERT INTO
"Client"("address_PostalZip", "phone_Fax", "modify_user_id",
"create_user_id", "date_Registration", "notes_textblob_id",
"birthDate", "date_LastPayment", "client_id", "isActive",
"sourceInformation", "address_Line1", "address_Line2",
"name_Last", "salesPerson_employee_id",
"address_ProvinceState", "branch_id", "name_First",
"date_RTEligible", "modify_date", "currentBalance",
"address_Additional", "address_City3C", "dlClass_id",
"address_Country", "address_City", "division_id",
"create_date", "phone_Home", "dlNumber", "date_LastBooking",
"phone_Cell", "highSchool", "phone_Additional", "office_id",
"eMail", "programCourse") VALUES ('A1Z-5Z1', NULL, NULL,
'rhonda', TIMESTAMP '2007-01-10 00:00:00.000', 1000633,
TIMESTAMP '1951-07-29 00:00:00.000', NULL, 1000553, 1, NULL,
'87-Spear Rd', NULL, 'Nesty', 1000018, 'BC', 100000
1, 'Mario', NULL, NULL, NULL, NULL, 'Chi', 1000001, 'Canada',
'Chillilove', 1000002, TIMESTAMP '2007-01-10 11:56:10.003',
'604-793-8439', '6892720', NULL, NULL, NULL, NULL, 1000001,
NULL, 'CL-3 ABC($900.00)')">:
Next exception:SQL State:00 subclass = " -- error code:
380 -- msg: Exception condition 380. Pessimistic locking:
multiple transaction conflict detected (deadlock).
Next exception:SQL State:40 subclass = 00 -- error
code: 363 -- msg: Exception condition 363. Transaction
rollback.
With Kind Regards,
Dennis Gaastra, M.B.A.[sfu.ca], B.Sc.[ubc.ca]
Chief Technology Officer,
WEBAPPZ Systems, Inc.
HQ: (+1) 604.921.1333
Fax: (+1) 604.921.4313
Cell: (+1) 604.787.2532
Web: www.webappz.com & www.1tracker.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden
)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase
their overall knowledge of WebObjects or who are trying to
solve specific problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-
email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve
specific problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden