Bugs item #831662, was opened at 2003-10-28 10:10 Message generated for change (Comment added) made by ejort You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=831662&group_id=22866
Category: JBossTX Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Marcus Eriksson (marcuseriksson) Assigned to: Adrian Brock (ejort) Summary: joxasPrep error in Oracle trace file Initial Comment: Windows 2000 Server SP4 JBoss 3.2.1 + Tomcat Oracle 9.2.0.3.0 Oracle trace file (in udump directory) reports many: EXIT joxasPrep(): err=24767 jojniPrepare(): err = 24767 On some installations these show up very regularly. It seems as if there is one such entry for each active JBoss data source every 10 minutes. However, the application works as expected. What is this? Perhaps the connection pooling mechanism is doing something strange? >From Oracle trace: Dump file d:\oracle\admin\dev9i\udump\dev9i_ora_1144.trc Tue Oct 14 10:43:51 2003 ORACLE V9.2.0.3.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Oracle9i Release 9.2.0.3.0 - Production JServer Release 9.2.0.3.0 - Production Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Instance name: dev9i Redo thread mounted by this instance: 1 Oracle process number: 14 Windows thread id: 1144, image: ORACLE.EXE *** SESSION ID:(29.64592) 2003-10-14 10:43:51.000 EXIT joxasPrep(): err=24767 jojniPrepare(): err = 24767 *** 2003-10-14 10:44:07.000 EXIT joxasPrep(): err=24767 jojniPrepare(): err = 24767 *** 2003-10-14 10:44:25.000 EXIT joxasPrep(): err=24767 jojniPrepare(): err = 24767 Dump file d:\oracle\admin\dev9i\udump\dev9i_ora_1144.trc Tue Oct 14 10:46:45 2003 ORACLE V9.2.0.3.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Oracle9i Release 9.2.0.3.0 - Production JServer Release 9.2.0.3.0 - Production Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Instance name: dev9i ---------------------------------------------------------------------- >Comment By: Adrian Brock (ejort) Date: 2003-10-28 13:23 Message: Logged In: YES user_id=9459 Did it commit? The dump shows Prep()/Prepare() Show the trace logging I asked for. The jboss tm does not try to commit resources that vote read-only. This won't cause you problems since voting read-only is an optimization to avoid round trips. Regards, Adrian ---------------------------------------------------------------------- Comment By: Marcus Eriksson (marcuseriksson) Date: 2003-10-28 12:40 Message: Logged In: YES user_id=711840 So - if Oracle voted read-only, why did the tm commit? (I have also created a TAR on Metalink for this) ---------------------------------------------------------------------- Comment By: Adrian Brock (ejort) Date: 2003-10-28 11:07 Message: Logged In: YES user_id=9459 I'm guessing 24767 is ORA-24767 An informational message that means the oracle xa session voted read-only during the prepare (i.e. no modifications to the db) I don't know why this would cause a dump? It is a standard part of XA. Perhaps you can enable TRACE logging for org.jboss.tm and org.jboss.resource to see whether there is some more information in log/server.log I don't see anything in the dump that shows the XID so it can be matched with the transaction. Regards, Adrian ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=831662&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: The SF.net Donation Program. Do you like what SourceForge.net is doing for the Open Source Community? Make a contribution, and help us add new features and functionality. Click here: http://sourceforge.net/donate/ _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development