Clear s2synch.update_queue if NC stuck "verifying config alignment"

Clear s2synch.update_queue if NC stuck "verifying config alignment"

Steve S did this at Allina:

The two NCs with "verifying config alignment" had credential attributes and access levels in s2synch.update_queue that Global was not pulling from the queue. So Steve did this:
s2config=> select 'curl http://localhost:2356/nbws/synchro/control/entityflush/' ||entity_uuid from s2synch.update_queue where entity_type != 'PERSON';
s2config=> \o flush_config.txt
flush_config.txt: Permission denied
s2config=> \q

(needed to change out of /var/log directory so it could write)

s2support@s2ncinit:/var/log$ cd ~
s2support@s2ncinit:~$ psql s2config s2dbo

s2config=> \o flush_config.txt
s2config=> select 'curl http://localhost:2356/nbws/synchro/control/entityflush/' ||entity_uuid from s2synch.update_queue where entity_type != 'PERSON';
s2config=> \q
s2support@s2ncinit:~$ vi flush_config.txt (take out extra lines at beginning and end)
s2support@s2ncinit:~$ chmod +x flush_config.txt
s2support@s2ncinit:~$ ./flush_config.txt
Then they both started synchronizing in the UI