Evergreen ILS Website

IRC log for #evergreen, 2022-11-22

| 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
03:11 jeffdavis joined #evergreen
05:02 book` joined #evergreen
07:39 BDorsey joined #evergreen
08:21 rfrasur joined #evergreen
08:26 kworstell-isl joined #evergreen
08:27 phasefx csharp_: looks like evergreen-ils.org and friends are down?
08:27 csharp_ an issue at ITS is affecting incoming connections to PINES/GPLS which affects most Evergreen community assets, including evergreen-ils.org, git.evergreen-ils.org, and list.evergreen-ils.org
08:27 csharp_ phasefx: you beat me to it!
08:27 phasefx oof, csharp++
08:28 csharp_ oddly, I'm chatting from an ITS server - I've seen from ITS discussions that existing connections are apparently ok in some cases
08:40 mmorgan joined #evergreen
08:58 jeff 7:42: everything's down! ... 7:50: all better! ... 8:21: everything's down!
09:00 phasefx we didn't start the fire...
09:01 jeff This incident affects: [3.3 KB of text]
09:08 mmorgan :-(
09:10 csharp_ I think we're back
09:10 csharp_ ITS is warning that we might not be done
09:16 Dyrcona joined #evergreen
09:17 mantis1 joined #evergreen
09:26 mmorgan csharp_++
09:36 dguarrac joined #evergreen
09:54 Stompro jeffdavis, I will add the query info for the hold shelf query.  It seems to be related to the left join for asset.call_number.
10:05 Dyrcona Stompro: Is it a left join with a null clause or a negative logic like a not equals?
10:07 Stompro There is an or condtion in there.  But even when I remove that part it still takes a long time.  I have to attempt to install Sage 50 for our finance director, and then I should have time to post the info.
10:12 mantis1 joined #evergreen
10:20 Stompro Wohoo, sage installed this time.
10:27 pinesol News from commits: LP1955403-Bootstrap opac - Google Books preview not rendering. <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=1762a1​7d803a77a88fa3d2d60e80f68036ccca1c>
10:43 Stompro Dyrcona, changing that one join to having a less open ended criteria brought the run down from 30-50 to 2 seconds.
10:52 Dyrcona Stompro: Cool! Are you going to Lp it?
11:05 jvwoolf joined #evergreen
11:09 Stompro Dyrcona, yep, just trying to gather everything and put it in a gist.
11:09 Stompro Dyrcona, and my co worker brought in a cheescake, so that is also slowing me down.
11:13 Dyrcona cheesecake++
11:14 Dyrcona Stompro: This is about Bug 1971745 right?
11:14 pinesol Launchpad bug 1971745 in Evergreen "Holds shelf list can fail to retrieve results" [Undecided,New] https://launchpad.net/bugs/1971745
11:21 Dyrcona Sometimes there are too many ways to do something....
11:21 mmorgan Dyrcona++
11:21 mmorgan Always...
11:22 Stompro Dyrcona, yes.
11:24 Dyrcona Stompro: OK. Just making sure.
11:26 Stompro Dyrcona, I finished adding the query data now to bug 1971745.
11:26 pinesol Launchpad bug 1971745 in Evergreen "Holds shelf list can fail to retrieve results" [Undecided,New] https://launchpad.net/bugs/1971745
11:33 Dyrcona Stompro++
11:33 Dyrcona I'll have to try that with the explains later to see if I can reproduce the same. I'd like to see what happens on more recent Pg releases as well.
11:37 Stompro I struggle with choosing which PG version, Now 10 is out of support... but the 3.9 install docs say "Evergreen support for PostgreSQL server versions greater than 10 is still exprimental."
11:38 Stompro So, I'm not sure if I should be using 11-15.  I'll have to see what people are using for their recent 3.9 upgrades.
11:39 Dyrcona Yeah, that hasn't been updated. Master still recommends Pg 10. I started looking at Pg 15 and Evergreen last week.
11:41 Christineb joined #evergreen
11:42 Dyrcona I suppose I could stop banging my head against cherry-pick conflicts and work on Pg 15 + Lp1871745, but first, lunch!
11:42 Dyrcona Oops. Typoed the bug number.
11:47 Stompro Dyrcona, I took a look at the work you did on moving that forward, the benchmarks of the various versions.  Thanks for sharing that.
11:52 Stompro Content Cafe seems to still be down.  But they have another cover art service that still seems to be up... the one that titlesource 360 uses.  https://contentcafeau.azureedge.ne​t/Jacket.svc/UUID/ISBN/Medium/Logo
12:03 dmoore joined #evergreen
12:04 sleary joined #evergreen
12:10 jihpringle joined #evergreen
12:15 sleary26 joined #evergreen
12:23 Dyrcona Stompro: Yeah. One of the things I have yet to do is build plprofiler for Pg 15. Guess I could try that now.
12:29 Dyrcona Oof. My previous installation is no longer in the bash history. This is gonna be interesting. There's also an upgrade from plprofiler 4.1 to 4.2....
12:30 jeff Stompro: ironic, since TS360 remains down. :-)
12:36 mmorgan Content Cafe may be back. Seeing images in our dev system and in Novelist
12:39 jihpringle mmorgan: we're seeing them on our live system this morning
12:50 jeff Yep, looks like contentcafe2.btol.com is responding once more.
12:51 jeff OCS and TS360 still appear down. Not sure of the status of EDI.
12:52 Dyrcona mmorgan++ jihpringle++
12:52 mmorgan jihpringle++
12:53 mmorgan jeff++
12:53 Dyrcona So, installing plprofiler for different Pg versions was relatively easy. I should document it for future me...
12:53 Dyrcona jeff++
13:01 Stompro mmorgan++, jihpringle++ thanks, just tested again and seems to be back for us also.  I'm going to wait a few hours before I re-enable though.
13:01 mmorgan Stompro: Probably a good idea :)
13:01 mmorgan Stompro++
13:42 jmurray-isl jeff++  Verified on my dev server.
13:51 Dyrcona Gotta love cascading failure...
13:58 mantis1 joined #evergreen
14:05 jmurray-isl Only the bjackson user (or root) can write to the bjackson folder.
14:05 jmurray-isl oops
14:08 Dyrcona :)
14:30 Dyrcona Oh, joy.... Looks like we'll have to add version checks in a couple of the schema SQL scripts. It looks like coalesce is not immutable in Pg 15, and Pg 15 allows NULLs to be not distinct for unique indexes. We've got two unique indexes that use coalesce and need to be converted for Pg 15.
14:32 Dyrcona I can't find anything in the release notes about changes to coalesce, but I found "Allow unique constraints and indexes to treat NULL values as not distinct"
14:44 Dyrcona Turns out this is our problem: Mark the interval output function as stable, not immutable, since it depends on IntervalStyle (Tom Lane). This will, for example, cause creation of indexes relying on the text output of interval values to fail.
14:45 Dyrcona I can probably fix it without anything version-specific being needed.
15:15 Dyrcona It's weird. Some of the emails sent to gitadmin go through my spam filter and others don't. I haven't figured out why that is.
15:16 Dyrcona Anyway... /me checks on the progress of the db build on Pg 15.
15:17 Dyrcona Success!
15:17 Dyrcona It still builds on Pg 14. Guess I'll try 10 through 13 before I commit any changes.
15:19 Stompro Dyrcona++
16:33 jvwoolf left #evergreen
17:02 mmorgan left #evergreen
17:26 jihpringle joined #evergreen
17:58 abneiman_ joined #evergreen

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