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...
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...
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...
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...