[JBoss-dev] [ jboss-Bugs-831662 ] joxasPrep error in Oracle trace file
Bugs item #831662, was opened at 2003-10-28 11:10 Message generated for change (Comment added) made by marcuseriksson You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=831662group_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: Marcus Eriksson (marcuseriksson) Date: 2003-10-30 12:12 Message: Logged In: YES user_id=711840 Hi Adrian! This is the response I received from Oracle (actually the same as your initial response): This return code is normal. Part of the XA spec says that if a Transaction Manager (TM) asks a Resource Manager (RM) to prepare a transaction or transaction branch that has not perform any writes the RM should respond XA_RDONLY, this informs the TM it should not request this branch be committed as there is nothing to commit. XA_RDONLY maps on to 24767. When using non-JDBC drivers you would only see the XA_RDONLY reported on the client side. The JDBC drivers implements XA via calls the stored procedures on the server, hence we see the message reported in udump. The message is not a error it is simply reporting the fact we returned XA_RDONLY, this is useful to know as it indicates there was no need to use XA if the transaction is single branched. Thank you for the quick response! Regards, Marcus -- Comment By: Adrian Brock (ejort) Date: 2003-10-28 14: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 13: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 12: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=detailatid=376685aid=831662group_id=22866 --- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/
[JBoss-dev] [ jboss-Bugs-831662 ] joxasPrep error in Oracle trace file
Bugs item #831662, was opened at 2003-10-28 11:10 Message generated for change (Settings changed) made by marcuseriksson You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=831662group_id=22866 Category: JBossTX Group: v3.2 Status: Closed Resolution: Accepted 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: Marcus Eriksson (marcuseriksson) Date: 2003-10-30 12:12 Message: Logged In: YES user_id=711840 Hi Adrian! This is the response I received from Oracle (actually the same as your initial response): This return code is normal. Part of the XA spec says that if a Transaction Manager (TM) asks a Resource Manager (RM) to prepare a transaction or transaction branch that has not perform any writes the RM should respond XA_RDONLY, this informs the TM it should not request this branch be committed as there is nothing to commit. XA_RDONLY maps on to 24767. When using non-JDBC drivers you would only see the XA_RDONLY reported on the client side. The JDBC drivers implements XA via calls the stored procedures on the server, hence we see the message reported in udump. The message is not a error it is simply reporting the fact we returned XA_RDONLY, this is useful to know as it indicates there was no need to use XA if the transaction is single branched. Thank you for the quick response! Regards, Marcus -- Comment By: Adrian Brock (ejort) Date: 2003-10-28 14: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 13: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 12: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=detailatid=376685aid=831662group_id=22866 --- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/
[JBoss-dev] [ jboss-Bugs-831662 ] joxasPrep error in Oracle trace file
Bugs item #831662, was opened at 2003-10-28 11:10 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=831662group_id=22866 Category: JBossTX Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Marcus Eriksson (marcuseriksson) Assigned to: Nobody/Anonymous (nobody) 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 -- You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=831662group_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
[JBoss-dev] [ jboss-Bugs-831662 ] joxasPrep error in Oracle trace file
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=detailatid=376685aid=831662group_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 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=detailatid=376685aid=831662group_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
[JBoss-dev] [ jboss-Bugs-831662 ] joxasPrep error in Oracle trace file
Bugs item #831662, was opened at 2003-10-28 11:10 Message generated for change (Comment added) made by marcuseriksson You can respond by visiting: https://sourceforge.net/tracker/?func=detailatid=376685aid=831662group_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: Marcus Eriksson (marcuseriksson) Date: 2003-10-28 13: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 12: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=detailatid=376685aid=831662group_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
[JBoss-dev] [ jboss-Bugs-831662 ] joxasPrep error in Oracle trace file
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=detailatid=376685aid=831662group_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=detailatid=376685aid=831662group_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