Open Source Integrated Library System

Evergreen on IRC

#evergreen Logs for Friday, October 28th, 2011

< Thursday, October 27th, 2011Raw Log FileSaturday, October 29th, 2011 >
#TimeNickMessage
#00:03:41sndwrx has quit IRC
#03:00:36AaronZ-PLS has joined #evergreen
#03:02:14AaronZ-PLS has quit IRC
#03:30:17Helenbean has joined #evergreen
#04:37:41Helenbean has joined #evergreen
#04:47:26jeffdavis has quit IRC
#05:22:46jeffdavis has joined #evergreen
#06:32:34csharpfor the logs, tsbere's suggestion of running 'ALTER DATABASE <dbname> SET search_path=evergreen, public, pg_catalog;' allowed the 2.0-2.1 upgrade script to complete and I updated the bug report with that information
#07:09:53tsberecsharp: I wonder why that isn't happening from the function call shortly after the create schema command, though. :/
#07:10:30csharptsbere: yeah - that's wierd
#07:10:51csharpbut it happened for me on two different servers and obviously to agJohn
#07:12:49tsbere wonders if the schema can't be added to the search path unless it is actually *there*, and not just "there" in the transaction
#07:13:48tsbereThen again, I don't think I have had any problems with initial loads, that do the same basic thing
#07:15:09csharpyeah - in place upgrades are way more fun! :-P
#07:23:40csharpokay - one more issue to resolve, and it looks like I've gotten through the initial testing run of the upgrade scripts...
#07:23:43csharppsql:2.0-2.1-upgrade-db.sql:8853: ERROR: insert or update on table "org_unit_setting_type" violates foreign key constraint "org_unit_setting_type_grp_fkey"
#07:23:46csharpDETAIL: Key (grp)=(circ) is not present in table "settings_group".
#07:24:03csharpand in fact, no rows are present in config.settings_group
#07:24:25tsbereHmmm
#07:24:26csharpthe table is created in the 1.6.1-2.0 upgrade script, but it is never populated after
#07:24:36tsbereYea, that would be a problem
#07:25:59tsbereI think you want script # 0622 for that. Maybe.
#07:26:05csharp looks
#07:26:23tsbereOr you want to stop populating the grp fields. I don't think the updated library settings editor made it into 2.1.
#07:27:58tsberecsharp: Fair warning, 0622 will make things less obvious, as it removes things that are duplicated in the "group" from the labels, because the master version of the library settings editor is much improved
#07:28:10tsbereI suppose you could grab just the group defs, though
#07:28:26csharphmm - not finding 0622 with a grep *
#07:30:11tsberereferring to the upgrade script in master. It never made it into 2.1. But that is where the groups get populated.
#07:30:19csharpah - I see
#07:31:06csharpso are you saying then that for 2.1 I can just modify the upgrade script to not try to add a grp for coust?
#07:31:34tsbereThat would be an option, yes.
#07:32:12csharpI think I'll go with that option since it sounds like it gets taken care of with the next release
#07:32:22csharpbut I'll file a bug report about the upgrade script
#07:50:20csharp is caught in a git non-fast-forward paradox
#07:50:53csharp# Your branch is ahead of 'egils/tags/rel_2_1_0' by 3 commits.
#07:52:15collum has joined #evergreen
#07:56:28plux has joined #evergreen
#07:57:11tsberehow is that a paradox?
#07:58:34csharpwell - maybe not a paradox, but I'm apparently unable to resolve it
#07:59:06csharpneither 'git pull' nor 'git pull --rebase' changed anything
#07:59:20csharp is a git n00b
#08:00:06tsberegit fetch --all && git rebase
#08:00:07tsbere?
#08:00:23tsbereBut then again, that tag hasn't *changed*
#08:00:45tsbereand "ahead of X by Y commits" means "you have Y commits locally that X doesn't have"
#08:01:34csharpok - well I thought that's what pushing them did :-(
#08:01:57csharpchange here then push to the remote repo
#08:01:58tsbereThat is saying "you have 3 commits that the *official repository's rel_2_1_0 tag* does not have"
#08:02:08csharpoh.. hmm
#08:02:17tsbereIt isn't saying anything about the version you pushed ;)
#08:02:36tsberethe egils part there is the official repository.
#08:02:54csharpI've been doing 'git push origin rel_2_1_0' the whole time without issue
#08:02:55tsbereIf it said "origin" instead of "egils" then it would be referring to your pines one.
#08:03:04csharpstill can from another test server
#08:03:25tsbereYour local branch "tracks" egils, because that is what you used when you did git checkout -b
#08:03:40csharpah
#08:03:44tsbereIf you want to stop tracking egils that can be changed
#08:03:57csharpI think I would like to stop tracking it
#08:05:48tsberegit branch --set-upstream rel_2_1_0 origin/rel_2_1_0
#08:07:09csharptsbere: thanks! especially for your patience with me
#08:07:17csharp will get the hang of this
#08:35:10_bott_ has quit IRC
#08:35:27_bott_ has joined #evergreen
#08:36:59kmlussier has joined #evergreen
#08:51:13akilsdonk has joined #evergreen
#09:06:39Meliss has joined #evergreen
#09:14:29csharpokay, now I'm having trouble getting the reingest-1.6-2.0.pl script to run as I'm expecting it to
#09:15:00csharpI'm running './reingest-1.6-2.0.pl --config /openils/conf/opensrf_core.xml --chunk-size=200000'
#09:15:36csharpand the output is just a single sql script that will try to reingest everything
#09:24:12mrpeters-islcsharp: 1 sec...let me look at notes on that
#09:24:39csharplooking further, looks like the config needs to be opensrf.xml, not opensrf_core.xml
#09:24:58csharpso the script defaults appear to be wrong
#09:25:01mrpeters-islah there u go
#09:25:20csharpmrpeters-isl: darshan, is that you?
#09:25:41csharp:-D
#09:27:00csharpargh - still not working
#09:27:20csharp inspects opensrf.xml more closely
#09:31:47csharpokay - it's configured correctly for the reporter DB parameters
#09:32:11csharpmrpeters-isl: did you have any pointers from your notes?
#09:33:47mrpeters-isli actually couldn't find anything about it, and here's why --- gmcharlt used our dev server to write that script
#09:33:55csharpah...
#09:33:55mrpeters-islso, i never had to run it myself
#09:33:58csharpI see
#09:37:47csharp decides to try and hack the script
#09:41:26gmcharltcsharp: the correct config file is opensrf_core.xml, not opensrf.xml
#09:42:00gmcharltas it's trying to establishing a client connetion to open-ils.settings to deduce the database connection parameters
#09:42:18gmcharltit thereby assumes that the opensrf settings (or at least opensrf.settings) is running
#09:42:57csharpgmcharlt: yeah - I just got it work
#09:42:59csharpto work
#09:43:04gmcharltbut ultimately what it *really* wants is just the number of biblio.record_record rows
#09:43:41leed has joined #evergreen
#09:43:48csharpgmcharlt: simple typo '--chunk-size' should've been '--chunk_size'
#09:48:33leed has quit IRC
#10:06:34bshumgmcharlt++ SIP2 clients page
#10:38:23adbowling-isl has joined #evergreen
#10:45:52fortin has joined #evergreen
#11:05:55eeevilgrabbing 0644
#11:11:42sal_ has quit IRC
#11:12:06sal_ has joined #evergreen
#11:23:53mrpeters-islanyone from skita here who can share the eg_vhost.conf entries needed for evergreen-mobile-opac?
#11:39:36berickmrpeters-isl: IIRC, no apache config needed. you just plop the files somewhere in the document root and navigate to that directory in the browser
#11:39:57jeffdavis has quit IRC
#11:40:54mrpeters-islyeah, that did work. Just wanted to make sure there weren't any modules it needed (other than the ones documented)
#11:41:13mrpeters-islbut, alas...im choking somewhere. just hangs on login or attempt to grab org tree
#11:42:55berick suggests JS console
#11:44:12mrpeters-islyeah, totally hangs up apache. have to restart the process afterwards.
#11:45:20jeffdavis has joined #evergreen
#11:46:06mrpeters-islhttp://pastie.org/2773782 looks fishy -- does this mean anything to anyone?
#11:48:14mrpeters-isli figure it's gotta be the proxying with proxy_http_module that it requires?
#11:53:35mrpeters-isllol @ over 150 apache processes from one connection
#11:54:11gmcharlt issues a call for additional testing of http://git.evergreen-ils.org/?p=OpenSRF.git;a=commit;h=ab63faa85e349020774e0b3297a84370281d573f - particularly relevant to folks running EG app servers on heavily loaded VMs
#11:58:45tsbere may install that....in a week or two during their next scheduled update cycle
#12:01:59tsbere throws it on his dev VM now, though
#12:16:10mrpeters-islso evergreen-mobile-opac just spins on "POST http://dev.evergreen.lib.in.us/osrf-gateway-v1" which is definetly in the ProxyPass/ProxyPassReverse code the documentation requires
#12:16:15jeffdavis has quit IRC
#12:24:30tater-laptop has joined #evergreen
#12:24:37mrpeters-islberick: this really seems to be rooted in the apache config. do you have access to any you may have configured in the past?
#12:27:13jeffdavis has joined #evergreen
#12:27:30csharpgmcharlt: is the problem VMWare specific? and by heavily-loaded, do you mean transaction-wise?
#12:28:36jamesrfmrpeters-isl: there is nothing extra in the eg_vhost.conf
#12:28:56gmcharltcsharp: not sure if it's specific to VMWare - it can happy to anybody if a SIGPIPE gets thrown, but the data point I have shows that it's particularly visible on that platform
#12:29:14csharpgmcharlt: thanks
#12:29:38gmcharltload, to the extent that it's a factor, is probably just general load on the VM host, not specific to OpenSRF transaction volume per se
#12:29:43mrpeters-isljamesrf: ok, thanks. strange...i can query the org tree directly like (http://dev.evergreen.lib.in.us/gateway?service=open-ils.actor&method=open-ils.actor.org_tree.retrieve&param)
#12:30:14gmcharltcsharp: also, this bug doesn't affect OpenSRF 1.6.x
#12:30:34mrpeters-islbut when the mobile OPAC tries, it just fires off 150 apache processes and spins
#12:31:56csharpgmcharlt: good to know
#12:32:11csharp hasn't smoked a good SIGPIPE since his college days
#12:32:31gmcharltheh
#12:32:48fortin has quit IRC
#12:32:53jamesrfmrpeters-isl: does the very first screen load with just the "search the catalogue" button?
#12:33:11mrpeters-isldev.evergreen.lib.in.us/mobile
#12:33:12gmcharlt@quote add * csharp hasn't smoked a good SIGPIPE since his college days
#12:33:12pinesol_green`gmcharlt: The operation succeeded. Quote #17 added.
#12:33:28mrpeters-islboth login and serach catalog
#12:33:29phasefx can't handle SIGPIPE's, gets the SIGHUP's
#12:33:41mrpeters-islthen you expand out search catalog and it just hangs until it times out
#12:34:48mrpeters-islsame thing when you try to authenticate
#12:37:13csharpphasefx++
#12:40:23jamesrfoh i see what you're doing
#12:40:27mrpeters-isloh great
#12:40:34jamesrfmrpeters-isl: if you need it to just work, you can just plop it on a running EG server and it should work
#12:40:45jamesrfi don't know about that ProxyPass stuff that is in the docs
#12:40:46mrpeters-islthis is a running EG server
#12:40:54mrpeters-islok, ill remove that stuff
#12:41:43jamesrfi think that's what steven did so he could do dev without a full eg stack
#12:41:50mrpeters-islaha
#12:42:30mrpeters-islwell, progress! it loads now...just no data
#12:43:15mrpeters-isli should clarify...no data in the org tree dropdown
#12:43:44mrpeters-islit does get the data back from open-ils.actor.org_tree.retrieve though
#12:44:25mrpeters-isli think its maybe this server though
#13:00:21mrpeters-islwell, it works in a browser but not any phones lol
#13:00:29mrpeters-isli think it's that proxy stuff
#13:05:46tlilleberg has joined #evergreen
#13:07:10lisah___ has joined #evergreen
#13:08:00jeffdavis has quit IRC
#13:09:31jeffdavis has joined #evergreen
#13:13:03atheos_ has joined #evergreen
#13:15:59atheos has quit IRC
#13:15:59atheos_ is now known as atheos
#13:20:15atheos has quit IRC
#13:31:20tsbere has multiple tickets asking to do changing of holds from one type to another
#13:33:06csharplike volume to copy?
#13:39:55tsbereOne request is volume to title
#13:40:02tsbereFor a single hold
#13:40:11tsbereAnother is "Title to Part" for two entire BIBS worth of holds
#13:40:24phasefx"and keep their place in line" I bet
#13:40:29tsbereWell yea
#13:40:47tsbereWe don't let library staff mess with the request times or cut in line flag currently, either.
#13:41:25tsbere actually installed CSS to *hide* those options to get them to stop trying to use them
#13:44:21tsbereLooks like 90 holds total right now would need to be messed with
#13:44:42csharpwow
#13:45:07csharpso is it staff or patrons or both who expect to be able to change this?
#13:45:08berickan API call to "broaden" the hold would be simple. going the other way, though.. sounds like a new hold ;)
#13:45:30atheos has joined #evergreen
#13:46:07tsberecsharp: Staff. Mainly because the on order records rarely have parts, and then they add parts to the real records...........
#13:48:13csharpwow
#13:48:28csharp decides to never tell PINES libraries about monograph parts
#13:49:00bericksomewhere in PINES, an IRC filter just buzzed
#13:49:13csharpheh - good thing I'm teleworking
#13:49:18berickheh
#13:54:07atheos_ has joined #evergreen
#13:54:19tsbereberick: I am considering a "broaden hold" interface already. Would help with the "ooops, we placed a volume hold and meant to place a title hold" scenarios.
#13:55:59atheos__ has joined #evergreen
#13:56:36bericktsbere: cool. you thinking staff-only for that?
#13:57:03atheos has quit IRC
#13:57:03atheos__ is now known as atheos
#13:58:22tsbereberick: Wasn't sure, really. My current point of planning was "It would be nice if staff could change hold types without opening tickets" followed by "Making things more specific could be a problem, so maybe only making them less specific" and "I may want to add a 'cut in line forcibly disabled when changing hold target' OU setting while I am at it"
#13:58:24atheos_ has quit IRC
#13:59:25berick nods
#13:59:34berick+1 to org setting to disable cut-in-line
#14:00:23tsbereAt some point I may want to add permissions for "you can cut in line holds of type X" in addition to the global one.
#14:01:00tsbereMaybe say "if you are moving a cut in line hold into a hold type you don't have permission to change cut in line on then cut in line is turned off" instead of the OU setting.
#14:07:20lisah___ has quit IRC
#14:08:36tsbereberick: A thought (for staff only): If you have permission to make both kinds of holds (start type and end type), let you convert a hold between the two. For things going towards title it wouldn't ask any questions. For things going away from title it would ask you to pick the specifics. Not sure how to handle metarecord holds in this case, though.
#14:08:45tsbereMaybe don't allow metarecord holds to be converted. <_<
#14:09:55bericktsbere: well, that starts to sound like "place new hold" interface. might be easier to let them create the new hold like normal, then modify the request_time (in a controlled fashion)
#14:10:46tsbereberick: Well, I was thinking that this could work for a large number of holds at once. I know of very few ways to mass-place holds for dozens of patrons at the same time. ;)
#14:11:48berickah, ok
#14:12:10tsbereberick: Dunno if avoiding "canceled hold sitting on patron's account waiting to be un-canceled" would be a benefit to doing it for one hold at a time. Or if not having that would be a downside.
#14:13:29tsbereI can come up with arguments for "cancel current, place new with request date of current" and "just edit the current" in regards to the canceled hold bit alone.
#14:16:44tsbereJust edit current avoids one potential side effect of cancel/re-place: Place Volume hold, elevate to title. Weeks later, un-cancel volume hold, re-elevate to title. Weeks later, un-cancel volume hold, re-elevate to title.....
#14:18:34berickright, it gives them a portal into which new requests may be injected
#14:19:31berick wonders if some of this could be helped with other software / work-flow improvements
#14:19:51bericklike, creating the bib parts before users starting placing holds
#14:21:43tsbereHalf the time the parts aren't even decided upon until they have the items
#14:22:06moodaepoI'm trying to find the logic used when an item is set to lost by calling open-ils.circ.circulation.set_lost but seems like I'm going round in circles. Any pointers?
#14:22:12tsbereLike DVD box sets. If they show up 2 dvds to one physical case they go out in pairs. If they are 4 to one case they go out in quads....
#14:22:30tsberemoodaepo: As in the perl function?
#14:23:44tsberemoodaepo: That is basically a "look barcode up, call set_item_list in Cat/AssetCommon.pm"
#14:23:58tsbereer, set_item_lost
#14:24:02tsberenot list
#14:24:03tsbere<_<
#14:24:17moodaepotsbere: That's the only place I see it referred to but can't tell what logic is used after that is called.
#14:24:38tsberemoodaepo: Open Cat/AssetCommon.pm and read the set_item_lost function?
#14:24:45tsberemoodaepo: Not sure what you are looking for
#14:33:21moodaepotsbere: I had set old circs to LOST by updating the tables a while back, well the costs for the items didn't get applied to the patron's bills since I didn't call the function. I am trying to set the circs set to LOST back to NULL and calling the function correctly so the items costs get applied. This didn't work as expected so am trying to figure out what criteria the function is expecting.
#14:34:09tsberemoodaepo: Set the items themselves to status 1 (Checked Out), set the circs to have no stop fines reason, make sure xact_finish is null?
#14:35:25moodaepotsbere++ # Yup I hadn't changed copy status back to checked out, saw that in AssetCommon.pm after you mentioned set_item_lost earlier
#14:36:07atheos has quit IRC
#14:39:22yboston has joined #evergreen
#14:40:52atheos has joined #evergreen
#14:54:57fortin has joined #evergreen
#14:58:25yboston has quit IRC
#15:25:00yboston has joined #evergreen
#15:27:12Helenbean has left #evergreen
#15:27:17Helenbean has joined #evergreen
#15:27:21Helenbean has left #evergreen
#15:27:32Helenbean has joined #evergreen
#15:27:44Helenbean has left #evergreen
#15:27:57Helenbean has joined #evergreen
#15:49:47jeffdavis has quit IRC
#15:55:46plux has quit IRC
#15:56:03Meliss has quit IRC
#16:01:09mrpeters-isljamesrf: ping?
#16:07:13jamesrfsdyo
#16:07:19jamesrfer
#16:07:20jamesrfyo
#16:07:25jamesrfdon't know where that sd came from
#16:10:54jamesrfmrpeters-isl: ^
#16:16:06kmlussier has quit IRC
#16:39:29Dyrcona has joined #evergreen
#16:47:34Helenbean has quit IRC
#16:57:50tlilleberg has quit IRC
#17:00:07akilsdonk has quit IRC
#17:01:29fortin has quit IRC
#18:08:40sal_ has quit IRC
#18:15:39yboston has quit IRC
#20:05:27bwicksall has joined #evergreen
#21:24:50bwicksall has quit IRC
#22:16:22jeff yawns
#22:36:48edoceo has quit IRC
#22:48:55edoceo has joined #evergreen
#23:09:35Dyrcona has quit IRC
< Thursday, October 27th, 2011Raw Log FileSaturday, October 29th, 2011 >