2011-01-03T00:58:11 *** youdonotexist has quit IRC 2011-01-03T01:02:13 *** youdonotexist has joined #evergreen 2011-01-03T01:09:56 *** youdonotexist has quit IRC 2011-01-03T01:14:20 *** bshum has quit IRC 2011-01-03T01:21:57 *** youdonotexist has joined #evergreen 2011-01-03T05:42:50 *** youdonotexist has quit IRC 2011-01-03T05:43:32 *** youdonotexist has joined #evergreen 2011-01-03T07:37:33 *** Dmagick-home has quit IRC 2011-01-03T07:37:34 *** phasefx has quit IRC 2011-01-03T07:37:34 *** gmcharlt has quit IRC 2011-01-03T07:37:35 *** eeevil has quit IRC 2011-01-03T07:37:35 *** wjr has quit IRC 2011-01-03T07:37:38 *** berick has quit IRC 2011-01-03T07:37:38 *** eby has quit IRC 2011-01-03T07:37:38 *** atz has quit IRC 2011-01-03T07:37:39 *** Dmagick has quit IRC 2011-01-03T07:37:39 *** artunit has quit IRC 2011-01-03T07:37:39 *** youdonotexist has quit IRC 2011-01-03T07:37:41 *** tildeequals has quit IRC 2011-01-03T07:37:41 *** tsbere has quit IRC 2011-01-03T07:37:41 *** mjgiarlo has quit IRC 2011-01-03T07:37:43 *** bradl has quit IRC 2011-01-03T07:37:43 *** jeffdavis has quit IRC 2011-01-03T07:37:44 *** phasefx_ has quit IRC 2011-01-03T07:37:44 *** denials has quit IRC 2011-01-03T07:37:45 *** dbwells has quit IRC 2011-01-03T07:37:45 *** _bott_ has quit IRC 2011-01-03T07:37:45 *** jeff has quit IRC 2011-01-03T07:37:49 *** sylvar has quit IRC 2011-01-03T07:37:50 *** rsinger has quit IRC 2011-01-03T07:37:54 *** cbandito-away has quit IRC 2011-01-03T07:37:54 *** leed has quit IRC 2011-01-03T07:37:54 *** senator has quit IRC 2011-01-03T07:37:55 *** shadowspar has quit IRC 2011-01-03T07:37:55 *** finnapz has quit IRC 2011-01-03T07:37:56 *** kbeswick_ has quit IRC 2011-01-03T07:37:57 *** csharp has quit IRC 2011-01-03T07:38:01 *** mtate has quit IRC 2011-01-03T07:38:01 *** moodaepo has quit IRC 2011-01-03T07:38:01 *** mrpeters-isl has quit IRC 2011-01-03T07:38:01 *** Callender has quit IRC 2011-01-03T07:54:43 *** rjackson-isl has joined #evergreen 2011-01-03T07:54:43 *** youdonotexist has joined #evergreen 2011-01-03T07:54:43 *** shadowspar has joined #evergreen 2011-01-03T07:54:43 *** rsinger has joined #evergreen 2011-01-03T07:54:43 *** wjr has joined #evergreen 2011-01-03T07:54:43 *** eeevil has joined #evergreen 2011-01-03T07:54:43 *** gmcharlt has joined #evergreen 2011-01-03T07:54:43 *** phasefx has joined #evergreen 2011-01-03T07:54:43 *** Dmagick-home has joined #evergreen 2011-01-03T07:54:43 *** berick has joined #evergreen 2011-01-03T07:54:43 *** artunit has joined #evergreen 2011-01-03T07:54:43 *** Dmagick has joined #evergreen 2011-01-03T07:54:43 *** atz has joined #evergreen 2011-01-03T07:54:43 *** eby has joined #evergreen 2011-01-03T07:54:43 *** phasefx_ has joined #evergreen 2011-01-03T07:54:43 *** finnapz has joined #evergreen 2011-01-03T07:54:43 *** tildeequals has joined #evergreen 2011-01-03T07:54:43 *** mtate has joined #evergreen 2011-01-03T07:54:43 *** bradl has joined #evergreen 2011-01-03T07:54:43 *** tsbere has joined #evergreen 2011-01-03T07:54:43 *** moodaepo has joined #evergreen 2011-01-03T07:54:43 *** denials has joined #evergreen 2011-01-03T07:54:43 *** mrpeters-isl has joined #evergreen 2011-01-03T07:54:43 *** dbwells has joined #evergreen 2011-01-03T07:54:43 *** kbeswick_ has joined #evergreen 2011-01-03T07:54:43 *** mjgiarlo has joined #evergreen 2011-01-03T07:54:43 *** sylvar has joined #evergreen 2011-01-03T07:54:43 *** Callender has joined #evergreen 2011-01-03T07:54:43 *** cbandito-away has joined #evergreen 2011-01-03T07:54:43 *** leed has joined #evergreen 2011-01-03T07:54:43 *** jeffdavis has joined #evergreen 2011-01-03T07:54:43 *** _bott_ has joined #evergreen 2011-01-03T07:54:43 *** csharp has joined #evergreen 2011-01-03T07:54:44 *** senator has joined #evergreen 2011-01-03T07:54:44 *** jeff has joined #evergreen 2011-01-03T08:28:55 *** AaronZ has joined #evergreen 2011-01-03T08:45:19 *** atz_ has joined #evergreen 2011-01-03T08:47:40 *** atz has quit IRC 2011-01-03T09:02:11 *** bshum has joined #evergreen 2011-01-03T09:10:28 *** Meliss has joined #evergreen 2011-01-03T09:20:39 *** r123 has joined #evergreen 2011-01-03T09:21:05 *** kmlussier has joined #evergreen 2011-01-03T09:27:07 *** jenny has joined #evergreen 2011-01-03T09:34:58 *** r123 has quit IRC 2011-01-03T09:38:51 *** rsoulliere has joined #evergreen 2011-01-03T09:41:03 *** tspindler has joined #evergreen 2011-01-03T09:44:47 I just noticed the link to adding localizations in the 1.6.1 install steps under optional. It's pointing to a page for steps in 1.4. Has anyone checked whether those work with 1.6+? 2011-01-03T09:45:23 Step 15 2011-01-03T09:55:26 That is a good question. I have used the disabling instructions to disable languages in 1.6+. 2011-01-03T09:56:21 I also noticed the language seed values sql scripts are still packaged in 1.6+ versions of Evergreen. 2011-01-03T10:00:48 rsoulliere: I've used some of those instructions in 2.0 to setup the es-ES language, but wasn't sure how it really works. 2011-01-03T10:01:27 Or if I was doing it right. 2011-01-03T10:03:22 bshum: These same instructions are also included in the official documentation for 1.6 maintained by DIG: http://docs.evergreen-ils.org/1.6/draft/html/languagesandlocalization.html#enabling_and_disabling_localization 2011-01-03T10:05:36 however, these have not been verified by someone with Evergreen locale expertise.... only migrated over from the downloads page as is. 2011-01-03T10:20:29 *** collum has joined #evergreen 2011-01-03T10:31:33 *** Meliss has quit IRC 2011-01-03T10:32:00 *** Meliss has joined #evergreen 2011-01-03T10:37:04 hey all --- Equinox is closed today it seems, and we're still suffering from major action/trigger issues. Anyone have any experience with debugging this? action_trigger_runner.pl is running, but I'm only seeing "2011-01-02 13:50:52.267874-05" as the last time any of the entries in the action_triger.event table were updated. 2011-01-03T10:37:44 any help is apprecaited. We've been suffering without notices for nearly 2.5 weeks because of the holidays and scheduling between us and ESI. Really hoping to find a way to resolve this today! 2011-01-03T10:39:11 I have entries from today, showing as "collected" but can't seem to find what that actually refers to. 2011-01-03T10:42:01 *** dbs has joined #evergreen 2011-01-03T10:42:01 *** dbs has joined #evergreen 2011-01-03T10:45:18 bshum: nothing significant has changed in how i18n works between 1.4 and 1.6, at least not for those who download the tarballs 2011-01-03T10:47:15 dbs: Ah, okay, thanks for following up on that. 2011-01-03T10:56:47 *** granitize has joined #evergreen 2011-01-03T10:58:48 mrpeters-isl: That sounds like trouble. Are all your events impacted? Or just email? 2011-01-03T10:59:06 (unsure of what events you're using) 2011-01-03T11:01:11 *** granitize has quit IRC 2011-01-03T11:01:56 bshum: its email, and our print notice generation 2011-01-03T11:02:19 we have some custom notices for 45 days overdue, items marked damaged, etc. 2011-01-03T11:02:40 it seems to run for a while, and then suddenly opens tons and tons of cstore drones 2011-01-03T11:02:56 That sounds scary. 2011-01-03T11:02:59 i let it run on an old server that was previously known working and the same thing occured 2011-01-03T11:03:20 yeah, if unchecked it will totally lock up the server its running on 2011-01-03T11:05:24 mrpeters-isl: Unrelated to your problem, but you're saying you folks have print notices working with action/triggers? 2011-01-03T11:05:43 (we don't have that, I've been wondering if it's possible) 2011-01-03T11:06:12 yeah 2011-01-03T11:06:33 I'll have to ask you to show me that when you're not under the gun 2011-01-03T11:06:39 be glad to 2011-01-03T11:07:26 mrpeters-isl: hmm. we had that happen (crazy number of cstore drones) the first time we ran action_trigger_runner.pl early last year; can't remember off-hand if an update to a later EG version solved the problem 2011-01-03T11:08:06 dbs: we had been getting by for almost a year now (IIRC) so it'd be kind of strange for it to break now, but possible i geuss 2011-01-03T11:08:09 add_time | 2011-01-03 09:10:23.703382-05 2011-01-03T11:08:10 run_time | 2010-12-09 19:49:11-05 2011-01-03T11:08:11 this is weird to me? 2011-01-03T11:08:57 Did your servers have a time hiccup? 2011-01-03T11:09:22 dont think so...its just this one transaction that appers this way 2011-01-03T11:09:34 but its the last one that ran prior to the cstore spike 2011-01-03T11:10:37 at least it appears to be the last one... 2011-01-03T11:16:49 mrpeters-isl: the story for us began at http://www.open-ils.org/irc_logs/evergreen/2010-06/%23evergreen.11-Fri-2010.log 2011-01-03T11:17:34 as i count back down through the id's they all have a state of "collected" or "complete" --- but that one with an id "6600498" has been pending, apparently since that 12/9 timestamp 2011-01-03T11:17:39 thanks dbs i will read 2011-01-03T11:19:37 anyone know off hand what action_trigger.event.target refers to? http://open-ils.org/documentation/schemas/evergreen-schema-1.6.0.0.html isn't quite clear 2011-01-03T11:21:42 mrpeters-isl: it'll be a fieldmapper object, the core type from the trigger hook 2011-01-03T11:22:13 so if the template is for circs, the target will be a circ (or circs) 2011-01-03T11:22:36 ok, yeah this looks like the circ that would match with the event 2011-01-03T11:22:51 timestamp on the event is within 5 minutes of the xact_start 2011-01-03T11:23:21 Wild guess: anything unique about the user or bib data (embedded line feeds, control characters, etc)? 2011-01-03T11:23:52 dbs: yeah, that's why I was asking if it might refer to a circ...looking to see if there is anything funny on the patron or item data 2011-01-03T11:25:26 user data looks normal 2011-01-03T11:26:56 Would be worthwhile seeing if there's anything interesting in open-ils.trigger_unix.log too, of couse 2011-01-03T11:27:50 mrpeters-isl: Just curious but you might want to see what version of the action_trigger_runner.pl you have running. I recall you guys are a 1.6.0 site. I see that there's been a few changes over the last years leading to 1.6.1 for that script 2011-01-03T11:28:18 Don't know if that's anything 2011-01-03T11:28:32 But I was just comparing the 1.6.0.0 to 1.6.1.4 and noticed a few differences 2011-01-03T11:28:56 dbs: yeah, the logs - we get a flood of "2011-01-03 10:46:48 208.119.0.102 open-ils.trigger: [ERR :3282:EX.pm:66:] Exception: OpenSRF::EX::Session 2011-01-03T10:46:48 OpenSRF::Application /usr/local/share/perl/5.8.8/OpenSRF/Application.pm:571 Session Error: osrf@private.jabber.evergreen.lib.in.us/client_at_apache.evergreen.lib.in.us_3265 IS NOT CONNECTED TO THE NETWORK!!!" when the cstores 2011-01-03T11:28:56 spike out 2011-01-03T11:33:02 http://www.open-ils.org/irc_logs/evergreen/2010-06/%23evergreen.15-Tue-2010.log has some more dialogue between berick, miker, jeff and I about what conspired to cause the problem for us 2011-01-03T11:33:08 *** r123 has joined #evergreen 2011-01-03T11:33:49 step 1: ensure max_connections in your postgresql.conf can handle the maximum number of database-connecting child opensrf processes (defined in opensrf.xml) across all your drones 2011-01-03T11:34:14 dbs: right - we've been through a long process of verifying that with Equinox recently 2011-01-03T11:35:54 quite honestly, i think ESI had a good idea what was happening but I think the ticket may just have gotten shuffled around during the holiday. Sounds like they're getting someone on it now though. 2011-01-03T11:36:01 appreciate your advice as well 2011-01-03T11:36:04 * dbs backs away 2011-01-03T11:36:40 don't take offense...what you said is very good for someone else who stumbles upon this at a later date 2011-01-03T11:36:51 and maybe hasn't calculated the proper database connection values, etc. 2011-01-03T11:42:38 *** Dyrcona has joined #evergreen 2011-01-03T11:45:38 mrpeters-isl: right, and of course I have no idea what you've discussed with Equinox and what changes might have occurred in your environment recently or what version of Evergreen you're running 2011-01-03T12:11:59 *** b_bonner has joined #evergreen 2011-01-03T12:25:10 Has anyone ever done a mass voiding of fines? One of our libraries is looking to forgive all of last year's fines for dvds/videos so I'm writing some SQL to target the billings associated and void them. Just wondering if there's any "oh no's" I should watch out for along the way :) 2011-01-03T12:28:17 make sure xact_finish is null, make sure you're considering the right billing type 2011-01-03T12:29:15 *** tate-home has joined #evergreen 2011-01-03T12:30:26 *** jamesrf has joined #evergreen 2011-01-03T12:31:54 phasefx: I got the billing type nailed, but I didn't think of xact_finish, hmm 2011-01-03T12:32:05 phasefx: Thanks! :) 2011-01-03T12:32:11 don't want to void bills that have been paid already :) 2011-01-03T12:32:31 xact_finish won't help there for partial payments (or ongoing circs) 2011-01-03T12:32:42 if someone is paying down fines 2011-01-03T12:33:15 phasefx: Hmm, didn't think about that. What would happen to those you think? Negative balance? 2011-01-03T12:34:53 negative balance / credit 2011-01-03T12:35:01 if xact_finish was null, they'd show up in the patron's billing interface with a Refund option available 2011-01-03T12:35:06 Not sure how credit will work with a 1.6.1.x 2011-01-03T12:35:26 whether the patron's total amount due was negative would depend on other bills 2011-01-03T12:36:00 Ahh, fun times. 2011-01-03T12:36:11 That sounds... complex then. 2011-01-03T12:36:19 For xacts that are still ongoing/partially paid 2011-01-03T12:36:41 could be thorny, though you may not have any instances of it 2011-01-03T12:36:54 Yeah, I'm off to check on that next. 2011-01-03T12:37:26 Today is happy forgiving day for the library... with super SQL updates to the rescue. 2011-01-03T12:37:44 csharp: if you're back, I think we're hoping to find out where support for new mailing lists on evergreen-ils.org is at (context is Evergreen Security and Evergreen Release Coordination); Equinox has offered to host at least the security list in the interim if it will still be a while 2011-01-03T12:37:48 consider that payment and billing line items are just lumped into buckets, as it were (credits/debits). You can only say they have a transaction in common, but not that one specific payment went toward a specific billing (exception: some stuff TADL funded that makes such an arbitrary determination) 2011-01-03T12:41:32 phasefx: Does the money.billing.xact refer to money.billable_xact.id or is that the action.circulation.id? 2011-01-03T12:42:08 bshum: both (for circulation transactions). action.circulation is a child table of money.billable_xact 2011-01-03T12:42:16 using postgres table inheritance 2011-01-03T12:42:26 Aha 2011-01-03T12:42:47 payment tables also use inheritance 2011-01-03T12:55:11 So anything with action.circulation.xact_finish or money.billable_xact.xact_finish (should be the same thing) as NULL would be a completed transaction, and therefore should be excluded from my voiding. 2011-01-03T13:17:36 Okay, so there are 34 payments in money.payment where the xact matches to a billing I want to void. Guess sifting through 34 unfinished xacts doesn't sound so bad. 2011-01-03T13:17:59 Thanks phasefx for pointing out some pitfalls for me :) 2011-01-03T13:20:16 bshum: I edited the meeting agenda page a bit for consistency with previous agendas (making action items more directly associated with a particular person by leading with that person's name and leaving a STATUS: ??? placeholder); hope you don't mind 2011-01-03T13:20:57 Also created http://evergreen-ils.org/dokuwiki/doku.php?id=dev:evergreen:release_checklist as a centralized document for discussing/developing the release checklist 2011-01-03T13:21:37 dbs: Not at all, I was just starting a page since I saw one hadn't been started yet. Writing action items from the combined agenda/minutes from the last meeting ended up being... tricky. 2011-01-03T13:24:11 bshum: hmm. I usually find it's a quick copy/paste of the previous agenda, with editing to cut out anything that wasn't an assigned/agreed-upon action item 2011-01-03T13:24:17 *** b_bonner has quit IRC 2011-01-03T13:24:37 *** brian_f has joined #evergreen 2011-01-03T13:25:17 *** b_bonner has joined #evergreen 2011-01-03T13:25:22 dbs: It's also possible that working on the agenda late at night was not a good idea for me. :) 2011-01-03T13:25:36 Oh, you did fine! and thanks for the reminder 2011-01-03T13:27:22 dbs: Ah, I remember now (had to look at the old page). I got lost looking between old action items from the previous, previous and making sure not to carry them over to the next meeting. You're right though that the copy/paste works well. I just got lost in the beginning bits. 2011-01-03T13:27:57 dbs: Glad to help out where I can. I probably won't make it to the meeting. Conflict on my end. But I'll track the logs. 2011-01-03T13:28:17 yeah, if people would just do their action items rather than carrying them over from meeting to meeting it would be simpler 2011-01-03T13:28:19 * dbs blushes 2011-01-03T13:28:24 :) 2011-01-03T13:34:12 *** agJohn has joined #evergreen 2011-01-03T14:24:31 *** kmlussier has quit IRC 2011-01-03T14:26:32 *** b_bonner has quit IRC 2011-01-03T14:42:42 bshum: re: xact_finish, null is open, non-null is finished, just to be clear 2011-01-03T14:48:10 phasefx: Yep, I got those backwards. But figured it out before I ran the updates fortunately. 2011-01-03T14:48:15 phasefx: Thanks :) 2011-01-03T14:51:33 *** brian_f has quit IRC 2011-01-03T15:05:42 * Dyrcona wonders if it is a common thing to get MARC files from vendors with duplicate records in them. 2011-01-03T15:18:41 *** tildeequals has quit IRC 2011-01-03T15:31:14 rsoulliere++ # You know what you did! 2011-01-03T15:33:01 *** b_bonner has joined #evergreen 2011-01-03T15:34:00 *** b_bonner has quit IRC 2011-01-03T15:40:55 Any postgres gurus around? Trying to craft some SQL and having some issues... 2011-01-03T15:41:32 We're applying a new group penalty threshold, but it doesn't seem to automatically take hold anywhere. Wondering if maybe I'm missing something, but it looks like I can also generate penalties I need by hand. 2011-01-03T15:42:05 It does generate the standing penalty for the user when hitting "refresh" in the staff client, but initially pulling them up does nothing. 2011-01-03T15:42:14 So I'm guessing there's some function that does this stuff. 2011-01-03T15:42:14 yes. 2011-01-03T15:42:23 there's a calculate penalties call, iirc. 2011-01-03T15:42:30 i've looked into it before 2011-01-03T15:42:58 Right, I saw a function called "actor.calculate_system_penalties" 2011-01-03T15:43:08 It uses two arguments, the ID of the user and the ID of the org unit. 2011-01-03T15:45:32 jeff: I'm poking at it right now to see if there's any way to run a whole range of user IDs through at the same time. 2011-01-03T15:45:44 i don't believe there is any batch interface 2011-01-03T15:46:06 Then take the whole thing and jam it into actor.usr_standing_penalty with inserts 2011-01-03T15:57:21 *** ChanServ changes topic to "Welcome to the #Evergreen library system channel! | We are publicly logged. | Large pastes at http://paste.lisp.org/new/evergreen" 2011-01-03T15:59:39 * dbs wonders about his use of "we" in his email to -dev about 1.6.2.0; that might be overly broad 2011-01-03T16:00:34 *** Meliss has quit IRC 2011-01-03T16:02:51 dbs: Maybe, but I also said the same thing to rsoulliere based on my memory of the past dev meetings. 2011-01-03T16:03:19 * Dyrcona agrees with dbs for the most part about 1.6.2.0. 2011-01-03T16:03:21 It seemed like there was a general consensus to avoid 1.6.2 to focus on 2.0 stuff. 2011-01-03T16:06:33 dbs: thanks for the clarifications on the list. I will revert the documentation to reflect 1.6.1 as the stable version in thr 1.6 series. 2011-01-03T16:08:08 *** tspindler has quit IRC 2011-01-03T16:09:00 rsoulliere: again - sorry for your wasted effort :( 2011-01-03T16:09:12 *** collum has left #evergreen 2011-01-03T16:09:42 dbs: no problem, I liked your version support policy you sent out a while back. I will write a response to the list in support. 2011-01-03T16:10:30 I would really like to keep the version support policy simple to make both development and documentation easier. 2011-01-03T16:11:24 I have to go. bye for now. 2011-01-03T16:11:50 *** rsoulliere has quit IRC 2011-01-03T16:18:18 *** rjackson-isl has quit IRC 2011-01-03T16:27:46 *** r123 has quit IRC 2011-01-03T16:40:19 *** bshum has quit IRC 2011-01-03T16:51:27 bshum: If you're still fighting with the actor.calculate_system_penalties, I can show you some tricks that might help you run it on a range of users. 2011-01-03T17:01:46 agJohn: looks like he just left -- you should post the tricks to the list, or on the wiki! :) 2011-01-03T17:09:49 *** mjg_ has joined #evergreen 2011-01-03T17:15:02 *** tildeequals has joined #evergreen 2011-01-03T17:19:15 *** tildeequals_ has joined #evergreen 2011-01-03T17:20:34 *** denials has quit IRC 2011-01-03T17:20:45 *** denials has joined #evergreen 2011-01-03T17:22:35 *** tildeequals has quit IRC 2011-01-03T17:23:11 *** AaronZ has quit IRC 2011-01-03T17:28:19 *** jamesrf has quit IRC 2011-01-03T17:30:44 *** Dyrcona has quit IRC 2011-01-03T17:35:26 *** phasefx__ has joined #evergreen 2011-01-03T17:35:33 *** dbwells_ has joined #evergreen 2011-01-03T17:35:40 *** jeff___ has joined #evergreen 2011-01-03T17:36:58 *** phasefx_ has quit IRC 2011-01-03T17:36:58 *** dbwells has quit IRC 2011-01-03T17:36:58 *** _bott_ has quit IRC 2011-01-03T17:36:59 *** jeff has quit IRC 2011-01-03T17:37:15 *** dbwells_ is now known as dbwells 2011-01-03T17:42:00 *** _bott_ has joined #evergreen 2011-01-03T18:00:58 *** jenny has left #evergreen 2011-01-03T18:07:55 *** mjg_ has left #evergreen 2011-01-03T18:25:31 *** bshum has joined #evergreen 2011-01-03T18:46:50 *** bshum has quit IRC 2011-01-03T19:26:01 *** brendan2 has joined #evergreen 2011-01-03T20:20:03 *** tpham has joined #evergreen 2011-01-03T20:31:01 *** tpham has quit IRC 2011-01-03T21:05:38 *** tildeequals has joined #evergreen 2011-01-03T21:05:50 *** tildeequals_ has quit IRC 2011-01-03T21:24:30 *** tildeequals_ has joined #evergreen 2011-01-03T21:25:47 *** tildeequals has quit IRC 2011-01-03T22:08:49 *** tate-home has quit IRC 2011-01-03T22:27:28 *** Dmagick-home has quit IRC 2011-01-03T22:59:52 *** tildeequals_ has quit IRC 2011-01-03T23:00:11 *** youdonotexist has quit IRC 2011-01-03T23:01:13 *** youdonotexist has joined #evergreen 2011-01-03T23:02:50 *** youdonotexist has quit IRC 2011-01-03T23:04:53 *** eby has quit IRC