Re: EOF - statement has been closed?
Re: EOF - statement has been closed?
- Subject: Re: EOF - statement has been closed?
- From: Chuck Hill <email@hidden>
- Date: Thu, 21 Mar 2013 09:39:33 -0700
Where is that method from? It is doing unlocked EOF access and if it is not called from code that has the EOF stack locked, then yes that will cause this error.
Chuck
On 2013-03-21, at 8:57 AM, vladimir gadyatskiy wrote:
> Hello all
>
> I think that the problem is somewhere here:
> public static void preFetchRelationship(String entityName, String relationshipName, NSArray<?> objects, EOEditingContext ec) {
> // EOEntity eoEntity = getEntityModelManager().getEOEntity(entityName);
> // EODatabaseContext dc = EODatabaseContext.registeredDatabaseContextForModel(eoEntity.model(), ec);
> // EORelationship rel = eoEntity.relationshipNamed(relationshipName);
> // batchFetchRelationship(dc, rel, objects, ec, true);
> }
>
> databaseContext.batchFetchRelationship(relationship, objectsToBatchFetch, editingContext);
>
> Seems that commenting all prefetches fixed problem with connections closed.
> But why?
>
> Best regards,
> Vladimir Gadyatskiy
>
>
>
> On Mar 21, 2013, at 5:06 PM, Chuck Hill wrote:
>
>> Another possibility is that something in your code (or Wonder, unlikely to be in WO itself) is accessing the database context or below without proper locking and using and closing this statement behind EOF's back. It looks less like a race condition and more like an improperly shared resource.
>>
>> Chuck
>>
>> On 2013-03-21, at 7:47 AM, Michael Gargano wrote:
>>
>>> Hi Vladimir,
>>>
>>> Mark and I work together. We have not found the solution to this problem. We modified the postgres jdbc driver to provide some additional logging, and whatever slight delay that has added seems to have lessened the frequency of the problem. We’re not sure where it is happening, but I’m convinced it has to be a race condition in wonder or EOF at this point (unless there’s something wrong with the postgres jdbc driver which I find hard to believe since so many people are using it). I’ve included Mark on this email as well. Maybe we can find a solution.
>>>
>>> Thanks.
>>> -Mike
>>>
>>>
>>> From: webobjects-dev-bounces+mgargano=email@hidden [mailto:webobjects-dev-bounces+mgargano=email@hidden] On Behalf Of vladimir gadyatskiy
>>> Sent: Wednesday, March 20, 2013 3:25 PM
>>> To: WebObjects Development
>>> Subject: RE: EOF - statement has been closed?
>>>
>>> Hello, all
>>>
>>> Sorry, I do not know how to ask Mark Cassidy directly, he'd asked about connection lost problems here: http://lists.apple.com/archives/webobjects-dev/2013/Jan/msg00429.html
>>> Mark, did you find a solution? Seems we have the same problems with Postgres 9.2...
>>> Thanks for any help.
>>>
>>> Best regards,
>>> Vladimir Gadyatskiy
>>>
>>> _______________________________________________
>>> 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
>> Executive Managing Partner, VP Development and Technical Services
>>
>> 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/gvc/practical_webobjects
>>
>> Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing Companies in B.C!
>> Global Village Consulting ranks 76th in 24th annual PROFIT 200 ranking of Canada’s Fastest-Growing Companies by PROFIT Magazine!
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
--
Chuck Hill
Executive Managing Partner, VP Development and Technical Services
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/gvc/practical_webobjects
Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing Companies in B.C!
Global Village Consulting ranks 76th in 24th annual PROFIT 200 ranking of Canada’s Fastest-Growing Companies by PROFIT Magazine!
_______________________________________________
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