You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airavata.apache.org by "Chathuri Wimalasena (JIRA)" <ji...@apache.org> on 2012/08/23 20:40:42 UTC
[jira] [Created] (AIRAVATA-545) 5 minutes tutorial fails when
running WS-Messenger with MySQL
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
[jira] [Resolved] (AIRAVATA-545) 5 minutes tutorial fails when
running WS-Messenger with MySQL
Posted by "Lahiru Gunathilake (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Closed] (AIRAVATA-545) 5 minutes tutorial fails when
running WS-Messenger with MySQL
Posted by "Suresh Marru (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/AIRAVATA-545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Marru closed AIRAVATA-545.
---------------------------------
works with mysql now
> 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
[jira] [Updated] (AIRAVATA-545) 5 minutes tutorial fails when
running WS-Messenger with MySQL
Posted by "Chathuri Wimalasena (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/AIRAVATA-545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chathuri Wimalasena updated AIRAVATA-545:
-----------------------------------------
Attachment: AIRAVATA-545.patch
Hi Lahiru,
Attaching the patch with necessary modifications. Please apply the patch from root level of airavata-source distribution. It will be great if you can review the patch before committing.
Regards,
Chathuri
> 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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira