| 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=Evergreen.git;a=commitdiff;h=9e98ef97bfa5c1d0c4d01a00bfd2221adfa27f77> |
| 02:02 |
pinesol |
News from commits: LP#1979345: restrict access to holds pull list <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=dada21eff78e8de6d735741201f7e813d7856683> |
| 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=Evergreen.git;a=commitdiff;h=c221e06cc40c83e70612f8357f5b96e27aede133> |
| 11:03 |
pinesol |
News from commits: LP#1901932: (follow-up) update dataset for upcoming 3.11-beta release <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=f34062f3f00d1ab8b0f3339d9e9c24a3e9d43c1b> |
| 11:03 |
pinesol |
News from commits: LP#1901932: (follow-up) update help in make_release <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=8f0aeae4f97f9853598fe0b36826c75bf11f47b6> |
| 11:03 |
pinesol |
News from commits: LP#1901932: (follow-up) update release notes <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=67c4a67349c5c0e4b65f267cea1e07e194dc5441> |
| 11:03 |
pinesol |
News from commits: LP#1901932 Wish List - Enhanced Concerto dataset <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=2ad817674d9a62094533500a3f9f9ff39fb31353> |
| 11:03 |
pinesol |
News from commits: LP#1901932 Wish List - Enhanced Concerto dataset <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=312792c5096f70a92ff6362a7255b3aa82f36cdf> |
| 11:03 |
pinesol |
News from commits: LP#1901932 Wish List - Enhanced Concerto dataset <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=01b17605a4df41fc2aadca0e7b0f9ccc0cfadd2b> |
| 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=Evergreen.git;a=commitdiff;h=016236c6ceeeedbe2c03295f802725ea93370327> |
| 11:33 |
pinesol |
News from commits: LP2018403 Update sr-only class in Facets sidebar <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=b9a0d45ff0778b03401e377369dc2baa17ad312d> |
| 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=Evergreen.git;a=commitdiff;h=cadb7351a932247e0ee9219217546ae09d4d0d4a> |
| 15:33 |
pinesol |
News from commits: LP1965446 Option to Disable Title-Level Holds on Bib Records with Parts <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=251ad10db75f72336a282fef2dc955aa03b48ef9> |
| 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=Evergreen.git;a=commitdiff;h=8782ae08c7c0d4a95999712b702443ccbc83a389> |
| 17:04 |
pinesol |
News from commits: LP#2006971: Batch penalty script additions <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=28d7884cabfe41d15f5dbe2da2bff8fdfc46b1e9> |
| 17:04 |
pinesol |
News from commits: LP1944986 Has / No-Has Penalty filters <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=5549ac01eefc4ecddd67bf0026e93e569929682b> |
| 17:04 |
pinesol |
News from commits: LP1944986 Patron penalty batch updater script <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=e58346a6687a04187c1d348c9756b24a873653d4> |
| 17:04 |
pinesol |
News from commits: LP#2006971: Custom system penalty business logic <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=20a752e24f7fb1efbfc9fb3c1483fcb3e6996291> |
| 17:04 |
pinesol |
News from commits: LP#2006971: Custom system penalties <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=1080e809c6b3968db5574b02b727fa3180a745a5> |
| 17:05 |
|
mmorgan left #evergreen |
