Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
0.4-INCUBATING
-
None
-
mac
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)