Re: [openstack-dev] [Openstack] Listing of volume fails while using openstack client

[Turbo Fredriksson]

On Jul 28, 2016, at 4:57 PM, varun bhatnagar wrote:

> are you asking me to set the value of max_connections to 5000 in mysql conf?

THere was no suggestion. I just told you that I had a similar/same problem
as you and how I solved it.
--
God gave man both a penis and a brain,
but unfortunately not enough blood supply
to run both at the same time.
- R. Williams


__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Re: [openstack-dev] [Openstack] Listing of volume fails while using openstack client

[varun bhatnagar]

Hi,

Thanks for the answer.

Just to be clear

are you asking me to set the value of max_connections to 5000 in mysql conf?
If yes then for me it is set to 8192 alreadyor have I misunderstood
your suggestion?

BR,
Varun

On Thu, Jul 28, 2016 at 5:35 PM, Turbo Fredriksson  wrote:

> On Jul 28, 2016, at 1:57 PM, varun bhatnagar wrote:
>
> > I am trying to list volumes using openstack client, the command works
> > sometimes but sometimes it fails:
>
>
> I get that when my MySQL server "max_connections" is reached.
> I've bumped it to 5000 to be absolutly sure!
>
> SET GLOBAL max_connections = 5000;
>
> For some reason, the
>
> max_connections = 5000
>
> in the config file doesn't take between reboots :(. Haven't had
> time or interest to investigate further.
> --
> As soon as you find a product that you really like,
> they will stop making it.
> - Wilson's Law
>
>
> __
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Re: [openstack-dev] [Openstack] Listing of volume fails while using openstack client

[Turbo Fredriksson]

On Jul 28, 2016, at 1:57 PM, varun bhatnagar wrote:

> I am trying to list volumes using openstack client, the command works
> sometimes but sometimes it fails:


I get that when my MySQL server "max_connections" is reached.
I've bumped it to 5000 to be absolutly sure!

SET GLOBAL max_connections = 5000;

For some reason, the

max_connections = 5000

in the config file doesn't take between reboots :(. Haven't had
time or interest to investigate further.
--
As soon as you find a product that you really like,
they will stop making it.
- Wilson's Law


__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Re: [openstack-dev] [Openstack] Listing of volume fails while using openstack client

[Duncan Thomas]

Looks like either you've got an intermittent network problem or the cinder
api service is restarting. Anything enlightening in the cinder-api log?

On 28 Jul 2016 16:41, "varun bhatnagar"  wrote:

Hello Steve,

Thanks a lot for such a quick response.

Yes the IP is reachable.

ping 10.33.237.104
PING 10.33.237.104 (10.33.237.104) 56(84) bytes of data.
64 bytes from 10.33.237.104: icmp_seq=1 ttl=64 time=0.587 ms
64 bytes from 10.33.237.104: icmp_seq=2 ttl=64 time=0.101 ms
64 bytes from 10.33.237.104: icmp_seq=3 ttl=64 time=0.092 ms
64 bytes from 10.33.237.104: icmp_seq=4 ttl=64 time=0.144 ms
^C
--- 10.33.237.104 ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3003ms
rtt min/avg/max/mdev = 0.092/0.231/0.587/0.206 ms
root@cic-1:~#


Endpoints for keystone and cinder are defined as below:

| keystone   | identity   | RegionOne
 |
|||   publicURL:
http://10.33.237.104:5000/v2.0  |
|||   internalURL:
http://192.168.2.28:5000/v2.0 |
|||   adminURL:
http://192.168.2.28:35357/v2.0   |


| cinderv2   | volumev2   | RegionOne
 |
|||   publicURL:
http://10.33.237.104:8776/v2/3cbbffce04d9463e8cb8d3ca6480ed92   |
|||   internalURL:
http://192.168.2.28:8776/v2/3cbbffce04d9463e8cb8d3ca6480ed92  |
|||   adminURL:
http://192.168.2.28:8776/v2/3cbbffce04d9463e8cb8d3ca6480ed92 |
|||
 |


And adding debug gives the below details:

openstack volume list --debug
START with options: ['volume', 'list', '--debug']
options: Namespace(access_token_endpoint='', auth_type='', auth_url='
http://192.168.2.28:5000/v2.0', cacert='', client_id='',
client_secret='***', cloud='', debug=True, default_domain='Default',
deferred_help=False, domain_id='', domain_name='', endpoint='',
identity_provider='', identity_provider_url='', insecure=None,
interface='', log_file=None, os_clustering_api_version='1',
os_compute_api_version='', os_data_processing_api_version='1.1',
os_data_processing_url='', os_dns_api_version='2',
os_identity_api_version='', os_image_api_version='',
os_key_manager_api_version='1', os_network_api_version='',
os_object_api_version='', os_orchestration_api_version='1',
os_project_id=None, os_project_name=None, os_queues_api_version='1.1',
os_volume_api_version='', os_workflow_api_version='2', password='***',
profile=None, project_domain_id='', project_domain_name='', project_id='',
project_name='admin', protocol='', region_name='RegionOne', scope='',
service_provider_endpoint='', timing=False, token='***', trust_id='',
url='', user_domain_id='', user_domain_name='', user_id='',
username='admin', verbose_level=3, verify=None)
defaults: {u'auth_type': 'password', u'compute_api_version': u'2', 'key':
None, u'database_api_version': u'1.0', 'api_timeout': None,
u'baremetal_api_version': u'1', u'image_api_version': u'2', 'cacert': None,
u'image_api_use_tasks': False, u'floating_ip_source': u'neutron',
u'orchestration_api_version': u'1', u'interface': None,
u'network_api_version': u'2', u'image_format': u'qcow2',
u'key_manager_api_version': u'v1', u'metering_api_version': u'2', 'verify':
True, u'identity_api_version': u'2.0', u'volume_api_version': u'2', 'cert':
None, u'secgroup_source': u'neutron', u'container_api_version': u'1',
u'dns_api_version': u'2', u'object_store_api_version': u'1',
u'disable_vendor_agent': {}}
cloud cfg: {'auth_type': 'password', u'compute_api_version': u'2',
u'orchestration_api_version': '1', u'database_api_version': u'1.0',
'data_processing_api_version': '1.1', u'network_api_version': u'2',
u'image_format': u'qcow2', u'image_api_version': u'2',
'clustering_api_version': '1', 'verify': True, u'dns_api_version': '2',
u'object_store_api_version': u'1', 'verbose_level': 3, 'region_name':
'RegionOne', 'api_timeout': None, u'baremetal_api_version': u'1',
'queues_api_version': '1.1', 'auth': {'username': 'admin', 'project_name':
'admin', 'password': '***', 'auth_url': 'http://192.168.2.28:5000/v2.0'},
'default_domain': 'Default', u'container_api_version': u'1',
u'image_api_use_tasks': False, u'floating_ip_source': u'neutron', 'key':
None, 'timing': False, 'cacert': None, u'key_manager_api_version': '1',
u'metering_api_version': u'2', 'deferred_help': False,
u'identity_api_version': u'2.0', 'workflow_api_version': '2',
u'volume_api_version': u'2', 'cert': None, u'secgroup_source': u'neutron',
'debug': True, u'interface': None, u'disable_vendor_agent': {}}
compute API version 2, cmd group openstack.compute.v2
network API version 2, cmd group openstack.network.v2
image API version 2, cmd group 

Re: [openstack-dev] [Openstack] Listing of volume fails while using openstack client

[varun bhatnagar]

Hello Steve,

Thanks a lot for such a quick response.

Yes the IP is reachable.

ping 10.33.237.104
PING 10.33.237.104 (10.33.237.104) 56(84) bytes of data.
64 bytes from 10.33.237.104: icmp_seq=1 ttl=64 time=0.587 ms
64 bytes from 10.33.237.104: icmp_seq=2 ttl=64 time=0.101 ms
64 bytes from 10.33.237.104: icmp_seq=3 ttl=64 time=0.092 ms
64 bytes from 10.33.237.104: icmp_seq=4 ttl=64 time=0.144 ms
^C
--- 10.33.237.104 ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3003ms
rtt min/avg/max/mdev = 0.092/0.231/0.587/0.206 ms
root@cic-1:~#


Endpoints for keystone and cinder are defined as below:

| keystone   | identity   | RegionOne
 |
|||   publicURL:
http://10.33.237.104:5000/v2.0  |
|||   internalURL:
http://192.168.2.28:5000/v2.0 |
|||   adminURL:
http://192.168.2.28:35357/v2.0   |


| cinderv2   | volumev2   | RegionOne
 |
|||   publicURL:
http://10.33.237.104:8776/v2/3cbbffce04d9463e8cb8d3ca6480ed92   |
|||   internalURL:
http://192.168.2.28:8776/v2/3cbbffce04d9463e8cb8d3ca6480ed92  |
|||   adminURL:
http://192.168.2.28:8776/v2/3cbbffce04d9463e8cb8d3ca6480ed92 |
|||
 |


And adding debug gives the below details:

openstack volume list --debug
START with options: ['volume', 'list', '--debug']
options: Namespace(access_token_endpoint='', auth_type='', auth_url='
http://192.168.2.28:5000/v2.0', cacert='', client_id='',
client_secret='***', cloud='', debug=True, default_domain='Default',
deferred_help=False, domain_id='', domain_name='', endpoint='',
identity_provider='', identity_provider_url='', insecure=None,
interface='', log_file=None, os_clustering_api_version='1',
os_compute_api_version='', os_data_processing_api_version='1.1',
os_data_processing_url='', os_dns_api_version='2',
os_identity_api_version='', os_image_api_version='',
os_key_manager_api_version='1', os_network_api_version='',
os_object_api_version='', os_orchestration_api_version='1',
os_project_id=None, os_project_name=None, os_queues_api_version='1.1',
os_volume_api_version='', os_workflow_api_version='2', password='***',
profile=None, project_domain_id='', project_domain_name='', project_id='',
project_name='admin', protocol='', region_name='RegionOne', scope='',
service_provider_endpoint='', timing=False, token='***', trust_id='',
url='', user_domain_id='', user_domain_name='', user_id='',
username='admin', verbose_level=3, verify=None)
defaults: {u'auth_type': 'password', u'compute_api_version': u'2', 'key':
None, u'database_api_version': u'1.0', 'api_timeout': None,
u'baremetal_api_version': u'1', u'image_api_version': u'2', 'cacert': None,
u'image_api_use_tasks': False, u'floating_ip_source': u'neutron',
u'orchestration_api_version': u'1', u'interface': None,
u'network_api_version': u'2', u'image_format': u'qcow2',
u'key_manager_api_version': u'v1', u'metering_api_version': u'2', 'verify':
True, u'identity_api_version': u'2.0', u'volume_api_version': u'2', 'cert':
None, u'secgroup_source': u'neutron', u'container_api_version': u'1',
u'dns_api_version': u'2', u'object_store_api_version': u'1',
u'disable_vendor_agent': {}}
cloud cfg: {'auth_type': 'password', u'compute_api_version': u'2',
u'orchestration_api_version': '1', u'database_api_version': u'1.0',
'data_processing_api_version': '1.1', u'network_api_version': u'2',
u'image_format': u'qcow2', u'image_api_version': u'2',
'clustering_api_version': '1', 'verify': True, u'dns_api_version': '2',
u'object_store_api_version': u'1', 'verbose_level': 3, 'region_name':
'RegionOne', 'api_timeout': None, u'baremetal_api_version': u'1',
'queues_api_version': '1.1', 'auth': {'username': 'admin', 'project_name':
'admin', 'password': '***', 'auth_url': 'http://192.168.2.28:5000/v2.0'},
'default_domain': 'Default', u'container_api_version': u'1',
u'image_api_use_tasks': False, u'floating_ip_source': u'neutron', 'key':
None, 'timing': False, 'cacert': None, u'key_manager_api_version': '1',
u'metering_api_version': u'2', 'deferred_help': False,
u'identity_api_version': u'2.0', 'workflow_api_version': '2',
u'volume_api_version': u'2', 'cert': None, u'secgroup_source': u'neutron',
'debug': True, u'interface': None, u'disable_vendor_agent': {}}
compute API version 2, cmd group openstack.compute.v2
network API version 2, cmd group openstack.network.v2
image API version 2, cmd group openstack.image.v2
volume API version 2, cmd group openstack.volume.v2
identity API version 2.0, cmd group openstack.identity.v2
object_store API version 1, cmd group openstack.object_store.v1
orchestration API version 

Re: [openstack-dev] [Openstack] Listing of volume fails while using openstack client

[Steve Martinelli]

try running the command with --debug when it fails. normally that error
happens when the client can't reach the host, does the IP address and port
number look correct?

On Thu, Jul 28, 2016 at 8:57 AM, varun bhatnagar 
wrote:

> Hi,
>
> I am using OpenStack Mitaka.
> I am trying to list volumes using openstack client, the command works
> sometimes but sometimes it fails:
>
> openstack volume list
> Unable to establish connection to
> http://10.33.237.104:8776/v2/3cbbffce04d9463e8cb8d3ca6480ed92/volumes/detail
>
> openstack volume list
>
> +--+--+---+--+-+
> | ID   | Display Name | Status| Size |
> Attached to |
>
> +--+--+---+--+-+
> | dfab04ce-5ad3-4787-8342-3e76afd877a0 | testvol  | available |1 |
> |
>
> +--+--+---+--+-+
>
>
> Can anyone please tell me what is wrong here.
>
> BR,
> Varun
>
> ___
> Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to : openst...@lists.openstack.org
> Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
>
__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

[openstack-dev] [Openstack] Listing of volume fails while using openstack client

[varun bhatnagar]

Hi,

I am using OpenStack Mitaka.
I am trying to list volumes using openstack client, the command works
sometimes but sometimes it fails:

openstack volume list
Unable to establish connection to
http://10.33.237.104:8776/v2/3cbbffce04d9463e8cb8d3ca6480ed92/volumes/detail

openstack volume list
+--+--+---+--+-+
| ID   | Display Name | Status| Size |
Attached to |
+--+--+---+--+-+
| dfab04ce-5ad3-4787-8342-3e76afd877a0 | testvol  | available |1 |
|
+--+--+---+--+-+


Can anyone please tell me what is wrong here.

BR,
Varun
__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev