Transaction (Process ID XX) was deadlocked ?

[Anonymous]

I am running SymmetricDS with SQL 2008. But when run update alot rows
SymmetricDS has ERROR

2011-06-10 17:35:25,818 ERROR
org.springframework.dao.ConcurrencyFailureException: ConnectionCallback; SQL ;
Transaction (Process ID 65) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the transaction.;
nested exception is java.sql.SQLException: Transaction (Process ID 65) was
deadlocked on lock resources with another process and has been chosen as the
deadlock victim. Rerun the transaction.

org.springframework.dao.ConcurrencyFailureException: ConnectionCallback; SQL ;
Transaction (Process ID 65) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the transaction.;
nested exception is java.sql.SQLException: Transaction (Process ID 65) was
deadlocked on lock resources with another process and has been chosen as the
deadlock victim. Rerun the transaction.

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate
(SQLStateSQLExceptionTranslator.java:110)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
nslate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
nslate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
nslate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348)

at org.jumpmind.symmetric.route.AbstractDataToRouteReader.execute(AbstractData
ToRouteReader.java:141)

at org.jumpmind.symmetric.route.AbstractDataToRouteReader.run(AbstractDataToRo
uteReader.java:133)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: Transaction (Process ID 65) was deadlocked
on lock resources with another process and has been chosen 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:2820)

at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)

at net.sourceforge.jtds.jdbc.TdsCore.getNextRow(TdsCore.java:765)

at net.sourceforge.jtds.jdbc.JtdsResultSet.next(JtdsResultSet.java:596)

at
org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168)

at org.jumpmind.symmetric.route.AbstractDataToRouteReader$1.doInConnection(Abs
tractDataToRouteReader.java:164)

at org.jumpmind.symmetric.route.AbstractDataToRouteReader$1.doInConnection(Abs
tractDataToRouteReader.java:141)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)

... 5 more

How to fix it ?

Thanks in advance

Tuan Hoang Anh

[Anonymous]

I fixed error by setting

ALTER DATABASE XXXX SET READ_COMMITTED_SNAPSHOT ON;

But new error time out happend. Here is my new error

RouterService - Routing other, data.routed.count=0, total.time.ms=300008

DataGapRouteReader - org.springframework.jdbc.UncategorizedSQLException:
ConnectionCallback; uncategorized SQLException for SQL ; SQL state ; error
code ; The query has timed out.; nested exception is java.sql.SQLException:
The query has timed out.

org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback;
uncategorized SQLException for SQL ; SQL state ; error code ; The query has
timed out.; nested exception is java.sql.SQLException: The query has timed
out.

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
nslate(AbstractFallbackSQLExceptionTranslator.java:83)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
nslate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.tra
nslate(AbstractFallbackSQLExceptionTranslator.java:80)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:348)

at org.jumpmind.symmetric.route.AbstractDataToRouteReader.execute(AbstractData
ToRouteReader.java:141)

at org.jumpmind.symmetric.route.AbstractDataToRouteReader.run(AbstractDataToRo
uteReader.java:133)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: The query has timed out.

at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3936)

at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1046)

at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:
465)

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedSt
atement.java:778)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegating
PreparedStatement.java:92)

at org.jumpmind.symmetric.route.AbstractDataToRouteReader$1.doInConnection(Abs
tractDataToRouteReader.java:154)

at org.jumpmind.symmetric.route.AbstractDataToRouteReader$1.doInConnection(Abs
tractDataToRouteReader.java:141)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)

... 5 more

Please help me. I must use immediately SymmetricDS.

Tuan Hoang Anh.

[Anonymous]

I fixed it by add db.sql.query.timeout.seconds=0 to symmetric.properties