Time |
Nick |
Message |
00:14 |
|
bmills joined #evergreen |
00:16 |
|
bmills1 joined #evergreen |
01:16 |
|
bmills joined #evergreen |
02:17 |
|
bmills joined #evergreen |
04:05 |
|
bmills joined #evergreen |
05:11 |
|
Slava_ joined #evergreen |
05:29 |
|
Slava_ joined #evergreen |
05:53 |
|
bmills joined #evergreen |
07:11 |
kmlussier |
Good morning #evergreen |
07:11 |
kmlussier |
@coffee someone |
07:11 |
* pinesol_green |
brews and pours a cup of Ethiopia Yirgacheffe Beloya Selection 8, and sends it sliding down the bar to someone |
07:11 |
kmlussier |
heh, looks like I'm in need of coffee |
07:12 |
kmlussier |
@coffee [someone] |
07:12 |
* pinesol_green |
brews and pours a cup of Ethiopia Yirgacheffe Beloya Selection 8, and sends it sliding down the bar to phasefx |
07:12 |
kmlussier |
@tea [someone] |
07:12 |
* pinesol_green |
brews and pours a pot of Bi Luo Chun Green Tea (Pi Lo Chun), and sends it sliding down the bar to mnsri_away (http://ratetea.com/tea/teavivre/bi-luo-chun-green-tea-pi-lo-chun/6490/) |
07:38 |
|
rjackson_isl joined #evergreen |
07:41 |
|
JBoyer joined #evergreen |
07:41 |
|
bmills joined #evergreen |
07:56 |
|
mrpeters joined #evergreen |
08:01 |
|
ericar joined #evergreen |
08:31 |
|
Stompro joined #evergreen |
08:32 |
|
remingtron joined #evergreen |
08:46 |
|
Dyrcona joined #evergreen |
08:48 |
|
RBecker joined #evergreen |
09:08 |
|
jwoodard joined #evergreen |
09:08 |
|
mmorgan joined #evergreen |
09:26 |
JBoyer |
I accidentally bought some Rooibos red tea and I think I've stumbled onto a terrorist plot. It smells like a cup of cigarettes and tastes like tobacco and licorice. |
09:26 |
|
maryj joined #evergreen |
09:26 |
csharp |
@quote add < JBoyer> I accidentally bought some Rooibos red tea and I think I've stumbled onto a terrorist plot. It smells like a cup of cigarettes and tastes like tobacco and licorice. |
09:26 |
pinesol_green |
csharp: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command). |
09:27 |
csharp |
@quote add < JBoyer> I accidentally bought some Rooibos red tea and I think I've stumbled onto a terrorist plot. It smells like a cup of cigarettes and tastes like tobacco and licorice. |
09:27 |
pinesol_green |
csharp: The operation succeeded. Quote #138 added. |
09:27 |
JBoyer |
At least some good can come of the whole ordeal. |
09:28 |
csharp |
JBoyer: I had that reaction when I gave up caffiene several years ago - it was a very poor replacement for morning coffee (I've since moved to decaf coffee and tea), but the taste has grown on me ;-) |
09:28 |
|
bmills joined #evergreen |
09:28 |
csharp |
caffeine? |
09:29 |
csharp |
one product of getting into my 40s is that my internal autocorrect is faulty |
09:29 |
* csharp |
relies on google/spellcheck constantly nowadays |
09:30 |
JBoyer |
My caffeine free tea of choice is peppermint. as for spell checking, is that not an option for your IRC client? I love it in mine. |
09:30 |
JBoyer |
(Though "auto-correct spelling errors" is not a good idea in IRC.) |
09:30 |
csharp |
probably - I use irssi and there's a plugin for pretty much anything you can think of |
09:33 |
|
yboston joined #evergreen |
09:46 |
tsbere |
JBoyer / csharp: I know some people that swear by "Teafee" - Half Coffee, half Tea |
09:49 |
JBoyer |
That initially sounds like something I would swear /at/, but I did just finish an entire mug of Mail Pouch and Red Vines, so I should probably at least try it. |
09:49 |
|
dbwells joined #evergreen |
09:49 |
csharp |
JBoyer++ |
09:50 |
csharp |
tsbere: yowza |
09:52 |
jonadab |
The only tea (well, "tea" -- it's an herbal) that I've had that I really disliked was chamomile. |
09:52 |
tsbere |
Apparently the tea in "Teafee" is nearly-coffee-strength black tea or something like that |
09:53 |
Dyrcona |
JBoyer: Mail Pouch? When I hear Mail Pouch as a brand name, I think of chewing tobacco. |
09:53 |
JBoyer |
See my description of that tea, above. |
09:54 |
JBoyer |
There's about to be a giveaway. |
09:56 |
JBoyer |
(Though I did reference both cigs and chewing tobacco, I suppose that's confusing. I couldn't think of a cig brand that sounded as good.) |
09:57 |
JBoyer |
Dyrcona: I was just thinking about you recently. Do you know if anyone has implemented the SHAREit XML API to include search results in their local catalogs? I'm reading the docs and it sounds like a proper ordeal. |
09:57 |
JBoyer |
I was curious if anyone has gone to the trouble, which would be a little bit surprising. |
09:57 |
Dyrcona |
JBoyer: We're using Z39.50. |
09:57 |
Dyrcona |
or, rather, they are... |
09:58 |
Dyrcona |
Hence all the discussion last week about z39.50 and it doing quoted searches. |
09:58 |
berick |
gmcharlt: I didn't have much in the way of sqitch slides. most of what I conveyed at the hackaway can be found at https://bugs.launchpad.net/evergreen/+bug/1521693 and http://wiki.evergreen-ils.org/doku.php?id=dev:sqitch |
09:58 |
pinesol_green |
Launchpad bug 1521693 in Evergreen "Investigate using Sqitch for database change management" [Wishlist,New] - Assigned to Bill Erickson (berick) |
09:58 |
JBoyer |
I mean the other way, including ComCat results in local opacs. Something like "Couldn't find what you need? try this..." |
09:58 |
gmcharlt |
berick: thanks (and that's ultimately what I pointed the person to) |
09:58 |
berick |
gmcharlt: awesome |
09:59 |
Dyrcona |
JBoyer: Oh, no. No one has done that. We added a link to go to the ILL search, though. |
09:59 |
Dyrcona |
As an aside, I hate how library vendors still call passwords/phrases, "PINs." |
10:00 |
Dyrcona |
"Are patrons required to enter PINs?" |
10:01 |
Bmagic |
There must be something we are missing for PG 9.3 - it's definatly slower than 9.2. I just loaded 29k bibs on two identical DB's one 9.2 and the other 9.3. 9.3 took 100 minutes longer! |
10:01 |
Dyrcona |
I feel like saying, "Yes, but it's a passphrase as complicated as they like and may contain characters that will cause your current system to barf all over itself, and btw, mine actually contains a character that precludes me from using SIP2." |
10:01 |
Dyrcona |
Bmagic: Did you tune it? |
10:01 |
Bmagic |
Dyrcona: yes |
10:02 |
Dyrcona |
Bmagic: Tune it some more. :) |
10:02 |
JBoyer |
That's what I thought. Given the two options it's 1000x easier to put together a URL that performs the same search again on their system, but we're hoping to have search results ready to go, so a-toiling-I-go. |
10:02 |
Bmagic |
Dyrcona: I assume you mean pgtune - I also decided to change some of the settings that pgtune created to match closer to what we had in 9.2 |
10:02 |
Dyrcona |
JBoyer: I don't think we perform the search for them. It just dumps them on the search page. |
10:02 |
Dyrcona |
Bmagic: Oh hells now. pgtune sucks. |
10:03 |
Bmagic |
Dyrcona: that's what I've learned here, so we don't rely on it. Here are the major final settings: shared_buffers = 8GB work_mem = 224MB |
10:04 |
JBoyer |
Oh, there's a simple way to use some URL params to take them right to a results page. That's what we'll probably distribute to several of our smaller ILS users. It's still searching again, but at least you might not have to type everything twice. |
10:04 |
Dyrcona |
JBoyer: yeah, i didn't pay too much attention to it. tsbere set it up. |
10:04 |
Bmagic |
Dyrcona: the hardware has 224GB RAM and the DB on disk is 80GB |
10:05 |
Dyrcona |
Bmagic: When I need to tune a Pg installation, I usually spend days pouring over wiki pages and conference slides, and then twiddle things until it is "fast enough." |
10:05 |
csharp |
Bmagic: do you have more than one RAID controller? |
10:05 |
csharp |
Dyrcona: that's my current method too ;-) |
10:05 |
Bmagic |
Dyrcona: what method do you use to test speed? |
10:06 |
tsbere |
JBoyer: For reference, I found that "search in their system" and "login to their system" didn't play nice together in the same link. So I skipped the "search" part. |
10:06 |
csharp |
Bmagic: http://www.postgresql.org/docs/9.3/static/runtime-config-connection.html and following explain every setting in pretty good detail |
10:06 |
Dyrcona |
Bmagic: None that's worth mentioning. |
10:07 |
Bmagic |
csharp: ty |
10:07 |
Dyrcona |
I might time some scripts, etc. |
10:08 |
JBoyer |
I'd like to someday pull an entire day's worth of queries from the logs, keep the dump from that day; clean up any that don't play nice, then see how long it takes to replay that day on a fresh reload. It would be easy to see how big an impact settings changes make across that level of activity. It's more difficult to improve everything when you can only really test this or that slow query. |
10:08 |
csharp |
Bmagic: check 'top' for high wait when things are slow - it might mean you need to reevaluate your disk setup - we're on SSDs now, but when we were on spinning disks, adding a second RAID controller solved all our problems |
10:08 |
Bmagic |
csharp: changing hardware isn't in the cards right now. The fact is, 9.2 was faster |
10:08 |
Bmagic |
on the same hardware |
10:08 |
csharp |
Bmagic: understood |
10:09 |
Dyrcona |
Trouble is, you can't really just copy someone else's config, even if they're roughly the same size as you. |
10:09 |
Dyrcona |
The use patterns may be very different. |
10:10 |
Bmagic |
Dyrcona: right, I understand that for sure |
10:10 |
Bmagic |
Dyrcona: But we basically copied the config from 9.2 to 9.3 |
10:10 |
csharp |
Bmagic: check for new settings in 9.3 config that are at the default values |
10:11 |
* csharp |
found vimdiff to be extremely helpful doing that |
10:11 |
Bmagic |
csharp: yeah, that thought crossed our mind - looking into that |
10:11 |
Dyrcona |
csharp++ # I was 'bout to recommend something similar. |
10:12 |
JBoyer |
tsbere: That makes sense, I think users would rather re-search than login again. |
10:12 |
csharp |
Bmagic: the settings I would scour first are Resource Consumption ( http://www.postgresql.org/docs/9.3/static/runtime-config-resource.html ) and Query Planning ( http://www.postgresql.org/docs/9.3/static/runtime-config-query.html ) |
10:13 |
csharp |
also I recommend pg_top (apt-get install pgtop on debian/ubuntu) |
10:13 |
csharp |
and, of course pgbadger for log sifting/analysis |
10:18 |
Bmagic |
thanks all - good suggestions |
10:19 |
Bmagic |
Dyrcona++ csharp++ |
10:20 |
miker |
Bmagic: higher load than 9.2? |
10:21 |
Bmagic |
miker: yes - we had to turn of autosuggest to calm it down |
10:22 |
Bmagic |
miker: but now, it's definatly apparent that the db is simply slower than 9.2 with that expierement mentioned above with reguard to bib load |
10:22 |
miker |
Bmagic: possibly relevant solution point in a PG thread. I suggest starting at the beginning of that thread and reading through the whole thing: http://www.postgresql.org/message-id/CAP=oouH0tXbA-4qw0Hd0tbJV2wj1Lp8A=UaSf-dvV2-soap5jA@mail.gmail.com |
10:23 |
miker |
csharp: this may also be relevant to your interests |
10:23 |
Bmagic |
miker++ |
10:26 |
|
krvmga joined #evergreen |
10:52 |
csharp |
miker: thanks - I'll take a look |
10:55 |
csharp |
interesting - I was reading about THP issues last week regarding this issue |
10:55 |
* csharp |
has too many "issue"s |
10:56 |
JBoyer |
I've got more issues than National Geographic. |
10:58 |
krvmga |
JBoyer: that's the best one of those i've heard...better than Vogue or Time. |
10:59 |
JBoyer |
Also, now that it's owned by Murdoch, it's all very meta. |
11:00 |
krvmga |
https://xkcd.com/917/ |
11:00 |
krvmga |
obligatory xkcd reference |
11:02 |
JBoyer |
krvmga++ |
11:02 |
|
Christineb joined #evergreen |
11:02 |
JBoyer |
It took two readthroughs, but only two. |
11:03 |
JBoyer |
xkcd++ |
11:08 |
|
RoganH joined #evergreen |
11:08 |
csharp |
GNU's Not Unix, y'all |
11:09 |
JBoyer |
GNUy's Not Unix, y'all see? |
11:11 |
krvmga |
JBoyer++ |
11:11 |
krvmga |
csharp++ |
11:11 |
RoganH |
I clearly haven't had enough coffee yet this AM. |
11:11 |
kmlussier |
@coffee RoganH |
11:11 |
* pinesol_green |
brews and pours a cup of El Salvador Finca Siberia Pacamara, and sends it sliding down the bar to RoganH |
11:13 |
|
bmills joined #evergreen |
11:14 |
|
mmorgan joined #evergreen |
11:17 |
JBoyer |
An Example of the <SOMEXMLSOAPELEMENT> is shown below: |
11:17 |
JBoyer |
(A bunch of WSDL spew) |
11:17 |
JBoyer |
Me: THAT'S NOT WHAT EXAMPLE MEANS. |
11:17 |
* jeff |
carefully backs away from JBoyer |
11:18 |
* jeff |
makes mental note to inquire at his next physical about getting his SOAP booster shot |
11:19 |
Dyrcona |
JBoyer: Perhaps XML examples are not quite exemplary? |
11:19 |
JBoyer |
jeff: I've been transcribing WSDL definitions into actual examples for an XML API that I'm trying to learn more about. The only thing more annoying than it being specified in copy/pasted chunks of WSDL obviously taken from IE is the inaccuracies between the prose and screenshots. |
11:20 |
JBoyer |
Dyrcona: evidently not. |
11:21 |
Dyrcona |
WSDL rings some long silent bells in mind....As if I had to use it briefly once, and chose to forget about it later. |
11:22 |
JBoyer |
I've only ever seen it used in web services implemented in an MS .Net language. I think everyone else gave up and moved on to REST. |
11:23 |
Dyrcona |
Yes, that sounds about right, something I was doing with IIS back in 2002 or so before I wised up, left that place, and worked as UNIX sysadmin. |
11:25 |
|
sandbergja joined #evergreen |
12:22 |
|
geoffsams joined #evergreen |
12:31 |
|
bmills joined #evergreen |
12:34 |
|
jihpringle joined #evergreen |
12:51 |
Dyrcona |
@decide make new test accounts or crack passwords on existing test accounts? |
12:51 |
pinesol_green |
Dyrcona: go with crack passwords on existing test accounts? |
12:56 |
RoganH |
Clearly that would take less time. Or at least be less tedious. One of those. |
12:58 |
Dyrcona |
Assuming that the majority of the test accounts have four digits for the password, yes. |
12:58 |
Dyrcona |
And by test account, I mean "not real patrons used for testing purposes." |
13:02 |
Dyrcona |
And now, I apparently don't have to.... |
13:03 |
Dyrcona |
We apparently already sent this information, and I was just given the spread sheet that was sent previously. |
13:03 |
Dyrcona |
Oh well, it could have been a "fun" way to spend the afternoon. |
13:09 |
* tsbere |
cracked the passwords on a few thousand accounts just to test some code he provided to Dyrcona for possibly cracking existing accounts >_> |
13:09 |
jeff |
yeah. it takes about 27ms to generate hashes for four digit pins. |
13:09 |
jeff |
and that's with storing them in a temp table for reuse. |
13:10 |
jeff |
for one, it's actually faster to skip the temp table. |
13:10 |
jeff |
~19ms |
13:10 |
pinesol_green |
Factoid '19ms' not found |
13:10 |
tsbere |
I don't store them, but I think PG generates them once for all the comparisons. |
13:19 |
jeff |
for extra fun, count the number of active users by group and/or limit to those with a work_ou. |
13:19 |
jeff |
(then disable and/or educate those users with great haste) |
13:23 |
jeff |
defaults have power. |
13:31 |
Dyrcona |
Hmm. Cronscript.pm could probably use a public accessor for the options..... |
13:32 |
Dyrcona |
$object->{opts_clean} is too dangerous. |
13:32 |
Dyrcona |
And $object->MyGetOptions() can only be done once before you do anything that calls it internally. |
14:00 |
kmlussier |
@developer |
14:00 |
pinesol_green |
kmlussier: Communication:11, BigPicture:13, DetailOriented:16, KungFu:9, GetsStuffDone:13, FlakeFactor:11, JavaAvoidance:8 |
14:06 |
Dyrcona |
@librarian |
14:06 |
pinesol_green |
Dyrcona: Management:17, Cataloging:11, Acquisitions:13, Reference:7, Circulation:10, Systems:13, Research:7, Custodial:11 |
14:13 |
kmlussier |
Dyrcona: Nice high score on acquisitions! |
14:13 |
kmlussier |
dbwells++ # Continuing the good fight with negative balance issues. |
14:13 |
Dyrcona |
Yeah, well, Dr. Sineath would be proud of the Management score. :) |
14:14 |
Dyrcona |
dbwells++ |
14:23 |
bmills |
dbwells++ thanks for the help with the listserv post! |
14:41 |
|
afterl joined #evergreen |
15:04 |
|
mmorgan left #evergreen |
16:00 |
|
jlitrell joined #evergreen |
16:14 |
|
afterl left #evergreen |
16:34 |
Dyrcona |
Nothing like doing a git gc to slow down your backups. :) |
16:39 |
jwoodard |
@librarian |
16:39 |
pinesol_green |
jwoodard: Management:15, Cataloging:13, Acquisitions:15, Reference:12, Circulation:9, Systems:14, Research:13, Custodial:14 |
16:40 |
jwoodard |
circulation is an accurate reflection atm |
16:50 |
|
maryj joined #evergreen |
17:22 |
|
bmills joined #evergreen |
17:24 |
kmlussier |
Since I've been filing so many web client bugs this week, I also want to add a gmcharlt++ miker++ berick++ for all of the work they've put into bringing the web client along this far. |
17:25 |
berick |
kmlussier++ right back atcha |
17:32 |
gmcharlt |
indeed |
17:32 |
gmcharlt |
kmlussier++ |
18:05 |
|
jihpringle joined #evergreen |
18:12 |
|
dcook joined #evergreen |
18:54 |
csharp |
kmlussier++ gmcharlt++ berick++ miker++ |
18:54 |
csharp |
allyall++ |
18:54 |
* gmcharlt |
remembers that I am, after from, from PA |
18:54 |
gmcharlt |
yous++ |
18:54 |
gmcharlt |
;) |
18:54 |
csharp |
heh |
21:54 |
* csharp |
plays with pg_prewarm |
21:56 |
* dcook |
would love to hear gmcharlt say yous in real life :P |
22:04 |
|
bmills joined #evergreen |