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-equinox/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_Staff_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/evergreen/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 |