There's a bunch of stuff wrong here. First, the only actually locked thread is:
-
com.webobjects.eocontrol.EOObjectStoreCoordinator.addCooperatingObjectStore(com.webobjects.eocontrol.EOCooperatingObjectStore)
@bci=5, line=130 (Interpreted frame)
-
com.webobjects.eoaccess.EODatabaseChannel.setCurrentEditingContext(com.webobjects.eocontrol.EOEditingContext)
@bci=34, line=166 (Interpreted frame)
-
com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEditingContext(com.webobjects.eocontrol.EOFetchSpecification,
com.webobjects.eocontrol.EOEditingContext) @bci=158, line=788 (Interpreted
frame)
-
com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecification(com.webobjects.eocontrol.EOFetchSpecification,
com.webobjects.eocontrol.EOEditingContext) @bci=64, line=215 (Interpreted
frame)
-
com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(com.webobjects.eocontrol.EOFetchSpecification,
com.webobjects.eocontrol.EOEditingContext) @bci=219, line=3205 (Interpreted
frame)
-
com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(com.webobjects.eocontrol.EOFetchSpecification,
com.webobjects.eocontrol.EOEditingContext) @bci=34, line=3346 (Interpreted
frame)
-
com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(com.webobjects.eocontrol.EOFetchSpecification,
com.webobjects.eocontrol.EOEditingContext) @bci=97, line=539 (Interpreted
frame)
-
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(com.webobjects.eocontrol.EOFetchSpecification,
com.webobjects.eocontrol.EOEditingContext) @bci=79, line=4114 (Interpreted
frame)
-
er.extensions.eof.ERXEC.objectsWithFetchSpecification(com.webobjects.eocontrol.EOFetchSpecification,
com.webobjects.eocontrol.EOEditingContext) @bci=72, line=1211 (Interpreted
frame)
-
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(com.webobjects.eocontrol.EOFetchSpecification)
@bci=3, line=4500 (Interpreted frame)
-
com.acaiq.fondation.acaiqCore._Licence.fetchLicences(com.webobjects.eocontrol.EOEditingContext,
com.webobjects.eocontrol.EOQualifier, com.webobjects.foundation.NSArray)
@bci=19, line=1062 (Interpreted frame)
-
com.acaiq.fondation.acaiqCore._Membre.licences(com.webobjects.eocontrol.EOQualifier,
com.webobjects.foundation.NSArray, boolean) @bci=77, line=8920 (Interpreted
frame)
-
com.acaiq.fondation.acaiqCore._Membre.licences(com.webobjects.eocontrol.EOQualifier,
boolean) @bci=4, line=8893 (Interpreted frame)
-
com.acaiq.fondation.acaiqCore.Membre.licencesParEtats(com.acaiq.fondation.acaiqCore.EtatMembre[])
@bci=100, line=980 (Interpreted frame)
- com.acaiq.fondation.acaiqCore.Membre.licencesValides() @bci=11, line=996
(Interpreted frame)
- com.acaiq.fondation.acaiqCore.Membre.estCourtier() @bci=5, line=1035
(Interpreted frame)
- sun.reflect.GeneratedMethodAccessor87.invoke(java.lang.Object,
java.lang.Object[]) @bci=40 (Interpreted frame)
Which reminds me of an unlocked EC/OSC. Second:
> java.lang.IllegalArgumentException: Attribute noCommandeOracle can't receive
> a null parameter :
> at
> com.acaiq.fondation.depot.lbaArticle._CommandesEcom.setNoCommandeOracle(_CommandesEcom.java:419)
This is a *template* that throws on null?? You sure that's such a bright idea?
Isn't this what validation is for? And third:
> at
> com.acaiq.depot.component.TransactionAchat.performAction(TransactionAchat.java:63)
> at
> com.webobjects.woextensions.WOLongResponsePage.run(WOLongResponsePage.java:119)
As you're throwing from inside a normal
com.webobjects.woextensions.WOLongResponsePage, I seriously hope you're doing
your part of try{} finally{} and EC unlocking.
Cheers, Anjo
Am 31.05.2010 um 20:02 schrieb Pascal Robert:
> One of our apps have deadlocked 5 times over 3 days, strangely enough it
> started when we moved our Oracle Database 10gR2 DB to our VMWare ESX 4.0
> cluster. e didn't re-install Oracle, I simply did a P2V (Physical to VM)
> conversion, so it's the exact same version of Oracle DB as before.
>
> What's happenning is that we store some information on our Oracle database,
> save it, and we built a copy of some of the data to a new EO (different
> entity) in a SQL Server 2005 db so the accounting system take care of billing.
>
> The exception that cause the deadlock (or at least the last thing written to
> the log before the deadlock) :
>
> java.lang.IllegalArgumentException: Attribute noCommandeOracle can't receive
> a null parameter :
> at
> com.acaiq.fondation.depot.lbaArticle._CommandesEcom.setNoCommandeOracle(_CommandesEcom.java:419)
> at com.acaiq.fondation.depot.Caissier.copiePourLBA(Caissier.java:267)
> at com.acaiq.fondation.depot.Caissier.paye(Caissier.java:137)
> at
> com.acaiq.depot.component.TransactionAchat.performAction(TransactionAchat.java:63)
> at
> com.webobjects.woextensions.WOLongResponsePage.run(WOLongResponsePage.java:119)
> at java.lang.Thread.run(Thread.java:613)
>
> And it happens here :
>
> commandeEcom.setNoCommandeOracle(((Integer) _commande.clefsPrimaire()));
>
> _commande.clefsPrimaire() is a method that simply do :
>
> return ERXEOControlUtilities.primaryKeyObjectForObject(this);
>
> So clefsPrimaire() returns null, even if the data was stored in the Oracle DB
> (and it's really there) and a primary key was generated (EOF did it, it's not
> a "human generated" PK).
>
> The whole block :
>
> try {
> _commande.setEstPaye(true);
> _commande.editingContext().saveChanges(); // This is when we save the
> EO in Oracle
> } catch (Exception e) {
> NSLog.err.appendln(e.getMessage());
>
> remboursementPayflow((Transaction)pfd.valueForKey("transaction"),_commande,
> (String) pfd.valueForKey("PNREF"));
> pfd = new NSDictionary<Object, String>(CODE_RESUTAT, "REMBOURSEMENT");
> } finally {
> try {
> copiePourLBA(_commande); // This is the method where we copy
> some data to SQL Server
> } catch (Exception e) {
> NSLog.err.appendln(e.getMessage());
> }
> _commande.editingContext().saveChanges();
> }
>
> This problem didn't happen in the past (but we also had less requests coming
> him) and it doesn't always happen :-/ jstack give me tons of this :
>
> Thread t...@71683: (state = BLOCKED)
> - java.net.PlainSocketImpl.accept(java.net.SocketImpl) @bci=0, line=382
> (Interpreted frame)
> - java.net.ServerSocket.implAccept(java.net.Socket) @bci=50, line=450
> (Interpreted frame)
> - java.net.ServerSocket.accept() @bci=48, line=421 (Interpreted frame)
> - com.webobjects.appserver._private.WOWorkerThread.run() @bci=26, line=238
> (Interpreted frame)
> - java.lang.Thread.run() @bci=11, line=613 (Interpreted frame)
>
> The only non-blocked thread is :
>
> Thread t...@78083: (state = IN_NATIVE)
> - java.net.PlainSocketImpl.socketAccept(java.net.SocketImpl) @bci=0
> (Interpreted frame)
> - java.net.PlainSocketImpl.accept(java.net.SocketImpl) @bci=7, line=384
> (Interpreted frame)
> - java.net.ServerSocket.implAccept(java.net.Socket) @bci=50, line=450
> (Interpreted frame)
> - java.net.ServerSocket.accept() @bci=48, line=421 (Interpreted frame)
> - com.webobjects.appserver._private.WOWorkerThread.run() @bci=26, line=238
> (Interpreted frame)
> - java.lang.Thread.run() @bci=11, line=613 (Interpreted frame)
>
> Beside going back to our Oracle physical server, I have no idea of why I'm
> getting this. Java 1.5 on OS X 10.4.11 Server, WO 5.3.3. W
>
> <pid23991.txt>
>
>
> ----
> Pascal Robert
> [email protected]
>
> AIM: MacTICanada
> Twitter : MacTICanada
> LinkedIn : http://www.linkedin.com/in/macti
> WO Community profile : http://wocommunity.org/page/member?name=probert
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/anjo%40krank.net
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
