Evergreen ILS Website

IRC log for #evergreen, 2018-03-12

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

Time Nick Message
00:15 remingtron__ joined #evergreen
02:26 eby_ joined #evergreen
02:27 sard_ joined #evergreen
02:30 Bmagic_ joined #evergreen
05:12 beanjammin joined #evergreen
07:15 rjackson_isl joined #evergreen
07:50 rlefaive joined #evergreen
07:53 jvwoolf joined #evergreen
08:43 mmorgan joined #evergreen
09:15 dbwells joined #evergreen
09:24 terran joined #evergreen
09:32 yboston joined #evergreen
09:36 kmlussier joined #evergreen
09:47 kmlussier Good morning #evergreen!
09:47 dbs morning!
09:47 * kmlussier thinks we need additional caffeine in here to help us recover from the time change.
09:47 kmlussier @coffee [someone]
09:47 * pinesol_green brews and pours a cup of Ethiopia Yirgacheffe, and sends it sliding down the bar to eby
09:47 kmlussier @tea [someone]
09:47 * pinesol_green brews and pours a pot of San Mateo Air Dried Loose Yerba Mate, and sends it sliding down the bar to jeff (http://ratetea.com/tea/guayaki/san-ma​teo-air-dried-loose-yerba-mate/4327/)
09:52 Bmagic_ I'm getting a "returning NULL" error when opening a report template folder with over 1000 templates in it. Should that be a problem for Evergreen?
09:52 Bmagic_ Returning NULL from app_request_recv after timeout: open-ils.reporter.folder_data.retrieve
09:54 jvwoolf joined #evergreen
09:54 Bmagic It will open the template folder no problem with any of the limiters (10,25,50) but not "all"
10:01 berick Bmagic: maybe dig a little deeper for the source error.  could be timeout, jabber message too big, etc.
10:01 berick there's a turtle at the bottom of the stack
10:02 csharp Bmagic: we have trouble with "all" too
10:03 Bmagic berick: which log then? I thought I had them all tailed
10:04 Bmagic request en-us open-ils.reporter-store.direct.​reporter.template.search.atomic [{"folder":1070},{"flesh":1,"​order_by":{"rt":"create_time DESC"},"flesh_fields":{"rt":["owner"]}}]
10:04 Bmagic followed by about 100 lines of
10:04 Bmagic [open-ils.reporter-store] sent 189 bytes of data to opensrf@private.localhost/open-ils.repo​rter_drone_at_localhost_130291
10:05 Bmagic Message processing duration 0.175308
10:05 Bmagic editor[0|1] open-ils.reporter-store.direct.r​eporter.template.search.atomic: returned 250 result(s)
10:05 mmorgan1 joined #evergreen
10:05 Bmagic and then the gateway.log spits out the aforementioned error
10:06 berick Bmagic: total time from start to end of Perl API call?
10:07 berick which I'm guessing is open-ils.reporter.folder_data.retrieve
10:08 Bmagic wait a minute.... it looks like one of the services is using a different time
10:08 Bmagic [2018-03-12 14:07:24] open-ils.reporter  vs. [2018-03-12 10:07:25] open-ils.reporter  within a split second
10:11 berick ok so not a timeout.  xmpp stanza too big?
10:11 berick i know that's not supposed to happen anymore, but i seem to recall some edge cases
10:12 pastebot "Bmagic" at 64.57.241.14 pasted "open-ils.reporter-store 2018-0" (32 lines) at http://paste.evergreen-ils.org/597
10:15 Bmagic paste.evergreen-ils.org/597
10:15 Bmagic Sorry that's not clickable http://paste.evergreen-ils.org/597
10:15 Bmagic CStoreEditor.pm is reporting times in the log with UTC (maybe) and Transport.pm is reporting times in EST. Could that have an impact here?
10:15 Bmagic joined #evergreen
10:16 pinesol_green [evergreen|Remington Steed] Docs: Remove docs not applicable in web client - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=3173dcf>
10:16 Bmagic Did I miss something? I DCed I guess
10:18 Bmagic http://paste.evergreen-ils.org/597
10:18 Bmagic CStoreEditor.pm is reporting times in the log with UTC (maybe) and Transport.pm is reporting times in EST. Could that have an impact here?
10:18 berick all we can see is the Perl API took 5.936 seconds total.  well within the default 60 second timeout.  and then the gateway reported a timeout.  which still has the appearance like a xmpp message size error.
10:19 berick the clock differences should not matter, since the services don't compare times.
10:19 Bmagic ok good to know
10:19 Bmagic There is a config with ejabberd that needs to change to accomodate 1000 templates in a single folder?
10:20 Bmagic accomodate / accommodate
10:20 berick Bmagic: don't know for sure that's the problem.  still just a theory
10:20 berick but maybe
10:21 berick doesn't jabber log an error when a message is too big?  i would expect some noise somewhere
10:21 Bmagic hmm, I didnt look
10:21 kmlussier joined #evergreen
10:22 Bmagic 2018-03-12 10:07:45.537 [info] <0.1017.3>@ejabberd_socket:send:181 Timeout on gen_tcp:send
10:22 berick huh, not familiar with that error
10:23 Bmagic it's followed up with this
10:23 Bmagic 2018-03-12 10:07:45.537 [info] <0.1017.3>@ejabberd_c2s:terminate:1788 ({socket_state,gen_tcp,#Port<0.10692>,<0.1016.3>}) Close session for opensrf@public.localhost/translator_nccard-upgrad​e.nccardinal.org_1520850307.050388_88848
10:23 Bmagic if that helps
10:24 berick well, we've angered ejabberd, that much is clear
10:25 berick you could always try raising the max stanza size and seeing what happens.  simple to test.
10:25 Bmagic sure
10:27 Bmagic upped from 2000000 to 5000000  - same error
10:28 Christineb joined #evergreen
10:28 Bmagic I guess add a zero?
10:30 bshum If it's already that high, seems like that's probably not the thing
10:30 bshum Since historically, that's already a high number
10:31 Bmagic it doesn't seem to matter
10:31 Bmagic same error
10:31 berick ok, yeah, that's already pretty well padded
10:32 Bmagic I would like the log to report the right time. where is the config for that?it's weird that a single perl module would report times in the logs 4 hours off while the rest of the modules are "correct"
10:32 pinesol_green [evergreen|Remington Steed] Docs: Fix broken include in root.adoc - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=506d1c2>
10:32 berick Bmagic: all i've ever had to do is modify the system time zone
10:33 Bmagic yeah, I have both /etc/timezone and /etc/localtime setup correctly
10:33 Bmagic the bash date command reports the right thing
10:35 Bmagic csharp: you cannot load template folders with more than x number of templates? This might help find such folder: select folder,count(*) from reporter.template group by 1 order by count(*) desc;
10:36 dbwells Bmagic: we've noticed the differing log timestamps since upgrading to 3.0 in December.  Maybe it happened before that, but that's the first time we've noticed.
10:36 Bmagic dbwells: interesting
10:36 dbwells It's been annoying, but we haven't looked into at all yet.
10:37 dbwells I assumed it was somehow related to the timezone-related feature changes, but not sure how.
11:02 jeff are you both using syslog or file-based logging for the opensrf log messages in question?
11:07 kmlussier joined #evergreen
11:19 kmlussier joined #evergreen
11:27 kmlussier joined #evergreen
11:27 mmorgan joined #evergreen
11:35 Bmagic jeff: file-based
11:43 kmlussier Bmagic / dbwells: We noticed the difference log timestamps back in 2.12. I remember seeing them when we were trying to troubleshoot the search stalling issues.
11:44 berick kmlussier: are you using file-based logging as well?
11:44 berick i.e. not syslog
11:48 yboston joined #evergreen
11:48 Jaswinder joined #evergreen
11:49 Jaswinder hey Guys, just an update with my setup with Evergreen, I did the setup using ubuntu 16.04 32 bit version. My next challenge is to find the existing APIs and learn how I can call external API for search
11:50 Jaswinder Anyone know, where I should look at in the code for API?
12:02 ngf42 joined #evergreen
12:07 beanjammin joined #evergreen
12:09 Bmagic Jaswinder: did you see this https://wiki.evergreen-ils.org/do​ku.php?id=osrf-devel:user_s_guide
12:15 Jaswinder Bmagic - Thanks for sharing the link. I am looking at this one now. The documentation is limited. I do see snippet of code for API on the server. It will be helpful to have complete example that shows all areas needed for API development.
12:16 Bmagic dbwells and remingtron are working on some awesome documentation project that might help
12:16 Jaswinder That will be great! When should I expect it to be out?
12:18 Bmagic I believe pieces of it are out there. I am waiting for them to respond. They did a presentation on it last year and I would have expected to see a link here https://evergreen-ils.org/conference/20​17-evergreen-international-conference/2​017-conference-programs-and-schedule/
12:19 dbwells Jaswinder: Well, it's an iterative process.  Here in the current public, temporary, rough form: http://library.calvin.edu/devd​ocs_project/doku.php?id=start
12:20 dbwells It mostly just draws a bunch of existing content together at the moment.
12:21 Jaswinder Alright! I will go over these document and then bug you guys if I have further questions.
12:22 Bmagic Jaswinder++ # Go forth!
12:22 Bmagic dbwells++
12:22 Bmagic remingtron++
12:23 dbwells Jaswinder: There isn't really a comprehensize API doc of any kind.  There is some generated documenatation for seach here, but it is really just a frame in many cases: https://webby.evergreencatalog.com/opac/​extras/docgen.xsl?service=open-ils.searc​h&amp;all=on&amp;offset=0&amp;limit=25
12:24 dbwells In your shoes, I would consider just cranking the logging up and poking at the system.  Many complete API calls will be revealed that way, though in some cases they are obscured.
12:42 terran dbwells++ remingtron++
13:10 kmlussier joined #evergreen
13:11 jihpringle joined #evergreen
13:21 Jaswinder I agree dbwells, I am digging up the code as we speak and certainly anything that sheds a light on APIs will help
13:30 kmlussier joined #evergreen
13:40 pinesol_green [evergreen|Jane Sandberg] Docs: adding some funding orgs to release notes acknowledgements - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=b44eb58>
13:40 pinesol_green [evergreen|Jane Sandberg] Docs: adding code contributors to 3.1 release notes acknowledgements - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=86ab5a9>
13:40 pinesol_green [evergreen|Jane Sandberg] Docs: adding translators to 3.1 release notes acknowledgements - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=daaa5de>
13:52 kmlussier joined #evergreen
13:54 rsoulliere joined #evergreen
13:59 rsoulliere Hi all, should the webclient support LDAP auth out of the box? If old staff client can connect via LDAP shouldn't the webclient?
14:16 dbwells rsoulliere: That seems like a reasonable assertion.  We use LDAP for patron accounts only, so we haven't missed it, and the same might be true for others.  So, probably just an oversight.  I would open a bug about it if one doesn't exist, or add a "me too" if it does exist.
14:20 rsoulliere thanks dbwells. I will do that.
14:37 pinesol_green [evergreen|Jane Sandberg] Docs: adding more funders to 3.1 release notes - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=ceca743>
14:37 Bmagic Anyone been able to create a report that shows average checkout length for a given circulation dataset?
14:40 dbs rsoulliere++
14:41 dbwells Bmagic: an actual report, or just a query?  We have a few saved queries for things like that.
14:41 Bmagic An actual report :)
14:42 dbwells Sorry, can't help you there :)
14:42 * dbs thought adding a circ rule defined by copy location would be as simple as adding a new entry with a non-NULL copy_location, copying the same grp/org_unit/circ_lib as before, but apparently not :/
14:42 Bmagic yeah, I am thinking that the formula avg(checkin_date - checkout_date) is not possible with reporter
14:44 dbs Ah, config.weight_assoc tells me that I am wrong
14:44 bshum Weights
14:44 bshum Heh, you got it
14:44 Bmagic weights are heavy
14:45 dbs I guess http://docs.evergreen-ils.org/reorg/3.0/sta​ff_client_admin/_circulation_policies.html could use some more touch-ups
14:45 Bmagic </ marty_mcfly>
14:45 bshum "There's that word again: "heavy." Why are things so heavy in the future? Is there a problem with the Earth's gravitational pull?"
14:45 Bmagic bshum++
14:45 bshum Bmagic++
14:45 Bmagic lol
14:46 dbwells Bmagic: FWIW, we usually do "coalesce(checkin_time, stop_fines_time) - xact_start" to avoid lost circs of infinite length.  It's like the roach hotel in reverse, "They check out, but they don't check in!"
14:47 Bmagic dbwells: I need it to work in the reporter
14:47 dbwells I know, just a hint for the future.
14:48 Bmagic roger that! One of the critera was xact_finish is not null
14:48 Bmagic or perhaps checkin_scan_time is not null
14:49 StomproJosh joined #evergreen
14:50 dbwells Yeah, if you limit to items that actually came back, it is easier.  We just had cases where we inadvertantly inflated the numbers, cause once they are averaged out, it isn't obvious that there was some 3000 day checkout for a lost item from 10 years ago thrown into the mix.
14:52 Bmagic I can see that being problematic
14:56 mmorgan In the xul receipt template editor, is there any way to strip out spaces and punctuation in a string returned by a macro?
14:57 mmorgan For example, for a hold slip, we would like to turn a patron last name of O'Connor into OCO
14:58 Bmagic I want to know the answer too!
14:58 mmorgan :)
14:59 Bmagic Does Evergreen Authority have a mechanizm for translating search for authors who used* to be called X but are being searched with Y? Example Jennifer Frantz is now Jennifer Fox and Authority control is fixing it. Searches for Frantz returns 0
15:06 mmorgan %SUBSTR(0,3)%%PATRON_LASTNAME%%SUBSTR_END% gives us the first three letters of the last name and we're using text-transform: uppercase;
15:26 kmlussier joined #evergreen
15:28 kmlussier Bmagic: Re your authority questions. Do you mean something like this? https://gapines.org/eg/opac/browse?blimit=20&amp​;qtype=author&amp;bterm=archer%2C+ur&amp;locg=1
15:28 Bmagic I suppose, but I was hoping it would work in a basic search
15:30 kmlussier Bmagic: Nope, not in keyword search. But your timing is good. We've been chatting at MassLNC about "Did You Mean?" searching and having some suggestions generated from authority data in that way.
15:30 Bmagic or even an author advanced search?
15:31 kmlussier Bmagic: Yeah, by keyword search, I meant any kind of keyword searching (author, title, general keyword).
15:31 mmorgan1 joined #evergreen
15:32 kmlussier Bmagic: If you want those cross references to show up in a browse search, you need to run the authority_authority linker.
15:33 Bmagic kmlussier++ # thanks
15:37 Bmagic I am getting search timeouts often. What can I do about it? I am looking at two different examples in osrfsys.log and it just seems like the issue is that it's taking to long. The query doesn't see particularly broad, paste inc.
15:37 pastebot "Bmagic" at 64.57.241.14 pasted "Example 1" (59 lines) at http://paste.evergreen-ils.org/598
15:38 kmlussier Bmagic: What release are you on?
15:38 Bmagic 2.12.7
15:39 pastebot "Bmagic" at 64.57.241.14 pasted "Example 2" (59 lines) at http://paste.evergreen-ils.org/599
15:39 kmlussier Bmagic: bug 1704396
15:39 pinesol_green Launchpad bug 1704396 in Evergreen 2.12 "Slowness for metarecord and one-hit searches in 2.12" [High,Fix released] https://launchpad.net/bugs/1704396
15:39 Bmagic oh! it's that?
15:39 kmlussier Bmagic: We had major issues with that.
15:40 Bmagic I remember that of course, I just didn't connect the two.
15:40 yboston joined #evergreen
15:42 Bmagic Are there any other cherry-picks that I need to include on this vanilla install?
15:42 kmlussier Bmagic: The title is misleading. I think it was easier to reproduce for metarecord and one-hit searches, but we saw the problem with a lot of our searches.
15:42 Bmagic The paste reports that there were "49 rows"...
15:43 Bmagic and the first example says "80 rows"
15:49 pinesol_green [evergreen|Chris Sharp] LP#1750912 - Add add_translations.py convenience script to i18n tools. - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=f09ae17>
16:22 mmorgan joined #evergreen
16:30 Bmagic kmlussier: thanks! I think that is the issue on those slow searches for that installation
16:31 kmlussier Bmagic: Awesome! There were cheers across all the Evergreen libraries in Massachusetts when that patch got loaded.
16:31 Bmagic kmlussier: Along these same lines, have you seen an Evergreen installation where attempting to open a reporting template folder with over 1000 templates in it fails?
16:31 yboston joined #evergreen
16:32 Bmagic berick and csharp and I were talking about it this morning. I have the logs http://paste.evergreen-ils.org/597
16:33 kmlussier Bmagic: I'm not aware of that problem, no.
16:33 Bmagic having over 1000 templates in a folder seems like a bad idea but it happens I guess
16:38 kmlussier Bmagic: Yes, I was going to say we probably don't have that many templates in a folder, but I could be wrong. I would think it would be difficult to find the template you need with that many in one folder.
16:38 * kmlussier heads out for the day.
16:43 pinesol_green [evergreen|Jane Sandberg] Docs: correcting funder names for 3.1 release notes - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=c9faf11>
16:43 pinesol_green [evergreen|Jane Sandberg] Merge branch 'master' of git.evergreen-ils.org:Evergreen - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=4900b49>
17:05 mmorgan left #evergreen
17:15 pinesol_green [evergreen|Remington Steed] Docs: Update "Circulation - Patron Record" for web client - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=6790dd6>
17:28 jvwoolf left #evergreen
17:49 gmcharlt joined #evergreen
17:50 gmcharlt joined #evergreen
18:19 abowling joined #evergreen
18:48 Christineb joined #evergreen
18:52 abowling1 joined #evergreen
19:43 jonadab joined #evergreen
21:50 jonadab joined #evergreen

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat