Skip to main content
Question

cpuaffinityset conflicts with another pool's reservation

  • September 1, 2024
  • 1 reply
  • 2 views

phil2
Forum|alt.badge.img+2
  • Participating Frequently

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.

1 reply

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • September 4, 2024

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