Evergreen ILS Website

IRC log for #evergreen, 2021-02-23

| 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
04:51 khuckins joined #evergreen
06:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
07:20 khuckins joined #evergreen
07:21 rjackson_isl_hom joined #evergreen
07:47 collum joined #evergreen
08:24 mantis1 joined #evergreen
08:30 rfrasur joined #evergreen
08:37 mmorgan joined #evergreen
08:39 Dyrcona joined #evergreen
08:46 Dyrcona I'm trying to decide if I should do my next test on Pg 9.6 or Pg 12. I also wonder if I should log all queries or just those over a certain threshold, like 250ms or so.
08:48 Dyrcona Looks like I have plenty of free space to log all queries for a while.
08:59 csharp looks like my troubles from yesterday may have been a super-long-running emergency closing (15 hours)
08:59 csharp also did some PG vacuuming last night
09:02 rfrasur joined #evergreen
09:12 jvwoolf joined #evergreen
09:19 Dyrcona csharp: It had that much impact? We've had them run for a long time but not really cause an issue.
09:27 dbwells joined #evergreen
09:58 berick joined #evergreen
10:26 nfBurton28 joined #evergreen
10:26 Dyrcona I should have used a duration on the query logging. Getting all of them is a bit much.
10:27 stephengwills left #evergreen
10:55 Dyrcona This bugs me: "AS x WHERE 1=0;"
10:55 sandbergja joined #evergreen
10:56 Dyrcona Looks to me like the query is running over a second only to have the results ignored.
11:00 Dyrcona OK. That's IDL stuff. Moving along....
11:08 Dyrcona Hmm.. Looks like my hold targeter ran faster than yesterday, but it is still too long.
11:14 Dyrcona I'll test my changes on Pg 9.6, and then tomorrow run the old code and log long running queries. The old code seemed faster yesterday.
11:27 Dyrcona So, my code is faster on Pg 9.6 than it is on Pg 12. This is an area that we'll have to look at.
11:29 Dyrcona The 9.6 db has default optimizations, and it was updated yesterday morning, so it has not had the hold targeter run since Saturday.
11:30 Dyrcona miker: Should I open a Lp bug about future Postgres versions?
11:32 Dyrcona Could be that my Pg 12 optimization is whack.
11:33 miker generally? sure ... was there a specific thing, though? I haven't been following the hold targeter speed stuff, sorry.  (and, re "where 1=0" those really shouldn't be taking 1s each!  we could change that to limit 0, maybe? that's the C code investigating the actual data types of the columns at startup)
11:34 Dyrcona miker: We've seen some things that seem slower in Pg 12 vs 9.6. I've seen other things that are a lot faster. I'll see if I can get some statistics.
11:35 Dyrcona On the "where 1=0" I think those are OK as they come from the IDL. I think it is part of making temporary views/tables.
11:37 Dyrcona I've also discovered that my maintenance_work_mem setting is way out of whack on my development server for Pg 12. I'm going to remove my optimizations from the config for now.
11:38 Dyrcona I had GB instead of MB. :)
11:38 csharp oof - I've done that
11:41 Dyrcona I should reload Pg 11 and Pg 13 and test this against those dbs, too.
11:53 jihpringle joined #evergreen
12:30 mantis1 left #evergreen
12:30 khuckins joined #evergreen
13:38 Dyrcona joined #evergreen
13:56 Dyrcona Grr.. mozilla--
13:56 Dyrcona Or, maybe I should blame the Ubuntu packagers.
14:02 Dyrcona Oh, all right. I forgot that Lightning is now built in to Thunderbird. Jumping from version 68 to 78 can be jarring. :)
14:03 Dyrcona Except that my Google calendars are not working..... :(
14:03 mantis1 joined #evergreen
14:04 Dyrcona In case this happens to you, not likely, just disable the "Provider for Google Calendar" and re-enable.
14:04 Dyrcona @dunno
14:04 pinesol Dyrcona: http://images.cryhavok.org/​d/1291-1/Computer+Rage.gif
14:05 sandbergja joined #evergreen
14:05 Dyrcona @dunno get 12
14:05 pinesol Dyrcona: Dunno #12: "Have you tried turning it off and back on again?" (added by csharp at 01:04 PM, August 31, 2012)
14:06 Dyrcona I sort of went through this with Manjaro on my Pinebook a couple of weeks ago.
14:13 Dyrcona I liked Enigmail better than this built-in OpenPGP encryption. At least, Enigmail worked. This new code can't seem to find keys on keyservers.
14:16 Dyrcona OK. I can blame the Ubuntu packagers for not including Enigmail 2.2. It provides a migration tool.
14:16 Dyrcona S'pose this is what I get for blindly updating in the middle of the day.
14:24 Dyrcona Installed the latest Enigmail and it migrated my keys with no problems. I now return to the usual Evergreen babble. :)
14:46 berick Dyrcona++
14:48 Dyrcona Whoa! The regular hold targeter code from 3.2.10 has queries going for over an hour on Pg 12 with default settings!
14:48 Dyrcona Longest-running query: 164292 | 01:48:58.605979 | active | 10.250.150.75 | open-ils.cstore | SELECT "ahr".current_copy AS "current_copy", "acp".id AS "id", "acp".status AS "status", "acp".circ_lib AS "circ_lib" FROM asset.copy AS "a
14:49 Dyrcona I believe I will go back to the "optimized" settings for Pg 12.
14:51 jeffdavis I see those specific long running queries, never did track down why they run so long
14:53 Dyrcona I don't usually see those running very long in production on Pg 9.6.
14:55 Dyrcona I sometimes see really long running searches.
14:55 jeffdavis We kill those.
14:56 Dyrcona Yeah, so do I.
14:57 Dyrcona I just updated the kernel on the development db server and rebooted, but the queries appeared to go away after I shutdown services on 10.250.150.75.
14:58 Dyrcona So, I think my hold targeter performance issues are more likely related to changes in Pg 12 and not something that I did.
15:07 Dyrcona I think I'll take another crack at this tomorrow with some increased settings for Pg 12.
15:15 sandbergja joined #evergreen
15:32 mantis1 left #evergreen
16:00 RFrasur_ joined #evergreen
16:32 sandbergja joined #evergreen
17:02 sandbergja joined #evergreen
17:05 mmorgan left #evergreen
17:30 issyl0LU joined #evergreen
17:30 issyl0LU /!\ this chat has moved to irc.crimeircd.net #pp /!\
17:33 Raito_BezariusvT joined #evergreen
17:33 Raito_BezariusvT /!\ this chat has moved to irc.crimeircd.net #0 /!\
17:33 * jeff sighs
17:49 sandbergja joined #evergreen
17:49 khuckins joined #evergreen
17:49 jihpringle joined #evergreen
17:49 berick joined #evergreen
17:49 dbwells joined #evergreen
17:49 rjackson_isl_hom joined #evergreen
17:49 alynn26 joined #evergreen
17:49 awitter joined #evergreen
17:49 book`_ joined #evergreen
17:49 kip joined #evergreen
17:49 egbuilder joined #evergreen
17:49 genpaku joined #evergreen
17:49 jeff joined #evergreen
17:49 yeats_ joined #evergreen
17:49 jweston joined #evergreen
17:49 rhamby joined #evergreen
17:49 gmcharlt_ joined #evergreen
17:49 Christineb joined #evergreen
17:49 jonadab joined #evergreen
17:49 troy__ joined #evergreen
17:49 laurie joined #evergreen
17:49 drigney joined #evergreen
17:49 abneiman joined #evergreen
17:49 miker joined #evergreen
17:49 JBoyer joined #evergreen
17:49 nfBurton joined #evergreen
17:49 dbs joined #evergreen
17:49 yar joined #evergreen
17:49 bshum joined #evergreen
17:49 dickreckard joined #evergreen
17:49 Bmagic joined #evergreen
17:49 phasefx joined #evergreen
17:49 jeff_ joined #evergreen
17:49 jeffdavis joined #evergreen
17:49 ejk joined #evergreen
17:49 jamesrf joined #evergreen
17:49 eby joined #evergreen
17:49 pinesol joined #evergreen
17:49 csharp joined #evergreen
17:49 lisacarlucci joined #evergreen
17:49 devted joined #evergreen
17:49 dluch joined #evergreen
17:49 pastebot joined #evergreen
17:49 akilsdonk joined #evergreen
17:51 WarpedMJ joined #evergreen
17:59 PityDaFool joined #evergreen
18:00 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:01 ome joined #evergreen
18:08 ljharbjj joined #evergreen
18:10 pinesol [evergreen|Terran McCanna] LP1916085 Bootstrap OPAC - Pagination on copy table - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=c2e0686>
19:49 nfBurton28 joined #evergreen
21:19 yar joined #evergreen

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