[Sporadic] Deadlock - Error occurred while deleting message metadata and content for queue

[Drifftr]

Steps

1. Create 5 subscribers with selectors who will aggregate only 30 messages each
   One subscriber will have a selector which does not match any messages
2. Publish 5000 messages to the topic from 3 publishers
3. Stop the subscribers just after all the messages are received by the subscribers. (one subscriber will not receive any)
   Client used is Jmeter.

Issue

The following deadlock is observed

TID: [] [] [2015-09-22 12:01:24,600] ERROR {org.wso2.andes.kernel.MessageFlusher} -  Error occurred while sending messages to subscribers from buffer {org.wso2.andes.kernel.MessageFlusher}
org.wso2.andes.kernel.AndesException: error occurred while deleting message metadata and content for queue 
	at org.wso2.andes.store.rdbms.RDBMSStoreUtils.convertSQLException(RDBMSStoreUtils.java:128)
	at org.wso2.andes.store.rdbms.RDBMSMessageStoreImpl.deleteMessages(RDBMSMessageStoreImpl.java:1171)
	at org.wso2.andes.store.FailureObservingMessageStore.deleteMessages(FailureObservingMessageStore.java:328)
	at org.wso2.andes.kernel.MessagingEngine.deleteMessages(MessagingEngine.java:463)
	at org.wso2.andes.kernel.NoLossBurstTopicMessageDeliveryImpl.deliverMessageToSubscriptions(NoLossBurstTopicMessageDeliveryImpl.java:153)
	at org.wso2.andes.kernel.MessageFlusher.sendMessagesToSubscriptions(MessageFlusher.java:364)
	at org.wso2.andes.kernel.MessageFlusher.sendMessagesInBuffer(MessageFlusher.java:325)
	at org.wso2.andes.kernel.slot.SlotDeliveryWorker.run(SlotDeliveryWorker.java:193)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.BatchUpdateException: ORA-00060: deadlock detected while waiting for resource

	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
	at org.wso2.andes.store.rdbms.RDBMSMessageStoreImpl.deleteMessages(RDBMSMessageStoreImpl.java:1160)
	... 9 more
TID: [] [] [2015-09-22 12:01:24,602] ERROR {org.wso2.andes.kernel.slot.SlotDeliveryWorker} -  Error running Message Store Reader Error occurred while sending messages to subscribers from message buffer {org.wso2.andes.kernel.slot.SlotDeliveryWorker}
org.wso2.andes.kernel.AndesException: Error occurred while sending messages to subscribers from message buffer
	at org.wso2.andes.kernel.MessageFlusher.sendMessagesInBuffer(MessageFlusher.java:340)
	at org.wso2.andes.kernel.slot.SlotDeliveryWorker.run(SlotDeliveryWorker.java:193)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.wso2.andes.kernel.AndesException: error occurred while deleting message metadata and content for queue 
	at org.wso2.andes.store.rdbms.RDBMSStoreUtils.convertSQLException(RDBMSStoreUtils.java:128)
	at org.wso2.andes.store.rdbms.RDBMSMessageStoreImpl.deleteMessages(RDBMSMessageStoreImpl.java:1171)
	at org.wso2.andes.store.FailureObservingMessageStore.deleteMessages(FailureObservingMessageStore.java:328)
	at org.wso2.andes.kernel.MessagingEngine.deleteMessages(MessagingEngine.java:463)
	at org.wso2.andes.kernel.NoLossBurstTopicMessageDeliveryImpl.deliverMessageToSubscriptions(NoLossBurstTopicMessageDeliveryImpl.java:153)
	at org.wso2.andes.kernel.MessageFlusher.sendMessagesToSubscriptions(MessageFlusher.java:364)
	at org.wso2.andes.kernel.MessageFlusher.sendMessagesInBuffer(MessageFlusher.java:325)
	... 4 more
Caused by: java.sql.BatchUpdateException: ORA-00060: deadlock detected while waiting for resource

	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
	at org.wso2.andes.store.rdbms.RDBMSMessageStoreImpl.deleteMessages(RDBMSMessageStoreImpl.java:1160)
	... 9 more

With reference to : https://wso2.org/jira/browse/MB-1349