We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


cpuaffinityset conflicts with another pool's reservation — Vertica Forum

cpuaffinityset conflicts with another pool's reservation

phil2phil2 ✭
in General Discussion

Hello.

I'm trying to set exclusive cpu affinity for loader pool and I cannot do this:

`
alter resource pool mypool cpuaffinitymode EXCLUSIVE cpuaffinityset '88-95'
-- Message: Request for reservation of CPU #88 conflicts with another pool's reservation,
-- Sqlstate: 22023,

alter resource pool mypool cpuaffinitymode EXCLUSIVE cpuaffinityset '10%'
-- Message: Unable to allocate 10 CPUs for resource pool in EXCLUSIVE affinity mode,
-- Sqlstate: 22023,
`

I see that for an empty test cluster there is no problem with enforcing exclusive affinity.
What are the limitations for setting cpu affinity? I'm geussing I need to close all sessions before doing it.

Answers

  • SruthiASruthiA Administrator

    Please open a support case and share scrutinize. we need to review what is going on in the cluster to share suggestions.

This discussion has been closed.