14:10 |
* csharp |
raises hand |
14:10 |
eeevil |
csharp++ |
14:11 |
csharp |
yeah - I'll whip up a vm directly |
14:11 |
senator |
@action csharp to test 2.4.2 rc so we can officialize it |
14:11 |
* pinesol_green |
csharp to test 2.4.2 rc so we can officialize it |
14:11 |
senator |
csharp++ |
14:11 |
senator |
whoops |
14:11 |
senator |
#action csharp to test 2.4.2 rc so we can officialize it |
14:11 |
senator |
that's what i meant to type |
14:11 |
senator |
ok, |
14:11 |
Dyrcona |
heh. too many bots. ;) |
14:11 |
bshum |
Well, it's just one bot with many command actions |
14:12 |
csharp |
overloaded_bots-- |
14:23 |
senator |
having already talked about that? |
14:23 |
senator |
#info qa topics |
14:23 |
senator |
phasefx: do you want to pose your question? |
14:23 |
phasefx |
some of what I was thinking may be impacted by the next agenda item, but in general... |
14:23 |
phasefx |
I wanted to see if we want to start writing pgTAP tests whenever we write db upgrade scripts |
14:23 |
senator |
#topic qa topics |
14:24 |
phasefx |
there are some good examples committed to master |
14:24 |
senator |
(just a correction of my meetingbot stuff, don't mind me) |
14:24 |
phasefx |
could start easy, make it a recommendation instead of a requirement |
14:25 |
phasefx |
thoughts? need more to time to mull it over? |
14:25 |
eeevil |
phasefx: I'll commit (heh) to providing pgtap tests with my changes to the db |
14:25 |
phasefx |
eeevil++ |
14:25 |
bshum |
It's an interesting idea, I know I'd like some handholding to learn the ropes. |
14:26 |
* phasefx |
can hold hands |
14:26 |
jeff |
+1 to more tests |
14:26 |
jeff |
phasefx: do you have any useful pointers for starters, and what's your preference on people seeking hand-holding -- irc, mailing list? |
14:27 |
phasefx |
jeff: I think looking at the tests in http://git.evergreen-ils.org/?p=Evergreen.git;a=tree;f=Open-ILS/src/sql/Pg/t;hb=HEAD is a good start |
14:27 |
phasefx |
also the launchpad bug: https://bugs.launchpad.net/evergreen/+bug/1194246 |
14:27 |
pinesol_green |
Launchpad bug 1194246 in Evergreen "pgTAP examples" (affected: 1, heat: 6) [Wishlist,Fix committed] |
14:27 |
jeff |
phasefx: thanks! |
14:27 |
berick |
+1 to easing into it |
14:32 |
phasefx |
wish the deprecate/supersede stuff was working |
14:32 |
mrpeters |
yeah, i had to run the RC1 in order to get one of the indexes rebuilt properly |
14:32 |
csharp |
phasefx: 'twould be awesome |
14:32 |
bshum |
Well, in theory, you shouldn't need those test scripts to do the proper install. |
14:33 |
bshum |
Have you guys made a bug ticket about this missing index? :( |
14:33 |
mrpeters |
i havent had time |
14:33 |
mrpeters |
i just figured i should have known to use that RC1 script |
14:35 |
bshum |
Well, if you guys get around to it. I think we ought to properly note this missing index, fix it and then also kill off these old alpha/rc scripts |
14:46 |
* eeevil |
will re-raise the "baseline schema carved in stone between major releases" point tomorrow, he thinks |
14:47 |
eeevil |
that will make supersedes/deprecates and intelligent upgrades actually possible (given our community resources) IMNSHO |
14:48 |
csharp |
eeevil++ |
14:51 |
eeevil |
while my attention's over here for a minute ... please consider my plea for a test run-through of 2.4.2 ... email with locations of the files went out friday |
15:00 |
bshum |
eeevil++ |
15:07 |
csharp |
okay - I'm running authority_control_fields.pl on a 2.3.6 test server and it is not linking bibs and authority records as I was expecting it to. |
15:08 |
csharp |
when I did /openils/bin/authority_control_fields.pl --all, I got "Can't use an undefined value as an ARRAY reference at /openils/bin/authority_control_fields.pl line 76.", but I didn't see any other errors or log messages to explain why |
15:09 |
tsbere |
csharp: I would assume a timeout on cstore |
15:09 |
csharp |
ah - thanks |
15:11 |
csharp |
okay - so processing ids 1 through 10 worked |
15:11 |
csharp |
thanks |
15:11 |
dbs |
csharp: a test server with all PINES bibs? |
15:12 |
csharp |
dbs: yessir |
15:12 |
dbs |
csharp: ah, yeah, like tsbere said, the POD help also says of --all: "For large |
15:12 |
dbs |
databases, this may take an extraordinarily long amount of time" |
15:48 |
rfrasur |
(who knew you could buy oboe reeds on amazon?) |
15:55 |
bshum |
csharp: I know we took it away and restructured the default view primarily so that we could get some holdings to show by default, along with electronic links. |
15:55 |
bshum |
As far as slow, well.... hmm. |
15:56 |
* dbs |
would want to turn on the timing trace option to double-check his off-the-cuff comment |
16:00 |
* dbs |
does so; doesn't seem to make much difference in practice. 0.38 seconds per page of results once things are warmed up (paging through the results for a large search) |
16:01 |
dbs |
(that's on our test server with 2.1M bibs) |
16:01 |
|
smyers_ joined #evergreen |
16:02 |
rfrasur |
jboyer-isl: do you know of a lib in the consortium with the item barcode prefix 36810? |
16:12 |
|
mrpeters joined #evergreen |
11:43 |
rfrasur |
well, it wasn't an expert search although I do tend to try and game it a little at times. |
11:43 |
rfrasur |
it wasn't a well organized search, so I guess I'll have to plan better next time, so I can see what's falling down. |
11:43 |
* rfrasur |
pushed a lot of buttons |
11:44 |
bshum |
eeevil: For that bug you'd like extra eyes on |
11:44 |
bshum |
eeevil: I'm trying to figure out how to replicate the issue/resolve it with testing :) |
11:44 |
bshum |
eeevil: And as I'm reading the upgrade script, it replaces a reingest function |
11:44 |
bshum |
Does that mean we need to reingest some bibs to see a change? |
11:45 |
eeevil |
no |
11:45 |
eeevil |
so, say you have a browse normalizer to push everything to upper case |
11:45 |
eeevil |
it's doing that well |
13:51 |
|
kitteh joined #evergreen |
13:58 |
asimon |
bshum: The cstore settings in opensrf.xml in our new Evergreen system match the settings in our old Evergreen system. Are you saying that the max_children in the other services also relate to cstore? |
14:00 |
|
smyers__ joined #evergreen |
14:02 |
phasefx |
dbs: berick: re: live_t/ and Cronscript.pm, do we only want to move subs to Cronscript when they are actually re-used across tests, or simply if they might get re-used? I'm thinking about create_closed_date and delete_closed_date in 04-overdue_with_closed_dates.t |
14:03 |
berick |
phasefx: i think no on those 2 |
14:03 |
berick |
those 2 examples, i mean |
14:03 |
bshum |
asimon: Can you share a snippet of your logging that made you look for these settings? |
14:03 |
bshum |
Maybe it's a postgres config issue and not an Evergreen one. |
14:03 |
phasefx |
roger that. If someone does make another test, maybe those should go into a new library altogether |
14:06 |
|
fparks joined #evergreen |
14:10 |
dbs |
phasefx: agreed with you and berick on that. Cronscript is meant for stuff that would often be used in real scripts; if there are test-specific methods that won't be used in production but will be reusable in test scripts, then a TestUtils.pm or the likes would make sense as a home for those |
14:13 |
phasefx |
so far I have put register_workstation, do_checkin, and do_checkout into Cronscript |
14:13 |
phasefx |
those seem like they could stay there |
14:14 |
berick |
hmm, if a TestUtils.pm is made, that would be a better place for those, imo |
14:15 |
phasefx |
I'll go ahead and make a TestUtils.pm then; the idea is that it would be an installed perl module? not something that gets loaded out of the source tree? |
14:16 |
berick |
not sure what dbs had in mind, exactly, but I don't think it would hurt to install it. but it would be loaded from source (for make check), i assume |
14:18 |
phasefx |
these particular tests assume a running instance of EG as it is |
14:18 |
berick |
ah, right |
14:18 |
phasefx |
and don't get called during make check |
14:18 |
berick |
in which case, scratch my load-from-source comment |
15:18 |
bshum |
Cause this all just seems like something is not in sync, either the VMs or the database being reset. |
15:24 |
rangi |
dbs++ |
15:44 |
|
Joe_L joined #evergreen |
15:47 |
bshum |
But of course, the first sample bib I pick doesn't work correctly |
15:48 |
|
ericar joined #evergreen |
15:48 |
bshum |
dbs: So I installed the commits from bug 1214012 to test the schema.org stuff and then went to that google.com page to test site pages directly to see. |
15:48 |
pinesol_green |
Launchpad bug 1214012 in Evergreen "Schema.org enhancements: holdings and RDFa Lite" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1214012 |
15:49 |
bshum |
The first bib I tried, which was 27 in the concerto fed me a "Error: Incomplete rdfa with schema.org." at the end of the entries. |
15:49 |
bshum |
Though I'm still reading up to figure out what that means exactly. |
15:50 |
bshum |
Going to go do some more reading now. |
15:57 |
Joe_L |
Question: I'm working on configuring action-trigger events and responses, specifically sending an email when an item is one day overdue. The action_trigger.event database table shows events marked as 'complete', but no emails were sent. |
15:57 |
Joe_L |
Is there a log somewhere I can check? |
16:00 |
paxed |
perhaps /var/log/mail.err etc |
16:01 |
paxed |
also, test if you send mail manually from the server command line |
16:04 |
Joe_L |
That's where things get hairy. I'm using an SMTP server which, for IPs within the private LAN doesn't need authentication. So I'll enter, for example, mail.orgx.com as the SMTP server name in /openils/conf/opensrf.xml but there aren't any spaces for port or encryption. None is necessary for this test, but the config options are very spartan. |
16:06 |
jeff_ |
my suggestion at this point would be that if you need to authenticate to an SMTP server, you use a local SMTP server to perform that authentication -- have your local MTA listen on localhost only, accept everything, and relay it to a remote relay/smarthost using the credentials/etc required. |
16:08 |
Joe_L |
The oddity is that for servers on this particular LAN there isn't authentication or even encryption required. I suppose my question is whether there's a documented function-call-stack visible anywhere for what happens during the "sendEmail" reactor execution. |
16:09 |
Joe_L |
at least something I can trace along and see where the failure is appearing. |
16:57 |
jeff_ |
Joe_L++ |
16:57 |
jeff_ |
:-) |
17:03 |
|
mmorgan left #evergreen |
17:09 |
Joe_L |
bshum: I was doing some testing and managed to force every event in the series into an ' |
17:09 |
Joe_L |
'error' state, but the emails still sent. Where are errors logged? |
17:32 |
dbs |
bshum: how did you test with the rich snippets tool - copy and paste, or pointing at a bib via a URI? |
17:39 |
Joe_L |
I'll continue testing tomorrow and see what scenarios break this script. Thanks again for the debugging help and have a great night! |
17:41 |
dbs |
bshum: as far as I can tell, it's an undocumented expectation that the Offer type will always have a given property that I haven't given. quite possibly a bug in the rich snippets tool. |
17:42 |
dbs |
(not just saying that defensively; the RDFa folk have complained about the quality of the rich snippets tool parsing a number of times before) |
17:59 |
* dbs |
figures out what el Goog wants: it wants a "price" attribute, and "your soul" isn't good enough, it wants at least one integer; but "your s0ul" works just fine. but two integers separated by any non-integer other than a "." or "," is RIGHT OUT |
18:01 |
dbs |
since I can't just put in "$0.00", I guess sorting out asset.copy.deposit / asset.copy.deposit_amount comes into play |
18:03 |
hopkinsju |
Can anyone tell me where the default hold notification phone number is stored in the db? We have a library that's reporting the wrong number printing on pickup slips and I"m trying to track it down. |
18:03 |
hopkinsju |
I don't suppose anyone else has seen that problem? |
18:04 |
bshum |
dbs: I used the URL you provided and then submitted my test server URL and record page. |
18:04 |
bshum |
Err, test server's record page URL |
18:05 |
bshum |
dbs++ for showing us the way |
18:05 |
bshum |
hopkinsju: Hold notification phone number for the patron? |
18:06 |
hopkinsju |
bshum: yessir |
18:06 |
bshum |
hopkinsju: If so, that's a per hold deal |
18:06 |
hopkinsju |
But the default is stored in their preferences. |
11:28 |
kivilahtio |
ejabberd tutorial says I need to convert my database, but I can't even start my ejabberdctl to do it |
11:33 |
|
finnx joined #evergreen |
11:34 |
dbs |
berick: I hope to give "Modularize Makefile.install" a shot with Fedora today |
11:34 |
* csharp |
is setting up a test vm now to test 12.04 |
11:38 |
kivilahtio |
http://pastebin.com/D2m4yCbU |
11:38 |
kivilahtio |
Changing hosts directive broke my ejabberd |
11:39 |
kivilahtio |
quite frankly maybe I am doing something incredibly stupid |
12:38 |
mrpeters |
does anyone have documentation for the "Age Overdues to Lost" feature? I can't seem to find any... |
12:40 |
bshum |
mrpeters: I don't think there was ever any official documentation created for that. |
12:40 |
bshum |
It was back in those early 1.6 days. |
12:40 |
kmlussier |
I'm testing available copy hold ratios in circ policies today. Working much better now that bug 1103706 has been fixed, but I'm confused by the message I received when I try renewing an item in the public catalog. |
12:40 |
pinesol_green |
Launchpad bug 1103706 in Evergreen "Hold ratios in circ policies cause errors when trying to renew items" (affected: 2, heat: 16) [Medium,Fix committed] https://launchpad.net/bugs/1103706 |
12:41 |
kmlussier |
The message says failed to renew 1 item and shows "config.circ_matrix_test.available_copy_hold_ratio" below the title I tried to remove. |
12:41 |
kmlussier |
But we have http://pastebin.com/A4YdZkSs in hold_error_messages.tt2 |
12:59 |
pinesol_green |
paxed: The formatted number used for sound recordings, printed music, and videorecordings. Publisher's numbers that are given in an unformatted form are recorded in field 500 (General Note). A print constant identifying the kind of publisher number may be generated based on the value in the first indicator position. (Repeatable) [a,b,6,8] |
13:00 |
paxed |
missing 028q |
13:02 |
paxed |
kivilahtio: onkohan konversiossa virhe. 028d-kenttää ei ole formaatin mukaan olemassa, ja meillä on siellä dataa... en tiedä sit olisko pitäny mennä 028q:hun. |
13:04 |
* dbs |
testing user/dbs/modularize_makefile_fedora fixes |
13:24 |
berick |
dbs++ |
13:24 |
dbs |
hmm, "make check" fails with a fatal error of not being able to find openils/oils_utils.h |
13:26 |
dbs |
wonder if that's because it's expecting to find /openils/include because it would normally be tested on a machine on which Evergreen had already been installed before |
13:29 |
dbs |
Yep, soon as I install Evergreen, "make check" passes. Obviously a bug, -I needs to include a local path pointing to the source tree instead of relying on the installed headers |
13:31 |
dbs |
well actually... make check fails with 2 instances of "cannot open liboils_util.so.2", which suggests that it would rely on the installed libs + ldconfig for that, too |
13:32 |
dbs |
Yeah, once they're installed and "ldconfig" is run, it works. But that's not really how "make check" is supposed to work. |
13:34 |
jeff |
yeah. ideally it would not only not rely on them being installed, but also ignore them if they are installed. |
13:35 |
jeff |
not having written a make check target before, i don't know how that is typically accomplished, but i'd imagine there's some common practice there. |
13:36 |
jeff |
gnu make manual is incredibly helpful. ;-) 'you should write the self-tests so that they work when the program is built but not installed' |
13:38 |
|
dboyle_ joined #evergreen |
13:42 |
kmlussier |
Looking at my config.circ_matrix_test.available_copy_hold_ratio problem again, I see that most of my renewal failure messages come from ils_events.xml, but config.circ_matrix_test.available_copy_hold_ratio is not there. Is it something that could be easily added there? I'm not quite sure where the event codes come from in that file. |
13:42 |
kmlussier |
Or is there another place I should be looking to customize that message? |
13:50 |
gmcharlt |
jeff: does the manual also advise eating one's brocolli? ;) |
13:55 |
|
zerick joined #evergreen |
13:55 |
|
dboyle joined #evergreen |
13:59 |
csharp |
berick: tested the modular makefile on ubuntu 12.04 - completed with no errors |
14:02 |
berick |
csharp++ |
14:04 |
dbs |
berick: I managed to make it through with the additional commit from user/dbs/modularize_makefile_fedora in place |
14:05 |
dbs |
still some room to clean up the Fedora install docs (running postgresql initdb & enabling host connections, for example) but that additional commit would be good. I'll signoff and push your commit |
14:05 |
phasefx |
dbs: jeff: is bug 1210601 what you guys are talking about? |
14:05 |
pinesol_green |
Launchpad bug 1210601 in Evergreen "C unit tests need to include/link to files directly out of the source tree" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1210601 |
14:06 |
dbs |
csharp: you signing off somewhere? |
14:06 |
dbs |
phasefx: yes |
14:06 |
csharp |
dbs: berick may be including my initial signoff on the ubuntu pieces I started and he fixed |
08:46 |
senator |
kmlussier: ooh, i bet you're right |
08:46 |
graced |
kmlussier: smart thinking! |
08:47 |
kmlussier |
Well, we had a consortium that had both running at one point, so it was easy to make that connection. |
08:50 |
csharp |
Sara Paulk used to be in a PINES library (general interest observation) |
08:53 |
csharp |
more trivia... we also decided that we are probably related since there are many Paulks on my mom's south Georgia side from the same area as her family |
08:54 |
|
yboston joined #evergreen |
08:55 |
csharp |
okay - so our libraries have just discovered that dupe name/address checking is restricting its scope to the workstation OU (or its system) when it used to be doing a consortium-wide check (in the patron reg screen) |
08:56 |
csharp |
we don't use opt-in, so it's not that (set to "false" in opensrf.xml and no YAOUS settings in place) |
08:56 |
csharp |
I tested setting opt-in to true and setting the boundary and default to "0" (expecting that to be consortium) - no change |
08:57 |
kmlussier |
https://bugs.launchpad.net/evergreen/+bug/1185524 |
08:57 |
csharp |
the code in register.js appears to scope the search to "0" unless opt-in is in place, so I'm kind of at the end of knowing what to check next |
08:57 |
pinesol_green |
Launchpad bug 1185524 in Evergreen "duplicate patron checking in the user editor is limited to the workstation OU" (affected: 4, heat: 20) [Undecided,Incomplete] - Assigned to Kyle Tomita (tomitakyle) |
09:42 |
senator |
csharp: were you able to work something up on 1185524 yet? |
09:42 |
rfrasur |
Maybe I need to change my permission so that I acrue fines. |
09:42 |
csharp |
senator: I was just experimenting with hard-coding the search_ou, but not really |
09:43 |
senator |
i have a branch along the lines of eeevil's suggestions you could test |
09:43 |
csharp |
oh - excllent |
09:43 |
csharp |
excellent, that is |
09:43 |
csharp |
cool - hard-coding does work ;-) |
09:45 |
senator |
https://bugs.launchpad.net/evergreen/+bug/1185524/comments/6 |
09:45 |
pinesol_green |
Launchpad bug 1185524 in Evergreen "duplicate patron checking in the user editor is limited to the workstation OU" (affected: 4, heat: 22) [Undecided,Confirmed] - Assigned to Kyle Tomita (tomitakyle) |
09:45 |
csharp |
senator: awesome - I'll test |
09:47 |
|
moodaepo_nb joined #evergreen |
09:49 |
* rfrasur |
does the "we got a new board member and it's the one we requested" dance. |
09:52 |
senator |
kmlussier++ |
10:02 |
csharp |
s/interested/interesting/ |
10:04 |
csharp |
senator: works in 2.3.6 |
10:05 |
csharp |
senator++ |
10:08 |
senator |
thanks for brining it back up and testing! signoff appreciated |
10:08 |
kmlussier |
csharp: I wonder if they really want a separate search, though, or if they just miss some features and the fact that it was easier to get to some searches, like numeric and MARC expert, in jspac. Having heard the same complaints here. |
10:08 |
kmlussier |
I think tsbere's work that allows staff to set a default search tab in the staff client will help with some of that here. |
10:09 |
csharp |
kmlussier: I'm sure you're right |
23:27 |
mrpeters |
ill copy from example and start fresh |
23:27 |
mrpeters |
worth a shot |
23:27 |
dbs |
401 = HTTP 401 Unauthorized |
23:28 |
mrpeters |
apache not running a problem? |
23:28 |
mrpeters |
i didnt think it had to be for just doing the opensrf smoke test |
23:28 |
dbs |
no, just explaining where the "401" came from |
23:28 |
mrpeters |
right on, thanks. i didn't realize it was http related |
23:28 |
dbs |
it's not, really. just trying to use familiar error codes. |
13:03 |
rfrasur |
#info rfrasur is Ruth Frasur, Hagerstown Library/Evergreen Indiana |
13:03 |
kmlussier |
Ok, let's move on and people can keep introducing themselves as they arrive. |
13:04 |
afterl |
#info afterl is Amy Terlaga (guest) |
13:04 |
kmlussier |
#topic Action items from last meeting |
13:04 |
kmlussier |
#info action items were (a) moodaepo to e-mail link to test site to the list for feedback, (b) StephenGWills to work on member directory/map for web site. (c) hbrennan and kmlussier to work on layout/design issues for downloads page. (d) kmlussier will send out another Doodle to schedule a regular meeting time. |
13:05 |
kmlussier |
moodaepo: Your action item is up first. Anything to report? |
13:05 |
|
hbrennan joined #evergreen |
13:05 |
moodaepo |
kmlussier: bshum is the man with the test server plan. I haven't emailed it out yet but if he gives the go ahead I will do so today. |
13:05 |
kmlussier |
ok, bshum will be giving an update further down in the agenda. |
13:05 |
bshum |
kmlussier: It's an old agenda item, we're probably past test server at this point. |
13:06 |
moodaepo |
bshum++ |
13:06 |
kmlussier |
StephenGWills isn't here, so let's table his action item until we see him again. |
13:07 |
kmlussier |
For my action items, I made contact with hbrennan on downloads page, but my vacation got in the way. We'll touch base and report back to the web team list. |
13:22 |
bshum |
Though with Firefox 23 removing the option for no-JS and setting everybody back to using it, I have wondered about that limitation long-term. |
13:23 |
RoganH |
I personally don't see many users living without JS. |
13:23 |
RoganH |
Very, very few. |
13:23 |
bshum |
Maybe given the new timeline, if moodaepo gets around to sending out the link to the test site, we can solicit ideas for improving the existing theme or picking some new ones. |
13:23 |
bshum |
#link Link to current test site for notes: http://wp.evergreen-ils.org |
13:23 |
gmcharlt |
I was one of the ones who had a expressed a non-JS concern -- but the main issue was that (IIRC) one of the initial themes that was tested *completely* failed to work without JS |
13:24 |
moodaepo |
bshum: I can send out the link and maybe the couple of themes we've looked at also but require javascript for full functionality |
13:24 |
gmcharlt |
as no, no content was rendered |
13:24 |
bshum |
gmcharlt: Right, that was an unfortunate bad theme. |
09:27 |
|
mrpeters joined #evergreen |
09:28 |
csharp |
jcamins: not that I've seen - I'd be interested if so |
09:30 |
jcamins |
csharp: yeah, I was just noticing that 2s seems to be fairly normal for OPACs, which seems to me to be somewhat beyond the realm of "acceptable" in a website. |
09:31 |
csharp |
quick tests of PINES' opac on a good network connection using FF23's Tools -> Web Developer -> Network feature shows 2s on the low end and 7s on the high end of keyword searches |
09:31 |
csharp |
jcamins: agreed |
09:32 |
|
moodaepo_nb joined #evergreen |
09:44 |
|
mllewellyn joined #evergreen |
10:09 |
|
krvmga joined #evergreen |
11:20 |
jcamins |
rfrasur: that does say something about our culture, doesn't it? |
11:22 |
jboyer-isl |
Has anyone run into issues where the report interface will say it's using an inner join, but the generated sql uses left outer? |
11:22 |
rfrasur |
jcamins: To answer briefly something that is a HUGE discussion - Yes. Apparently, my three sons aren't welcome there. That is all. I shall take a walk and let it go. |
11:23 |
pinesol_green |
[evergreen|Dan Wells] Add new get_combined_holdings() method to MFHD.pm - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=83f8420> |
11:23 |
pinesol_green |
[evergreen|Dan Wells] Tie in new MFHD method to serials module/MFHD tests for compressing, combining - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=fbe9e5a> |
11:23 |
pinesol_green |
[evergreen|Dan Wells] Fix logic in get_compressed_holdings() - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=07b28a0> |
11:23 |
pinesol_green |
[evergreen|Dan Wells] Solidify caption/holding relationship, improve MFHD::Holding comparisons - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=a6f3e3b> |
11:24 |
csharp |
jboyer-isl: using nullability selection? |
11:24 |
eeevil |
jboyer-isl: are you sure it /says/ it's using an inner join, and not a "default" join? some default joins are, indeed, left joins |
11:26 |
jboyer-isl |
You bet. I'm working with stat cats, so I wanted to limit it to patrons who have a specific SC set, and to a specific value. There's an "(inner)" in the source specifier box in the lower right. I also noticed that it's including an IS NULL OR ... for those, and an actual inner join on our_unit id. |
09:51 |
pastebot |
"paxed" at 204.193.129.146 pasted "opensrf compile error" (10 lines) at http://paste.evergreen-ils.org/13 |
09:52 |
|
rfrasur joined #evergreen |
09:53 |
eby |
thanks Dyrcona , tsbere , collum |
09:53 |
paxed |
(this is on debian testing) |
09:57 |
paxed |
oh. sprintf without format string. |
09:57 |
* paxed |
goes to report a bug and fix it |
10:20 |
|
artunit joined #evergreen |
10:31 |
|
jdouma joined #evergreen |
10:33 |
paxed |
would it make sense reporting a bug because apache2ctl configtest complains ... but i'm running debian testing? |
10:55 |
tsbere |
paxed: complains about what? |
10:55 |
tsbere |
If it appears to be a valid problem (or potential problem later) a bug report isn't a bad thing |
10:55 |
paxed |
AH00671: The Alias directive in /etc/apache2/sites-enabled/eg.conf at line 56 will probably never match because it overlaps an earlier ScriptAlias. |
12:38 |
Dyrcona |
heh. It kinda helps to execute your queries after binding the parameters, huh? ;) |
12:43 |
paxed |
dbs: using the 2.4 configs doesn't help, i still get the same warnings from apache2ctl |
12:43 |
paxed |
i'll file a bug |
12:45 |
pinesol_green |
[evergreen|Pasi Kallinen] Prevent paste from empty clipboard throwing an error - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=f25cc39> |
12:49 |
pinesol_green |
[evergreen|Jason Etheridge] Fix org unit setting names for this example test - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=de357ea> |
12:49 |
rjackson-isl |
any administrators have advice on cleaning up the action_trigger (event and event_output) tables? Do you have a standing policy such as deleting any that are complete and over a year old? |
12:50 |
rjackson-isl |
Evergreen Indiana currently has space issues and 26+ million action_trigger.event rows |
12:50 |
rfrasur |
(holy heckama) |
13:07 |
Dyrcona |
As in "This parrot is no more!" |
13:08 |
rfrasur |
in that case, I'd say delete those A/T, rjackson-isl |
13:08 |
Dyrcona |
trouble is, the at runner might say, hey! i have to run these. |
13:08 |
mmorgan |
did a lot of testing on notice triggers lately, and had great success getting triggers to run again once the rows for the event_def were deleted from action_trigger.event |
13:09 |
mmorgan |
good for testing, but as bshum points out, if they are valid, they'll run again |
13:10 |
rjackson-isl |
is ther any easy way to determine which ones you can delete without making a mess with the notices then? |
13:11 |
Dyrcona |
rjackson-isl: I'd suggest you look at auditor tables if you're looking for some low hanging fruit to reduce database size. |
13:12 |
rjackson-isl |
Dyrcona we are purging off of the auditors already |
14:05 |
|
dMiller joined #evergreen |
14:07 |
|
acoomes joined #evergreen |
14:07 |
|
acoomes joined #evergreen |
14:07 |
Dyrcona |
And, for my final feat, I shall mess up my training database with a test load of 12,000 patrons! |
14:07 |
rfrasur |
I have some patrons that could REALLY mess it up. |
14:07 |
* rfrasur |
will donate. |
14:08 |
Dyrcona |
It is always fun when you're loading patrons, and they are already in the database. :) |
14:10 |
rfrasur |
hah, reminds of a new book about the 2012 election |
14:11 |
Dyrcona |
And, only 1 patron falls on the floor because of a duplicate usrname key. That is exactly what I expected! |
14:11 |
Dyrcona |
The test is successful! |
14:11 |
Dyrcona |
Now, back to your regularly-scheduled programming. |
14:14 |
|
jihpringle joined #evergreen |
14:18 |
pinesol_green |
[opensrf|Bill Erickson] LP#1188195: Default per-process client locale (Perl) - <http://git.evergreen-ils.org/?p=OpenSRF.git;a=commit;h=8524849> |
14:18 |
pinesol_green |
[opensrf|Galen Charlton] LP#1188195: add tests for setting default client locale - <http://git.evergreen-ils.org/?p=OpenSRF.git;a=commit;h=8a4ee2d> |
14:19 |
gmcharlt |
general heads up that I've created the LP milestone for OpenSRF 2.2.1 |
14:20 |
gmcharlt |
if there are any current pullrequests that you want targeted for consideration for a release next week, please target them now |
14:41 |
gsams |
Does anyone have an example library that uses syndetics with Evergreen? I'm looking to see how it integrates with the catalog so that I can show a prospective library that uses it currently |
09:16 |
Dyrcona |
Bingo! |
09:16 |
kmlussier |
Dyrcona++ |
09:16 |
rfrasur |
Dyrcona++ |
09:17 |
Dyrcona |
kmlussier++ #For testing billing development without realizing it. :) |
09:17 |
* Dyrcona |
makes a note to do something more permanent when he gets home this evening. |
09:17 |
rfrasur |
kmlussier++ #for good discussion/points on bug squashing |
09:17 |
kmlussier |
Dyrcona: Never hurts to get an early start on testing! ;) |
09:18 |
Dyrcona |
I'm going to check our training server just to be sure. |
09:19 |
Dyrcona |
It might be something that went in recently, but I doubt it is a problem without my void payment code also being in place. |
09:20 |
Dyrcona |
tsbere: I think I just realized why you still use 2.3.0 as the production version. :) |
09:38 |
Dyrcona |
Though I use Ubuntu, I'm really starting to dislike it in a serious way. |
09:38 |
asimon |
bshum: Yes, OpenSRF 2.2.0 supports Wheezy. |
09:38 |
csharp |
Dyrcona: what issues are you seeing? |
09:38 |
bshum |
csharp: That and testing for some of us :( |
09:38 |
|
krvmga joined #evergreen |
09:39 |
Dyrcona |
csharp: Frequently busted packages that stay busted, among other things. |
09:39 |
csharp |
hmm |
09:42 |
krvmga |
which tt2 file is displaying this data? |
09:43 |
bshum |
dbs: Oh in that case, it's the old dupe bug 1014724 |
09:43 |
pinesol_green |
Launchpad bug 1190279 in Evergreen "duplicate for #1014724 Modularize Makefile.install" (affected: 3, heat: 16) [Wishlist,In progress] https://launchpad.net/bugs/1190279 |
09:43 |
bshum |
Which blah |
09:43 |
bshum |
Points the wrong way |
09:43 |
bshum |
I tested berick's code for supporting wheezy now, but it used more CPAN than packages so I wanted to poke it further. |
09:43 |
* dbs |
kind of hates when new bugs live on, and the old bugs get closed as a duplicate. a bit. |
09:43 |
asimon |
Dyrcona: Yes, "libpq-dev is already the newest version." |
09:44 |
dbs |
kind of gives a false view of history. |
09:51 |
asimon |
csharp: Installing Evergreen before PostgreSQL 9.2 would solve this problem, no? |
09:51 |
* berick |
wonders where csharp got w/ his ubuntu experiment for bug #1190279 |
09:51 |
pinesol_green |
Launchpad bug 1190279 in Evergreen "Modularize Makefile.install" (affected: 3, heat: 16) [Wishlist,In progress] https://launchpad.net/bugs/1190279 |
09:51 |
csharp |
asimon: I think this is an APT level problem and that shouldn't matter (theoretically) |
09:52 |
|
yboston joined #evergreen |
09:53 |
csharp |
berick: my branch is here: http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/csharp/ubuntu-per-distro-makefile - I got stalled out when CPAN was breaking on the 12.04 install |
09:53 |
csharp |
berick: I've been assuming the error is mine and when I spent a couple of hours trying to find it, I lost steam :-/ |
09:54 |
csharp |
10.04 installed okay in my test |
09:54 |
csharp |
my test only extended to seeing if the Makefile.install script finished without errors |
09:55 |
csharp |
asimon: interesting, I don't see a 9.2 branch here: http://apt.postgresql.org/pub/repos/apt/pool/ |
09:56 |
berick |
csharp: gotcha, thanks for the recap. i'll try to carve out a chunk of time soon to eyeball your branch |
09:56 |
berick |
would be nice to get these in |
09:56 |
csharp |
berick: thanks - I'll look again too |
10:00 |
dbs |
asimon: quite possibly. IIRC, there had been some question about PostgreSQL 9.2 support leading up to the 2.4 release, but AFAIK there's nothing preventing 9.2 from actually working |
10:00 |
Dyrcona |
dbs asimon: 9.2 works we've used it in our training and development servers. |
10:01 |
asimon |
dbs: Equinox Support has blessed PostgreSQL 9.2. |
10:01 |
* dbs |
seems to recall suggesting at some point that we make very clear statements about what distros / major dependencies are officially supported for particular releases as a standard process thing |
10:02 |
dbs |
Dyrcona: yeah, I've been using 9.2 on Fedora for a few months now too. but I don't hit all the pieces of Evergreen in my day-to-day testing |
10:06 |
csharp |
asimon: ah - I didn't look in /main |
10:07 |
asimon |
csharp: Note that Dyrcona has provided a different repo. |
10:08 |
csharp |
Dyrcona: asimon: thanks - getting my head turned around |
11:16 |
|
dboyle joined #evergreen |
11:19 |
mcooper |
berick++ too -- that looks great |
11:20 |
krvmga |
this is just a report back. in misc_util.tt2 adding the code -- or @code="h" -- to line 37 did not break anything and got me the GMD display in the title that i was looking for. |
11:21 |
pinesol_green |
[evergreen|Jason Etheridge] Eliminate a warning in Z3950.pm - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=e455913> |
11:21 |
pinesol_green |
[evergreen|Jason Etheridge] Test for an MFHD warning in 14-OpenILS-Utils.t - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=11f04ea> |
11:21 |
krvmga |
just for sanity, in my misc_util.tt2, i also changed line 36 'abmp' to 'abhmp' |
11:22 |
berick |
nc_cardinal++ # bug 1207396 |
11:22 |
pinesol_green |
Launchpad bug 1207396 in Evergreen "Patron self-registration form" (affected: 1, heat: 6) [Wishlist,In progress] https://launchpad.net/bugs/1207396 - Assigned to Bill Erickson (erickson-esilibrary) |
11:24 |
jeff_ |
uses the pending / staging user tables. |
11:24 |
rfrasur |
yes...and they hooked up a way to capture patron signatures (though I can't remember why right now...even though it was important) |
11:24 |
|
acoomes joined #evergreen |
11:25 |
pinesol_green |
[evergreen|Jason Etheridge] The check library for Debian and Fedora - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=ace3d99> |
11:25 |
pinesol_green |
[evergreen|Jason Etheridge] C unit test examples for Evergreen - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=33b6b48> |
11:25 |
egbuilder |
build #268 of evergreen-master-ubuntu-12.04-x86 is complete: Failure [failed test] Build details are at http://testing.evergreen-ils.org/buildbot/builders/evergreen-master-ubuntu-12.04-x86/builds/268 blamelist: Jason Etheridge <jasonesilibrary.com> |
11:25 |
egbuilder |
build #234 of evergreen-master-fedora-18 is complete: Failure [failed test] Build details are at http://testing.evergreen-ils.org/buildbot/builders/evergreen-master-fedora-18/builds/234 blamelist: Jason Etheridge <jasonesilibrary.com> |
11:26 |
egbuilder |
build #292 of evergreen-master-debian-6.00-x86_64 is complete: Failure [failed test] Build details are at http://testing.evergreen-ils.org/buildbot/builders/evergreen-master-debian-6.00-x86_64/builds/292 blamelist: Jason Etheridge <jasonesilibrary.com> |
11:26 |
phasefx |
ruh roh |
11:26 |
rfrasur |
jeff_: Do your libraries require picture ID? |
11:26 |
graced |
jeff_: neat! Where's the commit for that patron self-reg? |
11:27 |
rfrasur |
right...I was thinking that was bott |
11:27 |
* paxed |
is leery of leaving any kind of form that adds data to the database open without any kind of captcha. |
11:28 |
rfrasur |
paxed: it's not difficult to add that though, right? |
11:28 |
eeevil |
phasefx: no worries. buildslaves just need Test::Warn installed, it looks like |
11:28 |
csharp |
ubuntu and fedora slaves look ok |
11:29 |
bshum |
buildbot++ |
11:29 |
paxed |
rfrasur: nah. i've even rolled my own captchas for some small sites. |
11:34 |
bshum |
Dyrcona: It's a sign! |
11:35 |
Dyrcona |
Time to take up potato farming! |
11:35 |
|
jdouma joined #evergreen |
11:35 |
egbuilder |
build #293 of evergreen-master-debian-6.00-x86_64 is complete: Success [build successful] Build details are at http://testing.evergreen-ils.org/buildbot/builders/evergreen-master-debian-6.00-x86_64/builds/293 |
11:36 |
berick |
jeff_: if you have the time and feel like eyeballing my design doc for self-reg, i'd appreciate any input/suggestions you might have. real_world_experience++ |
11:37 |
pinesol_green |
[evergreen|Jason Etheridge] pgTAP examples - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=c36c86e> |
11:37 |
pinesol_green |
[evergreen|Galen Charlton] start adding pgTAP test cases - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=bb98f3f> |
11:37 |
pinesol_green |
[evergreen|Galen Charlton] use .pg extension for pgTAP test cases - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=97983b6> |
11:37 |
pinesol_green |
[evergreen|Galen Charlton] add regression test for LP#1155329 - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=bd4d765> |
11:37 |
pinesol_green |
[evergreen|Jason Etheridge] Use the .pg extension - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=7e8eec6> |
11:37 |
egbuilder |
build #270 of evergreen-master-ubuntu-12.04-x86 is complete: Success [build successful] Build details are at http://testing.evergreen-ils.org/buildbot/builders/evergreen-master-ubuntu-12.04-x86/builds/270 |
11:38 |
dbs |
phasefx et al: the test failures for buildbot are a good note to project-self that new prereqs should be called out in a specific section in release notes |
11:38 |
|
Rish joined #evergreen |
11:38 |
eeevil |
dbs: agreed |
11:38 |
phasefx |
dbs: sounds good |
11:40 |
Dyrcona |
OK. Works for me with either name. |
11:41 |
eeevil |
well, I should clarify that. I was thinking what I said /after/ Dyrcona mentioned a separate section... |
11:41 |
dbs |
"Upgrade notes" -> "New prerequisites" subsection, perhaps. |
11:41 |
csharp |
okay - I installed Test::Warn from respective distro repos and did general updates/reboots on fedora and ubuntu buildslaves |
11:42 |
dbs |
csharp: cool, resubmitted build |
11:43 |
egbuilder |
build #237 of evergreen-master-fedora-18 is complete: Success [build successful] Build details are at http://testing.evergreen-ils.org/buildbot/builders/evergreen-master-fedora-18/builds/237 |
11:43 |
dbs |
csharp++ |
11:44 |
csharp |
dbs: let me know if you'd like to either upgrade this one to F19 or build a separate F19 server |
11:45 |
pinesol_green |
[evergreen|Jason Etheridge] make-pgtap-tests.pl - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=d6ec452> |
11:45 |
dbs |
csharp: IMO, whenever you want to upgrade to F19. no rush :) |
11:45 |
csharp |
ok - understood |
11:46 |
bshum |
Dyrcona: tsbere: If either of you have time to poke again at bug 1204273, please do. Hoping to unbreak master in those areas. |
11:46 |
pinesol_green |
Launchpad bug 1204273 in Evergreen "bugs introduced with making state not required" (affected: 1, heat: 6) [High,Confirmed] https://launchpad.net/bugs/1204273 |
11:46 |
gmcharlt |
eeevil: you do realize that I now need to add a test case to catch instances of the misspelling "Moar"? ;) |
11:47 |
* csharp |
installs Test::Moar on the buildslaves too |
11:47 |
gmcharlt |
csharp++ |
11:47 |
csharp |
I CAN HAZ UNIT TESTZ? |
11:48 |
rfrasur |
csharp++ |
08:25 |
csharp |
heh |
08:25 |
bshum |
That's what led me to poke at it. |
08:26 |
bshum |
If I have a moment later this morning, I'll dust off my branch. |
08:27 |
csharp |
I believe 'LEFT JOIN actor.card circ_card ON circ_u.card = circ_card.id' will accomplish what I'm trying to fix |
08:27 |
csharp |
since users can have multiple active cards now too |
08:27 |
* csharp |
is testing the view query now |
08:28 |
csharp |
oh, and for the logs, we're discussing bug 1072892 |
08:28 |
pinesol_green |
Launchpad bug 1072892 in Evergreen "reporter.classic_item_list view creates repeated rows" (affected: 1, heat: 6) [Undecided,Incomplete] https://launchpad.net/bugs/1072892 |
08:28 |
bshum |
csharp++ |
08:29 |
|
kbeswick joined #evergreen |
10:11 |
csharp |
eeevil: thanks - I'll look into window functions |
10:12 |
|
CarrieC joined #evergreen |
10:17 |
pastebot |
"eeevil" at 204.193.129.146 pasted "possible replacement for csharp" (9 lines) at http://paste.evergreen-ils.org/14 |
10:17 |
csharp |
eeevil++ |
10:18 |
csharp |
I'll test it |
10:18 |
eeevil |
csharp: there are many more than that one to convert, of course. and I'm testing on an empty db, so the syntax works but we may need to add window range conditions |
10:18 |
csharp |
good to know |
10:25 |
|
mcooper joined #evergreen |
10:26 |
csharp |
eeevil: that returns a list of rows rather than a single row (though the last one has the correct total owed) |
13:15 |
|
kmlussier joined #evergreen |
13:19 |
csharp |
eeevil: I've been working on the other money views. The only ones I'm unsure how to approach conversion with are money.billable_xact_summary_new and money.billable_xact_with_void_summary since they are pretty complicated with subqueries |
13:20 |
|
dboyle joined #evergreen |
13:24 |
eeevil |
csharp: I don't have time to look currently, but I would say toss the ones you have up as a branch for testing and signoff and we can address the remainders later |
13:24 |
eeevil |
csharp++ |
13:25 |
csharp |
will do - thanks for your help! |
13:26 |
|
Dyrcona joined #evergreen |
13:35 |
|
timf joined #evergreen |
09:01 |
|
ericar joined #evergreen |
09:08 |
|
sborger joined #evergreen |
09:19 |
|
kmlussier1 joined #evergreen |
09:21 |
mmorgan |
jboyer-isl: your suggestion to delete rows from the action_trigger.event table worked, I was able to rerun my test trigger. Thanks! |
09:22 |
jboyer-isl |
Good to hear. maybe now I can clean up some of the failed events that are sitting around in ours. :D |
09:29 |
|
mcooper joined #evergreen |
09:33 |
bshum |
So I'm getting some javascript errors on large pull lists when using the "Clear Hold Shelf" option directly off the Circulation menu actions. |
14:13 |
dbwells |
jeff_: Let me know whenever you are done with your latest NCIP commits, and I will pull those into the jonscott repo right away. |
14:13 |
jeff_ |
dbwells: thanks! |
14:14 |
jeff_ |
dbwells: are you guys using the duplicate message detection? i've removed it in https://github.com/tadl/iNCIPit/commit/537b6a763ae6ec1a48d1bd9439daa177436f3bf1 |
14:15 |
dbwells |
jeff_: If your testing shows it should be removed, I have no issue with removing it. |
14:21 |
|
sseng joined #evergreen |
14:22 |
Dyrcona |
FWIW, I thought it should be removed the first time that I tried testing iNCIPit. |
14:24 |
jeff_ |
In testing, we rarely received duplicate messages (other than those that were legit retries after a failure to respond properly). The duplicate message detection was apparently due to an old issue that is no longer an issue, and it can cause problems such as failure to auth the same patron twice in a row. |
14:24 |
jeff_ |
Also, it would require shared storage or a modification to use memcache to work in multi-server environments, so I was pleased when told by MeLCat staff that it should no longer be needed. :-) |
14:26 |
|
bshum joined #evergreen |
14:28 |
|
rfrasur joined #evergreen |
14:29 |
bshum |
Am I back? Maybe... |
15:45 |
jventuro |
I was wondering the same thing about email requests. Should I have requesters respond to the list, or directly to me. |
15:45 |
|
AaronZ-PLS joined #evergreen |
15:46 |
jventuro |
I have no problem with doing that, chtrotter. I am the list admin :) |
15:46 |
AaronZ-PLS |
Looking for an action trigger hook to send a test email every day, is there one that would work? |
15:47 |
jventuro |
Hi AaronZ-PLS. We're having a meeting at the moment. Would you mind tabling your question for 15 minutes or so? |
15:48 |
AaronZ-PLS |
Willdo. |
15:49 |
jventuro |
Thanks! |
16:16 |
pinesol_green |
Minutes: http://evergreen-ils.org/meetings/evergreen/2013/evergreen.2013-07-30-15.00.html |
16:16 |
pinesol_green |
Minutes (text): http://evergreen-ils.org/meetings/evergreen/2013/evergreen.2013-07-30-15.00.txt |
16:16 |
pinesol_green |
Log: http://evergreen-ils.org/meetings/evergreen/2013/evergreen.2013-07-30-15.00.log.html |
16:17 |
AaronZ-PLS |
Looking for an action trigger hook to send a test email every day, is there one that would work? |
16:21 |
paxed |
AaronZ-PLS: if you just want to send a test email, you could just invoke mail directly from crontab ...? |
16:21 |
AaronZ-PLS |
paxed: Could do that, but looking to make action triggers arent hanging as well as making sure email is happy from end to end |
16:36 |
gsams |
AaronZ-PLS: I know it wouldn't be quite as informative, but the mail log should be a pretty good indication of whether action triggers are working or not. I can't say that I've tried looking into it in any other way myself. |
17:11 |
|
smyers_ joined #evergreen |
14:00 |
jeff |
email and IM are poor methods of revision control. |
14:01 |
Dyrcona |
Yes, they are. |
14:01 |
Dyrcona |
I use git as a sort of distribution mechanism, too. |
14:02 |
Dyrcona |
I edit the code on the laptop and then push to the server to test it. |
14:02 |
* jeff |
nods |
14:07 |
jeff |
fieldmapper alias typos are one of those "probably really difficult to fix" things. |
14:09 |
Dyrcona |
Could be.... |
14:56 |
yboston |
Dyrcona: Thanks. I guess setting active=false could be helpful if I change my mind so it is easy to reinstate? any other reasons off the top of your head? |
14:56 |
Dyrcona |
yboston: It's just what I typically do rather than delete. |
14:57 |
yboston |
Dyrcona: thanks for the info and sharing your preferred workflow |
14:57 |
kmlussier |
Dyrcona++ |
14:57 |
kmlussier |
I forgot include you in all the thanks I sent yesterday when signing off on the bib browse code, so I'm sending along karma now instead. |
14:58 |
kmlussier |
Dyrcona can not get enough good karma for all the assistance he gives me when I'm testing code. :) |
15:18 |
csharp |
@karma Dyrcona |
15:18 |
pinesol_green |
csharp: Karma for "Dyrcona" has been increased 382 times and decreased 3 times for a total karma of 379. |
15:31 |
|
mrpeters left #evergreen |
15:41 |
|
zerick joined #evergreen |
15:52 |
mmorgan |
I'm trying to test an action trigger. Is there a recommended way to remove rows from the database so I can tweak and retest? |
16:06 |
jboyer-isl |
mmorgan: A guess I'm thinking of testing soon: delete from action_trigger.event where event_def=(The event id you're testing). You could add additional clauses for add_time, state, etc. if needed. |
16:07 |
|
smyers_ joined #evergreen |
16:08 |
jboyer-isl |
but note that I've not tried it yet. |
16:10 |
mmorgan |
Thanks, anything I try will be on a test server :). Will deleting the row from action_trigger.event also remove rows from action_trigger.event_output? |
16:10 |
mmorgan |
or can those just stay there and not bother anybody? |
16:10 |
jboyer-isl |
Ah, I doubt it. |
16:10 |
|
rfrasur joined #evergreen |
16:10 |
jboyer-isl |
Cleaning them up might make testing easier, if that's where you're looking for success/failure. |
16:14 |
mmorgan |
Good point. I will give this a try on a test server, but maybe not til Monday. Thanks! |
16:16 |
bshum |
In the old days, we used to just put complete times on unfinished A/T events |
16:16 |
bshum |
And change the status |
16:17 |
bshum |
But deleting is also simple too. |
16:20 |
mmorgan |
I'm fine with updating rather than deleting. I'm testing notices and want to be able to run the same trigger again for the same user. |
16:23 |
mmorgan |
events for the event_def I'm working with have status complete but complete_ time of null. Can I update these fields to get it to run again after I make changes to the template? |
16:25 |
|
jdouma joined #evergreen |
16:25 |
|
kbeswick joined #evergreen |
16:30 |
|
jdouma joined #evergreen |
16:31 |
|
mcooper joined #evergreen |
16:36 |
|
smyers_ joined #evergreen |
16:46 |
|
shadowspar joined #evergreen |
16:49 |
bshum |
mmorgan: Hmm, I'd say, probably |
16:50 |
bshum |
I think we used to do that when we were testing acq EDI |
16:50 |
bshum |
And it would error out |
16:50 |
bshum |
So we'd tweak things, then null out the output and complete stuff and try again |
16:54 |
mmorgan |
Thanks! I'll look at that on Monday, too. Don't want to try anything new on a database on a Friday afternoon. |
16:55 |
kmlussier |
mmorgan: Go home and enjoy the beautiful weather! ;) |
16:55 |
mmorgan |
What beautiful weather?? Where?? It's quite gray out my window! |