Evergreen ILS Website

IRC log for #evergreen, 2014-01-30

| 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
02:01 paxed eeevil: i am now really loving the way Eg database does things. <3
05:11 j_scott1 joined #evergreen
07:39 eeevil paxed: "normalize 'til it hurts, denormalize 'til it works" [but use surrogate keys...]  ;)
08:05 akilsdonk joined #evergreen
08:13 remingtron joined #evergreen
08:19 ericar joined #evergreen
08:21 mrpeters joined #evergreen
08:31 Dyrcona joined #evergreen
08:39 Shae joined #evergreen
08:44 mmorgan joined #evergreen
08:54 timhome joined #evergreen
09:00 jwoodard joined #evergreen
09:19 dbs surrogate_keys+-
09:21 eeevil dbs: and that statements obvious corollary:
09:21 eeevil natural_keys+-
09:22 rjackson-isl joined #evergreen
09:22 dluch joined #evergreen
09:24 eeevil (FTR, I've no problem with natural keys -- it's finding them that's the problem.  "I'm sure the name of this object will never change" ... "This national identifier is never reused, right?" ... etc)
09:28 yboston joined #evergreen
09:29 Bamberrouse joined #evergreen
09:29 Bamberrouse left #evergreen
09:30 rfrasur joined #evergreen
09:42 Dyrcona Does anyone actually use collector and label in action_trigger events?
09:43 Dyrcona eeevil: Would you like to buy a .su domain? Perhaps .cs, .dd, or .yu? # RE your "national identifier" comment.
09:44 jeff .an is bring phased out also. :-)
09:45 eeevil Dyrcona: collector, yes, IIRC. label, it's there for convenience... maybe people prefer typing more :)a
09:45 jeff or were you talking about re-use?
09:45 eeevil Dyrcona: and I was thinking about SSN, actually
09:45 jeff heh
09:45 Dyrcona jeff: phased out, but .su is still in use.
09:45 jeff Dyrcona: right
09:45 Dyrcona Oh yeah, SSN.... They actually do reuse those.
09:47 * jeff wanders off to create a "what famous person from the past shares your SSN?" site
09:47 Dyrcona Besides, it isn't a "national identifier," it's a nuclear powered general purpose attack submarine.
09:48 Dyrcona Here's the deal with label and collector.
09:48 jeff it's not a nuclear powered general purpose attack submarine, it's a bunch of razor blades.
09:48 Dyrcona I am considering a branch to make it so that the path is fleshed when the initial object is fetched.
09:49 Dyrcona I should say, paths are fleshed.
09:49 paxed reuse SSNs???!!!
09:49 jeff paxed: yes. they are recycled and re-used after death.
09:50 Dyrcona paxed: It happens that when someone dies, their Social Security Number can be reassigned.
09:50 * paxed boggles
09:50 jeff er.
09:50 jeff or perhaps that's a myth.
09:50 Dyrcona It's not meant to be a universal ID number. It's meant to be used for Social Security purposes only.
09:50 mrpeters hah does that site exist?
09:51 jeff Q20 here claims "We do not reassign a Social Security number (SSN) after the number holder's death." http://www.ssa.gov/history/hfaq.html
09:51 paxed over here it's pretty much impossible to "reuse" them, as the birthday is encoded in it.
09:51 bradl in my previous life I worked with a large personal credit agency, and SSN was a unique identifier in their DB
09:51 bradl IOW, if SSNs are being reused, Equifax's DB is broken
09:51 mrpeters jeff: maybe they changed the law sometime in the past?
09:51 jeff bradl: and according to the SSA, that seems to be ok for "for several generations into the future with no changes in the numbering system"
09:51 Dyrcona Yes, it used that way, but it wasn't meant to be used for any purpose other than social security originally.
09:51 mrpeters good point, bradl --- that could really suck, or be really good! haha
09:52 Dyrcona SSN is the MARC of the financial world.
09:52 Dyrcona At any rate, back to Evergreen....
09:53 mrpeters funny story while we're on the subject (somewhat) -- last friday, i was listening to the radio (who i had previously "Liked" on facebook, making me eligible for prizes) and they announced "Michael Peters, you are todays winner for a trip for 2 to Florida!" so, of course, I call in.
09:53 bradl mrpeters: haha! I guess you aren't in Florida
09:53 jeff i think that SSNs are *published* after death, but apparently I was wrong about them being re-used.
09:53 mrpeters Talk to the DJ that answers, and she says yes! congrats!  let me get your phone number and email address so travel agent can contact you.  So, I give it to her.  WRONG MICHAEL PETERS!
09:53 mrpeters that stung
09:54 mrpeters at least announce the freaking city or something...who knows if the other one ever called in
09:54 bradl mrpeters: you should just have showed her your MULTIPASS
09:54 Dyrcona eeevil: We don't see anything in stock using collector.
09:54 mrpeters haha, that was one of the biggest mood swings of my life
09:54 * bradl hopes others have seen The Fifth Element
09:55 eeevil Dyrcona: not in stock, that's true. I'm pretty certain that it's in use, though
09:55 Dyrcona jeff: SSNs are often "published" in court records.
09:55 mrpeters i havent...
09:55 Dyrcona eeevil: Well, that throws a wrench in the works.
09:56 * eeevil reads up for the plan, though...
09:57 mrpeters Their FB response:  "B105.7 Soft Rock That's a big time bummer!  Sorry to have toyed with your emotions like that"
09:57 mrpeters lol
09:57 Dyrcona eeevil: The idea is simple: flesh the paths in the objective retrieval so as to make 1 call total, instead of 1 call for each path member.
10:01 eeevil Dyrcona: you can still do that if collector is null. and label doesn't really matter -- the current code fleshes the path and the label becomes an aliased location for the leaf object
10:01 eeevil that'd be a good optimization for the general case
10:02 eeevil just leave the existing path-fleshing code there for the remainder
10:02 Dyrcona ok. we'll see how that works out.
10:03 eeevil but, it assumes that we can create a path-to-flesh-clause compiler that covers all the cases in the same ways as the recursive flesher
10:03 eeevil (without additional help from cstore and friends)
10:04 eeevil and... hrm... here's why that will be hard. consider "give me the parent and children of this org unit"
10:05 eeevil it will flesh the entire org tree (potentially a bunch of times) if you say "flesh parent_ou and children when you see an aou"
10:05 eeevil that's just the most obvious case, though
10:06 eeevil anything that has a cycle, or makes use of self-referential link, will explode
10:06 eeevil Dyrcona: which, now that I've said it out loud, is exactly why I built the recursive flesher
10:10 eeevil perhaps we could analyze the path to detect cycles (of which self-refs are a subset) -- strictly speaking, we /can/ reason about that with just the IDL -- and use a fast-flesher when we detect none
10:10 kbeswick joined #evergreen
10:11 Dyrcona Well, to solve my original problem, I could also just modify the circ history csv download code to not go through action trigger.
10:12 Dyrcona ;)
10:13 tsbere joined #evergreen
10:14 eeevil there is that path, yes ;)
10:31 mcooper joined #evergreen
10:55 mceraso gmcharlt: I tested the candidate tarball for OpenSRF 2.2.2 using Ubuntu 12.04 LTS and it works well
10:56 gmcharlt mceraso++ # thanks for testing!
10:56 mrpeters joined #evergreen
10:56 mceraso Anytime :)
10:57 mcooper joined #evergreen
11:00 ericar joined #evergreen
11:21 * jeff goes to see if any portion of the new browse functionality in 2.5 is suitable for something like "show me everything in this shelving location at lib X"
11:22 mrpeters joined #evergreen
11:25 mrpeters random non-evergreen question --- does anyone know if the ldirector project has an IRC chat, or mailing list?  Doesn't look like they are on freenode if so.
11:26 mrpeters Trying to determine if you can give an ldirector server multiple real IP addresses and forward to different servers based on the incoming IP
11:27 mrpeters for example, library 1 at 1.2.3.4 > 10.10.10.10 / 10.10.10.20 (apaches) and library 2 at 4.5.6.7 forward to 10.20.20.10 / 10.20.20.20 (apaches)
11:36 eeevil mrpeters: I doubt you can do that with ldirector /by itself/ but the rules to do that are straight forward and can sit in front of the ld-managed rules
11:37 mrpeters eeevil: you thinking iptables or something else?
11:41 eeevil mrpeters: yes, iptables
11:43 eeevil ldirector uses it to, but IIRC puts it's rules in custom chains/tables. you just need to set your rules up first.  you could rewrite the destination to 127.0.0.10 or 127.0.0.20 based on source, and let ld take over from there, balancing on top of those separate local IPs
11:45 mrpeters interesting.  cool.
11:53 jeff dear jeff: bzgrep isn't going to return much when your input files are gzipped
12:02 jihpringle joined #evergreen
12:06 jeff logs++
12:10 smyers_ joined #evergreen
12:14 jeff csharp: just got bit by the floating data type change in a copy template. We don't even use floating copies yet. :-)
12:16 jeff single user in our system with a copy template that sets Floating.
12:17 jeff not sure what the cleanest path forward on this kind of thing would be -- versioned copy templates? upgrade script that modifies copy templates in place?
12:18 jeff or better handling when applying a copy template.
12:25 kmlussier1 joined #evergreen
12:26 csharp jeff: heh
12:26 jeff oh, and it just bit us here as well: https://github.com/tadl/evergreen-contrib-equin​ox/blob/master/collectionHQ/functions.sql#L131
12:27 csharp same here actually - we don't float anything, but I think it's getting set by catalogers who want to make *sure* it doesn't float
12:27 jeff i wonder if there's a way to make this safe for both current and older schemas: CASE floating WHEN TRUE THEN 'Y' ELSE NULL END
12:27 csharp it was like 9 users in PINES, so we ended up saying "you change it"
12:28 jeff perhaps CASE floating::int WHEN >0 THEN 'Y' ELSE NULL END
12:29 jeff or just make it 'Y' when not null.
12:30 jeff though that probably won't work for earlier versions, as i suspect they were not null default false.
12:30 * jeff looks
12:32 smyers__ joined #evergreen
12:33 eeevil or not changing columns in the db that are in use today
12:33 ericar joined #evergreen
13:07 mmorgan left #evergreen
13:09 jeff eeevil: or that. :-)
13:10 jeff and yes, original not null default false, so i'm thinking my initial "cast to int" for collectionhq extracts will be reasonable.
13:17 jwoodard joined #evergreen
13:20 mmorgan joined #evergreen
13:21 afterl joined #evergreen
13:27 * bshum is having too much fun playing with a laptop with SSD loaded with a copy of his production database.  SO FAST!
13:38 kmlussier bshum++
13:39 schatz joined #evergreen
13:39 mrpeters we're going to be building out a new installation with 900TB of SSD for their DB's.  Should be fun to see how it screams.
13:39 mrpeters I know PINES has talked about going SSD as well.
13:40 bshum 900TB?  Whoa?
13:40 bshum :)
13:41 bshum So far, I'm noticing significant gains in search response and hold placement via the catalog on my test server with SSD.
13:41 bshum Like an example bib where hold placement took 24 seconds in production system took 6 seconds in that test laptop.
13:43 * bshum should switch out to GIN indexes and see what happens....
13:44 eeevil oh, that reminds me. 9.4 looks like it's going to greatly improve GIN speed
13:44 bshum Yay!  :)
13:44 * bshum loves postgres
13:45 csharp ubuntu 14.04 comes with 9.3 by default
14:04 ericar joined #evergreen
14:09 hbrennan joined #evergreen
14:13 snowball joined #evergreen
14:26 akilsdonk joined #evergreen
14:33 bshum berick: I just setup the prototype code on one of our test servers, we're going to play around.  Just curious about one thing though:
14:33 bshum What might cause this to happen where it seems to get stuck a bit on the patron search and I can't seem to retrieve new result sets.
14:34 bshum Logging out I could get back to it again and things seemed fine, but on my first go, it found a patron, then I opened their record, then couldn't search for anybody new.
14:34 * bshum keeps playing around
14:34 berick bshum: haven't seen that.  i'd suggest checking the JS console for errors
14:34 berick bshum++ # testing
14:34 bshum berick: Yeah I thought of that after I'd left the client
14:34 bshum I'll try to replicate it and check the console next time.
14:35 bshum It's quite fun so far.
14:36 berick excellent
14:36 bshum berick++ # cool stuff
14:45 bshum CTRL clicking to select multiple form items is kind of fun
14:46 bshum Kind of makes sense the more I think about it.
14:46 Dyrcona bshum: It is standard behavior in most applications.
14:46 * bshum is too used to hitting shift then
14:46 rfrasur Pardon.  Is the difference between unpaid bills and unclosed bills that fines are still accruing on the unclosed bills?
14:47 Dyrcona rfrasur: Where do you want to go?
14:48 rfrasur I don't know what you mean.  I just need to know the difference between unpaid and unclosed bills.
14:48 bshum Might be relics.
14:48 bshum By "unclosed" do you mean that there's a transaction that's still open but no bills listed?
14:49 Dyrcona I don't know what "unclosed" bills means. I might guess what an unclosed (unfinished) circ is.
14:49 rfrasur I don't know.  That's what I'm asking.
14:49 * rfrasur has never encountered such a thing.
14:49 Dyrcona Neither have I.
14:49 Dyrcona Not in Evergreen anyway.
14:49 * Dyrcona fights the Cheshire Cat from coming back. :D
14:50 rfrasur My guess is that each unpaid bill could be closed or unclosed depending on whether or not it's hit a limit or has had fines stopped.
14:50 Dyrcona Ah, but you're confusing bills with circulations.
14:50 rfrasur No...I'm guessing at the effect of circulations on bills.
14:51 * rfrasur has been asked the question by a non-Evergreen librarian on behalf of another Evergreen librarian somewhere in the state.
14:51 Dyrcona There is no such thing as an "unclosed" bill.
14:52 rfrasur Just passing along what she asked me.
14:52 Dyrcona Sounds like terminology from a different system.
14:52 Dyrcona The closest thing that I can think of would be the circ having stop_fines or xact_finish set.
14:53 Dyrcona stop_fines will stop overdue fines from accumulating on the circulation.
14:53 Dyrcona xact_finish is set if all the bills are paid and the copy is checked in.
14:54 Dyrcona :D
14:55 Dyrcona So, an Evergreen library asked a non-Evergreen library for help, and the latter asked you?
14:55 rfrasur yes
14:55 * rfrasur has no explanation.
14:55 Dyrcona I guess you could say that there is no difference between unpaid and unclosed bills.
14:56 Dyrcona If a circ has unpaid bills, it should have xact_finish of null, which means it is still open, i.e. unclosed.
14:56 rfrasur I don't think they're a thing at all.  I think they're two crappy reports that someone made and now someone else is using them and doesn't know what the heck they're looking at.
14:56 jboyer-isl Tell them that an unpaid bill is one that has not been closed, and an unclosed bill is one that has not been paid.
14:57 Dyrcona jboyer-isl++
14:57 rfrasur jboyer-isl++
14:57 * rfrasur would like to tell them a couple other things
14:57 jboyer-isl Makes as much sense as the question.
14:57 Dyrcona jboyer-isl: You brought the Mad Hatter, I see.
14:57 * rfrasur cuts out more seed envelopes instead.
14:58 Dyrcona rfrasur++
14:58 rfrasur (I should have just had an accucut die made.  coulda woulda shoulda)
14:59 jcamins rfrasur: does your library lend out seeds?
14:59 Dyrcona Seed envelopes? You doing a seed giveaway thing in the library or just getting your spring planting ready?
14:59 rfrasur We're getting ready to start.
15:00 rfrasur We're going to have a seed library.  I'd wanted to have it ready this past summer, but time slipped away.  So, NOW, am hoping to have it going by the middle of February so people can sprout stuff indoors.
15:00 rfrasur We got some memorial money from a garden lover that paid for the start up seeds.
15:00 Dyrcona Hopefully not terminator seeds.
15:00 gdunbar joined #evergreen
15:00 rfrasur Hmm, that would be cool though.  You gotta admit that.
15:01 rfrasur Just so long as they started those seeds off premises.
15:01 timf joined #evergreen
15:01 Dyrcona ;)
15:02 Dyrcona I'll take a pouch of T-1000, please.
15:03 rfrasur Maybe we should have some easter eggs in the collection, like seeds for Rocky Horror Picture Show Venus Fly Traps.
15:03 rfrasur and Cabbage Patch Kids
15:03 jcamins rfrasur: how do you start a seed library?
15:04 rfrasur With a little bit of soil and water.
15:04 rfrasur Buh dum dum
15:04 jcamins I guess you solicit donations from local farmers?
15:04 rfrasur But seriously folks.  In our case, we purchased the starter seeds outright with some of the memorial money.
15:05 rfrasur We're using an old card catalog.  The seeds we're starting with are all heirloom seeds.  Then, the hope is that as people harvest, they either save seeds from the produce or depending on the plant, let it go to seed and collect those.
15:06 Dyrcona jcamins: I keep getting invited to join the Seed Sharers (Savers?) community on G+ by some people I "know" from online.
15:06 rfrasur Then, they can get envelopes from here to repackage those seeds, and on and on.
15:06 rfrasur Theoretically, it should be self sustaining.
15:06 jcamins Dyrcona: if I could grow anything, I would definitely try growing things.
15:06 Dyrcona rfrasur++ # recycling the card catalog cabinet.
15:06 jcamins But I can't even keep no-light houseplants alive.
15:07 rfrasur hehe, then the seed library might not be for you.
15:07 jcamins I'm hoping I'll do better with the kefir grains and sourdough starter I started this week.
15:07 rfrasur I had a garden plot all tilled and prepared last year and then work exploded and now I have a nice plot of volunteer grass.
15:08 rfrasur And not the Colorado kind (that's not legal here yet)
15:08 Dyrcona I have a perfect spot in my back yard for cultivating mushrooms.
15:08 jcamins I have... kefir?
15:08 rfrasur I don't even know what kefir is.
15:08 jcamins And a sourdough starter that might be viable, eventually.
15:08 * rfrasur googles it.
15:08 jcamins rfrasur: kefir is delicious.
15:09 rfrasur Oh, it's kinda like yogurt
15:09 jcamins Yeah, but yummier.
15:09 jcamins And healthier, possibly.
15:09 rfrasur Huh.  interesting.
15:09 jcamins And easier.
15:09 rfrasur To make?
15:09 rfrasur cuz it's just as easy to buy either one :D
15:10 jcamins To make.
15:10 jcamins You just have to strain the grains out of the kefir when it's done.
15:10 rfrasur (I wonder if, when I die, and hopefully people leave money to the library, they'll designate it to an asian food preparation library)
15:10 jcamins You leave it at room temperature.
15:11 rfrasur Hmm, I think that'd be worth trying after my children leave home.  As it is right now, that just sounds like the spoiled milk/cereal that gets left on the counter without parental intervention.
15:12 jcamins lol
15:12 jcamins You should do it when your children are around.
15:12 jcamins Kefir grains are very active.
15:12 rfrasur It's too late.  We've already cemented their poor nutritional habits.
15:12 rfrasur They're no longer maleable.
15:13 jcamins Hehe.
15:13 rfrasur well, at least not by me.  Apparently girlfriends can convince them of anything.
15:21 Dyrcona Ooh... Librarianship in the Cloud....Sounds dreamy. :)
15:23 rfrasur :p that is all
15:25 rfrasur Okay, I think it'd time for me to hearken back to my teen librarian days and go remind the next generation that library's suck and no fun shall be had here.
15:25 rfrasur s/library's/libraries/stupid usage
15:35 sseng the results of the memory leak in this report here (http://nox.esilibrary.com/~gmc/gpls/memleak/GPLS_S​taff_Client_Circulation_Memory_Leak_Report2.html), what "type" of memory is being measured using the task manager? for example, Working Set Memory, Private Working Set memory...etc. just wanted to make sure I am using the same one, thanks! (this is from bug https://bugs.launchpad.net/evergreen/+bug/1086458)
15:35 pinesol_green Launchpad bug 1086458 in Evergreen 2.4 "Staff client memory leaks in 2.3 and later" (affected: 11, heat: 76) [High,Fix released]
15:37 stevenyvr joined #evergreen
15:39 jeff sseng: gmcharlt is likely going to be the best person to answer that question.
15:40 gmcharlt private working set
15:40 sseng jeff: gmcharlt: alright, thanks!
15:46 Dyrcona rfrasur: Turns out, one of our members is also doing a seed lending program.
15:47 Dyrcona rfrasur: Groton Public Library (gpl.org), and they are reusing the card catalog shelves. :)
16:06 sseng gmcharlt: can I confirm that from the memory leak test report, I perform the test in the same tab right? that is to say, I press F1, enter the patron barcode, checkout a book, and click "Done", and this represent one iteration?
16:06 jeff Right now, if you have a standing penalty such as PATRON_EXCEEDS_FINES, you can configure what things that penalty blocks (CIRC, or CIRC|RENEW, etc), but you can't have that penalty block certain things for different groups of patrons. Does anyone else have interest in such functionality?
16:07 gmcharlt sseng: yes
16:07 jeff I'm trying to decide between a hack and a wishlist bug. :-)
16:07 sseng gmcharlt: great, thanks!
16:08 bshum jeff: I'm afraid to say that might interest somebody
16:08 jeff heh
16:09 jeff i don't know if it's something that could be taken to extremes. the use case here is that certain profile groups should have circ AND renew blocked when they have EXCEEDS_MAX_FINES, but overall we only block circ for that penalty.
16:11 Dyrcona jeff: If you're going to do it, then do it right. :)
16:16 jeff I've other things to do right first. :-)
16:22 j_scott joined #evergreen
16:41 bshum @hate holds
16:41 pinesol_green bshum: But bshum already hates holds!
16:41 kmlussier @whocares holds
16:41 pinesol_green bshum and tsbere hate holds
16:54 bshum berick: I can't find anything strange in the console, but it seems to happen most sporadically when I try making use of the workstation value during logins.
16:54 bshum Workstation-less, it seems to work more consistently, but with workstation, it's being unhappy.
16:54 bshum Might be the names I'm picking or some other weird issue.
16:56 afterl left #evergreen
16:56 bshum Bah, and now it works again.  Might just be some weird browser effect...
16:56 bshum I'll play more tomorrow.
16:57 berick bshum: holler when you do.  Now that it's browser-based, I can poke too!  (if you give me a login :)
16:58 bshum berick: Unfortunately I rolled it in with my local SSD test server.  Which is hidden behind too many layers to unveil.
16:58 bshum But I'm going to work on installing it to our public demo system soon.
17:00 berick ah
17:02 bshum Just have to remind myself how to log into everything...  too many passwords.
17:02 berick feel free to type them in here if you need a backup
17:03 bshum :)
17:22 kimo_sabe joined #evergreen
17:31 kimo_sabe I'm having an odd issue trying to do some testing on 2.5.2 but when I try and clone my production database over to dev to try the upgrade stuff goes missing. Anyone seen that before? I'm at a loss
17:39 mmorgan left #evergreen
18:10 dbwells kimo_sabe: There have been a few recent conversations about needing to set the search_path before using pg_restore.
18:11 dbwells e.g. here: http://evergreen-ils.org/irc_logs/evergr​een/2014-01/%23evergreen.22-Wed-2014.log at 12:54:55
18:18 smyers_ joined #evergreen
18:46 kimo_sabe dbwells: thanks
19:10 csharp kimo_sabe: also, the postgresql extensions and perl dependencies need to be installed into the target database before doing a pg_restore (assuming that's your method)
19:11 csharp (to be precise, the perl deps are installed at the OS level via apt/yum/cpan ;-))
19:12 kimo_sabe csharp: I had been just trying the pg_dump | psql route.
19:13 kimo_sabe csharp: I already did the make -f Open-ILS/src/extras/Makefile.install [distribution
19:14 csharp kimo_sabe: make sure you do the postgresql server target of Makefile.install too
19:14 csharp then you can create the database properly with this script: http://goo.gl/HD2aiF
19:24 kimo_sabe victory!
19:25 kimo_sabe I think the "CREATE LANGUAGE plperlu;" was the only thing missing from the pg_dump, but now after going through all the SQL upgrade scripts I can log in with the 2.5.2 client
19:25 kimo_sabe I did have to specify the search_path to do the 2.3-2.4.0-upgrade.sql
19:45 kimo_sabe thanks again
20:34 RBecker joined #evergreen
20:36 DPearl joined #evergreen
22:06 mrpeters left #evergreen
22:50 schatz2 joined #evergreen
23:40 dcook joined #evergreen

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