Evergreen ILS Website

IRC log for #evergreen, 2022-10-27

| 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
07:39 collum joined #evergreen
08:21 mantis1 joined #evergreen
08:37 jvwoolf joined #evergreen
08:37 mmorgan joined #evergreen
08:44 Dyrcona joined #evergreen
08:53 kworstell-isl joined #evergreen
08:56 dguarrac joined #evergreen
09:18 stephengwills joined #evergreen
09:18 Dyrcona miker: Since it would take a day pretty much to restore and "re-upgrade" the database, I'll stick with what I've got checked out. I'll see about pulling the top commits from your other branch.
09:57 Dyrcona miker: Everything is failing with the changes to metabib.reingest_metabib_field_entries. I'm going to back it out.
09:59 miker awesome. if you have more info than that, that'd be great. I'm not seeing everything fail...
09:59 miker thanks for testing, regardless
10:02 miker Dyrcona: that function has changes that depend on the deadlock branch, fwiw
10:03 Dyrcona Yeah, I have those. I did the DYM deadlock upgrade, too.
10:03 Dyrcona miker: Here's a PostgreSQL log entry, https://pastebin.com/SsECj4QB
10:13 Dyrcona I stopped the coordinator, replaced the function, and it seems to be working again.
10:15 mmorgan claiming 1343
10:28 Dyrcona typos-- # Not related.
10:46 Dyrcona There's no database function to clone a user.... Bummer.
10:56 pinesol News from commits: LP1396764 - Stamping upgrade script <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=c1b85d​1d09151483c62bba1cce268cec154ab0a4>
10:56 pinesol News from commits: LP1396764 - Add Release Notes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=2d89e1​4fd5de07a217f1c4bfbc6865addb169f21>
10:56 pinesol News from commits: LP1396764 - Apply Hours of Operation Note Field to tpac <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=5c42bd​1b095f374af50fca75563a089cdc5462ca>
10:56 pinesol News from commits: lp1396764 - Hourse of Operation Note Field <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=16c2c1​2e48cb0121a41475cdf33889276c297e3f>
10:57 miker Dyrcona: that's good, but strange... thanks again
11:15 mantis1 joined #evergreen
11:27 Dyrcona miker: By "replaced the function," I mean that I went back to the version from the base schema.
11:33 miker ah, ok. well, I confess that the error message in the log doesn't make much sense to me, it's complaining about a different table... but I'll see if I can sus out what's up there
11:34 Dyrcona I'll try the new implementation again tomorrow or next week. I'm also trying to test a load of records that say they're MARC8, but I have my suspicions.
11:35 Dyrcona I have some smaller batches that I'll use with the new implementation.
11:36 Dyrcona Yeah, I wasn't really sure about the error message, either. I've got a couple of thousand more if you want to extract another.
11:36 Dyrcona Something like 2,500 failed by the time that I noticed.
11:40 Dyrcona Going back to my lament about not being able to clone a user in the database, turns out that I have a function to do what I really want: CREATE OR REPLACE FUNCTION cwmars.mksipaccount(username TEXT, password TEXT, profile TEXT, home_ou TEXT).
11:40 Dyrcona Thanks, past me!
11:40 Dyrcona Let me make sure it does the new thing for the password.
11:41 Dyrcona It does! How about that!
11:41 * Dyrcona cranks up the Iron Maiden...
11:46 miker Dyrcona: so, I found the issue. the problem is in the details of PG's fkey checks. the cause is updating the id (which the named table points to as "entry"), even with the original value. we can replace sort_value, since it's the same and (basically) a key as well with the same effect and not bonk into that issue. I'm testing that change now (no explosions after 5min+), but it comes down to this if you want to use "\ef metabib.
11:46 miker reingest_metabib_field_entries" to adjust the new version in situ: https://pastebin.com/PKDrhfSX
11:46 jihpringle joined #evergreen
11:48 Dyrcona miker: Cool, I'll give that a shot after I play with my new SIP accounts.
11:48 miker +1
11:49 miker I force pushed that change (and it's the only difference) to the last branch linked on the bug
11:49 Dyrcona OK. I've got a SQL that I can patch. I extracted the function definitions to individual files.
11:49 Dyrcona That patch is on the new version, right?
11:52 * Dyrcona tries it to see if it applies.
11:59 mantis1 joined #evergreen
12:01 Dyrcona Oof!
12:02 Dyrcona rm
12:02 Dyrcona wrong window
12:13 miker sorry, yes, the id to sort_value change is on the branch now
12:15 Dyrcona I suppose that I could just replace the function while it's running and see what happens.
12:39 Dyrcona miker++ I swapped ou the function definition and it's still working.
12:39 miker huzzah!
12:49 Dyrcona My SIP test is not going so well. I can't tell if I'm failing to log in or if my test script is just blowing up. I'm getting a socket error.
13:04 Dyrcona hmm. I get no response from server when I try to login with a newly created account, but pre-existing ones work. I even tried running actor.change_password() with the password that I'm using.
13:09 Dyrcona There's a bug, I think. I was trying to use the location to add a workstation for the new users. When I removed the location, it worked.
13:09 mrtnnbr joined #evergreen
13:09 Dyrcona :(
13:12 Dyrcona Maybe location goes elsewhere?
13:13 JBoyer You can't create locations (workstations) via SIP, they have to exist already
13:13 Dyrcona JBoyer: yeah, the workstation exists.
13:13 Dyrcona I created them via SQL before doing this.
13:13 JBoyer Ah, I misread the "add a workstation" part.
13:13 Dyrcona Well, no. I just wasn't clear.
13:14 Dyrcona English.....
13:14 Dyrcona Oh, wait a minute. I bet I know what the problem is...
13:14 JBoyer So it's not working in the 93 message CP field?
13:15 Dyrcona I send the 93, and get no response when location is set (incorrectly).
13:15 Dyrcona I think I have the wrong name.
13:17 Dyrcona Yeah. I created the workstation in the db like the staff client does the shortname in front of it. I didn't put that in the oils_sip.xml. Fixed that, and it is working, now.
13:17 Dyrcona JBoyer++
13:17 JBoyer Aha, I was about to say, the client Does Things to the name you give it, SIPServer doesn't. :)
13:18 Dyrcona Yeah. Since I'm making these in the database, I won't add the shortname. Someone else is going to make the changes to the sip configuration.
13:22 jeff I don't remember if any receipt template logic ever supported this, but (did we / do we) have the ability for conditional logic in the receipt template to override print context?
13:23 jeff (I'm not certain how that would work, but I have a vague recollection of it being either a thing that was discussed, or perhaps even implemented.
13:23 jeff )
13:23 berick jeff: there's settings for that
13:24 berick e.g. eg.print.template_context.patron_address
13:25 berick well, that's not *in the template*
13:27 jeff Yeah, this would be in the template.
13:42 jihpringle joined #evergreen
13:58 Dyrcona Four new failures since the new function went in.
14:09 Dyrcona 2022-10-27 12:45:45.666 EDT [344410] evergreen@jasontest WARNING:  Process 344410 waits for ShareLock on transaction 456780009; blocked by process 344412
14:09 Dyrcona That's the first one.
14:12 sleary joined #evergreen
14:13 Dyrcona The other 3 are also deadlocks.
15:29 Dyrcona So, I am now getting sharelock violations. That's it. I'll have to reload everything next week and start over with a clean upgrade to master, etc., to make sure I have everything, but I am pretty sure that everything is up to date.
15:37 jeffdavis Do we have a way to flag bugs that need discussion rather than testing for bug squashing week? There's a fix for bug 1863387 that I'd like to commit as-is, but it would be good to know if end users think it needs more work.
15:37 pinesol Launchpad bug 1863387 in Evergreen "Carousels: shelving location selector should limit initial set of choices" [Medium,Confirmed] https://launchpad.net/bugs/1863387
15:37 Dyrcona jeffdavis: needsdiscussion tag.
15:40 jeffdavis oh, are needsdiscussion bugs already included in bug squashing? that would be great!
15:40 Dyrcona I don't know what gets considered for bug squashing. We have needsdiscussion for bugs that need discussion on the approach, so that seems like the tag you want.
15:49 sleary I forgot about that tag
15:50 Dyrcona On the plus side, the ingest coordinator has stayed up and running.
15:51 jvwoolf left #evergreen
16:16 mmorgan jeffdavis: I am pretty sure the main focus of bug squashing week is bugs with pullrequests, terranm does a masterful job of organizing them on test servers with signoffs as a goal.
16:17 mmorgan But I would think BSW is a great opportunity to look at needsdiscussion bugs, too.
16:50 stephengwills left #evergreen
17:06 mmorgan left #evergreen
18:25 sandbergja joined #evergreen
18:26 sandbergja claiming 1345
18:27 pinesol News from commits: LP#1964629 release note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=e4cffa​961ffd645702c90c6dc044619a8cdc46c8>
18:27 pinesol News from commits: LP#1964629 - Item Status - add column for Total Circs <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=c00507​abb2b9a2723caea0c812a7aadd1930ebd6>
18:27 pinesol News from commits: LP#1864507 follow-up, stamp upgrade script, and release notes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=b18c38​358b5164ad8d5e6797e811c86a0fc6376c>
18:27 pinesol News from commits: LP#1864507: Improve browse by removing more ISBD <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=fe9db5​1e9442c938d7d7226aa211b7a3cd09c38d>
18:57 pinesol News from commits: LP1952931 release notes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=b33f11​70050401a0c6066452a09d391fd97a7cd2>
18:57 pinesol News from commits: LP1952931 stamp upgrade script <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=25f23c​a394d5759f685f6b54933e9d0db18423cd>
18:57 pinesol News from commits: LP1952931 Support ACQ Advanced Shipment Notices (DESADV -- Dispatch Advice Messages) <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=eae6c7​e0eacc9ebf4bfd2014d9c6485a61de8a0c>
19:28 gmcharlt testing, then pusing fix to 1344
19:38 sandbergja joined #evergreen
19:38 sandbergja gmcharlt++
19:57 pinesol News from commits: LP#1724032: add release note entry <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=2cad20​e67af7d630b18834313960e00414dd758e>
19:57 pinesol News from commits: LP1724032 Permisson Group on Hold Shelf Slip Print Template <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=d30f91​c12f374d36c554652b40edd84cd61cee9b>
19:57 pinesol News from commits: LP1951996 release notes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=7686aa​6dd6e7089585748c96695b3fef7f6780f4>
19:57 pinesol News from commits: LP#1818303: add release note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=53b175​9cd6adb429a09ed42637aa16841a3f46d4>
19:57 pinesol News from commits: LP1818303 Add Approval Code to Bill History Grid <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=e7dd6e​3e29fa0d3349f01344651537fedcd94ec4>
19:57 pinesol News from commits: LP1951996 Preferred names in group member details <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=3d8262​fe1350615426e7e96d89d94564eefc49b3>
19:57 pinesol News from commits: LP#1864507: (follow-up) fix seed data and schema update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=57dfc3​af76fa8caa815adb7ba1462d2befc5e203>
20:14 * gmcharlt claims 1346
20:27 pinesol News from commits: lp1977877 release notes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=1f3213​9c68e5bac148148118fb01482a93103557>
20:27 pinesol News from commits: lp1977877 confirmation dialogs for Remove Note, Archive Note, and Unarchive Note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=16390a​0dfebd0253db1125b637054b0c32e1d227>
20:27 pinesol News from commits: lp1977877 action for unarchiving Notes in the staff UI <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=3ca17f​257c2fec0e363edc463baaf609dc5aa746>
20:27 pinesol News from commits: lp1977877 Hide Message Center from Patron -> Other menu <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=e14d6d​82dcde654f7b3686a344114e0a5909f0d9>
20:28 pinesol News from commits: LP#1904036: stamp DB update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=3cbfba​e842eaf6a6d274afb853fd33ae1146f4a7>
20:28 pinesol News from commits: LP1904036 release notes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=a1b98c​208d8c78a72214c6d07617ca478e8dabc4>
20:28 pinesol News from commits: LP1904036: Seed data fixes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=2fbab1​1405593dea8ed9b960295eee43bd4e4b41>
20:28 pinesol News from commits: LP1904036 Ang Circ Experimental Menu whitespace cleanup <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=03868e​e94a41c86f0e80a0a5b60b955b59860193>
20:28 pinesol News from commits: LP1904036 Ang Circ Experimental Menu <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=7a1800​eb8b3c2f8326db35cc2324bd03eea87665>
20:28 pinesol News from commits: LP1904036 View Ang Circ Menu Setting/Perm <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=c35be4​4ab5d09c7b14734fc2a5789ae34647a5a3>
20:28 pinesol News from commits: Revert "LP1904036 Ang Patron Menu Entries" <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=98e87e​983206aaf5ef7c1d5bd61dcbace0651d81>
20:28 pinesol News from commits: Revert "LP1904036 Ang Patron UI updating non-menu links" <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=584d3f​5c6c79bf159a13e5697acb4fa565f1ad08>
20:28 pinesol News from commits: LP1904036 ng lint continued <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=338579​3556d7f156999b2f7b7edf120d0780a4df>
20:28 pinesol News from commits: LP1904036 ng lint --fix <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=e4c730​eb4541f5e4ea5892987cb42c5c7427cc73>
20:28 pinesol News from commits: LP1904036 Copy SQL seed data into 950 file <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=93787b​ddf67beea941f19ce5a312241230a064b3>
20:28 pinesol News from commits: LP1904036 Ang Patron UI updating non-menu links <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=6d10de​e189c1e631c025004a52276c274507d6bc>
20:28 pinesol News from commits: LP1904036 Ang Patron Menu Entries <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=c2d41d​ac9ffa15568f0090e0bee8644ca820a520>
20:28 pinesol News from commits: LP1904036 Checkin modifiers get icons; more spacing <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=b395b1​ddaaaad3f2139135ec325539af305470d4>
20:28 pinesol News from commits: LP1904036 Mark Damaged always handles checkin <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=55941c​65290a23c682746c230b96fff12d38efc4>
20:28 pinesol News from commits: LP1904036 Checkin grid routeTo visible by default <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=5bc6f2​816ba2124198c9763f0d17c9aac88b05c4>
20:44 * gmcharlt claims 1347
20:57 pinesol News from commits: LP#1934162: stamp DB update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=00d652​8742c31a7b04aa876e6e4a471fec8c6bfc>
20:57 pinesol News from commits: LP#1934162: add release note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=1ea534​594a176b72b404f12f8071faf870e96c8f>
20:57 pinesol News from commits: LP1934162: (follow-up) sync whitespace <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=5ec73f​a03414a59bd8516e571da6070b45e3b3ce>
20:57 pinesol News from commits: LP1934162: add pgtap test, refreshing upgrade script <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=a51d23​66a735903adf04cfe7a32af1565313b334>
20:57 pinesol News from commits: LP#1934162: delete user messages and curbside notes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=d24c4d​be1e9b3b4dc924647c4c29082242b37622>
21:07 * gmcharlt claims 1348
21:16 * gmcharlt claims 1349
21:27 pinesol News from commits: LP#1982031: add release note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=244f0c​732b9358e8c272364047e03f1b92406d06>
21:27 pinesol News from commits: LP#1982031: stamp DB update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=10a967​a6175bf1785b9f21afde76d89085bfcb01>
21:27 pinesol News from commits: LP#1982031: (follow-up) corrections to DB update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=47d729​4f6582dddfaa2048b770cd53908a8b08c5>
21:27 pinesol News from commits: LP1982031 Reword Acq FYE library setting <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=6d8e24​87fc7a7336c0b7f61878b6cea873991bfa>
21:28 pinesol News from commits: Lp 1943168: Add Release Note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=5214b8​0d697d7902d11af606e8862d10c7f5c26c>
21:28 pinesol News from commits: Lp 1943168: Add Marc Stream Importer Match Quality Ratio Options <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=8746c2​ec573069a0be20ef142b0a52266597202f>
21:28 pinesol News from commits: LP#1891369: stamp DB update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=5451f9​058dfa75890da77d24002cceef9f0a9963>
21:28 pinesol News from commits: LP1891369 Renewal extension never shortens previous due date <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=858ac0​3fea6466f47ab666b64a6bfb32775dfa3b>
21:28 pinesol News from commits: LP1891369 Renewal exentions ignores overdues <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=7d822d​ef68be45e9dba9e93778d98aaa90d74aed>
21:28 pinesol News from commits: LP1891369 Renewal exentions uses min interval <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=dc3b93​3a4aea8b009ef7fa5d9e5db0c03826186f>
21:28 pinesol News from commits: LP1891369 Renewal due date extensions <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=0056e1​90c9327de5943fd460f5dea088e98e20c4>
21:28 pinesol News from commits: LP#1984114: add release note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=1fd3bd​71c6b470b4171ba0894d92b6b7958465a9>
21:28 pinesol News from commits: LP 1984114: Use Patron Preferred Name in SIP2 responses <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=9f3968​28afd9b6b806746dec1b3f321cb56c5815>
21:28 * gmcharlt claims 1350
21:40 * gmcharlt claims 1351
21:57 pinesol News from commits: LP#1977761: (follow-up) enforce use of the permission at API level <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=7c86cb​9248d0f238713d96ad3d56b06836074fb5>
21:57 pinesol News from commits: LP#1977761: add release note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=e9ecea​99041a194673c820610615f68293bc7243>
21:58 pinesol News from commits: LP#1977761: stamp DB update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=09e91a​572f13e8d705fc675223a12428c3efe09e>
21:58 pinesol News from commits: LP1977761: (follow-up) adjust seed data <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=fea3de​847f3f13e1772aa8e71e3324c2c1686b56>
21:58 pinesol News from commits: LP1977761: (follow-up) adjust DB update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=918399​54219504367ca5302633807b6b016035ec>
21:58 pinesol News from commits: LP1977761: Create fund rollover perm <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=7ec9de​d2422c939db8b4d34e5b7bc4c02c22096d>
21:58 pinesol News from commits: LP#1978976: stamp schema update <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=e5c273​174dbc19e16275be3fefe6af9c1f39da2d>
21:58 pinesol News from commits: LP#1978976: (follow-up) tweak formatting of releaste note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=9fd5b0​3258d497ecffd6a828e566b1b63ec95040>
21:58 pinesol News from commits: LP#1978976: add release note <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=0f3c71​60394bb284b79e335a16bc161d5f2f5b73>
21:58 pinesol News from commits: lp1978976 merge record notes during bib merge <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=08945f​2fd57d9f61fb794c04a72656d91ee7a307>
22:27 pinesol News from commits: LP#1966342: (follow-up) adjust for color contrast <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=04be58​0897d84c421e53eff41dfa2cc6191d249d>
22:27 pinesol News from commits: LP1966342 Highlight Zero Holdings in Staff Catalog <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=4cd5a9​4c3638e0b9e73028522d3795762a8c0556>
22:57 pinesol News from commits: LP1966342 follow-up: prefer === over == <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=551e76​6ad8f638f481c7ea932459c9c8f9ba2874>

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