| 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 |
