| # | Time | Nick | Message |
|---|
| # | 01:21:45 | Mark__T has joined #openils-evergreen |
| # | 04:43:37 | Mark__T has left #openils-evergreen |
| # | 04:44:35 | Mark__T has joined #openils-evergreen |
| # | 08:16:44 | Slazer has joined #openils-evergreen |
| # | 08:18:32 | kbeswick has joined #openils-evergreen |
| # | 09:15:28 | kgs_away has joined #openils-evergreen |
| # | 09:21:22 | kgs_away is now known as kgs |
| # | 09:24:08 | rsinger_ is now known as rsinger |
| # | 09:47:00 | dbs has joined #openils-evergreen |
| # | 09:49:35 | dbs | dan "bleary" scott |
| # | 09:56:48 | miker_ | me too... |
| # | 09:56:51 | miker_ | also, biab |
| # | 10:09:29 | kgs is now known as kgs_postoffice |
| # | 10:13:49 | phase_bb has joined #openils-evergreen |
| # | 10:24:18 | Mark__T has left #openils-evergreen |
| # | 10:28:59 | dbs | ah, marc expert only works on records with copies attached, eh? |
| # | 10:35:32 | miker_ | eh? |
| # | 10:37:35 | dbs | miker_: just tried a few marc expert searches for stuff like "245 a sudbury" and got no results |
| # | 10:38:10 | dbs | looking at the query, it's joining with conditions on asset.copy; and right now, everything is transcendent, so no dice |
| # | 10:39:25 | dbs | (opac) |
| # | 10:41:33 | miker_ | ahh... indeed. that stuff has not been touched in may moons, and I'm not surprised at all. We've found that while it's comforting to have it there, we see 10s of uses of it over the course of a year ... the quick searches above that (and the main searches) serve 99.9999% of use cases. probably 100%, actually, if indexing is appropriately adjusted |
| # | 10:44:10 | dbs | miker_: oh, for sure. it's really only for the librarians, and even then, mostly at demo time when they ask "... but can it search XXX?!!" |
| # | 10:44:32 | csharp_GPLS has joined #openils-evergreen |
| # | 10:44:33 | miker_ | yeah :) ... which is probably what you did, and then it didn't work |
| # | 10:44:36 | dbs | might get a bit more of a workout in academic libraries, mind you |
| # | 10:44:48 | miker_ | well, would it/should it? |
| # | 10:45:06 | miker_ | I mean, if there's something very specific to search, add a classed index def, no? |
| # | 10:46:06 | dbs | yes - but there will be lags between our music librarian telling me "I've been using 518a to retrieve venues" and me implementing a music venue index |
| # | 10:46:43 | dbs tries 518a CBGB |
| # | 10:46:51 | miker_ | "you want to search only on Toc? ok, sec" ... add //*[@tag='520'] as keyword|toc, insert into keyword_field_entry select value from full_rec where tag = 520 and subfield = a; |
| # | 10:47:40 | miker_ | I mean, I understand ... and it should be fixed (should be easy-ish, too) |
| # | 10:47:58 | dbs | And understand I'm not complaining! Just realizing. |
| # | 10:48:22 | miker_ | by all rights, complaints are/would-be valid |
| # | 10:49:33 | miker_ | dbs: which method is being called these days? (I need to prune metabib.pm ... badly) |
| # | 10:49:58 | dbs | need to work backwards from postgresql log - one sec |
| # | 10:50:12 | miker_ | heh ... well, does the query have m.metarecord in it? |
| # | 10:50:31 | miker_ | wel... nevermind ... it won't |
| # | 10:51:01 | csharp_GPLS has left #openils-evergreen |
| # | 10:53:11 | dbs | open-ils.search.biblio.marc |
| # | 10:53:45 | dbs | so marc_search |
| # | 10:55:15 | dbs | and then open-ils.storage.biblio.full_rec.multi_search |
| # | 10:59:22 | dbs | so ultimately biblio_multi_search_full_rec() in Open-ILS/src/perlmods/OpenILS/Application/Storage/Publisher/metabib.pm |
| # | 10:59:41 | dbs | see? slow. |
| # | 11:05:08 | skmurphy has joined #OpenILS-evergreen |
| # | 11:06:32 | miker_ | heh ... no, I couldn't sus it out either ... thus the pruning ;) |
| # | 11:08:45 | miker_ | hrm ... fix will be non-trivial ... restructuring of the query will be required |
| # | 11:11:01 | dbs | yeah - don't worry your pretty little head about it |
| # | 11:11:09 | miker_ | ha |
| # | 11:11:41 | miker_ | you know, I wouldn't be entirely against just ripping out the copy visibility parts of those queries altogther |
| # | 11:11:57 | miker_ | "if you're searching marc directly, you're gonna get exactly what you asked for" |
| # | 11:14:38 | berick | miker_: that's reasonable, IMO |
| # | 11:16:02 | dbs | miker_: or (shudder) make it toggleable? |
| # | 11:16:27 | dbs | actually |
| # | 11:16:56 | dbs | calling open-ils.storage.biblio.full_rec.multi_search.staff rips out the copy visibility |
| # | 11:18:03 | miker_ | sure ... and we /could/ use that in the public opac, I guess |
| # | 11:18:18 | miker_ | arg ... meeting |
| # | 11:18:21 | miker_ | biab |
| # | 11:18:22 | dbs | go go |
| # | 11:21:47 | pmurray_away is now known as pmurray |
| # | 11:46:08 | miker_ | dbs: does the expert search do what you want from within the staff client? |
| # | 11:46:29 | dbs | -= THIS MESSAGE NOT LOGGED =- |
| # | 11:46:49 | miker_ | k |
| # | 11:47:35 | miker_ | btw, I like the idea of a switch ... have a "filter on copy visibility" checkbox, defaulting to checked, and use the .staff version if it's unchecked |
| # | 11:50:56 | dbs | that's exactly what I was thinking |
| # | 11:51:34 | miker_ | see? now I'm the slow one |
| # | 12:01:32 | dbs | bbiab - long lunch time |
| # | 12:01:59 | dbs | Slazer / kbeswick : have you guys got any code to show for the last week or so? |
| # | 12:02:06 | Slazer | Nope. |
| # | 12:02:08 | dbs | show and tell, folks |
| # | 12:02:14 | dbs | boo |
| # | 12:02:24 | kbeswick | i have code to show!!!!! |
| # | 12:02:30 | kbeswick | well |
| # | 12:02:34 | kbeswick | there is code |
| # | 12:02:48 | kbeswick | that somewhat works. |
| # | 12:02:49 | dbs | I'll be back around 1:30, likely |
| # | 12:02:51 | kbeswick | haha |
| # | 12:02:55 | Slazer | Dojo i18n ... doesn't seem to want to work for me....even after following a two different tutorials. |
| # | 12:04:04 | miker_ | Slazer: there's a working example in the code now |
| # | 12:04:05 | miker_ | sec |
| # | 12:04:45 | miker_ | Open-ILS/web/js/dojo/openils/widget/TranslatorPopup.js |
| # | 12:04:50 | miker_ | in trunk |
| # | 12:05:01 | berick | one thing that came out of my acq meeting yesterday... they really want a column-picker like the staff client in the acq interfaces |
| # | 12:05:18 | berick | will need to build some generic dojo-grid-column-picker-widget |
| # | 12:05:31 | miker_ | hail |
| # | 12:05:39 | miker_ | or use xul ;) |
| # | 12:06:15 | berick | i bet djfiander would get on board with that ;) |
| # | 12:06:34 | miker_ | hrm.. I gues it's a matter of creating the widest possible layout, and then dynamically modifying a copy and switiching it out as columns are added and removed |
| # | 12:06:52 | miker_ | that doesn't sound too terrible, actually |
| # | 12:07:01 | berick | and they'll need to be sticky |
| # | 12:07:25 | berick rewrites acq as an FF plugin |
| # | 12:07:25 | miker_ | tell this picker deally where the layout is, and it can do the rest |
| # | 12:07:36 | miker_ | berick: non-expiring cookie? :) |
| # | 12:07:42 | berick | yeah |
| # | 12:19:02 | phasefx | the killer feature of xul trees is their ability to consume RDF :-) :-) :-) |
| # | 12:21:46 | miker_ | yeah, the feature that will kill them ;) |
| # | 12:22:49 | phasefx | the thing that kills is the pain of styling them.. you have to do some combination of CSS and properties |
| # | 12:25:30 | miker_ | can't set flex via css? |
| # | 12:25:36 | miker_ | flex, et al |
| # | 12:29:09 | berick | sboyette: echo -e "#\n#LoadModule mod_placeholder /usr/lib/apache2/modules/mod_placeholder.so" \ |
| # | 12:29:12 | berick | >> /etc/apache2/httpd.conf; \ |
| # | 12:31:03 | berick laments the lack of min-width for columns in dojo grids |
| # | 12:45:09 | rsinger_ has joined #OpenILS-Evergreen |
| # | 12:59:48 | rsinger has quit IRC |
| # | 13:04:48 | rsinger_ is now known as rsinger |
| # | 13:09:31 | Slaze1 has joined #openils-evergreen |
| # | 13:16:44 | kbeswick_ has joined #openils-evergreen |
| # | 13:18:23 | kgs_postoffice is now known as kgs |
| # | 13:24:19 | Slazer has quit IRC |
| # | 13:24:47 | berick | ui_dev-- |
| # | 13:24:52 | kbeswick has quit IRC |
| # | 13:28:01 | kbeswick_ is now known as kbeswick |
| # | 13:28:11 | Slaze1 is now known as Slazer |
| # | 13:28:26 | sboyette | kbeswick++ # got it working :) |
| # | 13:28:37 | kbeswick | sboyette++ |
| # | 13:31:21 | berick | sboyette: http://rafb.net/p/Jzn2aB62.html |
| # | 13:35:28 | miker_ | sboyette: is that in a make file? |
| # | 13:35:34 | miker_ | makefile |
| # | 13:36:41 | sboyette | i have the echo part, but not the enclosing if. except my echo echoes to `apxs2 -q SYSCONFDIR`/httpd.conf |
| # | 13:36:51 | sboyette | which i'm currently trying to figure out how to merge into the if |
| # | 13:37:58 | miker_ | dang ol' make and it's "no, really, just one line per shell command, srsly" ways |
| # | 13:38:37 | miker_ | how about `test [...] && echo "blah"` ? |
| # | 13:38:49 | miker_ | or is that too bash-y |
| # | 13:52:11 | dbsdb has joined #openils-evergreen |
| # | 13:52:53 | dbsdb | Slazer: tutorials? Bah, they're always out of date. Did you try the dojo i18n test? |
| # | 13:53:25 | Slazer | I looked at it...but got confused how it worked. |
| # | 13:54:37 | dbsdb | ah - in that case, tutorials can be good for concepts, and working tests show you how those concepts actually work in practice :) |
| # | 13:55:30 | dbsdb | miker_: http://dwarf.cs.uoguelph.ca/ still seems slow, but is definitely better |
| # | 13:57:11 | miker_ | dbsdb: better after what? ... |
| # | 14:03:58 | dbsdb | miker_: better after postgresql tuning |
| # | 14:04:01 | dbsdb | upping effective_cache_size to 9GB (it's a 16 GB machine, free -m is actually showing about 15GB cached) |
| # | 14:04:16 | dbsdb | upping max_fsm_pages to 750000 |
| # | 14:04:25 | dbsdb | and maintenance_work_mem to 1GB |
| # | 14:05:29 | dbsdb | still - day one after loading 4 million records, I'm sure there's lot of tweaking to do (and testing... oh lord, the testing) |
| # | 14:06:17 | miker_ | and the cold cache ;) |
| # | 14:06:30 | miker_ | it's full of the bare SQL files (or COPY files) |
| # | 14:06:40 | dbsdb | but first - I must investigate a mystery in this support ticket: "our scanner has been slow for the last two days, please investigate" |
| # | 14:06:44 | dbsdb | please kill me NOW |
| # | 14:07:26 | miker_ | haha |
| # | 14:07:31 | miker_ | "reboot windows" |
| # | 14:07:57 | dbsdb | indeed it is. maybe a little curl script for a cache-warmer would be a useful utility |
| # | 14:08:45 | dbsdb | crazy postgresql and its reliance on fs caching... :) |
| # | 14:08:54 | miker_ | ha |
| # | 14:09:14 | miker_ | cat /var/postgres/base/102021/* >/dev/null |
| # | 14:09:39 | dbsdb | hah! |
| # | 14:09:42 | miker_ | (though on a 16G machine, it would be good to be more table and index specific for that) |
| # | 14:11:47 | dbsdb | yeah, db is around 55GB at the moment. I don't think we're going to be able to pull a UPEI on this and hold it all in-memory |
| # | 14:14:26 | miker_ | that's about PINES-2006 size (about 75G now) so not unmanageable, and your circs will not be near the scale of PINES, I would imagine |
| # | 14:14:43 | dbsdb | I can guarantee you that. |
| # | 14:15:19 | dbsdb | Still have to load patrons and holdings, mind you |
| # | 14:22:52 | Slazer | woohoo... I'm getting it to work finally. *hugs firebug* I need to use this more |
| # | 14:28:20 | dbs_ has joined #openils-evergreen |
| # | 14:30:41 | dbsdb | yay! |
| # | 14:37:49 | dbs has quit IRC |
| # | 14:55:36 | berick | anyone who has access to the ACQ box, please don't break anything for the next hour or so :) |
| # | 14:58:10 | bradl | haha |
| # | 15:14:49 | Slazer has quit IRC |
| # | 15:30:40 | peanutb has quit IRC |
| # | 15:42:39 | kbeswick has quit IRC |
| # | 15:58:58 | dbsdb has quit IRC |
| # | 17:18:29 | pmurray is now known as pmurray_away |
| # | 17:46:44 | kgs is now known as kgs_workout |
| # | 18:02:16 | dbs_ has quit IRC |
| # | 18:28:13 | phase_bb has quit IRC |
| # | 18:57:14 | kgs_onroad has joined #openils-evergreen |
| # | 18:58:16 | kgs_onroad is now known as kgs_ |
| # | 19:01:04 | agJohn | Anyone know why I'd be getting a "the attempt to query the DB failed" message when I try to save a new bib record, but I can edit existing ones? |
| # | 19:01:06 | agJohn | The storage_unix.log reports this (multiple times): Use of uninitialized value in join or string at /openils/lib/perl5/OpenSRF/Application.pm line 101, <STDIN> line 1. |
| # | 19:01:07 | agJohn | The "stacktrace" value is: /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:540 (eval 625):1 (eval 625):1 -- which looks like a message handler, so not much help (at least not to me)... |
| # | 19:01:09 | agJohn | The "textcode" is DATABASE_QUERY_FAILED |
| # | 19:01:43 | agJohn | Oops, take that back. The Application.pm line 101 is the message handler.... |
| # | 19:02:42 | berick | agJohn: check the postgres log |
| # | 19:06:09 | agJohn | ERROR: duplicate key violates unique constraint "record_entry_pkey" |
| # | 19:06:11 | agJohn | I'm going to guess that the sequence on that column has not been updated after inserts with a key included.... |
| # | 19:06:37 | berick is thinking *bingo* |
| # | 19:07:45 | agJohn | Got it. |
| # | 19:09:34 | agJohn | Slicker than socks on a chicken! Thanks, berick--I should'a looked there w/o the suggestion. Little by little, I'm getting it, I hope. |
| # | 19:35:57 | kgs_ has quit IRC |
| # | 20:13:23 | kgs_ has joined #openils-evergreen |
| # | 20:47:39 | kgs__ has joined #openils-evergreen |
| # | 20:57:13 | kgs__ has quit IRC |
| # | 21:04:59 | kgs_ has quit IRC |
| # | 22:43:32 | kgs_ has joined #openils-evergreen |
April 10-13