On Mon, Mar 1, 2010 at 8:49 PM, Krishantha Samaraweera <[email protected]>wrote:
> > > On Mon, Mar 1, 2010 at 8:32 PM, Samisa Abeysinghe <[email protected]> wrote: > >> >> >> On Mon, Mar 1, 2010 at 7:25 PM, Krishantha Samaraweera < >> [email protected]> wrote: >> >>> Hi All, >>> >>> I haven't seen the same dead lock situation when running with mysql and >>> H2. The situation may be related oracle ojdbc14.jar >>> >> >> Have you had a chance to look at MSSQL? >> > > Nope, I do not have a MSSQL server instance on my machine. I will run the > perf tests with MSSQL by tomorrow using QA test machine. > Dead lock detected with MSSQL as well. Please refer to [1] for details. [2010-03-02 10:20:05,642] ERROR - Failed to update the content id: /test/thread_T3/resourceZ0. Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transact ion. java.sql.SQLException: Transaction (Process ID 64) was deadlocked on lock resources with another process and has been ch osen as the deadlock victim. Rerun the transaction. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.updateContentId(ResourceDAO.java:1276) at org.wso2.carbon.registry.core.jdbc.dao.ResourceDAO.add(ResourceDAO.java:575) at org.wso2.carbon.registry.core.jdbc.Repository.add(Repository.java:944) at org.wso2.carbon.registry.core.jdbc.Repository.put(Repository.java:286) at org.wso2.carbon.registry.core.jdbc.EmbeddedRegistry.put(EmbeddedRegistry.java:713) at org.wso2.carbon.registry.core.session.UserRegistry.put(UserRegistry.java:599) at org.wso2.carbon.registry.app.RegistryAdapter.postEntry(RegistryAdapter.java:1184) at org.wso2.carbon.registry.app.RegistryAdapter.postEntry(RegistryAdapter.java:52) at Thanks, Krishantha. [1] http://pastebin.com/rTgNxVPk > Thanks, > Krishantha. > > > >> Samisa... >> >> >> _______________________________________________ >> Carbon-dev mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev >> >> >
_______________________________________________ Carbon-dev mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
