You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airavata.apache.org by "Lahiru Gunathilake (JIRA)" <ji...@apache.org> on 2012/08/29 19:52:08 UTC

[jira] [Resolved] (AIRAVATA-545) 5 minutes tutorial fails when running WS-Messenger with MySQL

     [ https://issues.apache.org/jira/browse/AIRAVATA-545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lahiru Gunathilake resolved AIRAVATA-545.
-----------------------------------------

    Resolution: Fixed

Patch applied and thanks chathuri for the contribution.

Lahiru
                
> 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
>
>         Attachments: AIRAVATA-545.patch
>
>
> 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
For more information on JIRA, see: http://www.atlassian.com/software/jira