Missing Indexes
Jeremy: Warnings for missing indexes
[mod_feesfines] WARN CQL2PgJSON Doing LIKE search without index for accounts.jsonb->'status'->>'name', CQL >>> SQL: status.name == Open >>> lower(f_unaccent(accounts.jsonb->'status'->>'name')) LIKE lower(f_unaccent('Open'))
Do people manually add these indexex to the databases ? Or should we file tickets ?
It might be correlated to some kind of poor performance.
Florian switched on the slow query log. He sees slow queries because the ERM module has some performance issues. He could find some indexes that could speed up (the search).
He reported it to Owen Stevens
Jason: I found some of the tickets in mod-circulation and mod-feesfines. I think they added the index.
There was a performance to be gained. https://folio-org.atlassian.net/browse/CIRCSTORE-454
https://folio-org.atlassian.net/browse/MODFEE-319
Nils: In that case we should all start filing tickets to the developers.
Jason: A lot of these indexes will come in Poppy according to the Jira tickets.
mod-user, mod-feesfines and more modules are affected. Probably it is related to an RMB problem.
They are slowly phasing out the RMB framework.
Tod: It think it will be a long, long transition phase.
It is worth implementing mod-users.
2. Application Formalization from WolfCon.
Ingolf; This is being discussed also in a German governance meeting group, now with the participation of SysOps. They will continue to meet regularly and work out a concept or proposal: Documents which contain a list of questions directed towards the tri-council-group:
TC Questions: https://docs.google.com/document/d/1OLae-eGN3_dEOXbAr7Tr1cvudBzqNA7TttzH9QmvuR8/edit#heading=h.50f0f2jmdfjl
PC Questions: https://docs.google.com/document/d/1yxF-D47tpTmiusJYn8XtWbFKnk2ZapSvxH2kxEmE-F8/edit#heading=h.tlfg3xytadup
Jason: Developers will need some bare minimum to develop on.
Jason: I am setting up an Enterprise light container platform at A&M. Consolidate shared infrasctructure. I am involved in migrating the infrastructure.
Libraries has to move on to something. We run over 18,000 containers. We have 8 K8s cluster, a lot of which are FOLIO.
We run 4 scaled instances of FOLIO, dev, test, pre and prod.
We need representation at FOLIO councils. FOLIO is enterprise software.
3. A glitch in emails going out on test instances
Nils: A glitch with mails going out on test instances
Jason: Reset user email addresses on test instances for mail tests:
UPDATE tamu_mod_users.users
SET jsonb = Jsonb_set(jsonb, '{personal, email}', '"folio_user@library.tamu.edu"')
WHERE jsonb -> 'personal' ->> 'email' != 'folio_user@library.tamu.edu'; Ingolf also observed this behaviour. |