| Time |
Nick |
Message |
| 08:45 |
|
mmorgan joined #evergreen |
| 09:02 |
|
Dyrcona joined #evergreen |
| 09:04 |
|
dguarrac joined #evergreen |
| 09:36 |
Dyrcona |
My custom a/t filters with a subquery to limit by patron home_ou for autorenewals/courtesy notices seems to work. I got only the libraries expected in my first test run. |
| 09:37 |
Dyrcona |
The a/t runner only ran for about 16 minutes (15m54s according to time). |
| 09:37 |
|
collum joined #evergreen |
| 09:37 |
Dyrcona |
This looks promising for a move to production soon. |
| 09:56 |
Dyrcona |
Hm. It might be nice if one could override the delay for an action trigger via the a/t runner command line. The use cases that I see for that are 1) running missed action triggers because of a system fault and 2) transitioning to a new schedule for some events. |
| 09:56 |
Dyrcona |
It should probably only work when a granularity is specified.... Not sure. |
| 10:08 |
Dyrcona |
Lp 2106399 |
| 10:09 |
pinesol |
Launchpad bug 2106399 in Evergreen "Allow override of delay and max_delay from action_trigger_runner.pl command line" [Wishlist,New] https://launchpad.net/bugs/2106399 - Assigned to Jason Stephenson (jstephenson) |
| 10:10 |
Dyrcona |
Wild: I ran the same test on Pg 10, and it took 35 minutes. The 16 minutes was on Pg 17. The Pg 10 database is optimized to use about 80% of the hardware whereas Pg 17 is using default optimization. |
| 10:13 |
Dyrcona |
Same data and same results. It really makes sense to upgrade PostgreSQL just for the better performance. |
| 10:14 |
* Dyrcona |
starts the next test on Pg 10 to see how long it takes. |
| 10:55 |
|
Christineb joined #evergreen |
| 11:11 |
|
jihpringle joined #evergreen |
| 11:28 |
|
redavis joined #evergreen |
| 11:36 |
|
jihpringle joined #evergreen |
| 11:48 |
|
jihpringle9 joined #evergreen |
| 11:49 |
Dyrcona |
Oh. The comparison isn't quite fair. Turns out that the system talking to pg 17 has parallel for reactor and collect set to 3, and the one talking to pg 10 has parallel commented out. I'll change that after this run and restart services. |
| 12:02 |
|
mixo joined #evergreen |
| 12:02 |
mixo |
hi |
| 12:02 |
mixo |
sometimes when Evergreen usage is high, osrfsys.log gets 500 error. I think opensrf needs to increase some resources. How to do that? |
| 12:03 |
Bmagic |
mixo: what's the error? |
| 12:04 |
|
jihpringle joined #evergreen |
| 12:04 |
mixo |
open-ils.cstore 2025-04-06 00:00:11 [WARN:113232:osrf_application.c:864:174388320711318623] Returning method exception with message: An unknown server error occurred |
| 12:04 |
mixo |
[2025-04-06 00:00:11] open-ils.search [ERR :112859:CStoreEditor.pm:155:174388320711318623] editor[0|0] request error open-ils.cstore.json_query.atomic : {"from":["search.symspell_suggest","\u00e1\u0083\u009a\u00e1\u0083\u0098\u00e1\u0083 \u00e1\u0083\u0098\u00e1\u0083\u0099\u00e1\u0083\u0090 |
| 12:04 |
mixo |
.;qtype=subject;expand=cnbrowse;expand=awards;no_highlight=1;expand=cnbrowse;available=true;expand=awards;available=true;expand=marchtml;expand=awards;expand=cnbrowse;expand=awards;expand=marchtml;no_highlight=1;expand=awards;expand=cnbrowse;no_highlight=1;no_highlight=1;available=true","keyword","{}",null,0]} : Exception: |
| 12:04 |
mixo |
OpenSRF::DomainObject::oilsMethodException 2025-04-06T00:00:11 OpenILS::Utils::CStoreEditor /usr/local/share/perl/5.36.0/OpenILS/Utils/CStoreEditor.pm:481 <500> Severe query error -- see error log for more details |
| 12:05 |
mixo |
[2025-04-06 00:00:11] open-ils.search [ERR :112859:EX.pm:66:174388320711318623] Exception: OpenSRF::DomainObject::oilsMethodException 2025-04-06T00:00:11 OpenSRF::Utils::Logger /usr/local/share/perl/5.36.0/OpenSRF/Utils/Logger.pm:243 <500> Severe query error -- see error log for more details |
| 12:05 |
mixo |
[2025-04-06 00:00:11] opensrf.settings [WARN:43066:Server.pm:200:] server: no children available, waiting... consider increasing max_children for this application higher than 15 in the OpenSRF configuration if this message occurs frequently |
| 12:05 |
|
jihpringle5 joined #evergreen |
| 12:05 |
Dyrcona |
mixo: Those look like 2 different errors that coincided. |
| 12:06 |
mixo |
I saw now. I think max_children increase needed. |
| 12:07 |
Bmagic |
The max children error is something you can address by increasing the (opensrf.settings) max_children directive in the config file. However, that service in particular may not benefit much, because it's hit hard early on, and usually not hit that hard for the rest of the lifecycle of the brick. |
| 12:07 |
Dyrcona |
For the no children available error, edit /openils/conf/opensrf.xml. In the opensrf.settings section, find the max_children setting and increase it. I'd go to 20 or 30 to start with. |
| 12:09 |
mixo |
Thank you |
| 12:09 |
mixo |
and one question |
| 12:09 |
Dyrcona |
After you edit that file, you'll need to restart the opensrf.settings service at minimum: osrf_control -l --restart --service opensrf.settings |
| 12:10 |
mixo |
yes, I know. |
| 12:10 |
Dyrcona |
OK. |
| 12:10 |
mixo |
and how can I make simple_suggest to work for Unicode? |
| 12:11 |
mixo |
UTF-8 |
| 12:11 |
Dyrcona |
I was just going to say that is likely a bug in simple suggest. |
| 12:11 |
Dyrcona |
eeevil might be able to help. |
| 12:21 |
eeevil |
the bigger problem with the error involving the symspell_suggest function is that it's getting a pile of extra junk from the url. we apparently still have some code paths that generate URLs that use semicolon instead of ampersand as the param separator. we need to find and remove those. |
| 12:24 |
eeevil |
the supposed unicode codepoints seem to be nonsense, though. \u00e1 is "a-acute", but (for instance) \u0093 is a control character. so there's probably some encoding problem somewhere |
| 12:25 |
eeevil |
that's not a problem inside the suggest logic, it's before that |
| 12:29 |
Dyrcona |
Yeah. I was going to say that something didn't like the encoding of the data most likely. I forgot about the query string separator issue. |
| 12:30 |
Dyrcona |
"severe query error" is always a bug somewhere, but not always with the query generator. |
| 12:30 |
* Dyrcona |
clocks out for an optometrist appt. |
| 12:44 |
|
redavis joined #evergreen |
| 14:48 |
pinesol |
News from commits: LP1940867 Avoid error when reimporting vandelay queue <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=750bc317aa3a20247b1e9f6b7cba701a4e94b10c> |
| 16:48 |
pinesol |
News from commits: LP2095532 Ctrl+arrow creates only one new MARC row <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=a5df968f42b35778c20d2c09296144f3fb81d8e8> |
| 16:48 |
pinesol |
News from commits: LP2101884 MARC Rich Editor subfield tabbing order <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=bd3ea719ce11cfb2cdf48df080ae662bb26648d6> |
| 16:48 |
pinesol |
News from commits: LP2101886 MARC editor: allow right arrow in inputs <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=7e312a090065fb7f96ae0fb79861e16e169fdde4> |
| 16:50 |
|
jihpringle joined #evergreen |
| 17:05 |
Bmagic |
mmorgan: we have a production server that recently installed the patch from bug 1954937. We received a ticket about the patron holds interface running slowly. And the "Recently Canceled Holds" tab not loading any rows. After investigation, and performing a git bisect, I found that the problem went away after removing that patch |
| 17:05 |
pinesol |
Launchpad bug 1954937 in Evergreen 3.14 "Wide Holds API Incorrect Queue Position on Patron-Focused Searches" [Medium,Confirmed] https://launchpad.net/bugs/1954937 |
| 17:18 |
pinesol |
News from commits: LP2106414 OPAC Alert Banner - restore dropped line <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=7f1e4162b54a062b5f24c556a59cd1545bc6bfc7> |
| 17:18 |
pinesol |
News from commits: LP#2093840 Combobox says null when empty <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=a5b6bb92e5eaa3e4121f77d43ec1d6524ecbcae4> |
| 17:18 |
pinesol |
News from commits: LP2098712 Open lead record after merge from bucket <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=406f06b5a3f2cf0743c389c253f6126ee532f47e> |
| 17:18 |
mmorgan |
Bmagic: Interesting. I have to run, but we haven't had reports of the issue in production. |
| 17:18 |
|
mmorgan left #evergreen |
| 17:23 |
abneiman |
noting for anyone hanging out in IRC this evening - merge pause for main & 3.15 starting at midnight ET tonight in anticipation of the 3.15-rc build tomorrow. Thanks all! |
| 17:28 |
Bmagic |
you bet |
| 17:29 |
jeffdavis |
release_team++ |
| 17:48 |
pinesol |
News from commits: LP2091038 Self check: force light mode; button colors <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=63a2b3e6a3dec545e3bb5da1719824baa7909351> |
| 17:48 |
pinesol |
News from commits: LP2091038 Angular Self Check Usability Issues <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=9f52ac5625bb7cf8c2682b17133ab012663e2c61> |
| 18:09 |
jeff |
Bmagic: added comment to the bug, but are you running that wide holds queue position patch on PostgreSQL <12? |
| 18:10 |
jeff |
I suspect that the CTE behavior between "before 12" and "12 and later" may play a significant role in the performance of the query, due to CTEs being an optimization fence before PG 12. |
| 18:18 |
pinesol |
News from commits: LP#2105602 Default item alert type ignored <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=806866646fff176b1bec3487aa3668c2d8cadbba> |
| 19:01 |
|
jihpringle joined #evergreen |
| 19:18 |
pinesol |
News from commits: LP2101886 Follow-up: lint <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=d1c36459a6e15fe0443dc5e55c638b140c80f5a4> |
| 19:18 |
pinesol |
News from commits: LP#2105906 Follow-up: CSS class cleanup <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=9d15c6cfed1557cf637309b0c8b6c3c7b5aff6d7> |
| 19:18 |
pinesol |
News from commits: LP#2105906 Input Group Button Background Contrast <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=7f2a24cde4dbb7bd0ae2e21f4595d936fa0088ac> |
| 19:26 |
|
jihpringle joined #evergreen |
| 19:44 |
|
jihpringle joined #evergreen |
| 21:18 |
pinesol |
News from commits: LP2091178 Fix Acq providers codes in comboboxes <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=951eec731369ffa6225cef12c3fb4473c35874a9> |
| 21:18 |
pinesol |
News from commits: LP#2098903 Item Status Focus Is After Barcode When Not Found <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=fe5463be4ce73b6cc3cd6031165fba2878addf5f> |
| 21:48 |
pinesol |
News from commits: LP#2103714: Do not decode item fields in marc_export <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=59fe7c70ffef54c5de5140ac1a5e0517f8bbba74> |
| 22:19 |
pinesol |
News from commits: LP2069646: Add a github actions check that the Angular client can compile <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=4c0ed6b480349977b296b74ac7283c56ae75c1e8> |
