00:04:52 Jason Root: RIP local laptop ;) 00:11:41 Shelley Doljack: update _mod_users.users set jsonb = jsonb_set(jsonb, '{personal, email}', ‘”<“’whatever fake email>) where not jsonb #>> '{personal, email}' is null; 00:12:08 Jason Root: In my experience, you need to run this a few times. I don’t exactly know why but I’ve seen it not update every record… 00:12:24 Shelley Doljack: Replying to "In my experience, yo..." Really? 00:12:45 Jason Root: Replying to "In my experience, yo..." Yeah, let me find the exact SQL I was using 00:13:52 Jason Root: Replying to "In my experience, yo..." Here is what I was using back when I was at TAMU: UPDATE tamu_mod_users.users SET jsonb = Jsonb_set(jsonb, '{personal, email}', '"folio_user@tamu.org"') WHERE jsonb -> 'personal' ->> 'email' != 'folio_user@tamu.org'; 00:14:50 Jason Root: Replying to "In my experience, yo..." Ah yours is very similar - but has a “where not" 00:19:08 Florian Kreft (LRZ): https://gitlab.bib-bvb.de/folio-public/okapi-build/-/blob/v7.0.0/Dockerfile?ref_type=heads 00:21:07 Shelley Doljack: Sorry, had to take a phone call. 00:23:11 Shelley Doljack: Replying to "In my experience, yo..." The module system users don’t have email addresses, so their records have email is null. I do counts before and after and the update stmt changes all of the user records to the fake email address. 00:24:34 Jason Root: Reacted to "The module system us..." with 🙌 00:24:50 Jason Root: I have to drop a little bit before 11:30 to another meeting. 00:25:08 Jason Root: Jenkins CI builds Okapi from here: https://jenkins-aws.indexdata.com/job/folio-org/job/okapi/ 00:31:04 Jason Root: Gotta drop, adios all! 00:34:44 minus: https://developer.hashicorp.com/vault/docs/concepts/seal 00:37:30 Trent Spears: https://github.com/lrstanley/vault-unseal 00:38:21 Shelley Doljack: resources: limits: cpu: 1024m memory: 1Gi requests: cpu: 100m memory: 256Mi 00:42:28 Jason Root: I’m back! Meeting was short. 00:47:33 Jason Root: kubectl --kubeconfig .kube/ describe pod -n That output will tell you why it’s crashing 00:48:36 Shelley Doljack: These are our Kong resources: resources: limits: ephemeral-storage: 1Gi memory: 12Gi requests: ephemeral-storage: 50Mi memory: 9Gi 01:02:57 Jason Root: I remember the days when FOLIO was 10ish modules ;) 01:07:31 Jason Root: Can confirm now they don’t all need to be running to upgrade. 01:07:49 Jason Root: But if you have other tenants you don’t want to upgrade, or can’t - then you’ll need to keep the old ones up.