Evergreen ILS Website

Search in #evergreen

Channels | #evergreen index




Results

Result pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138

Results for 2020-10-15

13:15 JBoyer I doi like syslog grouping things together under /var/log/evergreen/... so you can get a good idea what's going on all in one place.
13:15 Dyrcona Some messages still end up in /var/log/apache2/other_vhosts.log or something like that, but that may just be our configuration.
13:16 JBoyer I think I've seen that too. Not sure if they're duplicated or if there's another config option that we're missing somewhere, etc.
13:16 Dyrcona Yeah, I agree for production environments, but for a test/development VM, it's a bit much.
13:16 Dyrcona I suspect they're duplicated, but I'll have to take a few minutes to make sure.
13:16 JBoyer It is annoying that there are so many places that need to be edited in opensrf_core.xml, that's true.
13:17 Dyrcona I have a couple of sed scripts for that. :)
14:45 nfBurton Although there aren't much costs for an online conference, we could probably garner some donations for that as well I mean we were willing to pay more to do the same face to face
14:46 Cowens Just to clarify, agoben, you wrote in the email to the community that we needed $15,000-$20,000 but we are paying out (at least ) $59,000 some, correct?
14:46 agoben I know that donations aren't an option for everyone, so we'll need to consider other options.  Obviously the e-conference is one options, but I'd like us to consider what else might be out there.
14:46 gmcharlt another factor for ongoing support: one of the ways of meeting the IRS' tests for showing that we, as a 501(c)3 charity, have public support, is to have a broad base of contributors
14:47 gmcharlt grants of course are another avenue to pursue
14:47 dluch I was just going to mention grants, lol
14:47 agoben The total is a little over $59,000, yes, but we have over half of that from previous conferences.
14:48 Cowens Thanks

Results for 2020-10-14

06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
06:58 agoben_ joined #evergreen
07:12 rjackson_isl_hom joined #evergreen
07:57 collum joined #evergreen
08:48 rfrasur joined #evergreen
08:56 collum_ joined #evergreen
09:07 Dyrcona joined #evergreen
09:36 Dyrcona Whee! Testing the new brick's OPAC over a ssh tunnel through the load balancer..... Have to adjust the URL to add my local port every time it does a redirect, but otherwise doable.
09:37 Dyrcona The web staff client.... Fuhgeddaboutit.....
09:38 Dyrcona Unless you can get the forwarding working as the root user, which I don't feel like dealing with.
09:42 Dyrcona Kernel update for the laptop. Think I'll install it and reboot. Back in a bit!

Results for 2020-10-13

04:04 jvwoolf1 joined #evergreen
06:02 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
06:46 jeff Bmagic, rhamby: Looking at this latest commit to match_fingerprints (from about two years ago), the change from '>' to '<' in the sort check seems to now conflict with the recommendation to sort in descending order (in examples and in the die message if the sort check fails):
06:46 jeff https://github.com/EquinoxOpenLibraryInitiativ​e/migration-tools/commit/775c66de891990851afcd​e5fbec9f6a8c6d004c3#diff-8a24e66df071b3db07de2​e015c625fd8ccc6533706ce69c138d4bba6d65869c7L65
06:48 jeff Any thoughts on if the examples/error need to be updated or if the change in comparison operator needs to be reverted?
17:26 mmorgan left #evergreen
17:27 JBoyer mmorgan++
17:31 jihpringle joined #evergreen
17:37 pinesol [evergreen|Galen Charlton] stamp release notes for 3.6.0 - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=e863fd2>
17:37 pinesol [evergreen|Galen Charlton] stamp version-upgrade script for 3.6.0 - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=5697364>
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:20 dbwells joined #evergreen
19:01 dbwells joined #evergreen
19:23 drigney joined #evergreen

Results for 2020-10-12

03:10 mrisher joined #evergreen
03:47 mrisher_ joined #evergreen
04:06 mrisher joined #evergreen
06:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
08:17 mantis2 joined #evergreen
09:11 Bmagic @coffee [someone]
09:11 * pinesol brews and pours a cup of NOBLE Coffee, and sends it sliding down the bar to bshum
12:08 csharp I tried changing "use open ':utf8';" to use open ':encoding(UTF-8)';" but that doesn't do it
12:08 csharp (those may be equivalent - my googled documentation was unclear)
12:09 csharp also, the problem may be that the incoming data from the bib records is not marked UTF-8?
13:39 jvwoolf We've got a staff member who's seeing icons in the angular catalog replaced with text, but only in Firefox. Happening on our test server and some community test servers for her. I can't replicate it. Anybody seen this?
13:47 jeff which community test servers? do you have a screenshot? any idea which version of firefox on what OS?
13:58 jvwoolf jeff: The server she mentions is terran-master.gapines.org. Windows 10, Firefox 81.0.1.
13:58 jvwoolf And here's a screenshot: https://photos.app.goo.gl/QTLDjZz6SKFgnhtRA
13:59 jvwoolf Oh and clearing site data (including cookies) didn't fix it.
14:39 terranm joined #evergreen
15:36 mantis2 left #evergreen
16:46 jvwoolf left #evergreen
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
20:50 sandbergja joined #evergreen
22:10 sandbergja joined #evergreen
22:13 mrisher joined #evergreen

Results for 2020-10-11

00:55 ejk_ joined #evergreen
06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
10:39 jeffdavis joined #evergreen
10:39 troy__ joined #evergreen
10:39 gmcharlt joined #evergreen
15:06 mrisher joined #evergreen
17:19 mrisher_ joined #evergreen
17:21 mrisher joined #evergreen
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:49 sandbergja joined #evergreen
20:11 sandbergja joined #evergreen
20:21 sandbergja joined #evergreen

Results for 2020-10-10

00:33 sandbergja joined #evergreen
14:07 mrisher joined #evergreen
16:54 sandbergja joined #evergreen
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:32 sandbergja joined #evergreen
21:50 jvwoolf1 joined #evergreen

Results for 2020-10-09

00:36 abowling1 joined #evergreen
06:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
06:59 collum joined #evergreen
07:35 mrisher joined #evergreen
07:40 collum joined #evergreen
16:19 sandbergja joined #evergreen
16:52 jvwoolf left #evergreen
16:57 Dyrcona Well, that's enough for now.
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:41 gmcharlt noting as a heads-up that I've turned on G Suite / Gmail for the evergreen-ils.org. I've set things up so that email to existing aliases like info@ and gitadmin@ will continue to go through lupin and work as expected, but if you see any cases where it looks like email is being dropped on the floor, let me know

Results for 2020-10-08

03:38 jvwoolf joined #evergreen
03:38 miker joined #evergreen
06:02 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
07:00 agoben joined #evergreen
07:16 mantis1 joined #evergreen
07:27 rjackson_isl_hom joined #evergreen
15:51 mantis1 left #evergreen
16:21 gmcharlt as a heads-up from the release team, we're thinking of doing the release two days early, i.e., on Monday 10/12 rather than Wednesday
16:22 Bmagic https://www.youtube.com/watch?v=r3Pr1_v7hsw
16:22 gmcharlt additional testing of the RC tarball requested, as well as minimizing further changes to rel_3_6
16:24 gmcharlt I imagine 1893463 will make it in 3.6.0, but I'm reserving the right to cut the release from commit e07ca51538 if something should crop up
16:24 pinesol gmcharlt: [evergreen|Galen Charlton] update Czech translation for Angular staff client - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=e07ca51>
16:24 Bmagic gmcharlt: hook me up with the tarball, I'll test it
16:24 gmcharlt Bmagic: great! it's available from the normal downloads page
16:24 Bmagic oh, THAT tarball
16:25 Bmagic :), no prob
17:04 mmorgan left #evergreen
17:22 Bmagic gmcharlt: look! It's working!
17:27 mrisher_ joined #evergreen
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:09 Bmagic gmcharlt: tarball works: https://bugsquash.mobiusconsortium.org/eg/staff/
20:35 mrisher joined #evergreen

Results for 2020-10-07

06:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
07:15 rjackson_isl_hom joined #evergreen
07:59 mantis1 joined #evergreen
08:22 collum joined #evergreen
14:49 JBoyer I'm mid-build on the rc, so I won't be pulling anything, should be fine.
14:49 csharp ok awesome
14:49 JBoyer (finally done with translation, may be finished soon...)
14:50 JBoyer ALSO, csharp++ for testing that one.
14:52 csharp calling 1241
14:58 pinesol [evergreen|Jason Boyer] LP1893463: Prevent duplicated report outputs - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=7ae38e7>
14:58 pinesol [evergreen|Chris Sharp] LP1893463: stamp upgrade script - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=7c0d5ee>
15:17 csharp yeah - looking into an approach now
15:17 Dyrcona csharp++
15:33 jihpringle joined #evergreen
15:40 csharp ok, I have a solution that I just tested - pushed it here: https://git.evergreen-ils.org/?p=working/Ev​ergreen.git;a=shortlog;h=refs/heads/user/cs​harp/lp1893463_upgrade_script_improvements - if someone wants to sign-off
15:40 csharp or I could just shove it in :-)
15:42 csharp JBoyer++ # buildin'
15:43 yar joined #evergreen
15:52 mantis1 left #evergreen
16:00 JBoyer csharp++ teaching me about DISTINCT ON () today. I'm +1 for that change.
16:38 Dyrcona I added just after the BEGIN;
16:38 Dyrcona It'll probably have to go at the top of the combined upgrade script.
16:40 Dyrcona It has to go inside the transaction or it doesn't work, and you get a message to that effect.
16:40 csharp works for me on my test
16:40 jeff I think it can come late in the transaction-- it appearing before the CREATE for the index should be sufficient, but should be tested. I think the effect of setting it late in the transaction is that it "flushes" the pending checks before returning from the SET.
16:40 csharp I'll update the working branch with that
16:42 csharp ok, same git location, force-pushed the single commit with the fix
16:45 Dyrcona berick++ jeffdavis++ # For helping me understand something in a different venue.
17:28 mmorgan left #evergreen
17:43 gmcharlt https://evergreen-ils.org/e​vergreen-3-6-rc-available/
17:48 csharp gmcharlt++
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:04 JBoyer joined #evergreen
20:42 Dyrcona joined #evergreen
20:42 Dyrcona @dunno add Your computer account is overdrawn. Please reauthorize.

Results for 2020-10-06

15:12 JBoyer #topic Evergreen Release Info
15:12 Topic for #evergreen is now Evergreen Release Info (Meeting topic: 2020-10-06 - Developer Meeting, Agenda Available at https://wiki.evergreen-ils.org/dok​u.php?id=dev:meetings:2020-10-06)
15:13 JBoyer #info Release candidate due 2020-10-07
15:13 gmcharlt so, I put up the two points here
15:13 gmcharlt and at this point, I'm curious if there's been additional testing of the Bootstrap OPAC from the betas
15:14 gmcharlt and would like to identify any absolute showstoppers that should go into the -rc
15:14 gmcharlt noting, also, that we're in string freeze
15:14 csharp gmcharlt: it's on mine and terranm's to-do, but we haven't gotten there yet
15:14 terranm I did some testing of the Bootstrap OPAC on festivus, but I'm not sure if that has the most recent version
15:15 csharp (bootstrap opac)
15:15 gmcharlt terranm: it does
15:15 gmcharlt (AFAIR, anyway)
15:16 terranm I think this bug summarizes the main issues - https://bugs.launchpad.net/evergreen/+bug/1895398
15:16 * mmorgan plans to finish up testing bug 1889128 for the rc
15:16 pinesol Launchpad bug 1895398 in Evergreen "Bootstrap OPAC: follow up needed" [Undecided,New] - Assigned to Christopher Burton (cburton)
15:16 pinesol Launchpad bug 1889128 in Evergreen "Angular Staff Catalog: Place Another Hold & Multi-Holds" [Undecided,Confirmed] https://launchpad.net/bugs/1889128
15:16 nfBurton11 there is a patch out there as well
15:29 gmcharlt are things squared away there?
15:29 JBoyer Finally, yes.
15:29 dluch As the two docs committers and the facilitator of DIG, @abneiman, @sandbergja and I made an executive decision that there will be no backporting of older docs
15:29 csharp gmcharlt: ping me about that - probably want a hostname change too (if we're talking about docs-testing)
15:30 Bmagic yep! JBoyer++
15:30 gmcharlt csharp: no, eg-docs
15:30 JBoyer After (mumble) minutes staring at it I added an @import line and the CSS was pleased.
15:50 JBoyer And on that point, while it proves they work and you can view them to verify, it's not really intended to be used from the CI output, right?
15:50 JBoyer (just making sure I'm following)
15:50 JBoyer The build outputs, I mean.
15:50 sandbergja JBoyer: correct.  It's set up more for building than testing
15:51 JBoyer ok
15:51 sandbergja (if I understood your question right)
15:51 gmcharlt quick preview for doc writers is the primary use case, I take it?
15:51 sandbergja gmcharlt: at this point, yes
15:52 JBoyer sandbergja++
15:52 Dyrcona sandbergja++
15:52 sandbergja although I could totally see it being beneficial to run the test suites we have for code, too
15:52 gmcharlt sandbergja++
15:53 sandbergja but we can get there eventually
15:53 sandbergja :-)
17:11 gmcharlt jeffdavis: thank you for helping to identify all the trees we need to tap
17:11 jeffdavis gmcharlt++
17:12 jeff *groan*
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:28 justdoglet joined #evergreen
18:33 justdoglet left #evergreen
19:45 sandbergja joined #evergreen

Results for 2020-10-05

06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
06:12 calvinm joined #evergreen
07:21 rjackson_isl_hom joined #evergreen
08:06 alynn26 joined #evergreen
10:54 csharp mmorgan: yes!  thank you
10:55 mmorgan YW!
10:58 JBoyer mmorgan++
10:59 JBoyer csharp, I'd be delighted if you could throw that on a test server with PINES data to see what's what with a real dataset. Obviously works pretty well with concerto. ;)
10:59 csharp JBoyer: will do
11:00 JBoyer (If that's what you're thinking)
11:00 JBoyer csharp++
11:12 Bmagic JBoyer: I hate to say it, but it seems that removing the ui supplement stuff from Evergreen is bugging the search. Though, I can't figure out why. I agree, that you've migrated the overrides over to eg-antora. Still diffing
11:13 Bmagic right now, I can say for sure that building antora with the ui-bits in Evergreen overlayed over eg-antora makes it work
11:33 Bmagic JBoyer: we may need to put the supplement stuff back. The issue was our nightly Evergreen builds were bombing on the absence of header-content.hba? Can we just make that file exist (with the updates from eg-antora) and call it a day?
11:34 Bmagic I'm starting to think that the lunr stuff needs* itself to be in the repo with the docs during build time. Alternatively, the build script could cp eg-antora -> Evergreen/docs/ui, commit a test branch, build that branch, then revert it all
11:47 gmcharlt the former, if there's no other way, is preferable to the latter: creating and throwing away git commits wouldn't be great for anybody with uncommitted changes in the clone who simply wants to try a doc build
11:57 jihpringle joined #evergreen
12:03 Christineb joined #evergreen
16:53 sandbergja joined #evergreen
17:05 mmorgan left #evergreen
17:29 Dyrcona joined #evergreen
17:54 pinesol [evergreen|Lisa Carlucci] docs: corrections to the 3.6 release notes - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=b2c3f81>
17:56 pinesol [evergreen|Galen Charlton] docs: release notes: adding EOLI to the list of commissioning entities - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=f900fbd>
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:44 sandbergja joined #evergreen
18:46 sandbergja For anybody still around: can I make a URL that opens the patron self-registration form with a specific library selected?
18:46 sandbergja (apart from setting up another OPAC with that library as physical_loc)?

Results for 2020-10-04

00:30 ejk joined #evergreen
01:32 mrisher joined #evergreen
06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
14:38 jvwoolf joined #evergreen
14:38 jvwoolf1 joined #evergreen
15:26 sandbergja joined #evergreen
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>

Results for 2020-10-03

06:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
11:43 troy__ joined #evergreen
11:44 jeffdavis joined #evergreen
11:45 Christineb joined #evergreen
14:37 jvwoolf1 joined #evergreen
14:37 jvwoolf2 joined #evergreen
16:15 dbriem joined #evergreen
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
22:30 sandbergja joined #evergreen

Results for 2020-10-02

01:37 mrisher joined #evergreen
06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
06:33 agoben_ joined #evergreen
06:34 annagoben joined #evergreen
07:22 rjackson_isl_hom joined #evergreen
17:11 Bmagic when the branch is cut, antora.yml (for rel_3_6) will need this line: version: 'latest' changed to: version: '3.6'
17:13 Bmagic and on master, we would want to tell antora to build two "versions" based on two git branches. This takes place in site.yml. This line: branches: HEAD would need to be: branches: [master, rel_3_6]
17:14 Bmagic I think* the url for the built rel_3_6 will be: /prod/docs/3.6/ (or whatver we call it in antora.yml for that branch)
17:15 gmcharlt hmm, OK, sounds like it can do what I want, but will need to test it
17:15 gmcharlt but in that case, I suggest rather than /prod/, we change the prefix to /eg/
17:15 gmcharlt (or evg)
17:15 Bmagic I like eg
17:17 gmcharlt easy to make that change via symlink right now
17:17 gmcharlt shall I do so?
17:20 gmcharlt I can also push out the site.yml and antora.yml changes now
17:22 Bmagic cool
17:22 Bmagic ready when you are
17:23 gmcharlt ok, I'm done with the /var/lib/antora/www/eg move and have pushed out the changes to master and rel_3_6
17:23 gmcharlt so handing off to yhou
17:24 gmcharlt meanwhile, I'm working on copying over the docbuilder stuff for previous versions over from docs-testing
17:26 pinesol [evergreen|Galen Charlton] update target branches for Antora - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=a5b3482>
17:31 Bmagic gmcharlt: https://eg-docs.georgialibrari​es.org/eg/docs/3.6/index.html
17:31 Bmagic nice!
17:46 Bmagic The search box is bugged. I'll have to debug it next week
17:48 gmcharlt cool
17:49 gmcharlt also, the link to the Acquisitions topic manual on the Antora index pages is broken
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:20 gmcharlt https://eg-docs.georgialibraries.org/ 's index page is now updated to include 3.3 -> 3.5 taken from docs-tester
18:20 gmcharlt and jobs running to rebuild the 3.3-3.5 documentation, including fixing an issue that was preventing the PDFs from being generated
22:33 mrisher joined #evergreen

Results for 2020-10-01

03:59 abowling joined #evergreen
04:07 gmcharlt joined #evergreen
05:10 gmcharlt joined #evergreen
06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
07:21 rjackson_isl_hom joined #evergreen
08:27 mantis1 joined #evergreen
08:31 sandbergja joined #evergreen
13:26 Dyrcona Bmagic: No. A development VM. Sticking with 9.6 in production for now.
13:26 Bmagic right on
13:26 Dyrcona csharp has plans for Pg10 in production.
13:26 Dyrcona I do test on Pg12 and I've found performance to be uneven. Some things are faster and others slower.
13:27 Bmagic I'm keen to know more about the prospect of 10. csharp++
13:28 Dyrcona For a small sample, you can read this: https://bugs.launchpad.net/ever​green/+bug/1482757/comments/18
13:29 pinesol Launchpad bug 1482757 in Evergreen 3.4 "Loading records with located URIs should not delete and recreate call_numbers" [Low,Confirmed]
14:08 abneiman how are things where you are dluch?
14:09 dluch Doing okay here, too. Weather is turning gorgeous - October is the best! Still working at home, and presently quarentined with my husband (though I'm almost positive we have colds and not COVID)
14:10 abneiman :( I hope so!
14:10 dluch Thanks! He's the one with the cough, and neither of us has fevers, but his doctor wanted us to wait until Saturday to be tested (??)
14:11 dluch *shurugs*
14:11 jweston dluch: hoping your colds, and waiting to get tested, are all over soon so you can enjoy the beautiful October
14:11 dluch Thank you! Me, too! :-)
14:11 dluch #info Evergreen Hack-a-Way, Oct. 26-28
14:12 dluch At the last DIG meeting, we decided that we would focus on 3.6 documentation at the Hack-a-Way.
14:38 Topic for #evergreen is now Collaboration time (Meeting topic: 2020-10-01 - Documentation Interest Group Meeting)
14:38 dluch What is everyone planning to work on today?  Please let us know here, and feel free to talk and work with each other.  If you'd like extra accountability, I can make an action item to show up in the minutes, but it's not necessary.
14:39 dluch I put a list of ideas on the agenda, but I assume everyone that's here today probably knows stuff they want to work on.
14:39 abneiman So, when gmcharlt did a build test with my giant-pile-o-docs, the build generated some errors in a couple adocs. I was going to look at those, but I was hoping there is someone here who can help me better understand "callout" syntax in adoc, because that's where several of the issues are.
14:40 abneiman *errors in existing adocs, not errors in my new adocs (phew)
14:40 abneiman anyway, I'm not familiar with the callout syntax and how it's supposed to work
14:41 dluch Hmm, I'm not either
14:41 abneiman and asciidoc cheat sheet has let me down for once :*( so I figured before I did deeper Googling, I would ask if anyone here has used that
14:42 jweston I'm no help there but hooray for abneiman++ generating pile-o-docs
14:44 abneiman which refers to this: https://eg-docs.georgialibraries.org/prod/docs/lat​est/admin/receipt_template_editor.html#_subtotals
14:45 abneiman line 208 specifically is "<1> This line sets the variable."
14:46 Bmagic when did you get the error?
14:47 abneiman build test
14:47 gmcharlt joined #evergreen
14:47 Topic for #evergreen is now Welcome to the #evergreen library system channel! | We are publicly logged: http://irc.evergreen-ils.org/evergreen | Large pastes at http://paste.evergreen-ils.org | Can't speak? Make sure your nickname is registered and that you are identified to freenode services: https://freenode.net/kb/answer/registration
14:48 Bmagic the error would have occured in the old docs (because the error is not from antora, but from asciidoctor)
17:10 rjackson_isl_hom joined #evergreen
17:37 rjackson_isl_hom joined #evergreen
17:57 sandbergja joined #evergreen
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:02 sandbergja joined #evergreen
18:27 gmcharlt https://evergreen-ils.org/r​elease-3-6-beta2-available/
19:57 dickreckard joined #evergreen

Results for 2020-09-30

05:13 stephengwills joined #evergreen
05:14 stephengwills left #evergreen
06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
06:37 agoben_ joined #evergreen
07:20 rjackson_isl_hom joined #evergreen
08:29 mmorgan joined #evergreen
16:48 terranm joined #evergreen
17:09 rjackson_isl_hom joined #evergreen
17:20 mmorgan left #evergreen
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:24 jihpringle joined #evergreen
18:37 gmcharlt jeffdavis: thanks!
19:45 dickreckard_ joined #evergreen

Results for 2020-09-29

05:34 book` joined #evergreen
06:01 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-29_04:00:04/test.78.html>
07:00 agoben joined #evergreen
07:26 rjackson_isl_hom joined #evergreen
07:28 JBoyer I think I figured out what's up with the failed log output errors, we were no longer ignoring the intentional error from 08-lp1366964-libdbi-error.t because the statement that's logged changed with the hopeless holds enhancement.
09:52 Dyrcona Hm... I think just 24 hours is OK.... "between" is inclusive, right?
09:53 Dyrcona Eh... no....Still need the extra minute for the 59 seconds.
09:54 Dyrcona Thanks, rubber ducky!
09:56 Dyrcona I suppose I could run some autorenewals on my test db before I make the change in production. ;)
09:59 dbwells joined #evergreen
10:05 stephengwills joined #evergreen
10:05 Dyrcona Hmm... action_trigger may be slower on Pg 12 than on 9.6, too.....
10:34 mmorgan scroll, scroll, scroll your @quote random
10:34 mmorgan nope.
10:40 pinesol [evergreen|Jason Boyer] LP1849212: (follow-up) Don't use group ids in upgrade scripts - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=72c71e7>
11:06 Dyrcona With about 700 out of about 30,000 autorenewals completed on my test db, I don't see anything crazy, yet.
11:08 Dyrcona I think I found another machine with the wrong timezone: 2020-09-30 00:59:59-04
11:09 Dyrcona I see more from the one that one that is set to Pacific time. The new delay is picking them up.
11:11 nfBurton joined #evergreen
14:42 Dyrcona Hm.
14:42 * Dyrcona wonders why exactly half of the events were processed, unless I somehow got two of each event created.
14:45 Dyrcona Yeahp. That's what happened. The drones from that first a/t runner that I stopped must have kept going. I *think* I have encountered that before.
14:47 Dyrcona No harm done. Just testing something on a development system.
14:49 mantis1 left #evergreen
15:04 terranm joined #evergreen
15:29 BAMkubasa joined #evergreen
16:47 Bmagic that's what I thought too :) - and I've seen it happen but now that I want* it to happen, it won't. What is the magic server response code? 404?
16:47 terranm Oh, I'm not sure
16:47 mmorgan Bmagic: Or, can folks go to offline directly via the link? https://<hostname>/eg/staff/offline-interface
16:48 terranm ^ that's what I do when I need to test it
16:49 Bmagic I want it to go there automatically (like it's suppose to do) - still trying some stuff
16:51 Bmagic perhaps when I change the hosts file (and the browser needs to recognize) - I need to use the CTRL+SHIFT+R (hard refresh) combo to make the browser re-read the hosts file, I get the connection timed out. Perhaps it's also clearing it's web app cached page for offline?
16:52 mmorgan berick: One question about bug 1889128, was the intent to clear the patron info after a hold is successfully placed as mentioned in comment #3?
17:55 laurie joined #evergreen
17:56 eby joined #evergreen
17:56 troy__ joined #evergreen
18:02 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:24 rjackson_isl_hom joined #evergreen
19:37 stephengwills joined #evergreen
19:47 stephengwills_ joined #evergreen

Results for 2020-09-28

06:02 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-28_04:00:10/test.78.html>
06:37 agoben joined #evergreen
07:23 rjackson_isl_hom joined #evergreen
08:07 Dyrcona joined #evergreen
16:54 nfBurton joined #evergreen
17:13 mmorgan left #evergreen
17:52 sandbergja joined #evergreen
18:00 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-28_16:00:02/test.78.html>

Results for 2020-09-27

04:35 gmcharlt joined #evergreen
06:11 eby joined #evergreen
06:14 laurie joined #evergreen
18:00 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-27_16:00:02/test.78.html>
19:11 sandbergja joined #evergreen
22:42 sandbergja joined #evergreen
23:22 sandbergja joined #evergreen

Results for 2020-09-26

06:01 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-26_04:00:09/test.78.html>
11:16 jonadab joined #evergreen
18:01 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-26_16:00:03/test.78.html>
19:14 Glen joined #evergreen
21:33 bshum joined #evergreen

Results for 2020-09-25

14:47 pinesol [evergreen|Andrea Buntz Neiman] Docs: 3.6 release notes update - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=2241632>
14:51 rfrasur joined #evergreen
14:52 jvwoolf joined #evergreen
14:57 nfburton That reminded me to putt a pullrequest tag on 1895398. If anyone has a chance to test and signoff
15:04 csharp mmorgan: yes - it's busted and I haven't had a chance to get back to it
15:04 csharp so not ready for a pullrequest :-)
15:05 mmorgan Ok, thanks.
16:01 terranm joined #evergreen
16:35 terranm berick: I'll refresh terran-master and put 1889128 on it
16:36 berick thanks terranm!
16:57 * mmorgan will be happy to test bug 1889128 when terran-master is refreshed.
16:57 pinesol Launchpad bug 1889128 in Evergreen "Angular Staff Catalog: Place Another Hold & Multi-Holds" [Undecided,Confirmed] https://launchpad.net/bugs/1889128
17:03 terranm berick: mmorgan: it's on terran-master now - I ran into several merge conflicts so hopefully I resolved them properly
17:04 mmorgan terranm++
17:15 terranm berick: thanks, I'll be happy to try applying again after the rebase.
17:17 terranm mmorgan: I'm going to refresh it to master again pending the rebase
17:17 mmorgan ok, sounds good!
17:24 berick doing some quick tests of my rebase
17:25 sandbergja joined #evergreen
17:28 berick terranm: https://git.evergreen-ils.org/?p=working/Ever​green.git;a=shortlog;h=refs/heads/user/berick​/lp1887429-lp1889128-hold-prefs-and-multi-v2
17:40 * mmorgan needs to hang up bug squashing galoshes for the day, but will give it a test when it's available.
17:40 berick mmorgan++
17:40 mmorgan berick++
17:40 mmorgan left #evergreen
17:55 terranm Okay, let me add that in case the script didn't get it
17:58 berick this is the change in question that would cause that error if it were not deployed:
17:58 berick https://git.evergreen-ils.org/?p=Evergreen.git;a=b​lobdiff;f=Open-ILS/src/perlmods/lib/OpenILS/Applic​ation/Circ/Holds.pm;h=25f26334877e426524be9fb5d94a​c574a92f65f9;hp=11c29f8914083abaa4dc2480e56fbef46a​d6d84d;hb=479402aeec518f7b9377c646a7379113604e7e21​;hpb=2002181c83f0cab35b5a230c504b0d9bd7b0d840
17:58 pinesol berick: [evergreen|Bill Erickson] LP1851882 Angular catalog recall/force/part holds - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=479402a>
17:58 pinesol berick: [evergreen|Chris Sharp] account for race condition in  courses live test - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=2002181>
18:00 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-25_16:00:02/test.78.html>
18:02 nfburton_ joined #evergreen
18:02 nfburton__ joined #evergreen
18:03 nfburton___ joined #evergreen

Results for 2020-09-24

00:12 dbwells joined #evergreen
00:37 sandbergja joined #evergreen
02:13 dbwells joined #evergreen
06:00 pinesol News from qatests: Failed Create Evergreen Database <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-24_04:00:03/test.41.html>
06:15 dbwells joined #evergreen
06:54 Dyrcona joined #evergreen
07:15 rjackson_isl_hom joined #evergreen
15:01 jvwoolf Hooray! It worked!
15:01 jvwoolf JBoyer++
15:09 JBoyer Glad it's working again! :)
15:30 terranm terran-master and tiffany-master have shiny new patches installed for testing
15:31 * csharp buffs with cloth
15:32 terranm :)
15:32 csharp this server right here *slaps top* is ready for y'all to test
15:33 * berick kicks the hard drives
15:34 mmorgan terranm++
15:34 mmorgan csharp++
17:18 mmorgan left #evergreen
17:48 collum joined #evergreen
17:48 jvwoolf left #evergreen
18:00 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-24_16:00:02/test.49.html>
18:09 jihpringle joined #evergreen
19:05 RBecker joined #evergreen
19:35 collum joined #evergreen
19:50 pinesol [evergreen|Chris Sharp] account for race condition in  courses live test - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=2002181>
20:44 collum joined #evergreen
21:08 abowling joined #evergreen
21:50 abowling left #evergreen

Results for 2020-09-23

06:00 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-23_04:00:02/test.49.html>
06:57 agoben_ joined #evergreen
07:17 rjackson_isl_hom joined #evergreen
07:52 collum joined #evergreen
16:34 pinesol [evergreen|Jeff Davis] LP#1835127: scoped permissions for reservations - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=0c4e0ec>
16:34 pinesol [evergreen|Chris Sharp] LP#1835127 - Stamp upgrade script - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=aa8b0f3>
16:46 csharp calling 1239
16:50 pinesol [evergreen|Jane Sandberg] LP1882825: Add setting for booking pull list grid - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=dabe1b6>
16:50 pinesol [evergreen|Chris Sharp] LP1882825 - Stamp upgrade script - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=5b687e8>
16:51 troy__ joined #evergreen
16:51 Glen joined #evergreen
17:07 mmorgan left #evergreen
17:26 jihpringle joined #evergreen
17:58 kip joined #evergreen
18:00 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-23_16:00:02/test.49.html>
18:07 dbwells joined #evergreen
18:52 ejk joined #evergreen
18:52 troy__ joined #evergreen

Results for 2020-09-22

07:32 rjackson_isl_hom joined #evergreen
08:08 mantis1 joined #evergreen
08:17 Dyrcona joined #evergreen
08:31 rhamby firefox-- for impressively aggresive caching of javscript making it annoying to test stuff
08:36 Dyrcona :)
08:40 alynn26 joined #evergreen
08:49 mmorgan joined #evergreen
09:08 Dyrcona Bleh... I don't want the "live server" image, Canonical. I want the regular install image. Gotta jump through hoops of fire to get it....
09:10 Dyrcona And, no.... It's not available at all, just the live image....
09:46 terranm joined #evergreen
09:54 rhamby it occurs to me that when I'm testing behavior before I apply a patch and confirm it I should check launchpad to see if it's still listed as new
09:54 rhamby bah, baka no rogan
09:55 pinesol [evergreen|Bill Erickson] LP1896512 Angular retrieve record by ID/TCN - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=d173567>
09:58 jvwoolf joined #evergreen
09:59 pinesol [evergreen|Bill Erickson] LP1896083 Staff catalog handles not-found barcodes - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=966be35>
12:25 Dyrcona But, I've been feeling that way lately.
12:32 Christineb joined #evergreen
13:32 collum_ joined #evergreen
13:37 mrisher I'm trying to test bug #1887852 involving pending users.  I went to the user buckets page, then click the "pending users" tab, then try to import users by uploading a txt file.  the .txt file has one patron barcode on each line.  The console shows this error twice:
13:37 pinesol Launchpad bug 1887852 in Evergreen "Last 4 digits of phone number for password doesn't work with pending users" [Medium,Confirmed] https://launchpad.net/bugs/1887852
13:37 mrisher error calling method open-ils.fielder.flattened_search : 500 :  *** Call to [open-ils.fielder.flattened_search] failed for session [0.136581471607516881600796217939], thread trace [0]:
13:37 mrisher Can't locate object method "content" via package "OpenSRF::DomainObject::oilsMethodException" at /usr/local/share/perl/5.20.2/O​penILS/Application/Fielder.pm line 276.
13:40 mrisher I see.
13:41 mrisher I was trying that because when I googled the topic of pending users and searched through the results I kept seeing references to the patron buckets.
13:41 mrisher Thanks for clarifying! :)
13:41 jeff you're welcome! thanks for testing!
13:42 rfrasur mrisher - pending users is used in a couple different places for different things that sometimes can interact but mean different things.
13:43 rfrasur "pending users" - that terminology.
13:47 terranm joined #evergreen
14:28 mrisher re:  1887852   something must still be off in my testing.  What I'm testing is that the phone number populates the password field.   When the patron self-registers there's no way to enter a phone number.  The bug description indicates I should generate a pssword without changing the data in the phone field
14:29 mrisher how do I self-register, add a phone number, then go generate a password without changing the phone numbrer?
14:29 miker berick: re above, nm, I found queryParams and queryParamsHandling examples
14:30 jihpringle mrisher: you can add the phone number to the self registration form through the library settings
14:31 jihpringle mrisher: I think it's the "Show day_phone field on patron registration" setting
14:43 mrisher Are you saying that I need to register a workstation with the BR1 location and then try again with that workstation?
14:43 mmorgan I don't see that the library setting "Patron: password from phone #" is set for any org unit on butternut.evergreencatalog.com
14:43 mmorgan I'll set that now.
14:44 mrisher mmorgan: thanks.  I didn't know that was another option that had to be enabled to test the work
14:44 mmorgan Patron: password from phone # is now set to TRUE for CONS
14:44 mrisher thanks
14:44 mmorgan So many settings ... :)
14:44 mrisher do you know if I need to be using a workstation at BR1 to test this?
14:44 mrisher CONS will not work?
14:46 terranm You don't have to have a workstation set up to test the self-reg form because that's in the OPAC
14:46 mmorgan Personally, I'm always leery of using CONS as a workstation for any testing. I would say BR1 would be better for testing.
14:47 terranm I actually didn't know you could set up a workstation at CONS level. I guess I'm thoroughly trained to use a branch!
14:47 mrisher terranm: After the patron does self-reg you need to switch to the admin interface to work with the pending user. That's where the CONS workstation enters the picture
14:48 mrisher I'll use a BR1 workstation for testing this.  thank you
14:48 mmorgan mrisher++
14:50 jihpringle the fact that you can register a workstation for CONS is actually a bug https://bugs.launchpad.net/evergreen/+bug/1807257
14:50 pinesol Launchpad bug 1807257 in Evergreen "Web Client Allows Register Workstation with Org_Unit that Can't Have Users" [Undecided,Confirmed]
15:08 mrisher thanks for the help all.  I finished testing that bug and confirmed it fixed.
15:17 terranm mrisher++
15:32 nfBurton joined #evergreen
15:33 mantis1 left #evergreen
16:29 JBoyer there are not.
16:29 JBoyer which leads me to believe there ought so be.
16:30 JBoyer Oh, wait, no. bare numbers should be  cool in json.
16:30 mmorgan There ought to be to do a proper test of the bug :)
16:31 JBoyer Ah. they can be put there if that's all you need
16:32 mmorgan Great! To test the bug, the value should be "6"
16:33 JBoyer right-o, now it's set to "6"
16:33 mmorgan JBoyer++ Thanks!
16:46 jihpringle joined #evergreen
16:55 terranm mrisher: yeah, something's broken there - I just put a note on the bug squashing sheet a few minutes ago about it :/
16:55 mrisher thanks terranm
16:55 terranm The other angular stuff on there appears to be broken, too
17:01 mrisher I did manage to get some testing done with the traditional search, but it didn't behave as expected.  Wasn't sure if it was the server or the code that caused it.
17:01 mrisher I'm holding off for now
17:08 csharp I got an alert from that server that swap was filling up, so I restarted a bunch of things to track down the cause
17:09 csharp when I started it back up with ng build --watch, that's failing with this error:
17:09 csharp ERROR in src/app/staff/common.module.ts:78:17 - error TS1005: ',' expected.
17:19 csharp my bad
17:19 csharp ok - try running those again
17:20 terranm csharp++
17:20 mrisher thanks csharp
17:22 mrisher going back to testing on tiffany-master and it's still acting a bit odd.  keeps hanging.
17:22 terranm confirmed that reports are running fine on tiffany-master now, and the new view looks good
17:24 terranm mrisher: hmm, it's loading fast for me
17:26 mrisher pages were taking like 10 seconds to load.  it's quicker now
17:26 mrisher I'm trying to test https://bugs.launchpad.net/evergreen/+bug/1885179
17:26 pinesol Launchpad bug 1885179 in Evergreen "Angular staff catalog Add All Search Result to Basket option" [Wishlist,New]
17:26 mrisher I did a search query and used the new ""add all search results" option.  a dialogue box opens... pauses, then closes
17:26 mrisher not sure if that's the server acting up or the code I'm testing
17:27 berick mrisher: do you see a number next to the basket icon (by the Basket Actions) dropdown?
17:27 mrisher yes, there's a basket and (248)
17:27 berick that means it worked
17:29 berick cool
17:29 terranm +1
17:30 mrisher I appreciate the help.  I'll sign off
18:01 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-22_16:00:02/test.49.html>
18:04 Glen joined #evergreen
18:05 Christineb joined #evergreen
18:05 jeffdavis joined #evergreen

Results for 2020-09-21

01:31 yboston joined #evergreen
03:31 yboston joined #evergreen
05:33 yboston joined #evergreen
06:01 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-21_04:00:29/test.49.html>
06:10 yboston joined #evergreen
06:24 oleonard joined #evergreen
06:34 tlittle joined #evergreen
17:24 Bmagic What do folks do when approving an address throws a database contraint error? ERROR:  update or delete on table "usr_address" violates foreign key constraint "actor_usr_billing_address_fkey" on table "usr"
17:27 Bmagic probably should be a bug
17:54 Bmagic Turned out I had to uncheck the boxes for "Mailing" and "Physical" on the pending address, then save the patron, then come back and approve the pending addresss
18:01 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-21_16:00:04/test.49.html>
20:08 mrisher joined #evergreen
20:41 sandbergja joined #evergreen
20:46 sandbergja joined #evergreen

Results for 2020-09-20

00:15 mrisher joined #evergreen
01:18 mrisher joined #evergreen
02:20 mrisher joined #evergreen
06:00 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-20_04:00:30/test.49.html>
07:44 mrisher joined #evergreen
13:41 yboston joined #evergreen
14:03 jvwoolf joined #evergreen
14:34 sandbergja joined #evergreen
18:01 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-20_16:00:02/test.78.html>
19:57 sandbergja joined #evergreen
21:17 csharp joined #evergreen
22:51 sandbergja joined #evergreen

Results for 2020-09-19

03:13 csharp joined #evergreen
03:14 pastebot joined #evergreen
05:58 dbwells joined #evergreen
06:01 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-19_04:00:02/test.78.html>
14:49 mrisher joined #evergreen
18:00 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-19_16:00:02/test.78.html>
23:28 sandbergja joined #evergreen
23:43 sandbergja joined #evergreen

Results for 2020-09-18

02:54 Glen joined #evergreen
02:54 laurie joined #evergreen
02:58 kip joined #evergreen
06:00 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-18_04:00:02/test.49.html>
06:07 mrisher joined #evergreen
06:14 mrisher joined #evergreen
06:29 oleonard joined #evergreen
14:01 mmorgan jeff++
14:29 jihpringle joined #evergreen
15:59 mantis1 left #evergreen
16:13 terranm JBoyer++ and Bmagic++ for getting bug squashing test servers going for next week already! (I've had a hellish day so probably won't do mine until Monday morning)
16:14 Bmagic terranm++ # no prob
16:18 terranm (Did I say day? I mean week.)
16:29 jeffdavis upload 100 barcodes in Item Status > select all > Mark Item Missing > 100 calls to open-ils.circ.mark_item_missing. I need to start keeping track of places like this where we should be using batch methods.
17:09 mmorgan left #evergreen
17:43 jihpringle joined #evergreen
17:57 dbwells joined #evergreen
18:00 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-18_16:00:02/test.49.html>
22:06 mrisher joined #evergreen

Results for 2020-09-17

05:06 mrisher joined #evergreen
06:01 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-17_04:00:03/test.49.html>
07:25 rjackson_isl_hom joined #evergreen
07:33 csharp fg
07:38 Dyrcona joined #evergreen
17:26 jeff If you don't need the data from the joined table, a NOT EXISTS (SELECT 1 FROM table WHERE ... ) can be faster than the JOIN. Either will be faster than a big NOT IN, though.
17:27 jeff (he says, without looking at the query in question)
17:49 jeff looks like at least as of 10 the planner gets the same plan with either NOT EXISTS or LEFT JOIN in the simple case I have in my head.
18:01 pinesol News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-17_16:00:02/test.49.html>
21:19 _bott_1 joined #evergreen

Results for 2020-09-16

06:02 pinesol News from qatests: Failed Create Evergreen Database <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-16_04:00:08/test.41.html>
06:28 collum joined #evergreen
06:29 collum_ joined #evergreen
07:01 pinesol [evergreen|Jason Boyer] Correct opensrf.xml.example - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=13dfa2d>
07:02 JBoyer Error message was a tad misleading but the root cause (xml error) is fixed.
07:18 rjackson_isl_hom joined #evergreen
07:35 tlittle joined #evergreen
16:58 Dyrcona neat trick: until [[ -z "$(ps --no-header $(pgrep -f fine))" && -z "$(ps --no-header $(pgrep -f action_trigger))" ]]; do  sleep 600 ; done ; osrf_control -l --stop-all
17:02 sandbergja joined #evergreen
17:26 mmorgan left #evergreen
18:02 pinesol News from qatests: Failed Log Output: osrfsys.log <http://testing.evergreen-ils.org/~live//arch​ive/2020-09/2020-09-16_16:00:03/test.78.html>
18:31 sandbergja joined #evergreen
21:56 sandbergja joined #evergreen
22:11 mrisher joined #evergreen

Result pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138