Vertica on openstack implementation

Hi,

Sometimes this is a "Resource Pool" issue. Are all user's using the general pool? If so, and there are many concurrent queries using all of the memory allocated to the GP, then all new queries, including those issued by the dbadmin user, will queue (which might appear as a frozen system).

Can you check the RESOURCE_QUEUES system table?

See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/ManageWorkloads/ResourceManagerImpactOnQueryExecution.htm

https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemTables/MONITOR/RESOURCE_QUEUES.htm

Hi Jim,
actually we are using different resource pools
we have a dedicated resource pool for loading (COPYies)
and 3 different pools for queries (1 for routable queries and 2 for reports)
I don't think it's a matter of resource contention...
(same load and amount of queries are tested over the time,
it can work smoothly for several days and then it got stuck..)
when it's frozen, restart of DB is not helping and I need to restart the VMs as well in order to get the service available again

I think it's a matter of architecture issue,
as I said we are using openstack as the virtual platform and to enhance the network bandwidth and to decrease network latency we are using an SRIOV ports implementation...
we used all recommendation we got (turn of tcp-offload... change RX/TX on the interconnect NIC)
still I feel that something is still harming the spread communication...
I would like to get some deeper configuration for the hosts interface used for Vertica and for the VMs as well...

Hi,
I would like to know where I can find the requirements/pre-requisites for Vertica Deployment on Openstack?
Can you share link to a document ?
Thank you,
Diana

Follow the guidance for Vertica on VM here:
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SupportedPlatforms/Virtualization.htm

General guidance for Vertica and OpenStack are described here:
https://www.vertica.com/blog/hpe-vertica-and-openstackba-p235411