Evergreen ILS Website

IRC log for #evergreen, 2020-10-21

| 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
00:19 mrisher joined #evergreen
00:20 mrisher joined #evergreen
00:23 Stompro joined #evergreen
00:39 mrisher joined #evergreen
00:39 mrisher joined #evergreen
01:09 sandbergja joined #evergreen
06:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
06:16 yar joined #evergreen
06:23 RBecker joined #evergreen
06:23 devted joined #evergreen
06:46 agoben_ joined #evergreen
07:20 rjackson_isl_hom joined #evergreen
07:28 Dyrcona joined #evergreen
08:08 alynn26 joined #evergreen
08:38 mmorgan joined #evergreen
08:53 collum joined #evergreen
08:56 Stompro joined #evergreen
09:14 dbwells joined #evergreen
09:16 rfrasur joined #evergreen
09:21 Dyrcona Ah ha! My problem is the org_close_overlap function: https://git.evergreen-ils.org/?p=Evergreen.gi​t;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/​Application/Storage/Publisher/actor.pm#l363
09:23 Dyrcona eby++ # Again, for unexpected synchronicity: http://irc.evergreen-ils.org/​evergreen/2019-01-24#i_392181
09:24 eby don't think i got to that feature request
09:37 Dyrcona Except....I see the queries running that match that SQL exactly. However, I don't see any calls to the storage method in the logs. Also, there are two definitions for the function!
09:38 Dyrcona https://git.evergreen-ils.org/?p=Evergreen.gi​t;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/​Application/Storage/Publisher/actor.pm#l350
09:38 Dyrcona "That's a bingo!"
09:39 Dyrcona Well, one of those similar loops. At least I have something to test.
09:40 mmorgan Dyrcona++
09:40 Dyrcona Also, I'm not clear on the difference between api level 1 and api level 0. How would I know which is being used?
09:51 Dyrcona request open-ils.storage open-ils.storage.actor.org​_unit.closed_date.overlap 207, "2020-10-16T16:30:43-0400"
09:52 Dyrcona This one "hangs" on my test server.
09:54 Dyrcona And, there's a query running from time to time checking "random" dates.
09:54 Dyrcona Now, to see what's so special about 2020-10-16.
09:55 mantis1 joined #evergreen
09:57 Dyrcona Another thing that I can never remember: actor.hours_of_operation.dow_0_* is Monday?
10:00 Dyrcona Also, the client gave up with "received no data from server," but the queries are still showing up on the db server.
10:01 Dyrcona I don't suppose there's a way to find the client PID for a storage process running queries against postgres?
10:01 berick Dyrcona: pg_stat_activity will show client pid, but not useful if you have a pgpool, etc. in the middle
10:02 mmorgan Dyrcona: Is there anything odd about the org_unit_closed entries for that library?
10:02 terranm joined #evergreen
10:02 * berick is considering adding pid to the application_name
10:03 Dyrcona mmorgan: It's only open 1 day/week. Closed on Friday, near as I can tell. The 16th blows up, but the 30th, another Friday, doesn't blow up.
10:03 terranm gmcharlt: JBoyer: mmorgan: does the targeting on this look right now? https://bugs.launchpad.net/​evergreen/3.6/+bug/1017990
10:03 pinesol Launchpad bug 3 in mono (Ubuntu) "Custom information for each translation team" [Undecided,Fix committed]
10:04 Dyrcona berick: I see client addr and client port, but not client pid in pg_stat_activity. pid is the backend pid.
10:05 Dyrcona I'm going to shutown the backend pid and see what happens.
10:05 JBoyer terranm, the 3.6 series isn't strictly necessary but otherwise yes.
10:06 berick Dyrcona: doh, I'm thinking of port :\
10:06 terranm JBoyer++
10:06 JBoyer terranm, oh, and you may as well duplicate the Importance
10:06 mmorgan terranm: and also duplicate the Status
10:06 terranm Will do, thx
10:07 Dyrcona berick: Yeah, I can use the port and addr combination to kill the drone, I think, but I'm not sure how opensrf will react.
10:07 berick Dyrcona: if the drone is busted, kill it.  the listener will just spawn a new one (if needed)
10:08 JBoyer Does anyone recall if we have any specific preferences for deleting obsolete series or just leaving them marked wontfix on bugs? That example has 7 rows now, one for 3.1 - 3.6 plus non-targeted.
10:08 JBoyer terranm++
10:08 Dyrcona canceling the backend seems to work.
10:09 Dyrcona JBoyer: I'm not sure it is documented anywhere. I guess it is up to the individual's discretion. I think I'd lean towards wontfix versus invalid.
10:09 mmorgan Also, can old series targets be recycled? For example, change a 3.1 series with status Won't Fix to 3.6.1 series with the appropriate status?
10:10 Dyrcona mmorgan: Drop the 3.1 series and add the 3.6 series.
10:10 Dyrcona Now, that I think about it. If the bug is going forward, I'll often drop the old series.
10:10 JBoyer Dyrcona, I mean if a bug is still valid but has old series targeted. Keep the history or keep them tidy. (I lean toward tidy myself)
10:11 JBoyer Sounds like we're on the same page
10:11 JBoyer Dyrcona++
10:12 Dyrcona JBoyer++
10:12 Dyrcona mmorgan++ # For clarifying my thought on the question that I didn't completely understand.
10:13 mmorgan Dyrcona: JBoyer: Does dropping the 3.1 and adding the 3.6 have a different result than recycling the 3.1?
10:13 JBoyer Other than the fact that LP won't let you do that, no I suppose not. :)
10:13 mmorgan It won't?
10:13 * mmorgan is going to try :)
10:14 JBoyer Well, we don't want to end up in a situation where there's a 3.2 target with a 3.5 milestone. I don't think you can change the series targets once they exist.
10:15 mmorgan Oh Ok, I get it now
10:15 JBoyer Now, if there are *no* series targeted (the Affected column just has Evergreen in it) then you can just change the milestone, yeah.
10:15 mmorgan JBoyer++
10:15 JBoyer mmorgan++
10:15 Dyrcona I'm also getting results from the overlap function that don't make sense.....
10:16 Dyrcona If I check for tomorrow, it says the library is closed from 10/16 to 10/28. If I check for today, when they're open, nothing comes back.
10:17 Dyrcona If I check for yesterday, it says that the library is closed from 10/19 through today at 4:30.
10:19 Dyrcona Looks like it only checks the date and returns whatever time it is given.
10:19 Dyrcona This is all kinds of buggy.
10:21 jeff ERROR:  invalid input syntax for type money: "8paperbackcopies"
10:21 rfrasur err
10:22 rfrasur I wanna pay my bills using paperback books.
10:22 jeff seven swans a swimming...
10:22 berick that's valid barter currency
10:22 rfrasur yep yep
10:23 Dyrcona Five cans of souuup!
10:24 rfrasur lol, that's very revolutionary of you, Dyrcona.
10:27 Dyrcona Well, food for fines is a thing.
10:29 rfrasur Yes.  It is.  I was referring to current cultural soup can references.
10:29 Dyrcona Canceling the backend only works for some of these. I canceled one, and that backend is running another, related query now.
10:30 Dyrcona Current cultural references?
10:30 rfrasur lol, I'll leave to you to track down or not.  I'd go with "don't." It's political crap and I regretted it as soon as I said it.
10:31 Dyrcona My score in Post-Ruin Culture is low. I'm only up on Pre-Ruin Culture. <- Obscure '80s RPG reference
10:31 Dyrcona Dunno, but a soup can forge can come in handy. :)
10:32 rfrasur I think it's worth prioritizing your current score balance.
10:35 Dyrcona :)
10:35 Dyrcona Looks like I'm going to have to kill the drones. One of them, at least, keeps coming back.
10:51 Dyrcona This is tedious
11:05 Dyrcona Well, that's all of the ones running, now. I suspect more will start up after the library opens this afternoon. At least, I'll know what to look for in the logs.
11:06 dbwells joined #evergreen
11:46 csharp I just removed 3.1 targets from the remaining open bugs, FYI
11:46 rfrasur csharp++
11:48 terranm csharp++
11:50 jihpringle joined #evergreen
11:55 sandbergja joined #evergreen
11:56 mmorgan csharp++
11:59 Christineb joined #evergreen
12:20 JBoyer terranm++ # I'm already applying cleanup to things.
12:20 terranm Great!
12:30 dbwells joined #evergreen
13:07 collum joined #evergreen
13:36 JonGeorg joined #evergreen
13:43 dbwells joined #evergreen
13:57 JonGeorg Hello. I am having an issue removing duplicate digital bookplates from an item record. I added the extra permissions, to myself and the user in question and am following the documentation on https://docs.evergreen-ils.org/3.2/​_removing_item_tags_from_items.html including with and without hitting Apply first.  I've used other browsers and computers,
13:57 JonGeorg with the same results. Bug #1761615 could be related. Has anyone else had similar issues removing them?
13:57 pinesol Launchpad bug 1761615 in Evergreen "deleting an item does not remove its copy tags" [Undecided,Confirmed] https://launchpad.net/bugs/1761615
14:10 JonGeorg Another issue is that when cron runs  /etc/profile && /openils/bin/bookbag_update.pl I'm getting a loghandler error. I can't find anything on that error, but am getting the impression that it's an undefined function within perl, but that doesn't make any sense.
14:12 dbwells joined #evergreen
14:14 Dyrcona joined #evergreen
14:19 Dyrcona JonGeorg: Pasting the exact error message somewhere would be helpful, but I'll wager that your environment is not properly setup in cron.
14:20 Dyrcona In short, sourcing /etc/profile or /etc/.bashrc doesn't work in cron on modern Linux, because most default versions of the .bashrc ship with code that exits if it is not being run from an interactive shell.
14:21 Dyrcona Sorry, didn't mean /etc/... I actually meant /home/user/.profile and /home/user/.bashrc. Unless you edited it /etc/profile won't either.
14:22 Dyrcona The fix is to set the environment variables at the top of the crontab.
14:24 Dyrcona In fact, I'd discourage source environment files in favor of setting the variables in the crontab.
14:25 Dyrcona terranm++ # Bug wrangling.
14:26 Dyrcona JonGeorg: Barring the environment, you're likely missing a Perl package.
14:30 Dyrcona So, I can consistently make open-ils.storage.actor.org​_unit.closed_date.overlap spin for this one org unit with a date of 2020-10-16.
14:31 Dyrcona Now, to figure out why.
14:33 Dyrcona Killing the drone is the only reliable way to stop it.
14:33 Dyrcona I just got lucky on my test server last time that I canceled the postgres backend.
14:33 JonGeorg This was an issue from a while back, so I was looking through my notes. The issue was when we tried to manually run the command. This is from an inherited system. There are no errors in syslog. So I'm thinking it was an error with how I was attempting to run the command manually, as we were trying to see if an update to the bookbag had been
14:33 JonGeorg populated or not. It was telling me the error was on line78 which is the "$log = new Loghandler($logFile);" line and I couldn't find any reference to that function anywhere. I think I might have gone down a rabbit hole over nothing. I'll do some more checking to make sure it's working correctly.
14:38 Dyrcona JonGeorg: I'm not find any script by the name of bookbag_update.pl i the source code.
14:38 * Dyrcona can type gud.... ;)
14:50 abneiman terranm++ csharp++ # all the bug wranglin'
14:51 csharp yeehaw!
14:53 Dyrcona Bleh. Trying to make something standalone from the publisher code feels like too much work.
14:54 JonGeorg Looking over it all again with a fresh, non-panicked eye :)  , it looks like it was written for our consortia probably by my predecessor.
14:57 Dyrcona It would be nice if I could use a debugger on this code.
14:57 Dyrcona JonGeorg: Did you recently upgrade the O/S on the machine where you're having this problem?
14:59 abowling joined #evergreen
14:59 rfrasur https://meet.google.com/hve-jeby-cte
14:59 Bmagic we're here https://meet.google.com/hve-jeby-cte&amp;sa​=D&amp;source=calendar&amp;ust=160364794739​1000&amp;usg=AOvVaw19TNt-dV5CL9VQ2KD31zb_
15:00 rfrasur If you wanna come to the New Developers Working Group
15:00 JBoyer JonGeorg, I think bookbag_update.pl may be a filename used in the pre-3.4 carousels that MEC made available, if that helps you track things down
15:02 Bmagic JonGeorg - bookbag_update.pl is a "custom" script - and if you have been running it before and suddenly it's not working - I would guess that your version of Perl updated? If so, that script might* need a new line added to the top "use lib qw('.');"
15:03 Dyrcona Bmagic: That probably works, but there are better solutions. BTW, did you that I marked your bug a duplicate of mine?
15:04 Dyrcona Trouble with using '.' is it changes depending on where you run the command.
15:05 JonGeorg No the OS was last upgraded a while ago, before we noticed the issue. But worth checking. Thanks.
15:05 Bmagic Dyrcona: if you are referring to the SIPServer bug I reported - yes, jeff marked it duplicate
15:05 JonGeorg I look into when perl was last updated thanks
15:06 Bmagic JonGeorg: Dyrcona makes a good point - in that if you find that you need to add that line to the top of that script, then you will likely need to also change your cronjob to cd into the working directory before executing the script
15:07 Dyrcona Bmagic JonGeorg: It's better to put your Perl libraries somewhere specific and specify that directory.
15:08 Bmagic agreed
15:10 Dyrcona Too bad kivilahtio's debuggin instruction don't work anymore. They stopped working for me somewhere around Ubuntu 16.04.
15:18 Dyrcona Hm...
15:19 Dyrcona I discovered something interesting by removing this library's closed dates. The default start and end for the closed spanset runs from 10/11 to 10/21 for 10/16. The end is correct. They're open today, but they weren't open on the 10th.
15:20 Dyrcona In fact, they were last open on the 14th, so I think it should be from the 15th to the 21st, no?
15:21 Dyrcona My suspision now is that the closed on the 12th was breaking things because a) it is right after the 11th and b) the library is normally closed.
15:21 Dyrcona I'm going to put that date back and see what happens.
15:23 Dyrcona Nope. It's not that date by itself.
15:48 Dyrcona Well, I found my culprit date, though I don't know exactly why it causes this particular problem. On the plus side, it's not that likely to happen again.
16:06 terranm joined #evergreen
16:15 jihpringle joined #evergreen
16:16 rfrasur Dyrcona++
16:37 csharp Dyrcona: it's almost worse when you go through all that and realize it's a one-time thing
16:37 csharp then in 3 years you'll be back wondering what it was before :-)
16:45 Dyrcona Well, I don't think it will happen for this library again this year.
17:05 sandbergja joined #evergreen
17:06 mmorgan left #evergreen
17:39 berick terranm++ bug-wrangle-mania++
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
19:14 jihpringle joined #evergreen
19:38 dbwells joined #evergreen
20:16 dbwells joined #evergreen
20:55 jvwoolf1 joined #evergreen
21:30 jvwoolf joined #evergreen
21:59 sandbergja joined #evergreen

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