Evergreen ILS Website

IRC log for #evergreen, 2015-04-15

| 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
01:12 bmills joined #evergreen
01:20 RBecker joined #evergreen
01:27 edoceo joined #evergreen
07:16 kmlussier Good morning #evergreen
07:18 csharp kmlussier: happy tax day!
07:24 kmlussier It is tax day, isn't it?
07:29 Newziky joined #evergreen
07:32 graced joined #evergreen
07:44 rjackson_isl joined #evergreen
08:02 krvmga joined #evergreen
08:10 _bott_ joined #evergreen
08:21 Dyrcona joined #evergreen
08:22 mrpeters joined #evergreen
08:32 mrpeters is a bug fix for the  2.6.3-2.6.4-upgrade-db.sql version-upgrade script still welcome, or has 2.6 gone out of support?
08:32 mrpeters it's trying to use "located_uris" and should be "evergreen.located_uris"
08:32 mrpeters on line 53
08:33 csharp mrpeters: 2.6 hasn't reached EOL, so I would assume it's welcome
08:34 eeevil mrpeters: that's due to ye ol' pg_dump backup/restore. the local fixes are: use pg_dumpall, or run this: SELECT evergreen.change_db_setting('search_path', ARRAY['evergreen','public','pg_catalog']);
08:34 mrpeters ah -- eeevil -- that makes sense
08:34 mrpeters thank you
08:36 mrpeters wonder if we should add that to the "Backing Up" in docs
08:36 csharp oh eeevil, since you popped up ;-)... which tables' indexes should I be looking at for the slow search issue?
08:36 eeevil csharp: metabib.*_field_entry
08:36 csharp k
08:37 mrpeters http://docs.evergreen-ils.o​rg/2.1/html/backingup.html -- clearly that is dated, but the newest version i could find -- maybe a rewrite for later versions would be good for DIG team to include running the change_db_setting function after a restore from pg_dump
08:41 csharp eeevil: here's a glance at those: http://pastie.org/10093803 (if you have a minute to look) :-)
08:42 Shae joined #evergreen
08:43 eeevil csharp: yep, you're missing the index on the title table. likely happened during an upgrade.
08:43 csharp eww
08:43 csharp ok
08:44 csharp the one on index_vector?
08:44 eeevil create index concurrently metabib_title_field_entry_index_vector_idx on metabib.title_field_entry using gin (index_vector);
08:44 eeevil yes
08:44 * krvmga is trying to understand the exchanges between eevil and csharp.
08:45 csharp eeevil: excellent - thank you!
08:45 Dyrcona krvmga: It has to do with lp 1438136
08:45 pinesol_green Launchpad bug 1438136 in Evergreen "OPAC searching significantly slowed by adding format filters" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1438136
08:45 csharp krvmga: you must first undergo the Rite of Initiation
08:46 csharp krvmga: or, just look at the bug link, either way :-P
08:46 krvmga Dyrcona: i figured it was that. i'm trying to grok whether or not we have the same cause for our slow searches.
08:46 krvmga csharp: :)
08:46 Dyrcona krvmga: Well, there are two things going on. 1) a suboptimal query, and 2) csharp's installation missing an index.
08:46 Dyrcona Number 1 gets you either way.
08:47 Dyrcona eeevil: If you think it would be helpful, I'll run the tests on my database in a bit.
08:47 krvmga Dyrcona: gonna have to check if we're missing the index, too.
08:47 Dyrcona I meant to yesterday, but got busy with other stuff.
08:47 eeevil Dyrcona: more data is more better, thanks!
08:47 collum joined #evergreen
08:48 deric_ joined #evergreen
08:50 csharp @praise data
08:50 * pinesol_green Shall I compare data to a summer's day? data is more lovely and more temperate.
08:50 Dyrcona krvmga: Yep, a good idea. I'm pretty sure we have 'em all, but I'll double check, too.
08:50 csharp @praise CREATE INDEX CONCURRENTLY
08:50 * pinesol_green the upgrade came off brilliantly, and it's all because of CREATE INDEX CONCURRENTLY
08:51 csharp pinesol_green: actually... we think the upgrade *caused* the issue
08:51 pinesol_green csharp: http://images.cryhavok.org/​d/1291-1/Computer+Rage.gif
08:51 pinesol_green csharp: I am only a bot, please don't think I'm intelligent :)
08:51 Dyrcona Little bit or irony there, given the contest.
08:51 Dyrcona context...
08:52 csharp eeevil++ # index has definitely improved search
08:52 mmorgan joined #evergreen
08:53 eeevil csharp: I'll say... ;)
08:53 Dyrcona indexes++
08:55 collum|2 joined #evergreen
08:57 ericar joined #evergreen
09:07 Dyrcona Hmm.. Query plans don't appear to differ much on 9.1.
09:08 Dyrcona Maybe that is expected.
09:08 * Dyrcona should really learn more about Pg.
09:08 eeevil Dyrcona: pasted somewhere?
09:09 eeevil Dyrcona: nm, I see it
09:09 Dyrcona Ok.
09:12 eeevil Dyrcona: yeah, I think your data distribution has stats that say the search terms are more rare than the pinned 0.05% estimate for the queryint operator
09:13 csharp Dyrcona: this slideshow has a nice quick overview: http://www.slideshare.net/pgcon​f/the-postgresql-query-planner
09:13 rjackson_isl Is there a method in reports to report on the RDA data (tag equals 264) and get the data on one line per item as opposed to a line per Subfield indicator1 and indicator2 combination from the Flattened MARC Fields source?
09:13 csharp (of query plans)
09:13 sarabee joined #evergreen
09:13 Dyrcona csharp: Thanks. I'll take a look.
09:13 eeevil if you made the search term more common (stats-wise), you'd likely see what csharp sees. like, search on "the"
09:14 Dyrcona I think I get what's going on mostly.
09:14 csharp rjackson_isl: I'll look - just a second
09:14 Dyrcona OK.
09:14 rjackson_isl thanks csharp
09:17 csharp rjackson_isl: what is the desired outcome?  showing the place of publication? or the publisher's name?
09:18 rjackson_isl not sure - this is request from a library for reporting will have to get back to you :(
09:19 rjackson_isl csharp - are there sources that allow for reporting on one or the other?
09:20 csharp rjackson_isl: well, if it's publisher name it's 264 subfield $b, if place of publication, it's subfield $a, pub date, subfield $c, etc.
09:21 csharp rjackson_isl: if you can pastebin the generated SQL from the debugging info screen, I'll have a look
09:21 bshum But only on specific indicator combinations. Otherwise 264 could be other things besides "publisher"
09:21 csharp bshum: right
09:21 csharp sorry, should've been clear
09:21 csharp @blame marc
09:21 pinesol_green csharp: marc stole bradl's tux doll!
09:22 bshum No, no, no.
09:22 rjackson_isl csharp++ ok - I had sent an example output with all fields from the flattened source so she should be able to figure out a filter based on that
09:22 bshum @blame rda
09:22 pinesol_green bshum: rda is why we can never have nice things!
09:22 csharp bshum: my gripe with MARC is that the same field can mean different things conditionally - it's a nightmare
09:23 bshum Hehe, that too.
09:23 csharp and it all depends on manual entry, which in turn depends on human competence
09:23 kmlussier bshum: Isn't today supposed to be a travel day?
09:23 rjackson_isl differnt libraries have differnet standards?!?!? ;)
09:23 bshum kmlussier: Yes, but I just woke up and will continue packing shortly.
09:24 kmlussier Fun!
09:24 * kmlussier wants to pack for a trip somewhere
09:25 bshum Packing my electronics stresses me out. Inevitably I leave behind an important cable or something.
09:25 Dyrcona csharp: You're running into Gilb's law of computer reliability.
09:26 csharp Dyrcona++
09:26 jeff heh. going to computer conferences where i was driving was often an... interesting packing experience. i'd often end up taking WAY more tools/gear/parts than i ever needed.
09:27 Dyrcona Guess it is really know as Gilb's law of unreliability, but anyway....
09:27 Dyrcona known even.
09:28 kmlussier I'm sure you all have seen the emails already, but I'm just posting a reminder here that if you want the hotel conference rate, you should book your hotel rooms today for eg15.
09:28 * kmlussier takes off her conference hat for the rest of the day.
09:31 jeff that conference thing is soon, right?
09:31 jeff *ducks*
09:33 * kmlussier stares at jeff until she goad him into making his travel plans.
09:33 kmlussier goads
09:37 yboston joined #evergreen
09:39 maryj joined #evergreen
09:44 jeff 12:39a return flight departure? well, on one hand i'll save one night's worth of hotel expenses...
09:46 * Dyrcona commiserates. The flight times that I've gotten have been almost as ridiculous.
09:50 collum joined #evergreen
09:51 Dyrcona jeff: Hopefully, you don't get to spend 11 hours in the Newark airport.
09:52 kmlussier If your flight from Portland to Michigan brings you to Newark, I would say find another flight.
09:52 * Dyrcona thinks they do it just to jerk me around.
09:52 kmlussier Dyrcona: 11 hours?
09:52 kmlussier At that point, I would rent a car and drive home.
09:52 Dyrcona Almost, yeah.
09:52 kmlussier From Newark, not Portland.
09:52 Dyrcona That's on the way there.
09:53 Dyrcona On the way back, I believe I have just enough time in Chicago to make it from one terminal to the other.
09:56 * csharp 's layover on the way back is in Detroit
09:57 ericar_ joined #evergreen
10:21 Dyrcona kmlussier: Are you using my dev vm today? I'm considering making a new branch and playing with something in the staff client.
10:21 kmlussier Dyrcona: No, I'm focusing on other things today.
10:22 Dyrcona Thanks.
10:22 kmlussier Or, trying to focus on them. Not getting very far.
10:22 * Dyrcona nods knowingly.
10:23 Dyrcona Hmm. Turns out I get a conflict.
10:25 Dyrcona Minor conflicts with the conditional negative balance branch and recent changes to master.
10:25 Dyrcona Easily resolved, I think.
10:31 dbwells There is at least two lines with bugs in the negative balances branch which were discovered when I was testing for fine issue in master.  I should go ahead and rebase it, since a few more pieces are in master now.
10:32 Dyrcona dwells: That's cool.
10:32 Dyrcona dbwells, even.
10:33 Dyrcona My fingers appear to be on strike.
10:34 csharp @quote add < Dyrcona> My fingers appear to be on strike.
10:34 pinesol_green csharp: The operation succeeded.  Quote #110 added.
10:35 kmlussier @quote random
10:35 pinesol_green kmlussier: Quote #87: "<jeff> responsive XUL isn't really a thing." (added by bshum at 02:49 PM, July 30, 2014)
10:37 sarabee joined #evergreen
10:42 csharp Bmagic++ # fixing bug 1424646
10:42 pinesol_green Launchpad bug 1424646 in Evergreen "Paid-For Long Overdue Items Still Appear in "Other/Special Circulations" Window" (affected: 7, heat: 32) [Undecided,New] https://launchpad.net/bugs/1424646
10:42 csharp signoff branch a'comin'
10:43 mmorgan Bmagic++ csharp++
10:43 Bmagic csharp++  # testing
10:47 Dyrcona @quote random
10:47 pinesol_green Dyrcona: Quote #85: "< bshum> *Everything* is awesome." (added by csharp at 09:29 AM, May 27, 2014)
10:48 csharp https://www.youtube.com/watch?v=StTqXEQ2l-Y
10:50 tsbere So, I think amnesty mode should override backdating for voiding purposes. Right now if you backdate in amnesty mode you only get voiding to the backdate date.
10:50 tsbere To that end, I think this would fix it: http://git.evergreen-ils.org/?p=working​/Evergreen.git;a=shortlog;h=refs/heads/​user/tsbere/amnesty_overrides_backdate
10:50 tsbere But I am unsure if other people agree with me or not
10:51 ericar_ joined #evergreen
10:51 * kmlussier agrees with tsbere
10:54 mmorgan tsbere: Just to make sure I'm understanding: right now, if you are backdating, the behavior is the same whether Amnesty mode is on or off?
10:55 tsbere mmorgan: Almost. The only difference is "does the voided overdue get the amnesty note attached".
10:56 ericar_ joined #evergreen
10:56 * tsbere throws bug 1444514 up and then wanders off to run a quick training session
10:56 pinesol_green Launchpad bug 1444514 in Evergreen "Amnesty Mode doesn't work correctly with Backdating" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1444514
10:57 mmorgan Ah, ok. I would also agree that Amnesty mode should override backdating.
10:58 * mmorgan secretly wishes, however, that Amnesty mode would forgive rather than void...
11:02 jwoodard joined #evergreen
11:23 jeff +1 to that
11:23 * csharp debates with himself about whether to ride the 10 a.m. shuttle or hitch with one of the ~11 a.m. car drivers on Saturday of the conference
11:25 kmlussier I was thinking of hitching a ride with collum. If it's still available.
11:26 kmlussier As long as somebody doesn't bribe him with chocolate into leaving earlier.
11:26 * kmlussier might have some leftover cookies to bribe him into sticking into the 10:45 time.
11:27 collum It is still available.  No cookies necessary.
11:28 kmlussier Speaking of which, I need to start thinking about what cookies I'm going to make for the MassLNC development partners. Maybe I should put a poll out and let the community decide.
11:28 bshum That's not negotiating. Negotiating would be more like, "Hmm, how many cookies?"
11:29 berick kmlussier: do you really want to be making bacon-beer-cat cookies?
11:30 * collum loves cookies, but doesn't really need cookies. However ginger snaps are a favorite.
11:30 kmlussier berick: No, not at all. Who puts cats in cookies?
11:31 kmlussier gmcharlt: Are you paying attention to this?
11:31 berick correction: bacon beer cat-shaped cookies
11:32 kmlussier berick: Phew! I feel better now. I know I'm not a cat person, but it doesn't make me a monster. ;)
11:33 berick hah
11:33 yboston joined #evergreen
11:39 * csharp 's kids love the Trader Joes cat-shaped cookies
11:39 csharp no bacon, though
11:39 csharp or beer - what kind of father do you think I am? Jeez!
11:40 gmcharlt kmlussier: not yet, but I will be in 15 minutes
11:45 * csharp decides to play it safe and go with the 10 a.m. shuttle
11:55 gmcharlt kmlussier: berick: upon reading scrollback - I'm pretty sure my cats would object to being placed in cookies
11:56 gmcharlt however, if either of you care to bake tuna-catfish cookies...
11:57 berick cat-shaped, tuna-catfish bacon beer cookies
11:57 RoganH joined #evergreen
11:57 berick sounds like something at the bottom of a garbage disposal
11:58 bmills joined #evergreen
11:58 kmlussier I think I'll stick to my traditional recipes for now.
11:59 kmlussier Though I am a bit perplexed by csharp's comment that I should not be feeding beer cookies to my children. Is that wrong?
12:00 berick only if it's Icehouse
12:01 kmlussier Heh
12:04 RoganH I assume the alcohol is cooked out unless it's what my grandmother would call an "old world" recipe.
12:10 ericar_ joined #evergreen
12:19 Dyrcona A bit late to the party, but I think bread happened when someone tried to make beer but messed up, and then they decided to bake it.
12:20 RoganH Dyrcona++
12:20 RoganH Obviously they weren't from the south or they would have tried deep frying it.
12:20 jonadab tuna-catfish bacon beet cookies
12:21 * Dyrcona misses "cat-head" biscuits.
12:21 jonadab flavored with dill
12:21 berick RoganH++
12:22 csharp @quote add < RoganH> Obviously they weren't from the south or they would have tried deep frying it.
12:22 pinesol_green csharp: The operation succeeded.  Quote #111 added.
12:22 Dyrcona RoganH++
12:23 csharp following up on the bread was probably supposed to be beer discussion: https://www.youtube.com/watch?v=vyyyh8_Afyw (some nsfw language)
12:25 sandbergja joined #evergreen
12:26 Dyrcona heh
12:29 Dyrcona I don't think the one knows the difference between cheese and yogurt. :)
12:35 * dbs tries to remember the DojoSRF GET param for setting a workstation so that one can maybe use LDAP auth...
12:37 dbs ws
12:41 dbs sets the workstation but sadly doesn't magically invoke the LDAP auth plugins :)
12:41 yboston_ joined #evergreen
12:43 csharp @quote add <RoganH> My most remembered contributions to IRC will involve coffee and deep frying.
12:43 pinesol_green csharp: The operation succeeded.  Quote #112 added.
12:43 csharp :-D
13:00 RoganH joined #evergreen
13:09 csharp dh-make-perl's --cpan parameter makes packaging the CPAN modules for debian/ubuntu so easy, it's a wonder we haven't been doing that the whole time :-)
13:11 jihpringle joined #evergreen
13:12 csharp steps (on ubuntu 14.04 but probably universal to Debian & familiy): 0) install build-essential, dh-make and dh-make-perl 1) create a directory named for the package name (e.g. "libbusiness-stripe-perl") 2) cd into that directory 3) run 'dh-make-perl --cpan Business::Stripe' 4) run 'dpkg-buildpackage -F' 5) profit
13:12 csharp (as roo)
13:12 csharp s/roo/root/
13:14 csharp well, there are a couple of environment variables to set too, so  0.5) follow the steps at https://www.debian.org/doc/manuals​/maint-guide/first.en.html#dh-make to set environment variables
13:20 sarabee joined #evergreen
13:20 jeff travel-wise, it looks like I'm catching one of the tuesday afternoon shuttles, then taking the saturday 5 pm shuttle to be to PDX in time to catch my midnight-ish flight.
13:20 jeff oh, stuck in scroll. i see we've moved on to other topics. :-)
13:21 Dyrcona heh.
13:21 Dyrcona Some of us are getting rooms in PDX on Saturday night to catch 6:45 am flights on Sunday.
13:22 csharp the rest of the PINES folks are leaving on Sunday
13:22 RoganH joined #evergreen
13:26 csharp hmm - for some reason I added "Safe" as one of the CPAN modules to install on 14.04, but that looks like a core Perl module - any reason why we'd need the CPAN version?
13:26 csharp I see that wheezy installs it too
13:26 csharp and I pretty much worked from a copy of wheezy's makefile
13:27 * gmcharlt <3 Mozilla
13:27 Dyrcona Hmm. Not sure on Safe.
13:27 gmcharlt a think to try: open up Firefox to the default tab; hit referesh a few times
13:27 gmcharlt (look at the bit under the search box)
13:29 gmcharlt (or for a more direct link to what I'm talking about: https://snippets.mozilla.com/media/bundles/24​dfc3950b1ee3c947f1235a59730d2d183cb310.html)
13:31 jeff glad for the link -- i only see "Thanks for choosing Firefox! To get the most out of your browser, learn more about the latest features." and "It's easy to customize your Firefox exactly the way you want it. Choose from thousands of add-ons." -- nothing about library week.
13:31 * csharp only sees start.fedoraproject.org :-/
13:31 jeff csharp: you may be able to navigate to about:home
13:31 csharp jeff: yeah, just did that
13:32 gmcharlt jeff: yeah, I had to bounce on the refresh button several times for it to cycle through
13:33 jeff possible that Firefox 38 uses a different set
13:35 * Dyrcona gives up on building a new dev branch today.
13:35 Dyrcona I'll drop a branch or two and do it again tomorrow.
13:36 Dyrcona Think I'll schedule a database reload for tonight, too, so I don't have to wait on it tomorrow.
13:40 csharp yep - Safe comes within the perl package on wheezy and jessie - maybe the wheezy version was too old?
13:41 Dyrcona Maybe it's a hold over from squeeze or before it was added to the base distribution?
13:42 csharp from the pre-modularized version of Makefile.install: # Are we sure most distros don't come with an acceptable version of Safe.pm?
13:42 dbs what does the commit referenced in "git blame" say about that line
13:45 dbs Can't get the library love page in FF 37.0.1 or 40.0a1; refresh causes a hit to geo.mozilla.org, maybe it's geofenced
13:46 csharp de3d6fb5 (Dan Scott              2010-06-24 03:29:02 +0000 244) # Are we sure most distros don't come with an acceptable version of Safe.pm?
13:46 pinesol_green [evergreen|dbs] First stab at Fedora 13 support in prerequisite installer - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=de3d6fb>
13:48 Dyrcona My start page is start.ubuntu.com, so doesn't work for me either.
13:48 csharp looks like the only PM that uses Safe is lib/OpenILS/Application/Trigger/Event.pm
13:49 csharp Open-ILS/src/perlmods/lib/OpenI​LS/Application/Trigger/Event.pm
13:50 * dbs digs further with "git blame de3d6fb5b8^ Open-ILS/src/extras/Makefile.install"
13:50 pinesol_green [evergreen|dbs] First stab at Fedora 13 support in prerequisite installer - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=de3d6fb>
13:51 dbs it was added in e88c8b24
13:51 pinesol_green [evergreen|miker] loop-based targeting (does not need the views defined the other day ... may remove those at some point), cut the first; org unit weighting for hold targeting - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=e88c8b2>
13:51 dbs which dates back to 2009. So yeah, I bet the packaged versions of Safe.pm are fine in any supported distros by now.
13:52 * csharp agrees
13:53 csharp e397d929
13:53 pinesol_green [evergreen|miker] use Safe to protect against EVIL evals coming in from the outside world -- we share the environment into the Safe compartment using the name $current_environment - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=e397d92>
13:53 csharp same date, different commit
13:54 csharp eeevil: any thoughts on this? ^^
13:54 * csharp has already begun a branch - the fewer out-of-repo packages the better IMHO
13:55 dbs good old Subversion and haphazard commits :)
13:58 eeevil csharp: thoughts on what, exactly? any version of Safe should be fine, as dbs says, if that's what you mean
13:58 csharp eeevil: yeah - that was it - just wanted your blessing before removing it from the Makefiles
13:59 jeff pracrastinators beware! the hotel is selling out of the cheap rooms! :-)
13:59 eeevil sure thing, as long as wheezy has Safe as a core module, I say go for it
13:59 jeff (read: has sold out of the cheapest for the arrival/departure i have)
14:00 kmlussier jeff: I think the cheap rooms have been gone for a while. I had to *settle* for a river view.
14:00 dbs Probably dates back to something like Etch
14:06 bmills joined #evergreen
14:08 RoganH joined #evergreen
14:12 * csharp changed makefiles for wheezy/jessie/precise/trusty, but left squeeze alone
14:12 csharp bug 1444623
14:12 pinesol_green Launchpad bug 1444623 in Evergreen ""Safe" is no longer needed as a separate CPAN package" (affected: 1, heat: 6) [Medium,Confirmed] https://launchpad.net/bugs/1444623 - Assigned to Chris Sharp (chrissharp123)
14:13 Newziky joined #evergreen
14:14 Newziky left #evergreen
14:24 ericar_ joined #evergreen
15:27 krvmga joined #evergreen
16:04 vlewis joined #evergreen
16:05 vlewis_ joined #evergreen
16:05 chatley joined #evergreen
16:06 mglass joined #evergreen
16:06 ericar_ joined #evergreen
16:22 bmills joined #evergreen
16:39 mrpeters left #evergreen
16:50 artunit joined #evergreen
17:06 pinesol_green Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
17:14 jihpringle joined #evergreen
17:16 mmorgan left #evergreen
17:21 jboyer-isl joined #evergreen
18:18 jihpringle joined #evergreen
18:26 jihpringle joined #evergreen
18:28 jihpringle joined #evergreen
19:32 DPearl1 joined #evergreen
19:33 jeff__ joined #evergreen
19:40 _bott_ joined #evergreen
20:33 remingtron_ joined #evergreen
20:33 BigRig joined #evergreen

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