Evergreen ILS Website

IRC log for #evergreen, 2023-05-03

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

Time Nick Message
01:32 jeffdavis claiming 1372
02:02 pinesol News from commits: LP#1979345: Stamping upgrade script <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=9e98ef​97bfa5c1d0c4d01a00bfd2221adfa27f77>
02:02 pinesol News from commits: LP#1979345: restrict access to holds pull list <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=dada21​eff78e8de6d735741201f7e813d7856683>
07:04 kworstell-isl joined #evergreen
07:34 BDorsey joined #evergreen
07:44 Dyrcona joined #evergreen
08:40 mmorgan joined #evergreen
08:44 rfrasur joined #evergreen
09:00 dguarrac joined #evergreen
09:00 kworstell-isl joined #evergreen
09:01 JBoyer rhamby++
09:03 kworstell-isl joined #evergreen
09:09 mmorgan claiming 1373
09:13 BDorsey joined #evergreen
09:51 Stompro rhamby++ thanks for getting the videos posted.
09:57 kworstell-isl joined #evergreen
10:18 Dyrcona Well, there might be a reason that actor.usr_purge_data skips the authority schema. It apparently takes a long time to update 1,050,880 authorities with all of the linked bibs, etc.
10:18 Stompro mmorgan, Bob B wrote and said they found the root problem that caused Content Cafe to have issues on Monday.  He didn't tell me what it was, but hopefully the same thing won't happen again.
10:19 mmorgan Stompro: Thanks for the update! Hopefully, a learning experience.
10:19 Dyrcona I wonder if it is possible to disable authority propagate changes temporarily....
10:22 berick Dyrcona: there are some ingest.disable_authority_linking* settings that may help
10:22 berick global_flag's
10:23 berick well, ingest.disable_authority_*
10:25 Dyrcona berick: Yeah. I was just looking.... I can do that in a transaction and it won't affect anything outside of the transaction, either....
10:28 jeff "queued userpurge"
10:29 jvwoolf joined #evergreen
10:29 berick heh
10:29 jeff (but i kid, somewhat)
10:35 Dyrcona Well, we often get asked to delete users in the database because the client times out.
10:35 jvwoolf joined #evergreen
10:35 Dyrcona In this case, we have a staff account that loaded 1,050,880 authorities and changing the creator and owner will take some time.
10:37 Dyrcona It looks like all I have to do is disable ingest.reingest.force_on_same_marc.
10:38 Dyrcona And, it's not enabled already, so I guess the update is just slow.....
10:38 kworstell_isl joined #evergreen
10:41 Christineb joined #evergreen
10:51 Dyrcona I may just disable some triggers during this update.
10:54 kworstell-isl joined #evergreen
10:57 kworstell_isl joined #evergreen
10:58 gmcharlt mmorgan: are you ready to go with 1373? I have a DB update ready to push now as well
10:58 berick thunderdome
10:59 mmorgan gmcharlt: No, hit a snag. You can have 1373 if you need it.
10:59 * gmcharlt grabs 1373, then
10:59 mmorgan gmcharlt++
10:59 gmcharlt DOH
10:59 gmcharlt never mind - I don't actually need it; crossed wires
11:00 gmcharlt all thunderdome bets are now void
11:01 Dyrcona heh
11:02 Dyrcona So, yeah, DISABLE TRIGGER ALL really speeds things up. :)
11:03 Dyrcona I just HOPE that no one else messes with authorities while this update runs.
11:03 pinesol News from commits: LP#1901932: (follow-up) add caveats to documentation <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=c221e0​6cc40c83e70612f8357f5b96e27aede133>
11:03 pinesol News from commits: LP#1901932: (follow-up) update dataset for upcoming 3.11-beta release <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=f34062​f3f00d1ab8b0f3339d9e9c24a3e9d43c1b>
11:03 pinesol News from commits: LP#1901932: (follow-up) update help in make_release <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=8f0aea​e4f97f9853598fe0b36826c75bf11f47b6>
11:03 pinesol News from commits: LP#1901932: (follow-up) update release notes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=67c4a6​7349c5c0e4b65f267cea1e07e194dc5441>
11:03 pinesol News from commits: LP#1901932 Wish List - Enhanced Concerto dataset <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=2ad817​674d9a62094533500a3f9f9ff39fb31353>
11:03 pinesol News from commits: LP#1901932 Wish List - Enhanced Concerto dataset <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=312792​c5096f70a92ff6362a7255b3aa82f36cdf>
11:03 pinesol News from commits: LP#1901932 Wish List - Enhanced Concerto dataset <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=01b176​05a4df41fc2aadca0e7b0f9ccc0cfadd2b>
11:06 Dyrcona Well, this should be safer: SET session_replication_role = replica;
11:06 * Dyrcona tries that in another copy
11:10 Dyrcona Shouldn't use session_replication_role in a db function, though.
11:12 Dyrcona Ok. That's acceptable and safer.
11:13 Dyrcona Down from running for an hour with no output to finished in about 3 minutes.
11:33 pinesol News from commits: Translation updates - newpot - main branch <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=016236​c6ceeeedbe2c03295f802725ea93370327>
11:33 pinesol News from commits: LP2018403 Update sr-only class in Facets sidebar <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=b9a0d4​5ff0778b03401e377369dc2baa17ad312d>
11:35 jvwoolf joined #evergreen
11:39 jihpringle joined #evergreen
11:46 JBoyer Does the authority trigger not check to see if the MARC changed? If not that’s clearly a bug. (Not that it helps with the current issue, necessarily.)
11:57 Stompro rhamby, did you handle uploading the 2022 conference videos also?
12:00 Stompro rhamby, I was working on adding the 2022 videos to the web site /video/ area, and noticed that the "Speed Up Receiving with Automated Shipment Notifications" video seems to be missing.
12:32 Dyrcona JBoyer: Have a look at \d authority.record_entry in psql, scroll down to triggers, then look at what each of them does. It's not just a matter of "A" trigger.
12:33 JBoyer I figured (and sent that at lunch :) ) there's probably cause to re-evaluate how a good number of our triggers work and what / why they're doing what they do.
12:36 Dyrcona Well, it's not too bad if you're only updating a few records, but when it's 1,050,880 and you've already updated the other database records that would be affected by the two fields you're changing....
12:38 Dyrcona I do wonder if session_replication_role would work in a db function and what possible side effects it might have.
12:39 Dyrcona Because we really don't want the triggers to fire when all we're doing is updating creator and editor on some bib and authority records.
12:43 Dyrcona Looks like we couldn't use it, or it would have no effect, in a db function, since session_replication_role is a client connection parameter.
12:44 jvwoolf joined #evergreen
13:15 kworstell-isl joined #evergreen
13:39 kco joined #evergreen
13:48 Dyrcona Question: Lp 1981712 should have the pullrequest tag on it, no? The related bug 1989481 does.
13:48 pinesol Launchpad bug 1981712 in Evergreen "wishlist: SIP redaction" [Wishlist,Confirmed] https://launchpad.net/bugs/1981712 - Assigned to Jason Etheridge (phasefx)
13:48 pinesol Launchpad bug 1989481 in SIPServer "SIP filters" [Undecided,New] https://launchpad.net/bugs/1989481
13:51 Dyrcona Oh, wait. I missed that the former is assigned to phasefx, so I guess it is being worked on.
13:51 kworstell-isl joined #evergreen
13:53 Guest7 joined #evergreen
14:28 mmorgan1 joined #evergreen
14:53 mmorgan joined #evergreen
15:08 rhamby_ Stompro I think Tiffany actually did the work of uploading them though I gave them to her. There were a few corrupted if memory serves but tlittle may want to sanity check me.
15:33 pinesol News from commits: LP#1965446 Stamping upgrade script <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=cadb73​51a932247e0ee9219217546ae09d4d0d4a>
15:33 pinesol News from commits: LP1965446 Option to Disable Title-Level Holds on Bib Records with Parts <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=251ad1​0db75f72336a282fef2dc955aa03b48ef9>
15:41 mmorgan joined #evergreen
16:28 jvwoolf left #evergreen
16:46 berick grabbing 1374
17:04 pinesol News from commits: LP2006971 Stamping SQL Upgrade (Custom Penalties) <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=8782ae​08c7c0d4a95999712b702443ccbc83a389>
17:04 pinesol News from commits: LP#2006971: Batch penalty script additions <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=28d788​4cabfe41d15f5dbe2da2bff8fdfc46b1e9>
17:04 pinesol News from commits: LP1944986 Has / No-Has Penalty filters <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=5549ac​01eefc4ecddd67bf0026e93e569929682b>
17:04 pinesol News from commits: LP1944986 Patron penalty batch updater script <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=e58346​a6687a04187c1d348c9756b24a873653d4>
17:04 pinesol News from commits: LP#2006971: Custom system penalty business logic <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=20a752​e24f7fb1efbfc9fb3c1483fcb3e6996291>
17:04 pinesol News from commits: LP#2006971: Custom system penalties <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=1080e8​09c6b3968db5574b02b727fa3180a745a5>
17:05 mmorgan left #evergreen

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat