You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Kishan Kavala (JIRA)" <ji...@apache.org> on 2015/09/16 12:39:45 UTC
[jira] [Commented] (CLOUDSTACK-8870) external network device usage
monitor runs even when there are no external devices
[ https://issues.apache.org/jira/browse/CLOUDSTACK-8870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14747281#comment-14747281 ]
Kishan Kavala commented on CLOUDSTACK-8870:
-------------------------------------------
Following is an extract of the logs from MySQL slow query file:
SELECT COALESCE(GET_LOCK('ExternalDeviceNetworkUsageManagerImpl', 20),0);
Time: 150611 12:01:14
User@Host: cloud[cloud] @ x2 [10.81.28.127] Id: 4752998
Query_time: 20.000116 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
SET timestamp=1434024074;
SELECT COALESCE(GET_LOCK('ExternalDeviceNetworkUsageManagerImpl', 20),0);
Time: 150611 12:06:14
User@Host: cloud[cloud] @ x2 [10.81.28.127] Id: 4756489
Query_time: 20.000102 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
SET timestamp=1434024374;
SELECT COALESCE(GET_LOCK('ExternalDeviceNetworkUsageManagerImpl', 20),0);
Time: 150611 12:11:14
User@Host: cloud[cloud] @ x2 [10.81.28.127] Id: 4759411
Query_time: 20.000115 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
SET timestamp=1434024674;
SELECT COALESCE(GET_LOCK('ExternalDeviceNetworkUsageManagerImpl', 20),0);
Time: 150611 12:16:14
User@Host: cloud[cloud] @ x2 [10.81.28.127] Id: 4762525
Query_time: 20.000117 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
SET timestamp=1434024974;
SELECT COALESCE(GET_LOCK('ExternalDeviceNetworkUsageManagerImpl', 20),0);
Time: 150611 13:40:33
User@Host: cloud[cloud] @ x2 [10.81.28.127] Id: 4783985
Query_time: 16.206891 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
SET timestamp=1434030033;
SELECT COALESCE(GET_LOCK('ExternalDeviceNetworkUsageManagerImpl', 20),0);
> external network device usage monitor runs even when there are no external devices
> ----------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-8870
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8870
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Reporter: Kishan Kavala
> Assignee: Kishan Kavala
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)