Chathuri Wimalasena created AIRAVATA-545:
--------------------------------------------
Summary: 5 minutes tutorial fails when running WS-Messenger with
MySQL
Key: AIRAVATA-545
URL: https://issues.apache.org/jira/browse/AIRAVATA-545
Project: Airavata
Issue Type: Bug
Components: WS-Messenger
Affects Versions: 0.4-INCUBATING
Environment: mac
Reporter: Chathuri Wimalasena
Fix For: 0.5-INCUBATING
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)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
