Evergreen ILS Website

IRC log for #evergreen, 2024-09-27

| 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
07:45 kworstell-isl joined #evergreen
07:46 cbrown joined #evergreen
08:35 redavis joined #evergreen
08:51 mmorgan joined #evergreen
09:03 dguarrac joined #evergreen
09:07 csharp_ still alive in GA!
09:12 redavis csharp_++
09:12 redavis That is the best news of this nascent day.
09:29 Bmagic csharp_++
09:31 Bmagic @coffee csharp_
09:31 * pinesol brews and pours a cup of Colombia El Castillo Micro-Lot Nelson Melo, and sends it sliding down the bar to csharp_
09:31 Bmagic @coffee [someone]
09:31 * pinesol brews and pours a cup of El Salvador Los Planes Pacamara, and sends it sliding down the bar to berick
09:31 Bmagic @coffee [someone]
09:31 * pinesol brews and pours a cup of El Salvador Montecarlos Tablon Crater, and sends it sliding down the bar to Jaysal
09:31 Bmagic @tea [someone]
09:31 * pinesol brews and pours a pot of Earl Grey Decaffeinated Black Tea, and sends it sliding down the bar to dguarrac (http://ratetea.com/tea/big​elow/earl-grey-decaf/87/)
09:31 Bmagic @tea [someone]
09:31 * pinesol brews and pours a pot of Chamomile Lemon (Sweet Meadows), and sends it sliding down the bar to dmoore_doppel (http://ratetea.com/tea/numi/chamomile-lemon/504/)
09:31 Bmagic @tea [someone]
09:31 * pinesol brews and pours a pot of Magic Summer Organic Tea, and sends it sliding down the bar to pinesol (http://ratetea.com/tea/organic-herb​ie/magic-summer-organic-tea/9533/)
09:31 berick woot.  just soupy dregs here
09:36 dguarrac Bmagic: Thanks!
09:36 dguarrac pinesol: Decaf? On Friday?
09:36 pinesol dguarrac: PHRASING!!!
09:38 Bmagic haha
10:49 kworstell_isl joined #evergreen
10:57 sleary Equinox folks are all OK. Some are having intermittent power outages.
10:57 redavis sleary++
11:04 Bmagic sleary++
11:05 Bmagic from the ashes, Evergreen will arise anew
11:07 berick Evergreen 4.0 codename Phoenix
11:08 Bmagic berick++ # perfect
11:15 redavis But...it'd be great to forego the ashes...
11:15 redavis Maybe just some burning of incense or something?
11:15 redavis A beautiful sage smellin' phoenix?
11:57 Dyrcona joined #evergreen
12:01 * Dyrcona has a day off, and I'm sitting in the Salem, Mass. public library, working on Evergreen.... Well, answering some related emails.
12:05 jihpringle joined #evergreen
12:11 csharp_ Dyrcona++ # look forward to being up there soon
12:13 Dyrcona csharp_: I know a few places to hang out in the evening, despite living about 30 miles inland.
12:16 cbrown joined #evergreen
12:17 Dyrcona https://thecastlebeverly.com/ <- This might be a nice stop for Tuesday or Wednesday evening.
12:27 Dyrcona I have been there for a poetry night last year. Haven't played games there, yet.
12:36 jihpringle21 joined #evergreen
13:35 kworstell-isl joined #evergreen
14:18 smayo joined #evergreen
14:52 kmlussier joined #evergreen
15:02 jeffdavis The Vandelay slowness I mentioned yesterday seems to be because the reporter.old_super_simple_record view is super slow, the bbb_simple_rec_trigger on biblio.record_entry (which does a lookup on that view) gets called during overlay, and for some reason vandelay.overlay_bib_record doesn't finish until the trigger is done even though it's an AFTER trigger.
15:15 jeffdavis reporter.old_super_simple_record lookups are also super quick in our old environment, but super slow in the new one, which is maybe the immediate problem.
15:42 eeevil jeffdavis: is JIT enabled in the new env? IIRC, that was one of the views that gets much worse when PG tries to apply JIT optimizations
15:52 jeffdavis hmm, no it's not, and oddly the jit_above_cost setting has disappeared from postgres.conf in our old environment too...
15:55 jeffdavis eeevil++ # that did it, thank you!
15:55 eeevil disabling JIT? cool, glad it was "easy" :)
16:07 jihpringle joined #evergreen
16:25 csharp_ jeffdavis++ eeevil++
17:00 Bmagic jeffdavis: JIT! I was about to ask that as I was reading and I see eeevil beat me to it. That is the exact function that suffers the most from JIT being turned on. It manifested for me when saving a bib in the staff client. It was so slow, that the interface would fail to save the marc record.
17:00 Bmagic function/table/view
17:04 Bmagic I found the conversation http://irc.evergreen-ils.org/evergreen/2023-10-30 and http://irc.evergreen-ils.org/evergreen/2023-10-31
17:05 mmorgan left #evergreen
17:07 jeffdavis I even commented on the bug at the time saying that disabling JIT fixed the issue for us (LP 2042158). Some days my memory is like a whaddayacallit.
17:07 pinesol Launchpad bug 2042158 in Evergreen "Postgres 12+ needs to have JIT disabled" [High,Fix released] https://launchpad.net/bugs/2042158
17:48 Bmagic jeffdavis++
20:48 kmlussier left #evergreen
21:50 pinesol News from commits: LP2081758 Self Check with invalid email <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=409997​1e96c875571daa6ed0cfff40a188d564b1>

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