Global

Global out of space on /mnt/store2 that has all the index files

02/03/2025Rick Hansen
If /mnt/store2 runs out of space, you will see "out of space" messages in syslog and may get an error trying to save changes. This should be escalated to Fred, but he likes to see what he did the last time. df -h global=> SELECT schemaname, ind...

Find duplicate access cards assigned to people

01/30/2025Rick Hansen
global=> select count(*), encoded_number FROM personinfo.access_cards GROUP BY 2 having count(*)>1; count | encoded_number -------+---------------- 2 | 166772 2 | 166118 2 | 166123 (3 rows) global=> BEGIN; BEGIN global=> delete from personinf...

Try to remove login from Global user, get hibernate error

05/14/2024Rick Hansen
If you get a hibernate error when clearing a login in global then make sure there are no alarms adopted by the user. 1- Select user_id from personinfo.users where person_id=xxxxx 2- Select * from transient_alarms where owner_id= 3- Delete from...

Reinstall nbws

05/14/2024Rick Hansen
s2support@s2ncinit:/var/log/s2$ locate nbws.war /var/lib/tomcat8/webapps/nbws.war s2support@s2ncinit:/var/log/s2$ cd /var/lib/tomcat8/webapps/ s2support@s2ncinit:/var/lib/tomcat8/webapps$ ll total 70540 drwxr-xr-x 6 tomcat8 tomcat8 4096 Jan 2 11:4...