It looks like I am getting some deadlocks in my alert storage profile table. I have alot of devices going in and out of alarm every few seconds. Have any suggestions to correct this issue? I am using sql server 2008 and Ignition version
7.2.11-beta1 (b209)
INFO | jvm 1 | 2012/03/20 21:11:17 | WARN [StorageManager ] [21:11:17,271]: Alert storage profile "New_Alert_Storage" threw an exception on receive.
INFO | jvm 1 | 2012/03/20 21:11:17 | com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 54) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
INFO | jvm 1 | 2012/03/20 21:11:17 | at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate(SRConnectionWrapper.java:810)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runPrepUpdate(SRConnectionWrapper.java:139)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.inductiveautomation.ignition.gateway.alert.storage.DatasouceAlertStorageProfile.cleared(DatasouceAlertStorageProfile.java:405)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.inductiveautomation.ignition.gateway.alert.storage.DatasouceAlertStorageProfile.receiveAlert(DatasouceAlertStorageProfile.java:373)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.inductiveautomation.ignition.gateway.alert.storage.AlertStorageManagerImpl.receiveAlert(AlertStorageManagerImpl.java:308)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.inductiveautomation.ignition.gateway.alert.AlertBusImpl$Publisher.run(AlertBusImpl.java:88)
INFO | jvm 1 | 2012/03/20 21:11:17 | at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:526)
INFO | jvm 1 | 2012/03/20 21:11:17 | at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
INFO | jvm 1 | 2012/03/20 21:11:17 | at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
INFO | jvm 1 | 2012/03/20 21:11:17 | at java.util.concurrent.FutureTask.run(Unknown Source)
INFO | jvm 1 | 2012/03/20 21:11:17 | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
INFO | jvm 1 | 2012/03/20 21:11:17 | at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
INFO | jvm 1 | 2012/03/20 21:11:17 | at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
INFO | jvm 1 | 2012/03/20 21:11:17 | at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
INFO | jvm 1 | 2012/03/20 21:11:17 | at java.lang.Thread.run(Unknown Source)