Menu
▾
▴
Re: [Wonder-disc] no database channel is available / Cannot rollbackTransaction() while a fetch is in progress
|
From: Lachlan D. <lac...@gm...> - 2008-07-10 23:48:33
|
I'm also getting this exception:
(ish.willowservices.soap.controllers.SOAPController, updateRecords,
SOAPController.java:652) -
failed to save
java.lang.IllegalStateException: attempt to refault an object that was
inserted into this context
at
com
.webobjects
.eocontrol.EOEditingContext.refaultObject(EOEditingContext.java:4029)
at er.extensions.ERXEC.refaultObject(ERXEC.java:1079)
at
com
.webobjects
.eocontrol
.EOEditingContext
._newChangesFromInvalidatingObjectsWithGlobalIDs(EOEditingContext.java:
3520)
at
com
.webobjects
.eocontrol
.EOEditingContext._processObjectStoreChanges(EOEditingContext.java:3558)
at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.webobjects.foundation.NSSelector.invoke(NSSelector.java:354)
at
com
.webobjects.foundation.NSSelector._safeInvokeSelector(NSSelector.java:
108)
at
com
.webobjects
.eocontrol
.EOEditingContext._sendOrEnqueueNotification(EOEditingContext.java:4784)
at
com
.webobjects
.eocontrol
.EOEditingContext._objectsChangedInStore(EOEditingContext.java:3598)
at er.extensions.ERXEC._objectsChangedInStore(ERXEC.java:1256)
at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:
120)
at com.webobjects.foundation.NSNotificationCenter
$_Entry.invokeMethod(NSNotificationCenter.java:601)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:545)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:575)
at
com
.webobjects
.eocontrol
.EOObjectStoreCoordinator
._objectsChangedInSubStore(EOObjectStoreCoordinator.java:744)
at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:
120)
at com.webobjects.foundation.NSNotificationCenter
$_Entry.invokeMethod(NSNotificationCenter.java:601)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:545)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:575)
at
com
.webobjects
.eoaccess
.EODatabaseContext._snapshotsChangedInDatabase(EODatabaseContext.java:
3821)
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:
120)
at com.webobjects.foundation.NSNotificationCenter
$_Entry.invokeMethod(NSNotificationCenter.java:601)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:545)
at
com
.webobjects
.foundation
.NSNotificationCenter.postNotification(NSNotificationCenter.java:575)
at
com
.webobjects
.eoaccess.EODatabaseContext.commitChanges(EODatabaseContext.java:6589)
at
com
.webobjects
.eocontrol
.EOObjectStoreCoordinator
.saveChangesInEditingContext(EOObjectStoreCoordinator.java:425)
at
com
.webobjects
.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3226)
at er.extensions.ERXEC._saveChanges(ERXEC.java:962)
at er.extensions.ERXEC.saveChanges(ERXEC.java:885)
On 11/07/2008, at 9:45 AM, Lachlan Deck wrote:
> The next morning... and I find that the symptoms are back again from
> the other machine also.
> I'm at a loss on this one. Any ideas on tracking this down?
>
> On 10/07/2008, at 7:18 PM, Lachlan Deck wrote:
>
>> Hi there,
>>
>> Would I be right in thinking that both these exceptions ([1] and
>> [2]) are symptoms of networking issues? i.e., periodic/regular
>> connection losses.
>> Anecdotal evidence (i.e., running the instance from another
>> machine) which doesn't appear to have these problems - but I'm
>> interested to know if anyone has any other insights.
>>
>> Thanks.
>> (mysql 5.0.51, jconnector 5.1.6, Wonder nightly 4.0.0.711, WO
>> 5.3.3, FreeBSD 7 etc).
>>
>> -------- [1] -------
>> Note: this occurs after previous successful fetches...
>>
>> 528838 INFO 2008-07-10 16:51:53,805 [WorkerThread15]
>> (er.extensions.ERXJDBCConnectionAnalyzer, testConnection, 196) -
>> JDBC connection successful!
>>
>> [2008-07-10 16:51:53 EST] <WorkerThread15> AxisFault
>> faultCode: {http://schemas.xmlsoap.org/soap/
>> envelope/}Server.userException
>> faultSubcode:
>> faultString: java.rmi.RemoteException: nextBatch failed to fetch
>> records; nested exception is:
>> java.lang.IllegalStateException: A fault was fired while another
>> fetch was in progress and no other channels were available to
>> process the fault. Either make sure not to touch faults while
>> fetching, or register more channels with the EODatabaseContext
>> (perhaps in response to the EODatabaseChannelNeededNotification).
>> Original Exception:java.lang.IllegalStateException:
>> _obtainOpenChannel -- com.webobjects.eoaccess.ISHDatabaseContext
>> com.webobjects.eoaccess.ISHDatabaseContext@197ebe66: no database
>> channel is available.
>> faultActor:
>> faultNode:
>> faultDetail:
>> {http://xml.apache.org/axis/}stackTrace: java.rmi.RemoteException:
>> nextBatch failed to fetch records; nested exception is:
>> java.lang.IllegalStateException: A fault was fired while another
>> fetch was in progress and no other channels were available to
>> process the fault. Either make sure not to touch faults while
>> fetching, or register more channels with the EODatabaseContext
>> (perhaps in response to the EODatabaseChannelNeededNotification).
>> Original Exception:java.lang.IllegalStateException:
>> _obtainOpenChannel -- com.webobjects.eoaccess.ISHDatabaseContext
>> com.webobjects.eoaccess.ISHDatabaseContext@197ebe66: no database
>> channel is available.
>> at
>> au
>> .com
>> .ish
>> .oncourseservices
>> .v2.services.InfoReplicator.nextBatch(InfoReplicator.java:117)
>> at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
>> at
>> sun
>> .reflect
>> .DelegatingMethodAccessorImpl
>> .invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585)
>> at
>> org
>> .apache
>> .axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)
>> at
>> org
>> .apache
>> .axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)
>> at
>> org
>> .apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:
>> 333)
>> at
>> org
>> .apache
>> .axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
>> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
>> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
>> at
>> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:
>> 481)
>> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
>> at
>> com
>> .webobjects
>> .appserver
>> ._private.WOWebService.performActionNamed(WOWebService.java:375)
>> at
>> com
>> .webobjects
>> .appserver
>> ._private
>> .WOActionRequestHandler._handleRequest(WOActionRequestHandler.java:
>> 240)
>> at
>> com
>> .webobjects
>> .appserver
>> ._private
>> .WOActionRequestHandler.handleRequest(WOActionRequestHandler.java:
>> 142)
>> at
>> com
>> .webobjects
>> .appserver
>> ._private
>> .WOWebServiceRequestHandler
>> .handleRequest(WOWebServiceRequestHandler.java:95)
>> at
>> ish
>> .willowservices
>> .appserver
>> .ISHWebServiceRequestHandler
>> .handleRequest(ISHWebServiceRequestHandler.java:145)
>> at
>> com
>> .webobjects
>> .appserver.WOApplication.dispatchRequest(WOApplication.java:1306)
>> at
>> er
>> .extensions
>> .ERXApplication.dispatchRequestImmediately(ERXApplication.java:1542)
>> at
>> er.extensions.ERXApplication.dispatchRequest(ERXApplication.java:
>> 1506)
>> at
>> com
>> .ish
>> .webobjects
>> .appserver.ISHApplication.dispatchRequest(ISHApplication.java:1154)
>> at
>> ish
>> .willowservices
>> .appserver.Application.dispatchRequest(Application.java:216)
>> at
>> com
>> .webobjects
>> .appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:173)
>> at
>> com
>> .webobjects
>> .appserver._private.WOWorkerThread.run(WOWorkerThread.java:254)
>> at java.lang.Thread.run(Thread.java:595)
>> Caused by: java.lang.IllegalStateException: A fault was fired while
>> another fetch was in progress and no other channels were available
>> to process the fault. Either make sure not to touch faults while
>> fetching, or register more channels with the EODatabaseContext
>> (perhaps in response to the EODatabaseChannelNeededNotification).
>> Original Exception:java.lang.IllegalStateException:
>> _obtainOpenChannel -- com.webobjects.eoaccess.ISHDatabaseContext
>> com.webobjects.eoaccess.ISHDatabaseContext@197ebe66: no database
>> channel is available.
>> at
>> com
>> .webobjects
>> .eoaccess
>> .EOAccessFaultHandler
>> .completeInitializationOfObject(EOAccessFaultHandler.java:91)
>> at
>> com
>> .webobjects.eocontrol.EOCustomObject.willRead(EOCustomObject.java:
>> 1189)
>> at com.webobjects.eocontrol._EOMutableKnownKeyDictionary
>> $Initializer
>> $
>> _GenericRecordBinding
>> .valueInObject(_EOMutableKnownKeyDictionary.java:519)
>> at
>> com
>> .webobjects
>> .eocontrol.EOCustomObject.storedValueForKey(EOCustomObject.java:1736)
>> at
>> com
>> .ish
>> .willow
>> .eoaccess
>> .model._TrainingPackage.copyrightCategory(_TrainingPackage.java:115)
>> at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
>> at
>> sun
>> .reflect
>> .DelegatingMethodAccessorImpl
>> .invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585)
>> at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor
>> $1.methodValue(NSKeyValueCoding.java:684)
>> at com.webobjects.foundation.NSKeyValueCoding
>> $_MethodBinding.valueInObject(NSKeyValueCoding.java:1160)
>> at
>> com
>> .webobjects
>> .eocontrol.EOCustomObject.valueForKey(EOCustomObject.java:1559)
>> at
>> com
>> .ish
>> .webobjects
>> .eocontrol.ISHGenericRecord.valueForKey(ISHGenericRecord.java:383)
>> at
>> ish
>> .willowservices
>> .soap.controllers.SOAPTranslator.soapTranslate(SOAPTranslator.java:
>> 212)
>> at
>> ish
>> .willowservices
>> .soap
>> .controllers
>> .SOAPController
>> .faultRecordsFromRawRowsForEntity(SOAPController.java:192)
>> at
>> au
>> .com
>> .ish
>> .oncourseservices
>> .v2.services.InfoReplicator.nextBatch(InfoReplicator.java:113)
>> ... 24 more
>>
>>
>> ----------- [2] ---------
>> Note: have been getting lots of these over the last day :-/
>>
>> [2008-07-10 16:55:52 EST] <WorkerThread15> AxisFault
>> faultCode: {http://schemas.xmlsoap.org/soap/
>> envelope/}Server.userException
>> faultSubcode:
>> faultString: java.rmi.RemoteException: updateAndReleaseCurrentBatch
>> data failed to save; nested exception is:
>> com.webobjects.jdbcadaptor.JDBCAdaptorException: Cannot
>> rollbackTransaction() while a fetch is in progress
>> faultActor:
>> faultNode:
>> faultDetail:
>> {http://xml.apache.org/axis/}stackTrace: java.rmi.RemoteException:
>> updateAndReleaseCurrentBatch data failed to save; nested exception
>> is:
>> com.webobjects.jdbcadaptor.JDBCAdaptorException: Cannot
>> rollbackTransaction() while a fetch is in progress
>> at
>> ish
>> .willowservices
>> .soap
>> .eocontrol
>> .WillowDequeueingHandler
>> .updateAndReleaseCurrentBatch(WillowDequeueingHandler.java:530)
>> at
>> ish
>> .willowservices
>> .appserver.Session.updateAndReleaseCurrentBatch(Session.java:76)
>> at
>> au
>> .com
>> .ish
>> .oncourseservices
>> .v2.services.WillowReplicator.nextBatch(WillowReplicator.java:112)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at
>> sun
>> .reflect
>> .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun
>> .reflect
>> .DelegatingMethodAccessorImpl
>> .invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585)
>> at
>> org
>> .apache
>> .axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)
>> at
>> org
>> .apache
>> .axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)
>> at
>> org
>> .apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:
>> 333)
>> at
>> org
>> .apache
>> .axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
>> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
>> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
>> at
>> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:
>> 481)
>> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
>> at
>> com
>> .webobjects
>> .appserver
>> ._private.WOWebService.performActionNamed(WOWebService.java:375)
>> at
>> com
>> .webobjects
>> .appserver
>> ._private
>> .WOActionRequestHandler._handleRequest(WOActionRequestHandler.java:
>> 240)
>> at
>> com
>> .webobjects
>> .appserver
>> ._private
>> .WOActionRequestHandler.handleRequest(WOActionRequestHandler.java:
>> 142)
>> at
>> com
>> .webobjects
>> .appserver
>> ._private
>> .WOWebServiceRequestHandler
>> .handleRequest(WOWebServiceRequestHandler.java:95)
>> at
>> ish
>> .willowservices
>> .appserver
>> .ISHWebServiceRequestHandler
>> .handleRequest(ISHWebServiceRequestHandler.java:145)
>> at
>> com
>> .webobjects
>> .appserver.WOApplication.dispatchRequest(WOApplication.java:1306)
>> at
>> er
>> .extensions
>> .ERXApplication.dispatchRequestImmediately(ERXApplication.java:1542)
>> at
>> er.extensions.ERXApplication.dispatchRequest(ERXApplication.java:
>> 1506)
>> at
>> com
>> .ish
>> .webobjects
>> .appserver.ISHApplication.dispatchRequest(ISHApplication.java:1154)
>> at
>> ish
>> .willowservices
>> .appserver.Application.dispatchRequest(Application.java:216)
>> at
>> com
>> .webobjects
>> .appserver._private.WOWorkerThread.runOnce(WOWorkerThread.java:173)
>> at
>> com
>> .webobjects
>> .appserver._private.WOWorkerThread.run(WOWorkerThread.java:254)
>> at java.lang.Thread.run(Thread.java:595)
>> Caused by: com.webobjects.jdbcadaptor.JDBCAdaptorException: Cannot
>> rollbackTransaction() while a fetch is in progress
>> at
>> com
>> .webobjects
>> .jdbcadaptor.JDBCContext.rollbackTransaction(JDBCContext.java:437)
>> at
>> com
>> .webobjects
>> .eoaccess.EODatabaseContext.rollbackChanges(EODatabaseContext.java:
>> 6606)
>> at
>> com
>> .webobjects
>> .eoaccess.EODatabaseContext.commitChanges(EODatabaseContext.java:
>> 6482)
>> at
>> com
>> .webobjects
>> .eocontrol
>> .EOObjectStoreCoordinator
>> .saveChangesInEditingContext(EOObjectStoreCoordinator.java:425)
>> at
>> com
>> .webobjects
>> .eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3226)
>> at er.extensions.ERXEC._saveChanges(ERXEC.java:962)
>> at er.extensions.ERXEC.saveChanges(ERXEC.java:885)
>> at
>> com
>> .ish
>> .willow
>> .eocontrol
>> .WillowEditingContext.saveChanges(WillowEditingContext.java:168)
>> at
>> ish
>> .willowservices
>> .soap
>> .eocontrol
>> .WillowDequeueingHandler
>> .updateAndReleaseCurrentBatch(WillowDequeueingHandler.java:526)
>> ... 27 more
>>
>> with regards,
>> --
>>
>> Lachlan Deck
>>
>
> with regards,
> --
>
> Lachlan Deck
with regards,
--
Lachlan Deck
|