Evergreen ILS Website

IRC log for #evergreen, 2021-11-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
06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
07:25 rjackson_isl_hom joined #evergreen
07:52 JBoyer @band add CONNECTED TO THE NETWORK!!!
07:52 pinesol JBoyer: Band 'CONNECTED TO THE NETWORK!!!' added to list
08:30 mmorgan joined #evergreen
08:33 mantis joined #evergreen
08:34 csharp_ JBoyer++
08:34 * csharp_ imagines raging house music beats
08:50 Dyrcona joined #evergreen
09:18 rfrasur joined #evergreen
09:26 jvwoolf joined #evergreen
10:02 rfrasur joined #evergreen
10:03 jeff we have a group of libraries where -- thanks to duplicate item barcodes and "legacy" barcodes that require transformation -- barcode completion expands to 12 possible values
10:04 jeff hooray for ANY()
10:21 * Dyrcona has been using ANY(?) a good bit with Perl DBI programs, you can jam a Perl arrayref into that parameter slot and it just works.
10:32 jeff evergreen.get_barcodes already uses ANY(), and I don't recall offhand if it's a huge performance boost here (text arrays, not int arrays), but *shrug*
10:33 jeff I now have a table where I can put regex-based barcode transformations.
10:33 jeff (which are only used in get_barcodes style autocompletion contexts... doesn't do any kind of general input normalization, etc)
10:33 jeff that would be a nice next step.
10:35 Dyrcona I have a TODO in my latest script to normalize a date input parameter, but meh.... I'm the only one who will ever use the option, right? :)
10:36 Dyrcona Just added it this morning, in fact.
10:37 Dyrcona Also, speaking of regexes, gotta love code where: if (this_option) $query = ~ s/some comparison/some other comparison/;
10:52 Dyrcona Looks like the modified queries work so long as the date time is properly formatted.
11:24 jihpringle joined #evergreen
12:30 csharp_ *sigh* - while the ejabberd shaper settings seemed to help a bit, still seeing open-ils.actor die off without warning and without clues as to why
12:45 Dyrcona csharp_: Happens to me with storage. Do you have log messages about it trying to restart?
12:46 csharp_ Dyrcona: what do the logs say so I can grep?
12:47 Dyrcona I see you mentioned it yesterday morning. Mine looks different: http://irc.evergreen-ils.org/​evergreen/2021-11-02#i_494286
12:48 Dyrcona I see this for the restart attempt: "server: restarting after fatal crash..."
12:49 Dyrcona After that, the listener is running, but it can't start drones.
13:08 Dyrcona csharp_ ^^
13:13 Dyrcona Meh. Searching Lp for a bug that I'm "sure" exists, and can't find it, not even with fix released checked.
13:14 Dyrcona Does anyone remember a bug about the pre-cat item call number being editable?
13:14 jeff yes.
13:14 Dyrcona jeff: You wouldn't happen to have the Lp number handy, would you?
13:15 jeffdavis bug 1849334
13:15 pinesol Launchpad bug 1849334 in Evergreen "Precat owning library should not be editable" [Medium,Confirmed] https://launchpad.net/bugs/1849334
13:15 csharp_ pinesol: ahem
13:15 pinesol csharp_: have you tried local mean solar time for the named city as the reference point?
13:16 jeff in addition to that, there have been recent bugs regarding precat bib merges:
13:16 jeff bug 792595
13:16 pinesol Launchpad bug 792595 in Evergreen "it's possible to merge the precat dummy bib" [Medium,Fix released] https://launchpad.net/bugs/792595
13:16 jeff bug 827356
13:16 pinesol Launchpad bug 827356 in Evergreen "DB Doesn't protect against precat merges" [Medium,Fix released] https://launchpad.net/bugs/827356
13:16 jeff (one of those is more recent than the other) :-)
13:17 jeff that last one is the one I had in mind, but realized after I found it that it was about merging.
13:17 Dyrcona jeff++ jeffdavis++
13:18 jeff oh, but the bug title is no longer accurate, as in the comments it looks like the scope expanded a bit.
13:19 jeff one of the things the patch claims to do is: "adds rules to biblio.record_entry id -1, asset.copy_location id 1, asset.call_number id -1 so that edits are rejected for those ids on those tables"
13:33 khuckins joined #evergreen
14:48 Dyrcona Number of git branches always feels like a trade off with no real upside: At times, it seems I have too many so I consolidate branches and commits, and at another time I wish my branches and commits were more split up.
14:48 Dyrcona I wish I had more branches at the moment.
14:54 mmorgan Dyrcona: I have a few branches that fell in my yard you can have if you want ;-)
15:14 Dyrcona mmorgan: Thanks, I have more than enough of those branches. :)
15:15 * mmorgan figured as much :)
15:56 jlundgren joined #evergreen
16:08 * mmorgan is still struggling with group_penalty_thresholds
16:09 mmorgan I have a grp_penalty_threshold at the consortium level for PATRON_EXCEEDS_LOST_COUNT with threshold 1
16:09 mmorgan I also have one set for a specific group at a specific library with threshold 99
16:09 mmorgan The idea is that if they go into that specific library, they shouldn't be blocked, but they should be at other libraries.
16:11 mmorgan To confuse things further, these are new thresholds, so existing patrons with lost items will need the appropriate blocks.
16:13 mmorgan I'm using actor.calculate_system_penalties to apply the blocks retroactively. Do I just need to be judicious about what org units I apply them for for these specific groups?
16:14 mmorgan Or is in not possible to have a consortium level block that is stricter than a local block?
16:15 mmorgan in/it
16:17 JBoyer mmorgan, I believe I've seen in the past that the most restrictive penalty that can be applied will be. There isn't a concept of a more-specific override the way there is with OUS and the like.
16:19 JBoyer So you could swap things around if that was what was wanted, but you can't do things where the whole consortium uses value X and this branch uses X+1. (Short of duplicating the penalty at every level where it could change and leaving it undefined at the cons level)
16:23 mmorgan JBoyer: Ok, that's disappointing. So it sounds like the number of rows in my grp_penalty_threshold table might need to expand exponentially :-(
16:27 Dyrcona Well, this isn't right, either: Exception: OpenSRF::EX::Session 2021-11-03T16:26:12 main /openils/bin/action_trigger_runner.pl:247 Session Error: Transport::handler(): No AppSession object returned from server_build()
16:27 Dyrcona Looks like the password reset email trigger.
16:28 Dyrcona Yay. The server is using almost all of its RAM.
16:29 Dyrcona It's a report.
16:33 Dyrcona Can I just kill the reporter that's running the report? Will that cancel the backend and clean up any temp space possibly used by it? (I suppose I've killed the reporter before.)
16:48 jihpringle joined #evergreen
17:05 mmorgan left #evergreen
17:27 jeffdavis According to my notes, killing the relevant report process will usually but not always cancel the db query. I think our usual process is (1) stop reporter, (2) cancel PG backend manually if necessary, (3) set complete_time = now() with error_code and error_text for the relevant report in reporter.schedule, (4) start reporter
17:56 jihpringle joined #evergreen
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
19:43 jihpringle joined #evergreen

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