| Time |
Nick |
Message |
| 02:30 |
|
remingtron_ joined #evergreen |
| 02:30 |
|
dbwells_ joined #evergreen |
| 03:23 |
|
serflog joined #evergreen |
| 03:23 |
|
Topic for #evergreen is now Welcome to the #evergreen library system channel! | We are publicly logged. | Large pastes at http://paste.evergreen-ils.org |
| 06:01 |
|
dbwells joined #evergreen |
| 06:44 |
|
jboyer-isl joined #evergreen |
| 07:11 |
|
timlaptop joined #evergreen |
| 07:12 |
|
tfaile joined #evergreen |
| 08:00 |
|
rjackson-isl joined #evergreen |
| 08:09 |
|
akilsdonk joined #evergreen |
| 08:29 |
|
ericar joined #evergreen |
| 08:35 |
|
mrpeters joined #evergreen |
| 08:36 |
|
Dyrcona joined #evergreen |
| 08:38 |
|
Shae joined #evergreen |
| 08:54 |
|
kbeswick joined #evergreen |
| 09:07 |
|
mmorgan joined #evergreen |
| 09:10 |
|
collum joined #evergreen |
| 09:26 |
|
dluch joined #evergreen |
| 09:34 |
csharp |
since we moved to 2.5, we're seeing our report outputs being sorted alphabetically rather than by run time descending as before (and as described in bug 1050432) - any ideas about how to troubleshoot that? |
| 09:34 |
pinesol_green |
Launchpad bug 1050432 in Evergreen "Wish List: Alphabetization of report templates" (affected: 3, heat: 18) [Wishlist,Fix released] https://launchpad.net/bugs/1050432 |
| 09:37 |
|
timf joined #evergreen |
| 09:38 |
Dyrcona |
Oof... Time to leave G+....It's starting to smell like Facebook, i.e. smell like stupid. |
| 09:41 |
dbs |
The stupids, they find you wherever you go |
| 09:41 |
Dyrcona |
csharp: It's not a trouble since it was requested in that bug. I'd say revert the commits introduced in that branch and you'll probably be all set. |
| 09:41 |
Dyrcona |
dbs++ |
| 09:42 |
Dyrcona |
In this particular case, it is someone freaking out about bubonic plague. |
| 09:43 |
* Dyrcona |
wonders if Bmagic and hopkinsju got their holds sorted out last night? |
| 09:43 |
jeff |
csharp: yeah, what Dyrcona said -- the alpha-sort is new wanted (by some) behavior. I might have voiced objection if we still used reports. |
| 09:43 |
dbs |
Uncircle! |
| 09:44 |
jeff |
(which i suppose is a bad attitude for me to have -- distilled to "we don't use it so i don't care" it sounds bad. :P) |
| 09:44 |
Dyrcona |
dbs: This person appear to be a follower of another person I follow. |
| 09:45 |
csharp |
I was looking at bshum's comment here, which appears to indicate that the outputs should be sorted by date run descending: https://bugs.launchpad.net/evergreen/+bug/1050432/comments/3 |
| 09:45 |
pinesol_green |
Launchpad bug 1050432 in Evergreen "Wish List: Alphabetization of report templates" (affected: 3, heat: 18) [Wishlist,Fix released] |
| 09:45 |
kmlussier |
csharp: Yes, I read that comment the same way. |
| 09:46 |
jeff |
@later tell yboston this is the kind of unpolished-but-detailed input i was seeking advice on from DIG: http://goo.gl/nEc5gU |
| 09:46 |
pinesol_green |
jeff: The operation succeeded. |
| 09:46 |
Dyrcona |
jeff: I take that attitude all the time. |
| 09:46 |
jeff |
"Standing Penalties in Depth" http://goo.gl/nEc5gU is pretty much me just typing into a document while code reading as I was attempting to solve some problems / gain better understanding of behavior / internals. |
| 09:47 |
csharp |
actually, I'm fine reverting commits, but we *would* like the template/report/output folders to sort alphabetically, just not the templates/reports/outputs themselves |
| 09:47 |
Dyrcona |
csharp: Sounds like a new code branch, more options, and then you can sort anyway you like! |
| 09:48 |
kmlussier |
csharp: I'm looking in master, and the ouput is sorting by runtime. It doesn't help you troubleshoot, but confirms that what you're seeing isn't expected behavior. |
| 09:48 |
dbwells |
csharp: I am also seeing runtime sorting for outputs on 2.5. |
| 09:48 |
jeff |
I suppose it works well as a wiki page, and with some additional effort could become official documentation, but 1) it goes a bit far in terms of specificity (calling out specific internal perl subs) and 2) it needs lots of polishing :-) |
| 09:48 |
Dyrcona |
And, Drycona stabs another fork of complexity into the horse carcass, 'cause it ain't done until every line of code has 6 knobs to tweak its behavior! |
| 09:50 |
* dbwells |
pictures Drycona and Dyrcona's slightly corrupted evil clone |
| 09:51 |
Dyrcona |
Evil clone? What evil clone? *grins maniacally* |
| 09:51 |
|
jwoodard joined #evergreen |
| 09:52 |
* dbs |
adds a commit to fix sorting by automatically prepending more and more "AAAAAAA"s |
| 09:52 |
jeff |
report_sort_key |
| 09:53 |
csharp |
dbs++ |
| 09:53 |
csharp |
thanks for everyone's feedback - I'll keep poking |
| 09:54 |
* Dyrcona |
adds permissions to allow the user to sort reports, otherwise they come out in a pseudorandom ordered seeded by the number of nanoseconds since the latest checkin. |
| 09:54 |
Dyrcona |
And, done! |
| 09:54 |
dbwells |
$report_name = "A" x epoch() . $report_name; |
| 09:55 |
Dyrcona |
dbwells++ # Now, that is diabolical! |
| 09:55 |
jeff |
dbwells++ |
| 09:55 |
jeff |
dbs++ |
| 09:55 |
jeff |
Dyrcona++ |
| 09:55 |
jeff |
praise absurdity. |
| 09:56 |
csharp |
@praise absurdity |
| 09:56 |
* pinesol_green |
absurdity can run a report without assistance |
| 09:56 |
csharp |
pinesol_green++ |
| 09:58 |
jeff |
there is a panda and a hippo reading my google doc. |
| 09:58 |
jeff |
(speaking of absurdity) |
| 09:59 |
Dyrcona |
It would be kind of funny to send an email to someone with an attachment with S/MIME heads that was just A X time(). Might give the NSA fits trying to figure out this new crypto scheme. :) |
| 10:00 |
Dyrcona |
jeff: I only see you and the anonymous panda. |
| 10:00 |
dbwells |
Dyrcona: you're the hippo! |
| 10:00 |
jeff |
Dyrcona: as they say in poker, if you look around the google doc and you can't pick out the hippo, then it's you. |
| 10:01 |
phasefx_ |
I see jeff and a buffalo |
| 10:01 |
jeff |
the hippo is gone. phasefx_ is the panda. |
| 10:01 |
Dyrcona |
Now, there's a gopher. |
| 10:01 |
phasefx_ |
now I see a gopher and an auroch |
| 10:02 |
dbwells |
Sweet, I must be the gopher, I guess. |
| 10:02 |
jeff |
thanks to google AdWords for Docs, I'm making a mint off of this silly conversation! |
| 10:02 |
Dyrcona |
jeff: The viral marketing ploy is working. There are more animals reading your document than before. |
| 10:02 |
jeff |
but anyway, I'd be interested in thoughts on how best to share this kind of ascii brain-dump, or if it's even worth sharing. |
| 10:03 |
dbs |
You won't believe this one weird trick for turning hippos into pandas! |
| 10:03 |
jeff |
until i came across and shared it this morning, i've been the only one with access since i created it in october. |
| 10:03 |
Dyrcona |
dbs++ |
| 10:03 |
jeff |
dbs++ |
| 10:04 |
Dyrcona |
jeff: Google Docs/Drive seems like a good enough place to share these things. |
| 10:04 |
|
yboston joined #evergreen |
| 10:06 |
Dyrcona |
Ooh. |
| 10:06 |
jeff |
? |
| 10:06 |
|
keynote2k joined #evergreen |
| 10:06 |
Dyrcona |
Four lines down from, and inside of elsif( $check_expire) { |
| 10:07 |
Dyrcona |
$check_expire ||= '12h'; |
| 10:07 |
jeff |
heh |
| 10:07 |
dbs |
Ah, legacy code |
| 10:21 |
|
gsams joined #evergreen |
| 10:25 |
|
krvmga joined #evergreen |
| 10:28 |
krvmga |
i'm experimenting with using multiple keywords for searches in my kpac configuration but i'm running into a problem. keyword:princess works fine but keyword:princess&&keyword:disney does not. Any thoughts? |
| 10:29 |
krvmga |
the line in the config file reads as follows |
| 10:30 |
krvmga |
<cell name="Disney Princesses" img="category.png" type="search">keyword:princess&&keyword:disney</cell> |
| 10:31 |
Dyrcona |
@later tell Bmagic If you want to see what the hold targeter is really doing, have a look at sub new_hold_copy_targeter in OpenILS/Application/Storage/Publisher/action.pm |
| 10:31 |
pinesol_green |
Dyrcona: The operation succeeded. |
| 10:31 |
krvmga |
i used & instead of & because & by itself caused a 500 error |
| 10:32 |
Dyrcona |
krvmga: Right. XML entities and all that. I don't have an answer for you, though. |
| 10:33 |
krvmga |
i'll get it sooner or later. i can usually beat these things into submission. i thought i'd ask before i thumped on it any further. |
| 10:33 |
dbwells |
krvmga: Did you try simply adding spaces around the '&&' operator? |
| 10:34 |
Dyrcona |
Yeah, I was about to suggest spaces or only 1 &.... |
| 10:36 |
dbwells |
Not sure you really need the operator at all... |
| 10:37 |
krvmga |
ok, here's what worked: && with spaces = 500 error; && with spaces = he shoots, he scores! |
| 10:38 |
jcamins |
לרהצעש: ׳ןךך ומגקרדאשמג ןא ׳ןאיםוא איק ₪₪ץ |
| 10:38 |
jcamins |
Ummm... that was supposed to be in the Latin alphabet. |
| 10:38 |
dbwells |
Only in an academic library: search for 'disney princess' in our catalog returns 'Tangled', 'The Little mermaid', and 'The sexualization of childhood' |
| 10:38 |
csharp |
dbwells: heh |
| 10:39 |
krvmga |
since i know hebrew...no wonder i got confused there |
| 10:39 |
jcamins |
What I meant was "krvmga: QP will understand the query without the &&." |
| 10:39 |
krvmga |
jcamins: i'll give it a try. |
| 10:39 |
jcamins |
I forgot to change my keyboard, and connection lag meant that I didn't see what I had typed until after hitting enter. |
| 10:40 |
csharp |
@locale he |
| 10:40 |
pinesol_green |
csharp: Fire BAD! Reading GOOD! |
| 10:40 |
krvmga |
dbwells: obviously not filtered to the juvenile collection |
| 10:48 |
|
JCxMLnblFl joined #evergreen |
| 10:48 |
|
JCxMLnblFl left #evergreen |
| 10:51 |
csharp |
@weather 30345 |
| 10:51 |
pinesol_green |
csharp: The current temperature in Storybook Estates, Decatur, Georgia is 30.7°F (10:51 AM EST on January 28, 2014). Conditions: Overcast. Humidity: 30%. Dew Point: 3.2°F. Windchill: 30.2°F. Pressure: 30.27 in 1025 hPa (Rising). Winter Storm Warning in effect until 7 am EST Wednesday... |
| 10:53 |
_bott_ |
@weather 49503 |
| 10:53 |
pinesol_green |
_bott_: The current temperature in Near Lake Michigan Dr and Collindale, Grand Rapids, Michigan is 8.4°F (10:53 AM EST on January 28, 2014). Conditions: Snow. Humidity: 84%. Dew Point: 5.0°F. Windchill: -0.4°F. Pressure: 30.28 in 1025 hPa (Steady). Wind chill warning in effect until 7 am EST Wednesday... |
| 10:53 |
_bott_ |
Ooo, already 10 degrees warmer than when I left the house today. |
| 10:55 |
Dyrcona |
@wunder 01845 |
| 10:55 |
pinesol_green |
Dyrcona: The current temperature in North Andover, Massachusetts is 14.5°F (10:37 AM EST on January 28, 2014). Conditions: Clear. Humidity: 42%. Dew Point: -2.2°F. Windchill: 14.0°F. Pressure: 30.30 in 1026 hPa (Rising). |
| 11:01 |
|
afterl joined #evergreen |
| 11:40 |
ldwhalen |
It looks like we are missing the public. normalizing functions like public.content_or_null in our config.index_normalizer table. |
| 11:41 |
ldwhalen |
I am trying to figure out which file in the sql/ directory they get added to the table, but I cannot track it down. Does anyone know the file name? |
| 11:42 |
csharp |
ldwhalen: looks like Open-ILS/src/sql/Pg/002.schema.config.sql ? |
| 11:43 |
eeevil |
ldwhalen: they may be in the evergreen schema. if so, assuming proper search_path for the db, PG should find them fine, unqualified. if you're logging in as a user other than evergreen and haven't set the db's search_path, you will have trouble finding them (assuming they are, indeed, in the evergreen schema) |
| 11:43 |
csharp |
ldwhalen: have you verified that the DB user's search path inlcudes public? |
| 11:43 |
ldwhalen |
csharp: That creates them in the database, but it does not add them to the config.index_normalizer table |
| 11:44 |
csharp |
er... what eeevil said ;-) |
| 11:45 |
ldwhalen |
the biblio.indeing_or_delete needs them to be in config.index_normalizer from what I can tell. Am I wrong? |
| 11:45 |
ldwhalen |
*biblio.indexing_ingest_or_delete |
| 11:45 |
eeevil |
you're correct |
| 11:46 |
ldwhalen |
So, they are not added by default, I need to add them explicitly? |
| 11:47 |
|
mrpeters joined #evergreen |
| 11:48 |
dbs |
ldwhalen: you probably pg_restore'd this database? |
| 11:48 |
ldwhalen |
dbs: yes |
| 11:48 |
dbs |
We had a big discussion about this on IRC last week IIRC |
| 11:48 |
ldwhalen |
dbs: thanks I will look it up |
| 11:49 |
ldwhalen |
although I just checked and they are not in our production database either. Although, it may have been pg_restored at some point. I will find out. |
| 11:49 |
eeevil |
ldwhalen: so, yes, it looks like you're correct |
| 11:50 |
eeevil |
the seed data, in master, does not add content_or_null to config.index_normalizer |
| 11:50 |
* eeevil |
wonders if it did in the past, and if so, how did that go away... |
| 11:51 |
dbs |
yikes. |
| 11:51 |
ldwhalen |
eeevil: I think it leaves out all of the public. normalizers |
| 11:51 |
|
schatz joined #evergreen |
| 11:53 |
eeevil |
looks like it never did ... |
| 11:54 |
eeevil |
ldwhalen: that's purely an oversight, there's no reason to not add them (especially since we attempt to make use of them). I suspect a big fat me-- for not propagating testing env changes to the seed and upgrade scripts |
| 11:55 |
ldwhalen |
eeevil: If I add them is there anything in config.index_normalizer that needs a specific value other than config.index_normalizer.func? |
| 11:56 |
eeevil |
ldwhalen: depends on the function ... if it takes parameters /beyond/ the input text, the number of them must be recorded in param_count |
| 11:56 |
eeevil |
for that one, it's 0 |
| 11:57 |
eeevil |
where "that one" == content_or_null |
| 11:57 |
ldwhalen |
eeevil: But, name and description are descriptive not functional? |
| 11:57 |
eeevil |
correct |
| 11:57 |
ldwhalen |
eeevil: ok, thanks for the information. |
| 11:58 |
eeevil |
np! ... least I can do for not registering them to begin with :P |
| 12:01 |
|
plux joined #evergreen |
| 12:02 |
|
plux joined #evergreen |
| 12:04 |
plux |
have a fresh install of 2.5.2 with sample data loaded..... everything fine except the staff client is looking for *custom* files in the server staff client build that aren't there.... i |
| 12:04 |
plux |
e.g. File does not exist: /openils/var/web/xul/rel_2_5_2/server/locale/en-US/auth_custom.properties |
| 12:05 |
dbs |
plux: harmless errors |
| 12:06 |
dbs |
you can "touch" them if you want to make them go away |
| 12:06 |
Bmagic |
Dyrcona: Thanks for the info. We have not resolved the issue and I keep coming up with more questions. I will review that code and see what I can see. Right now, I have expanded the query to show me holds that have not had the prev check time updated in the last 24 hours that have items available for the bib, [113 rows] |
| 12:07 |
|
smyers_ joined #evergreen |
| 12:17 |
Dyrcona |
Bmagic: Good luck. |
| 12:40 |
Bmagic |
What is the criteria of a row in action.hold_request for it to show on the "Pull list" current_copy!=null and..... ? |
| 12:42 |
tsbere |
capture_time null, cancel_time null, fulfillment_time null, copy owning library = workstation OU, copy in status 0 or 7 I believe it is.... |
| 12:42 |
phasefx_ |
though I think one of the pull lists is slightly off in that regard (didn't consider copy status), or was. may have been fixed |
| 12:42 |
tsbere |
oh, wait, copy *circ* lib, not owning lib... |
| 12:43 |
* tsbere |
gets that confused as almost every MVLC copy has owning lib = circ lib |
| 12:43 |
Bmagic |
tsbere: I get those mixed up as well |
| 12:51 |
eeevil |
Rule of thumb for circ vs owning lib: when we care about where the item is on a shelf /now/ (if it's on a shelf) because we need to retrieve it, we use copy.circ_lib. if we care about who owns the item, and could take it back from copy.circ_lib, because we want to know who controls it in policy, etc, we use copy.call_number.owning_lib |
| 13:02 |
|
mrpeters joined #evergreen |
| 13:09 |
Bmagic |
does this result in anything for anyone? |
| 13:09 |
Bmagic |
select aou.shortname,ahr.id,ahr.capture_time,ahr.prev_check_time,ahr.target, ahr.current_copy, ahr.request_lib,ahr.pickup_lib,ahr.usr from action.hold_request ahr, asset.call_number acn, asset.copy ac, actor.org_unit aou |
| 13:09 |
Bmagic |
where |
| 13:09 |
Bmagic |
ahr.target=acn.record and |
| 13:09 |
Bmagic |
ac.call_number=acn.id and |
| 13:09 |
Bmagic |
ac.status=0 and |
| 13:09 |
Bmagic |
aou.id=ahr.pickup_lib and |
| 13:09 |
Bmagic |
ahr.capture_time is null and |
| 13:10 |
Bmagic |
ahr.fulfillment_time is null and |
| 13:10 |
Bmagic |
ahr.cancel_time is null and |
| 13:10 |
Bmagic |
ahr.current_copy is null and |
| 13:10 |
Bmagic |
prev_check_time < '1-26-2014' |
| 13:10 |
Bmagic |
order by id |
| 13:10 |
Bmagic |
oops, bad paste sorry, I'm not sure I like this client |
| 13:10 |
jeff |
Bmagic: gist.github.com or paste.evergreen-ils.org are your friend when it comes to pasting large quantities of text in here. |
| 13:11 |
Dyrcona |
You run the risk of being booted by the IRC network for flooding if you paste directly into the channel. |
| 13:11 |
Bmagic |
jeff: yeah but this client automatically put my \r\n as new submits, when it could have easily been one single post |
| 13:11 |
Bmagic |
sorry everyone |
| 13:11 |
|
ningalls joined #evergreen |
| 13:13 |
jeff |
and yes, it appears i have about seven holds matching that query. 14 rows output total. |
| 13:14 |
Bmagic |
jeff: interesting: I have 91, and it seems to me that these should have a current copy assigned. Am I wrong? |
| 13:14 |
jeff |
all are title holds. |
| 13:17 |
jeff |
four of the holds are on deleted bibs. |
| 13:17 |
jeff |
and the remaining holds are frozen. |
| 13:17 |
Bmagic |
ah, I should alter the query a bit then |
| 13:18 |
|
schatz joined #evergreen |
| 13:19 |
Bmagic |
not acn.deleted and not ahr.frozen = Still getting 91 rows, and I guess in your case, you will get none |
| 13:20 |
jeff |
zero here. |
| 13:20 |
jeff |
but i've a new reminder to clean up after some old holds on deleted items dating back to before UI and/or process tried to prevent that -- so thanks. :-) |
| 13:20 |
Bmagic |
:) |
| 13:21 |
Bmagic |
I can't seem to get the hold targeter to assign a current copy to these when there is clearly an available copy |
| 13:21 |
Bmagic |
I wonder if the selection_ou has anything to do with it. What role does the selection_ou play here? |
| 13:25 |
jeff |
selection_ou combined with selection_depth will have an impact on what copies are considered eligible, yes. |
| 13:30 |
Bmagic |
In all of these cases, the selection_ou is assigned to the parent of the pickup_lib |
| 13:31 |
Dyrcona |
As tsbere mentioned yesterday, ours typically have the selection_ou equal to the pickup_lib. |
| 13:32 |
tsbere |
Or the request_lib, but it is occasionally neither... |
| 13:32 |
Bmagic |
I am going to expierement on 1 row and flip the selection_ou = pickup_lib and see what happens |
| 13:32 |
tsbere |
Bmagic: Note that the hold targeter won't assign a copy that is already on another non-filled non-canceled non-frozen hold |
| 13:33 |
Bmagic |
tsbere: I thought of that too, the query does not watch out for that but under close inspection, these should be getting targeted |
| 13:55 |
|
mrpeters1 joined #evergreen |
| 13:58 |
|
mrpeters2 joined #evergreen |
| 14:15 |
eeevil |
@weather 30101 |
| 14:15 |
pinesol_green |
eeevil: The current temperature in Cedarcrest Road, Acworth, Georgia is 21.0°F (2:15 PM EST on January 28, 2014). Conditions: Snow. Humidity: 76%. Dew Point: 14.0°F. Windchill: 14.0°F. Pressure: 30.18 in 1022 hPa (Falling). Winter Storm Warning in effect until 7 am EST Wednesday... |
| 14:16 |
eeevil |
solid inch of snow on the roads, and a good 4' of car in the ditches... ;) |
| 14:17 |
|
mrpeters joined #evergreen |
| 14:19 |
dbwells |
That's funny, at my house we have 4' of snow in the ditch, and I can still see a solid inch of my car stuck in there. |
| 14:22 |
* dbwells |
wishes he were exaggerating more than he is :( |
| 14:24 |
|
stevenyvr joined #evergreen |
| 14:29 |
|
keynote2k left #evergreen |
| 14:30 |
paxed |
why is your car in the ditch? |
| 14:31 |
dbwells |
cause I couldn't find my driveway :) |
| 14:32 |
paxed |
ow. |
| 14:33 |
|
mrpeters joined #evergreen |
| 14:37 |
dbwells |
Don't worry, I exaggerate. It is mostly in the driveway and only partially in the ditch, but it is unfortunately quite stuck. |
| 14:44 |
|
StephenGWills joined #evergreen |
| 14:49 |
ldwhalen |
eeevil: I have added a normalize bug to launchpad along with my working branch for the sql file to add the functions. |
| 14:49 |
ldwhalen |
https://bugs.launchpad.net/evergreen/+bug/1273820 |
| 14:49 |
pinesol_green |
Launchpad bug 1273820 in Evergreen "Public schema normalizing functions are missing from config.index_normalizer" (affected: 1, heat: 6) [Undecided,New] - Assigned to Liam Whalen (whalen-ld) |
| 14:51 |
eeevil |
ldwhalen: hrm... I think pronargs is wrong. the number of args will be that minus 1, because we're counting args beyond the assumed input text. (it's the number of user-supplied args per mapping to drive the function beyond the system-supplied input) |
| 14:51 |
ldwhalen |
eeevil: Right, thank you. I'll fix it up along with the indentation |
| 14:52 |
eeevil |
and, while it's not critical for the update script, we'd want i18n markers for the seed data version |
| 14:52 |
eeevil |
however, |
| 14:52 |
eeevil |
ldwhalen++ |
| 14:54 |
ldwhalen |
eeevil: Should I add these changes to the seed file and modify the logic there to get values from pg_proc? |
| 14:58 |
dbs |
got bit by 1200770 today. that was not fun. |
| 14:59 |
dbs |
bug 1200770 that is, pinesol_green |
| 14:59 |
pinesol_green |
Launchpad bug 1200770 in Evergreen 2.4 "Search result rendering can crush the system" (affected: 1, heat: 6) [High,Fix released] https://launchpad.net/bugs/1200770 |
| 15:00 |
dbwells |
dbs: Does the bug still live, or was this on an older version? |
| 15:02 |
dbs |
this was an older 2.4 version; fix came along after I had gone on sabbatical and was trying not to be intimately involved |
| 15:02 |
* dbs |
curses the simultaneous searches for "a", "the", "the." and "history" that drove postgresql connections through the roof |
| 15:05 |
* dbwells |
nods |
| 15:28 |
jboyer-isl |
Has anyone had any trouble with the MARC Import Remove Fields (Import Bib Trash Fields) function in Evergreen (especially 2.5.2?) I don't think there's an LP bug about it, but as far as I can see the client interface doesn't function at all. (just dumps an "unhandled exception: Transaction begin error" from dojo/openils/PermaCrud.js) |
| 15:29 |
jboyer-isl |
Before filing anything I wanted to see if it was only a local issue. |
| 15:29 |
jeff |
are other similar interfaces behaving the same? can you use the circulation policy editor, for example? |
| 15:30 |
jeff |
it's a rather vague error, but I believe we've run across similar in the distant past when there was an ejabberd domain issue preventing cross-server communication. |
| 15:30 |
jboyer-isl |
Well, there's something. Nope. |
| 15:31 |
jboyer-isl |
I've looked in our logs and come up with a whole lot of nothing, but I'll take a closer look at the jabber stuff. |
| 15:34 |
jeff |
check route_subdomains in ejabberd.cfg -- i'm guessing it's set to local and think you might have luck with s2s. |
| 15:35 |
jeff |
doh't make production changes during business hours based on my hunch, though. :-) |
| 15:36 |
|
gdunbar joined #evergreen |
| 15:38 |
|
akilsdonk joined #evergreen |
| 15:39 |
jeff |
and much credit to berick and eeevil (and others?) for their help on that a few years ago. :-) |
| 15:39 |
jeff |
jboyer-isl: i'll be interested in what your eventual resolution is, if you care to follow up. |
| 15:41 |
* berick |
notes that w/ websockets (and no translator) we can remove the x-domain jabber requirement / brick cross-talk |
| 15:41 |
jboyer-isl |
I can smack it with a hammer whenever, it's just on our test instance. :) Thanks for the pointers, if I can get it going I'll be back to grouse/brag, heh. |
| 15:41 |
eeevil |
ldwhalen: the seed file should really just insert the proc name (no schema), no need to check pg_proc. see related ones for isbn and replace normalizers. the the upgrade file could check pg_proc to avoid double insertion, I suppose |
| 15:44 |
eeevil |
berick: or, at least not depend on it for staff client interaction ... still nice for simple HTTP clients with transactional requirements :) |
| 15:47 |
eeevil |
ldwhalen: or just check that it's not there already with a CTE, or blindly insert outside any explicit transaction |
| 15:49 |
ldwhalen |
eeevil: Is it worth while adding the param_count from pg_proc? |
| 15:50 |
eeevil |
you need the param_count when it's not 0. I'd suggest just setting it to what it should be. I wouldn't involve pg_proc at all. IMO, just look at the definition of the proc, count the params requested, and subtract 1 |
| 15:53 |
jboyer-isl |
jeff: route_subdomains was commented out on both test bricks, but setting it to s2s doesn't seem to have been the whole fix. I could/should check the other service machines, but these bricks should be talking straight to the db without too much bouncing around. |
| 15:58 |
eeevil |
jboyer-isl: can the other domains find each other via dns or /etc/hosts? (IOW, is ejabberd listening on all IPs, and are the foreign IPs named something they would recognized) |
| 16:01 |
tsbere |
jboyer-isl: I would also check for local firewalling - If the server(s) aren't allowing incoming traffic on the S2S port the rest of the proper config won't help....and are your different bricks using different ejabberd domains for that matter? |
| 16:03 |
jboyer-isl |
the machines appear to be able to find each other by name, I don't believe there's a firewall running (they're off on a private 10. network) and they are all using individual private.name.evergreen.lib.in.us and public.evergreen...., and localhost domains. |
| 16:03 |
jboyer-isl |
I'll admit I'm not certain what stanza controls the IPs that ejabberd listens on, though. |
| 16:04 |
tsbere |
jboyer-isl: I have run into "oh, crap, the os distribution gave me a crappy default firewall config!" way too many times. >_> |
| 16:06 |
berick |
eeevil: re: clients w/ transactional requirements... hmm, i wonder. i bet by the time removing the translator is an option, writing a (e.g. Perl) WS client will be easier than writing a translator client |
| 16:07 |
berick |
since the translator has lots of custom headers and uses the multipart/mixed stuff |
| 16:08 |
berick |
(and to my knowledge, no one has written such a client) |
| 16:08 |
berick |
but they certainly could have |
| 16:12 |
jboyer-isl |
tsbere: all good there. the Precise defaults for iptables are wide open. |
| 16:14 |
eeevil |
berick: agreed ... I was really just thinking of xdr JS clients, though I don't know if that's strictly possible right now, and since only older MOZ supports multipart/mixed-replace, it's probably never going to be worth worrying about |
| 16:15 |
* dbs |
does a bit of a double-take at "Bill Erickson moved some example seed data out of the base install and into a sample data set." |
| 16:16 |
* eeevil |
goes to look more closely and make sure he didn't lie... |
| 16:17 |
dbs |
berick does _tons_ of stuff that deserves credit, and I certainly appreciate his testing & signing off |
| 16:17 |
eeevil |
I did lie. dbs, my apologies |
| 16:17 |
* eeevil |
updates |
| 16:21 |
dbs |
thanks eeevil |
| 16:22 |
eeevil |
dbs: thanks for bringing that to my attention |
| 16:56 |
|
ericar joined #evergreen |
| 17:14 |
jeff |
@seen sal |
| 17:14 |
pinesol_green |
jeff: I have not seen sal. |
| 17:14 |
jeff |
@seen sal_ |
| 17:14 |
pinesol_green |
jeff: sal_ was last seen in #evergreen 11 weeks, 5 days, 22 hours, 46 minutes, and 0 seconds ago: <sal_> jeff:similarly, can renew rental items using 11 + BOY. (Can understand why 29 might not work, but it shouldn't drop the SIP connection :-( ) I'll check in again tomorrow--gotta scoot. Thanks! |
| 17:14 |
jeff |
hrm. |
| 17:15 |
|
dcook joined #evergreen |
| 17:15 |
|
mmorgan left #evergreen |
| 17:17 |
|
dMiller__ joined #evergreen |
| 17:50 |
|
mrpeters left #evergreen |
| 18:09 |
|
StephenGWills left #evergreen |
| 18:44 |
|
bibliophylum joined #evergreen |
| 18:46 |
|
bibliophylum left #evergreen |
| 19:01 |
|
snowball joined #evergreen |
| 20:59 |
|
afterl left #evergreen |
| 21:31 |
jeff |
i had almost zero memory of bug 1257264 |
| 21:31 |
pinesol_green |
Launchpad bug 1257264 in OpenSRF 2.2 "JSON::XS 3.0 changes the way booleans are represented" (affected: 1, heat: 6) [Medium,Fix committed] https://launchpad.net/bugs/1257264 |
| 21:31 |
jeff |
insomnia+- |
| 23:01 |
|
twatcup joined #evergreen |
| 23:01 |
|
twatcup left #evergreen |
