[JBoss-user] [Messaging, JMS & JBossMQ] - Re: Locking issues with JMS
I tried "NO-TRANSACTION" at my JMS datasource, but MySQL doesn't support datasources with No_Transaction isolation level. Anyway, the problem I was seeing was just about overusing the database. We decreased the number of connections on the datasource and everything worked. We discovered that by doing I wanted to send this post for educational purposes, so someone could look at this if having a similar problem. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3890240#3890240 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3890240 --- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Messaging, JMS & JBossMQ] - Re: Locking issues with JMS
:-) It's very funny I have copied the wrong URL here. I really meant JBAS-2056. Well anyway, now I realized what you meant by using a separate data-source without transaction isolation. I already had anothere datasource but I though you meant to set Read_Commited instead of Repeatable_Read. This benchmark is driving me crazy :-) Thanks, Clebert View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3890093#3890093 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3890093 --- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Messaging, JMS & JBossMQ] - Re: Locking issues with JMS
I've seen it once before with MySQL. The database log showed it doing page level locking (horrible) and that caused a deadlock. I didn't hear how it was fixed or worked around? Use search for similar issues with MSSQL or Sybase. i.e. stupid database locking. Like I said to you elsewhere, you don't need any locking for JBossMQ. It already does the necessary isolation. So you could try a separate DataSource with no transaction isolation, if you don't want to research MySQL locking. No idea what JBAS-1842 has to do with this? I think you've commit-option D on the brain. :-) If you mean JBAS-2056 that query is only used at startup/recovery. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3890092#3890092 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3890092 --- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user