Having trouble purging an old node

[Jonathan Gazeley]

Hi peeps,

I'm having trouble purging a node from PuppetDB. This is something I've
done many times before - I just issue "sudo puppet node deactivate
<fqdn>" on the puppetmaster, the node gets deactivated in PuppetDB, and
other nodes purge appropriate resources on their next checkin (e.g. the
monitoring server purges Nagios checks).

On this occasion, submitting "sudo puppet node deactivate" seems to have
no effect for this particular node. Its resources are not removed from
PuppetDB, and it never gets purged from my Nagios config. I manually
edited my Nagios configs to remove references to the dead node but on
the next run, the references are put back into the config.

The old node is most definitely switched off, not running, not checking in.

Do I need to manually erase these resources from PuppetDB? If so, what
SQL do I run to achieve this without breaking stuff?

Thanks,
Jonathan