[AIRAVATA-545] 5 minutes tutorial fails when running WS-Messenger with MySQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4-INCUBATING
• Fix Version/s: 0.5
• Component/s: WS-Messenger
• Environment: mac
• Assignee: Unassigned
• Reporter: Chathuri Wimalasena
• Created: 23/Aug/12 18:40
• Updated: 29/Aug/12 18:10
• Resolved: 29/Aug/12 17:51

Description

When running five minutes tutorial after setting up WS-Messenger with MySQL, following exception throws. This does not come with derby.

161133 [HttpConnection-8080-2] ERROR org.apache.airavata.wsmg.commons.storage.WsmgPersistantStorage - unable to enque the message in persistant storage
java.sql.SQLException: Table 'disQ' was not locked with LOCK TABLES
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
at org.apache.airavata.wsmg.commons.storage.WsmgPersistantStorage.enqueue(WsmgPersistantStorage.java:342)
at org.apache.airavata.wsmg.messenger.OutGoingQueue.storeNotification(OutGoingQueue.java:52)
at org.apache.airavata.wsmg.broker.NotificationProcessor.save(NotificationProcessor.java:299)
at org.apache.airavata.wsmg.broker.NotificationProcessor.matchAndSave(NotificationProcessor.java:279)
at org.apache.airavata.wsmg.broker.NotificationProcessor.onWSEMsg(NotificationProcessor.java:172)
at org.apache.airavata.wsmg.broker.NotificationProcessor.processMsg(NotificationProcessor.java:100)
at org.apache.airavata.wsmg.broker.wseventing.WSEventingPublishMsgReceiver.process(WSEventingPublishMsgReceiver.java:48)
at org.apache.airavata.wsmg.broker.AbstractBrokerMsgReceiver.invokeBusinessLogic(AbstractBrokerMsgReceiver.java:44)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:173)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:167)
at org.apache.axis2.transport.http.HTTPWorker.service(HTTPWorker.java:266)
at org.apache.axis2.transport.http.server.AxisHttpService.doService(AxisHttpService.java:281)
at org.apache.axis2.transport.http.server.AxisHttpService.handleRequest(AxisHttpService.java:187)
at org.apache.axis2.transport.http.server.HttpServiceProcessor.run(HttpServiceProcessor.java:82)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:680)