Hi,
I got this error log[1] when testing a long running mb cluster.
1. Start two clustered mb nodes with serializers (nodeA(coordinator),
nodeB).
2. Add queue subscriber "MyQueue1", to nodeB and publish "MyQueue1"
messages to nodeA with average 1500TPS.
3. Add queue subscriber "MyQueue2" to nodeA and publish "MyQueue2" messages
to nodeB with average 1000TPS.
4. After around 12 hours, om exception has thrown from nodeB and all
operations has halted.
before the om exception throws following oracle exception has repeatedly
thrown by nodeB.
TID: [] [] [2015-03-18 02:18:08,684] ERROR
{org.wso2.andes.kernel.distruptor.inbound.InboundLogExceptionHandler} - [
Sequence: 400477036 ] Exception occurred while processing inbound
events.Event type: MESSAGE_EVENT
{org.wso2.andes.kernel.distruptor.inbound.InboundLogExceptionHandler}
org.wso2.andes.kernel.AndesException: Error occurred while adding message
content to DB
at
org.wso2.andes.store.rdbms.RDBMSMessageStoreImpl.storeMessagePart(RDBMSMessageStoreImpl.java:125)
at
org.wso2.andes.kernel.MessagingEngine.messagesReceived(MessagingEngine.java:223)
at
org.wso2.andes.kernel.distruptor.inbound.MessageWriter.onEvent(MessageWriter.java:58)
at
org.wso2.andes.kernel.distruptor.inbound.ConcurrentBatchEventHandler.onEvent(ConcurrentBatchEventHandler.java:126)
at
org.wso2.andes.kernel.distruptor.inbound.ConcurrentBatchEventHandler.onEvent(ConcurrentBatchEventHandler.java:36)
at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:128)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
*Caused by: java.sql.BatchUpdateException: ORA-01653: *unable to extend
table MB.MB_CONTENT by 8192 in tablespace USERS
at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11190)
at
oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244)
at
org.wso2.andes.store.rdbms.RDBMSMessageStoreImpl.storeMessagePart(RDBMSMessageStoreImpl.java:121)
... 8 more
What is the best way to handle this issue ? is there a oracle database
configuration to avoid this issue ?
[1]
https://drive.google.com/a/wso2.com/file/d/0B3o_bweLeo43a2tCRmt0TjRSVzQ/view?usp=sharing
Regards,
--
Pumudu Ruhunage
Associate Software Engineer | WSO2 Inc
M: +94 779 664493 | http://wso2.com
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
