Evergreen ILS Website

IRC log for #evergreen, 2020-02-05

| 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:18 sandbergja joined #evergreen
00:58 cmalm joined #evergreen
02:13 remingtron_ joined #evergreen
07:26 dbwells_ joined #evergreen
08:31 mantis1 joined #evergreen
08:34 Dyrcona joined #evergreen
08:41 mmorgan joined #evergreen
08:43 rjackson_isl joined #evergreen
09:05 * csharp goes crosseyed trying to fully grasp Perl array and hash references while using DBI to retrieve data from postgres
09:05 Dyrcona csharp: That's "easy." :)
09:05 csharp yeah - I'm sure I'm overthinking it
09:06 Dyrcona Which retrieve call did you use?
09:06 Dyrcona Or fetch call.
09:06 csharp use case - my SQL selects a single column from a table and I want to take all those values and push them into an array
09:06 csharp then grep the array for values that I have in another array
09:07 csharp (table is recording files I've fetched via FTP - similar to acq)
09:08 Dyrcona @array = @{$statement_handle->fetchall_arrayref()};
09:08 pinesol Dyrcona: What do you mean? An African or European swallow?
09:08 Dyrcona Wasn't talking to you, pinesol. :)
09:08 csharp heh
09:09 Dyrcona You might need to use a Slice parameter with that... Hm...
09:09 csharp oh - that's interesting - I'll try that syntax @{}
09:09 Dyrcona Is your SQL static?
09:09 csharp yes
09:10 csharp wait - no
09:10 Dyrcona This might be better: @array = @{$database_handle->selectcol_arrayref($sql)};
09:10 csharp my $prev_files_sql = "select filename from student_card.import where district_id = ?";
09:10 csharp where district_id is for a school district we have an FTP account for
09:11 csharp yeah, I was just looking at selectcol_arrayref
09:11 Dyrcona Well, you could build that with a printf or string concatenation to make it static.
09:11 csharp yeah
09:12 Dyrcona Just be careful not to add "; drop table ..." or something similar to the variable. :)
09:12 csharp ha!
09:14 Dyrcona I thought there was a DBD::Pg function for escaping dangerous characters in a variable, but I'm probably thinking of MySQL....
09:14 Dyrcona You could just make sure the variable is an int before you concatenate it.
09:14 Dyrcona If you're worried you'll do something bad, or if the input comes from a source you don't control.
09:16 Dyrcona remingtron++ For pointing out the bug wrangler FAQ yesterday.
09:17 Dyrcona Sorry I "missed" the meeting. I was engrossed in mangling configuration files for some new servers and forgot about it.
09:18 Dyrcona I linked the minutes and the log on the DokuWiki and put up the agenda for the March meeting. I figured that would give me a chance to catch up on what I missed.
09:25 csharp Dyrcona++ # selectcol_arrayref did what I needed
09:25 csharp thanks for being my sounding board :-)
09:26 Dyrcona Cool! Glad I could help. I don't use that one very often.
09:47 sandbergja joined #evergreen
09:59 jvwoolf joined #evergreen
10:12 collum joined #evergreen
10:19 collum joined #evergreen
10:21 Dyrcona We should probably tighten up the language of the bug wrangler FAQ and be more strict about the assignment of milestones.
10:23 bshum I read that as "lighten up" at first, and thought about what joke I'd insert in the FAQ about bugs and wrangling
10:23 Dyrcona heh.
10:41 collum joined #evergreen
10:44 sandbergja joined #evergreen
10:48 Dyrcona This is even more ridiculous: 2020-02-03 16:29:35 bd2-bh5 open-ils.actor: [WARN:18183:Server.pm:200:] server: no children available, waiting... consider increasing max_children for this application higher than 150 in the OpenSRF configuration if this message occurs frequently
10:55 berick bug 1848550
10:55 pinesol Launchpad bug 1848550 in Evergreen "Cache settings more aggressively in web client" [Undecided,Confirmed] https://launchpad.net/bugs/1848550
10:55 berick Dyrcona: ^-- that would help
10:58 Dyrcona It would.
11:27 Christineb joined #evergreen
12:19 troy__ joined #evergreen
12:29 jihpringle joined #evergreen
12:44 sandbergja joined #evergreen
13:14 Dyrcona Assign yourself a bug, start looking at it, and decide that maybe it doesn't need to be fixed on its own.
13:28 khuckins joined #evergreen
15:04 Dyrcona What do we think about a branch coming along 3 or more point releases later and changing the main database upgrade script?
15:18 jeffdavis I think that's generally not advisable, but sometimes preferable to the alternative (like the auto_renewal not null thing).
15:31 mantis1 left #evergreen
15:44 jeffdavis hmm, 324 simultaneous open-ils.actor.ou_setting.ancestor_default.batch requests for the cat.default_copy_status_normal setting
15:44 jeffdavis that seems like a bug
15:46 berick jeffdavis: from one client?
15:46 jeffdavis well, same library and authtoken, all within 0.5 seconds
15:46 jeffdavis so I assume so
15:47 jeffdavis (our gateway logs aren't recording originating IP properly at the moment)
15:49 berick impressive.
15:49 berick so yeah that settings lookup should be refactored to happen elsewhere
15:50 berick add a bunch of copies, it will keep firing the lookup until the first async call returns
15:51 jeffdavis ah, so this person wasn't necessarily trying to create 324 copies at once, which would be surprising
15:51 berick hm, no, they did 324 of something
15:51 berick it doesn't fire in a loop
15:52 berick but it fires once per new copy action
15:52 berick until a response arrives
16:00 jeffdavis We could lookup and cache the setting on vol/copy editor page load - doesn't reduce the number of lookups but at least they'd be hitting cache instead of going over the network. But I guess it's possible that owning lib != working location so the appropriate setting might not be cached.
16:02 jeffdavis I'll open an LP bug
16:04 jvwoolf Question about the Library time zone OUS: If it is set to EST, do we have to go in and set it to EDT in March?
16:05 berick jeffdavis: hm, that's probably exacerbating the issue... since the org settings code only caches settings for "here".  the volcopy code needs to do its own caching for non-here orgs
16:06 berick ideally in addition to looking up the value for 'here' on page load (just to cover a typical case)
16:06 berick refactoring the function to return a promise to avoid the dogpiling looks like it would be pretty complicated
16:10 berick jvwoolf: hm, I think you can set the TZ to something like America/New_York and it'll just work.
16:21 jeffdavis bug 1862068
16:22 pinesol Launchpad bug 1862068 in Evergreen "Problematic setting lookups in generateNewCopy" [Undecided,New] https://launchpad.net/bugs/1862068
16:25 jvwoolf berick: Thanks. We're just experimenting with the setting on account of a confused traveling patron.
16:29 Dyrcona Gotta love how we'll go out of our way for 1 person out of 500,000.
16:30 berick jeffdavis++
16:31 frank_g joined #evergreen
16:35 frank_g Hi all, I have a problem with a copy, The user can't renew it thought its account in opac, it shows the message "Failed to renew 1 item(s), Permission Denied", other checked out item can be renewed well,
16:36 frank_g it can be renewed well by web staff client by yhe librarian
16:39 jvwoolf berick++
16:39 jvwoolf That works and takes a load off my mind!
16:42 jeffdavis frank_g: does the user have the RENEW_CIRC permission at the library that owns the item?
16:44 berick shouldn't need RENEW_CIRC when renewing one's own circulations
16:49 frank_g jeffdavis, yes, it has the permission, actually the user has other copy and it can be renewed well, I already compare the 2 copies and they have the same info
16:53 jvwoolf left #evergreen
17:08 mmorgan left #evergreen
17:32 frank_g I got it, the problem was that the copy was mark as bookeable.
17:59 troy__ joined #evergreen
19:03 jihpringle joined #evergreen
19:18 abneiman_ joined #evergreen
19:18 jgoodson_ joined #evergreen
19:18 lbarry_ joined #evergreen
19:18 BigRig joined #evergreen
19:18 rhamby_ joined #evergreen
19:25 troy__ joined #evergreen
19:26 laurie joined #evergreen
21:55 sandbergja joined #evergreen

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