| # | Time | Nick | Message |
|---|
| # | 00:05:22 | dkyle has quit IRC |
| # | 00:05:51 | dkyle has joined #evergreen |
| # | 01:34:35 | mrpeters-isl has quit IRC |
| # | 01:36:12 | matt_carlson has joined #evergreen |
| # | 02:27:53 | matt_carlson has quit IRC |
| # | 04:37:24 | darshan has joined #evergreen |
| # | 04:37:57 | darshan | I am new to Ubuntu os for linux, |
| # | 04:38:14 | darshan | i m using lucid lynx 10.04 version of server edition for installing Evergreen Library server-side software int it. |
| # | 04:38:23 | darshan | my command is as follows :- |
| # | 04:38:31 | darshan | useradd -m - s /bin/bash opensrf |
| # | 04:38:41 | darshan | but ,its giving me an error of |
| # | 04:38:48 | darshan | useradd :cannot lock /etc/passwd .try again later |
| # | 04:38:55 | darshan | so what can i do now to resolve it |
| # | 05:00:41 | darshan | is ne1 der |
| # | 05:40:17 | darshan has quit IRC |
| # | 05:46:27 | pinesol_green` has joined #evergreen |
| # | 05:46:27 | pinesol_green has quit IRC |
| # | 06:11:27 | LarryB has joined #evergreen |
| # | 06:26:11 | anjali_ has joined #evergreen |
| # | 06:26:36 | anjali_ | hi |
| # | 06:27:26 | anjali_ | I need help on get the action trigger working for overdue item |
| # | 06:32:11 | anjali_ has quit IRC |
| # | 06:56:03 | eeeevil has quit IRC |
| # | 06:59:42 | eeeevil has joined #evergreen |
| # | 07:19:06 | artunit_ has joined #evergreen |
| # | 07:20:35 | artunit has quit IRC |
| # | 07:20:43 | artunit_ is now known as artunit |
| # | 07:42:37 | eeeevil has quit IRC |
| # | 08:07:33 | plux_ has joined #evergreen |
| # | 08:17:44 | Dyrcona has joined #evergreen |
| # | 08:30:12 | _bott_ has quit IRC |
| # | 08:30:49 | _bott_ has joined #evergreen |
| # | 09:04:16 | kmlussier has joined #evergreen |
| # | 09:11:16 | jenny has joined #evergreen |
| # | 09:11:31 | Dyrcona mumbles something about hating email. |
| # | 09:12:22 | berick | gmcharlt: fyi collab/berick/acq-remove-excess-cancel-reasons |
| # | 09:20:26 | mrpeters-isl has joined #evergreen |
| # | 09:32:26 | sfortin has joined #evergreen |
| # | 09:49:16 | bwicksall has joined #evergreen |
| # | 09:53:24 | matt_carlson has joined #evergreen |
| # | 10:09:56 | matt_carlson has quit IRC |
| # | 10:11:22 | dbs has joined #evergreen |
| # | 10:11:22 | dbs has joined #evergreen |
| # | 10:14:30 | darshan__ has joined #evergreen |
| # | 10:16:20 | darshan__ | i want to ask ,that can i use evergreen 2.0.1 server side software to install ,bcoz while installing 1.6 version of it ,i m getting an error of can't find packages |
| # | 10:17:19 | matt_carlson has joined #evergreen |
| # | 10:19:23 | bshum | darshan__: Hi there, just to confirm, are you working on installing Evergreen or OpenSRF right now? |
| # | 10:20:19 | bshum | darshan__: If you're installing OpenSRF, then I heartily recommend OpenSRF 2.0.1 instead of the 1.6.3, if you intend to later install the latest version of Evergreen (2.1 or 2.0 series). |
| # | 10:22:33 | darshan__ | so is it better to insatll 2.0 evergreen and opensrf |
| # | 10:23:25 | matt_carlson has quit IRC |
| # | 10:25:30 | dbs | OpenSRF 2.0.1, Evergreen 2.1.0 is what I would suggest |
| # | 10:25:36 | bshum | darshan__: I definitely suggest OpenSRF 2.0, as for Evergreen, you might find value in being on the latest 2.1.0 release |
| # | 10:25:42 | bshum | ^-- what dbs said :) |
| # | 10:28:48 | darshan__ | ok |
| # | 10:28:51 | darshan__ | thanks |
| # | 10:33:19 | jeffdavis has quit IRC |
| # | 10:49:21 | jeffdavis has joined #evergreen |
| # | 10:55:43 | anjali has joined #evergreen |
| # | 11:11:32 | kmlussier has quit IRC |
| # | 11:13:34 | anjali | any body familiar here with action trigger setting?? |
| # | 11:14:50 | dbs | anjali: probably. some more so than others. next question? |
| # | 11:15:50 | anjali | i created an action trigger from staff client... |
| # | 11:16:26 | anjali | and a relevant INSERT of record has also happened in table event_definition |
| # | 11:17:15 | anjali | I have specified email template too while creating A.T. |
| # | 11:17:31 | anjali | now what should be done next? |
| # | 11:19:59 | collum has joined #evergreen |
| # | 11:21:04 | dbs | anjali: if nobody is around that knows how to answer your question, you might still get a response from someone later - keep an eye on the IRC logs at http://evergreen-ils.org/irc_logs/evergreen/2011-10/ |
| # | 11:21:21 | AaronZ-PLS has quit IRC |
| # | 11:21:51 | anjali | @dbs...ok |
| # | 11:21:51 | pinesol_green` | anjali: Error: "dbs...ok" is not a valid command. |
| # | 11:22:02 | anjali | ok |
| # | 11:22:31 | dbs | anjali: are you running action_trigger_runner.pl ? you might want to collect a lot of your info (for example the action_trigger.event_definition values for the row), reference http://docs.evergreen-ils.org/2.0/draft/html/ProcessingActionTriggers.html and send your question as an email to the open-ils-general mailing list |
| # | 11:23:03 | anjali | ok dbs |
| # | 11:24:41 | anjali | i didnt get "you might want to collect a lot of your info (for example the action_trigger.event_definition values for the row" |
| # | 11:25:17 | anjali | i noticed a relevant record in event_definition table... |
| # | 11:26:26 | anjali | in email template I noticed [%- user = target.0.usr -%] |
| # | 11:27:01 | anjali | how this will be processed and from where these dynamic values will be picked up?? |
| # | 11:29:14 | dbs | anjali: I would suggest describing what your goal is (for example, "I want the system to send an email to users the day after an item is due") as part of your email. |
| # | 11:30:59 | anjali | yes I want to send a notification email to patron and additonally want a copy of that email in one of my test mailbox |
| # | 11:31:22 | anjali | like cc or bcc |
| # | 11:32:31 | dbs | Another useful part of your email would be to state whether you have any of the email notices that ship with Evergreen sending successfully |
| # | 11:36:37 | anjali | sorry i didnt get you... |
| # | 11:38:53 | dbs | anjali: In your email, you should indicate whether this is a problem getting action trigger notifications to work at all - or whether you have other notices working, just that you're having trouble figuring out how to add a new one. |
| # | 11:39:12 | dbs | If people assume that you already have other notifications working, then they'll respond differently. |
| # | 11:39:43 | anjali | so i need to email on this...right?? |
| # | 11:40:08 | dbs | anjali: that's what I would suggest, given that nobody else is jumping in to help |
| # | 11:40:38 | anjali | ok... |
| # | 11:41:10 | anjali | i'll write an email... |
| # | 11:42:56 | anjali | but would add that I am not getting any notificaton email delivered till now... |
| # | 11:43:17 | dbs | anjali: okay, then I would suggest that your first step should be getting help in getting notification email delivered |
| # | 11:43:29 | dbs | worry about the basics first, before moving on to a customized notice |
| # | 11:44:37 | anjali | and want the setup to be done for this...like any record INSERT in any table or any configurational setting any any XML for this before I run action_trigger_runner.pl |
| # | 11:46:13 | anjali | yes you are right, I want first notification email to be delivered...that would required help to begin with |
| # | 11:46:21 | matt_carlson has joined #evergreen |
| # | 11:49:59 | dbs | anjali: you might also want to read through threads like http://markmail.org/thread/uvyxt3meuek6fs5l |
| # | 11:51:47 | kmlussier has joined #evergreen |
| # | 11:52:42 | darshan__ | i am switch to some user opensrf and want to perform step as:- ./configure --prefix=/openils --sysconfdir=/openils/conf ,but its giving me error at one place ,and dat is "opening dependency file .deps/libopensrf_la-osrf_message.Tpo :permission denied".leaving directory /home/opensrf/opensrf-2.0.1/src/libopensrf. |
| # | 11:53:31 | dbs | darshan__: link to the docs you're using? |
| # | 11:53:49 | darshan__ | http://open-ils.org/dokuwiki/doku.php?id=opensrf:2.0:install |
| # | 11:54:08 | darshan__ | at 4th step |
| # | 11:54:38 | dbs | darshan__: it sounds like you've run that step already as a different user |
| # | 11:54:58 | darshan__ | hmm ya as a root |
| # | 11:55:08 | darshan__ | now wat shold i do |
| # | 11:55:23 | darshan__ | i read it later that i should run it as opensrf |
| # | 11:55:50 | dbs | darshan__: As the root user, "rm -fr /home/opensrf/opensrf-2.0.1" |
| # | 11:55:53 | berick stops wantonly pushing tpac fixes |
| # | 11:56:09 | berick | the sun was warm, but I flew too close |
| # | 11:56:27 | darshan__ | <dbs> wat |
| # | 11:56:28 | dbs | darshan__: then as the opensrf user, do step 2 and step 4 |
| # | 11:56:37 | darshan__ | ,plz ders is no another way to do it |
| # | 11:57:16 | darshan__ | ok |
| # | 11:57:21 | dbs | darshan__: that will resolve your problem |
| # | 11:57:26 | darshan__ | ok |
| # | 12:05:50 | dbs notes that as far as he can tell there is no documentation on "aged circulations" (for protection of patron privacy while retaining circ history of stats) |
| # | 12:06:18 | csharp | dbs: I haven't seen any either, fwiw |
| # | 12:06:22 | dbs | Feature consists of issuing a DELETE on action.circulation using the pertinent criteria (date xact was finished, etc) |
| # | 12:06:51 | dbs | so the docs wouldn't have to be much, but would help flesh out a nice selling point. particularly if tsbere's outstanding pull request gets pulled in |
| # | 12:07:04 | dbs hopes to look at that one soon |
| # | 12:07:13 | csharp | yeah - I learned that the hard way when trying to delete a huge number of old circs on a test machine |
| # | 12:07:26 | dbs | csharp: thanks for the confirmation, I thought I was crazy there for a little while :) |
| # | 12:07:39 | csharp | ;-) |
| # | 12:07:47 | tsbere | Heh |
| # | 12:07:51 | dbs | csharp: oh, heh - you learned that you're not saving any space by doing that? :) |
| # | 12:07:59 | tsbere | I believe there is a cron job that handles it automatically too? |
| # | 12:08:04 | csharp | definitely not ;-) |
| # | 12:08:28 | phasefx | hey, isn't it less data? :) |
| # | 12:08:38 | dbs | tsbere: aged-to-lost there is, I don't think there's anything for aged-to-protect-privacy |
| # | 12:08:42 | tsbere | ahh |
| # | 12:09:06 | dbs | tsbere: this is why I was feeling a bit lost, poking around in our many directories where we squirrel away scripts :) |
| # | 12:09:07 | tsbere | phasefx: I think it is more data, technically. Most of action.circulation, PLUS some user fields instead of the usr id itself. |
| # | 12:09:27 | phasefx | doh |
| # | 12:10:17 | dbs | first reference shift of the day over, whee |
| # | 12:14:56 | gmcharlt | dbs: do I infer that you have multiple shifts today? ouch |
| # | 12:15:07 | dbs | gmcharlt: yeah, a special day :) |
| # | 12:15:16 | gmcharlt | all days are special ;) |
| # | 12:15:56 | anjali | dbs : how will [%- params.recipient_email || user.email %] get value at run time ?? |
| # | 12:16:17 | darshan__ | <dbs> plz tell me the exact command for command for step 4.3 |
| # | 12:16:35 | bjwebb has quit IRC |
| # | 12:17:04 | matt_carlson has quit IRC |
| # | 12:17:06 | dbs opens a support company |
| # | 12:17:21 | matt_carlson has joined #evergreen |
| # | 12:17:53 | rangi | dbs: please make me a coffee |
| # | 12:18:21 | dbs | anjali: if you're testing the event through the staff client, I think you should be able to pass in an email address for params.recipient_email; if it's a real event, then the value of the email column on the actor.usr row associated with the user will be used |
| # | 12:19:13 | dbs | darshan__: echo /openils/lib >> /etc/ld.so.conf.d/osrf.conf && echo /usr/local/lib >> /etc/ld.so.conf.d/osrf.conf |
| # | 12:19:27 | dbs | rangi: coffee is most definitely support |
| # | 12:19:30 | rangi | :) |
| # | 12:21:34 | darshan__ | <dbms>thank u |
| # | 12:31:41 | darshan__ | tell me commands for 4.4 |
| # | 12:31:48 | darshan__ | step |
| # | 12:32:23 | anjali | dbs: how to test event thru' staff client? |
| # | 12:32:53 | dbs | darshan__: sorry, you need to know how to use some kind of text editor on Linux. I suggest that you search google for an intro to nano or vim |
| # | 12:41:39 | shopkins has joined #evergreen |
| # | 12:51:24 | anjali has quit IRC |
| # | 13:02:06 | darshan__ has quit IRC |
| # | 13:07:23 | csharp | dbs++ # helping Evegreen n00bs |
| # | 13:08:28 | dbs | csharp: eh, we all take our turns |
| # | 13:08:52 | dbs was an Evergreen n00b once, and berick / eeevil / phasefx showed amazing patience |
| # | 13:09:25 | csharp had the same experience and mentors ;-) |
| # | 13:09:41 | csharp often still feels like an Evergreen n00b |
| # | 13:11:34 | dbs | csharp: me too :) |
| # | 13:19:08 | csharp sees 'oils_text_as_bytea' in upgrade script output; craves tea |
| # | 13:26:28 | gmcharlt | "this function was sponsored by Lipton" |
| # | 13:29:45 | dbs | that function would be a perfect pg_tap test case, wouldn't it? |
| # | 13:34:17 | shopkins has quit IRC |
| # | 13:44:25 | csharp | okay - I did a pg_dump/pg_restore of a 1.6.1.8 database, and I'm finding as I run these upgrade scripts that certain schemas/tables do not exist... would it be a good idea to run through each of the sql install scripts before continuing? |
| # | 13:44:39 | csharp | the only harm would be "already exists" errors, right? |
| # | 13:44:56 | csharp | (installing 2.1.0, btw) |
| # | 13:45:27 | gmcharlt | csharp: the install scripts have drop schema cascades in them |
| # | 13:45:38 | gmcharlt | which would not lead to happiness |
| # | 13:46:20 | gmcharlt | what tables and schemas are missing? |
| # | 13:47:58 | csharp | well, in this case, I did not pg_dump the auditor schema, and I'm now trying to create that |
| # | 13:48:35 | csharp | which leads me to 'schema "serial" does not exist' |
| # | 13:49:10 | csharp | which, in turn, leads me to 'ERROR: schema "evergreen" does not exist' |
| # | 13:49:54 | kmlussier has quit IRC |
| # | 13:50:38 | csharp | looks like 000.functions.general.sql includes that schema creation |
| # | 13:50:44 | csharp | (evergreen) |
| # | 13:50:50 | gmcharlt | which is part of the upgrade |
| # | 13:51:02 | csharp | ah |
| # | 13:51:10 | gmcharlt | rather than mess with that, you could do a schema-only pg_dump of the auditor schema from 1.6.1.8 |
| # | 13:51:24 | csharp | gmcharlt: ah - good idea |
| # | 13:51:27 | gmcharlt | then pg_restore that schema into the copy you're testing the upgrade with |
| # | 13:51:44 | csharp | gmcharlt: you should do this for a living ;-) |
| # | 13:52:11 | gmcharlt | bradl: you hear that? ;) |
| # | 13:59:16 | bradl | gmcharlt: guess it's time to give up on the cat farm |
| # | 14:00:13 | csharp was hoping for some Equinox(TM) brand cat fur slippers for xmas |
| # | 14:02:07 | gmcharlt winces |
| # | 14:02:11 | gmcharlt | *faux* cat fur |
| # | 14:02:19 | csharp | heh |
| # | 14:13:16 | dbs feels sorry for the poor little kitty named 'faux' |
| # | 14:23:27 | Dyrcona | Faux Paw???? |
| # | 14:23:47 | dbs | Dyrcona++ |
| # | 14:48:03 | akilsdonk has joined #evergreen |
| # | 14:52:45 | csharp | hmmm: 'psql:Evergreen/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql:6573: ERROR: could not create unique index "only_one_concurrent_checkout_per_copy"' |
| # | 14:53:02 | csharp | DETAIL: Key (target_copy)=(6201167) is duplicated. |
| # | 14:56:13 | tsbere | So you have a copy that is active on more than one circ? |
| # | 14:56:37 | tsbere isn't sure what csharp is looking for help with |
| # | 14:58:39 | csharp | well, I now have to figure out how many open circs have the same copy, then deal with them - basically I'm just chattering... |
| # | 14:59:38 | tsbere | select target_copy, count(id) from action.circulation where xact_finish is null group by target_copy? |
| # | 15:00:08 | tsbere | or does the index use checkin time? Check what the index uses. :P |
| # | 15:00:20 | tsbere | and "having count(id) > 1" might be a good addition <_< |
| # | 15:00:59 | mrpeters-isl | devs++ for making the choice to switch to git -- i love it more and more every day! |
| # | 15:02:05 | csharp | tsbere: thanks. My Evergreen SQL-fu is a bit rusty |
| # | 15:10:08 | _bott_ | hmm, staff reports that self-check/SIP allows first checkout: SUCCESS second, moments later, returns: PATRON_EXCEEDS_FINES SIP logs seem to confirm a couple cases of this. Any brilliant thoughts before I start digging? |
| # | 15:11:46 | tsbere | _bott_: I wonder, could https://bugs.launchpad.net/evergreen/+bug/835036 have anything to do with it? |
| # | 15:14:43 | _bott_ | tsbere: not sure. It's odd that it always seems to catch the second. |
| # | 15:15:05 | jeff | the bug description is "Specifically, ILSEvent codes."? |
| # | 15:15:22 | _bott_ | theoretically, both attempts should through the same |
| # | 15:18:10 | _bott_ | off to a meeting. will have to think more later |
| # | 15:18:25 | tsbere | jeff: There are two different ways, as far as I can tell, to determine "failure". One is "there is an event, in the list of events, which has a numeric code". The other is to just return a non-success text code. |
| # | 15:19:10 | tsbere | jeff: Those without ids return without an event code defined. Success is an event code of 0. Guess what happens if you "if (event code)" to determine failure... |
| # | 15:19:57 | jeff | tsbere: got it. |
| # | 15:49:57 | plux_ has quit IRC |
| # | 15:54:58 | jenny has left #evergreen |
| # | 16:02:20 | Callender has quit IRC |
| # | 16:05:54 | sfortin has quit IRC |
| # | 16:10:50 | edoceo has joined #evergreen |
| # | 16:13:25 | Callender has joined #evergreen |
| # | 16:23:45 | collum has quit IRC |
| # | 16:29:47 | tsbere | huh. Replied to berick and apparently I caused my signature to be eaten. |
| # | 16:30:00 | tsbere probably wiped it out on accident when cleaning up some of the quoted message stuff |
| # | 16:47:03 | dbs has quit IRC |
| # | 17:06:55 | matt_carlson has quit IRC |
| # | 17:07:37 | akilsdonk has quit IRC |
| # | 17:25:47 | fortin has joined #evergreen |
| # | 17:29:57 | Dyrcona has quit IRC |
| # | 17:34:07 | csharp | so is there a particular reason why in the 1.6.1-2.0 upgrade script the "--functions to create auditor objects" (beginning at line 7545 in rel_2_1_0) are straight "CREATE" commands rather than "CREATE OR REPLACE" or "DROP" THEN "CREATE"? I'm feeling some pain because these functions already exist |
| # | 17:35:14 | csharp | in a database our size it takes a good while to get to that point in the script, and because it's within a transaction, the whole thing fails |
| # | 17:47:20 | gmcharlt | which functions, specifically? |
| # | 17:48:45 | gmcharlt | you had also mentioned running the 2.1 auditor creation script at some point prior to starting with the upgrade scripts -- is it possible that you're running into functions that had been created from that action? |
| # | 17:50:32 | csharp | gmcharlt: very possible. to know for sure, I'm going to do a schema-only pg_dump of our database and throw it into a fresh vm, then run the script |
| # | 17:51:54 | csharp | auditor.create_auditor_seq, auditor.create_auditor_history - just those so far |
| # | 17:52:55 | csharp | I guess "not running the script as intended" is a good reason it's not working ;-) |
| # | 17:53:11 | _bott_ | back to my SIP/self-check issue. It looks like all fines were relatively old (v. 1.4 days), and the patrons hadn't been in since. New standing penalties were generated immediately with the initial checkout, which is why the next was blocked. I've identified 15000+ users with this situation, 3900+ unexpired. The latter could potentially check out one item. Other than manual inserts. Are there any good tricks to set these penalties? |
| # | 17:53:24 | csharp | I've just been doing this for days and I'm going a little bonkers :-D |
| # | 17:54:13 | csharp | _bott_: that makes sense. that almost certainly means that we'll be feeling that pain too |
| # | 17:54:20 | bshum | _bott_: If you learn of one, let me know. The only trick I know is some insert SQL we tried that was on the magic spells page |
| # | 17:54:48 | fortin has quit IRC |
| # | 17:55:14 | bshum | http://evergreen-ils.org/dokuwiki/doku.php?id=scratchpad:random_magic_spells, at the part "Using SQL to Generate SQL" |
| # | 17:55:38 | bshum | Contains an example where we were needing to recalculate penalties for a whole slew of patrons. |
| # | 17:55:51 | bshum | We adapted from that to redo penalties for patrons of a whole org unit |
| # | 17:55:54 | csharp wonders if he'd be happier just dropping the auditor schema and starting over |
| # | 17:56:01 | _bott_ | bshum: yep || is my close friend |
| # | 17:56:28 | bshum | _bott_: It's on my list of things to wonder about whether it's possible to put together a better function in the future. |
| # | 17:56:54 | bshum | Our libraries get fickle about raising fine group penalty thresholds. |
| # | 17:57:04 | bshum | And then complaining when the blocks don't automatically go away |
| # | 17:57:30 | _bott_ | well, it's a quick command to remove them all |
| # | 17:57:49 | bshum | Right |
| # | 17:58:01 | fortin has joined #evergreen |
| # | 17:58:05 | bshum | Well I'm outta here to get some dinner. Good luck _bott_ |
| # | 17:58:24 | tsbere | _bott_: May be a candidate for "have the checkout code re-calc penalties before checking" <_< Maybe with a "penalties last calculated" date somewhere so it can decide when to. |
| # | 17:59:31 | _bott_ | tsbere: does the staff client handle that differently? I hadn't considered what happened there |
| # | 18:01:47 | phasefx | staff client asks for penalty re-calc if you press the Refresh button, but that's the only spot where it explicitly does that |
| # | 18:02:33 | _bott_ | phasefx: it doesn't do so on initial patron retrieval? |
| # | 18:02:53 | phasefx | no, but I've mused having it do that recently |
| # | 18:04:19 | phasefx | I think it could be a useful catch-all, but could also obscure cases where penalties should be getting calculated but aren't |
| # | 18:05:31 | _bott_ | well, I'm happy to have put together the answer to my initial question. I'll worry about others tomorrow. |
| # | 18:50:15 | edoceo | is the stat cat the normal place to store user preferences? Like reciept - re-printing or email option? |
| # | 18:52:00 | fortin has quit IRC |
| # | 18:55:04 | matt_carlson has joined #evergreen |
| # | 18:58:42 | csharp | there's a problem with the 9.1 install deps script on fresh squeeze... it doesn't appear to be pulling in the contrib modules |
| # | 18:59:33 | tsbere | edoceo: Stat cat? No. |
| # | 18:59:56 | tsbere | edoceo: There is actually a user pref system in place. Don't ask me how to use it. <_< |
| # | 19:00:08 | tsbere | csharp: What are you using to install them? |
| # | 19:00:36 | csharp | the Makefile.install from master |
| # | 19:00:47 | tsbere | What command, then? ;) |
| # | 19:00:48 | csharp | it appears to install the package |
| # | 19:01:00 | tsbere | Oh, are you looking for the contrib sql files? |
| # | 19:01:16 | tsbere | They don't exist. 9.1 uses the new "extension" mode. See the create_database_9.1.sql file. |
| # | 19:01:30 | csharp | ah - that was my problem |
| # | 19:02:26 | csharp | I was using the create_database script, not the one for 9.1 |
| # | 19:02:30 | csharp | never mind! |
| # | 19:08:01 | mtcarlson has joined #evergreen |
| # | 19:08:15 | matt_carlson has quit IRC |
| # | 19:09:05 | tsbere thinks he has a decent way to get a list of "new" items for a given library |
| # | 19:38:05 | edoceo | tsbere: yep, I'll look into that |
| # | 20:42:23 | jeff | tsbere: visible copies at LIB sorted by creation date of oldest volume at LIB works well for me. |
| # | 20:42:55 | jeff | few false positives, mostly from instances where the volume was deleted and re-created for some odd reason. |
| # | 20:43:12 | jeff | and works well in multi-system consortia. |
| # | 20:44:06 | jeff | s/visible copies at/titles or records with visible copies at/ |
| # | 21:00:20 | eeevil | csharp: re auditor, I'd recommend dropping the auditor schema as you mention, as long as you don't have any open support requests that look like they might need the data ... or keep it around elsewhere for a while in a pre-upgrade db |
| # | 21:00:37 | mtcarlson has quit IRC |
| # | 21:20:22 | tsbere | jeff: Haven't decided how to do the "visible copies" part. Suppose I just join on the table. |
| # | 21:28:47 | tsbere | jeff: http://pastie.org/2732987 < What do you think? Using copies, not volumes, for information for a couple of reasons. |
| # | 22:12:12 | jeff | tsbere: first glance looks good. i'm going to compare with my version once i can find it. |
| # | 22:12:35 | jeff | too many things buried on test VMs from the past. i've been bringing them up, lifeboating things off, and destroying. |
| # | 22:14:14 | jeff | (in the process of making test vms be ephemeral, with test code pushed to them for testing. less testing in place, less risk of something getting lost on one) |
| # | 22:15:57 | jeff | (because "let me dig that out" sucks) |
| # | 22:41:59 | csharp | now I hit this: http://fpaste.org/fHOh/ |
| # | 22:42:13 | csharp wanders if he'll ever get through this script... |
| # | 22:42:23 | csharp | s/wanders/wonders/ |
| # | 22:42:34 | csharp stumbles off to bed |
April 10-13