| 06:01 |
pinesol |
News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//archive/2022-06/2022-06-09_04:00:02/test.49.html> |
| 07:28 |
|
collum joined #evergreen |
| 07:33 |
|
rjackson_isl_hom joined #evergreen |
| 07:48 |
|
rjackson_isl_hom joined #evergreen |
| 09:25 |
|
mantis1 joined #evergreen |
| 09:30 |
|
jvwoolf left #evergreen |
| 09:31 |
|
jvwoolf joined #evergreen |
| 09:58 |
mantis1 |
I upgraded one of our test servers from 3.6.5 to 3.9. Has anyone had weird spacing problems in the Boopac after an upgrade? I have no idea why it's spacing out so much like it is. There is a width=device-width element added in base.tt2, but it doesn't seem to make a difference if it's deleted or not. |
| 10:37 |
|
mantis2 joined #evergreen |
| 10:38 |
csharp_ |
mantis1: is it stock EG or did you apply customizations on top of the upgrade? |
| 10:39 |
csharp_ |
(or conversely, applied stock EG stuff on top of your customized stuff?) |
| 17:02 |
csharp_ |
I'm on at&t, which while not awesome either, at least it's not comcast :-) |
| 17:21 |
mmorgan |
not_comcast++ |
| 17:28 |
|
mmorgan left #evergreen |
| 18:01 |
pinesol |
News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//archive/2022-06/2022-06-09_16:00:02/test.49.html> |
| 20:14 |
jeffdavis |
the 34-lp1787968-cover-uploader.t live test is failing with a 404 on http://127.0.0.1/jacket-upload |
| 20:16 |
jeffdavis |
29-lp1817645-remoteauth-patron-api.t also does HTTP requests, but that test is actually being skipped right now because the test environment's version of LWP::Protocol::https is not >=6.0.7 |
| 20:19 |
jeffdavis |
and 24-offline-all-assets.t (which does a wget on https://localhost/eg/staff/offline-interface) technically isn't failing but I'm not sure the test is robust - in an environment with an nginx proxy, the test will pass if apache isn't running because the response is a 502 error and the test only checks for 404 |
| 20:20 |
jeffdavis |
I'm also not really sure that the wget output is being parsed properly |
| 20:22 |
jeffdavis |
in other words, none of the 3 live tests that do direct HTTP requests against the test server are really "working" |
| 20:23 |
jeffdavis |
something to fix at the hackfest maybe? |
| 02:50 |
|
berick joined #evergreen |
| 06:00 |
pinesol |
News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//archive/2022-06/2022-06-08_04:00:02/test.49.html> |
| 07:25 |
|
rjackson_isl_hom joined #evergreen |
| 07:49 |
|
collum joined #evergreen |
| 08:05 |
|
RFrasur joined #evergreen |
| 15:19 |
Dyrcona |
People do get uptight about the queue order, but it's just a guess at best. |
| 15:19 |
mmorgan |
We're not using a soft regarget interval. Maybe that would help. |
| 15:21 |
Dyrcona |
We've experimented with every half hour, every 15 minutes, etc. Then, it started running into itself and it ended up being 1/hour effectively. We skip the hours between midnight and 6:00 am to avoid the overnight jobs that run during those hours. |
| 15:22 |
Dyrcona |
The soft retarget interval might help. John Amundson could probably tell you better why we use it because it was his testing that made us decide on that value. I forget exactly why we ended up with that value. |
| 15:23 |
* mmorgan |
would thing you could end up with a LOT more holds being retargeted using a soft interval. |
| 15:25 |
Dyrcona |
Our "normal" retarget interval is 48 hours to keep things on pull lists a little bit longer. |
| 15:25 |
Dyrcona |
We'd typically see the running into itself happen for a day or so after an upgrade, then it just kept up (probably because of the soft interval), so we changed the schedule. |
| 17:09 |
|
mmorgan left #evergreen |
| 17:14 |
jeffdavis |
hm, that doesn't work for me unfortunately |
| 17:17 |
jeffdavis |
we're using skins, I wonder if that is causing trouble |
| 18:00 |
pinesol |
News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//archive/2022-06/2022-06-08_16:00:03/test.49.html> |
| 22:45 |
jeff |
jeffdavis: do you see the text-white class in the output html and it isn't working, or does that class not make it to the html seen by the browser? |
| 06:01 |
pinesol |
News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//archive/2022-06/2022-06-03_04:00:04/test.49.html> |
| 07:16 |
|
rjackson_isl_hom joined #evergreen |
| 07:42 |
|
collum joined #evergreen |
| 08:05 |
|
RFrasur joined #evergreen |
| 12:34 |
* pinesol |
brews and pours a cup of Colombia Huila Supremo, and sends it sliding down the bar to Character Set |
| 14:14 |
jeffdavis |
unapi.metabib_virtual_record_feed is incredibly slow in our production database: ~30 seconds to return results for 10 records, ~2s for a single record. In a Concerto db I get results for 10 records in less than 1s. |
| 14:27 |
Dyrcona |
Probably needs an index on something. |
| 15:22 |
jeffdavis |
No, it's weirder than that I think. |
| 15:22 |
jeffdavis |
It's actually the call to unapi.mmr_holdings_xml from within unapi.metabib_virtual_record_feed that's slow. |
| 15:23 |
jeffdavis |
unapi.mmr_holdings_xml takes ~23s for my test query ... but an SQL query that ought to be equivalent to that function takes <1s |
| 15:25 |
Dyrcona |
You say the query is "equivalent." Is it identical to the one used in the function? |
| 15:29 |
jeffdavis |
looks like our version of unapi.mmr_holdings_xml uses evergreen.array_remove_item_by_value in a few places instead of array_remove |
| 15:30 |
jeffdavis |
I'll see if I can make things more exact |
| 16:24 |
Dyrcona |
I think you alter the function to change the owner. |
| 16:25 |
Dyrcona |
Yeah, ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] OWNER TO { new_owner | CURRENT_USER | SESSION_USER } |
| 16:27 |
|
jvwoolf left #evergreen |
| 16:28 |
jeffdavis |
unfortunately it doesn't help - changed the owner to evergreen in a test env and the function is still slow |
| 16:32 |
jeffdavis |
modifying it to use array_remove doesn't help either |
| 16:36 |
Dyrcona |
That's puzzling. It seems like a crazy hit to take for calling a function. |
| 16:40 |
jeffdavis |
yeah seems to be 2.5s per item in the array |
| 16:43 |
Dyrcona |
jeffdavis: You could try asking in #postgresql. Somebody there might have some idea what's going on. |
| 16:44 |
jeffdavis |
Good idea. Thanks for the help! |
| 16:59 |
|
mmorgan left #evergreen |
| 18:00 |
pinesol |
News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//archive/2022-06/2022-06-03_16:00:02/test.49.html> |
| 06:02 |
pinesol |
News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//archive/2022-06/2022-06-02_04:00:04/test.49.html> |
| 07:17 |
|
rjackson_isl_hom joined #evergreen |
| 08:07 |
|
rfrasur joined #evergreen |
| 08:29 |
|
mantis1 joined #evergreen |
| 12:22 |
|
collum joined #evergreen |
| 12:37 |
Dyrcona |
We started getting reports of bug 1976403 yesterday: one yesterday and one today so far. |
| 12:37 |
pinesol |
Launchpad bug 1976403 in Evergreen "Advanced search checkboxes missing / incorrectly positioned in Bootstrap OPAC" [High,Confirmed] https://launchpad.net/bugs/1976403 |
| 13:05 |
Dyrcona |
jeff's workaround of removing form-check-input works on my test vm. I think I'll throw this in production later. |
| 13:13 |
jeffdavis |
We've got a local customization that shows global "news" updates on the splash page. The implementation isn't right for general use (the content is pulled from an external source and displayed in an iframe) but it's a feature we'd like to see in stock EG. Not sure if it serves precisely the same function as a maintenance message would. |
| 13:14 |
Dyrcona |
jeffdavis: My mind was moving toward something more generic than just a message thing. I was heading toward a message of the day feature with expiration dates, etc. |
| 13:15 |
Dyrcona |
With the possibility of having multiple messages display based on org unit hierarchy as well and some way to provide the messages in multiple/appropriate languages. |
| 15:04 |
|
jonadab joined #evergreen |
| 16:05 |
|
jvwoolf1 left #evergreen |
| 17:21 |
|
mmorgan left #evergreen |
| 18:01 |
pinesol |
News from qatests: Failed Running perl live tests <http://testing.evergreen-ils.org/~live//archive/2022-06/2022-06-02_16:00:01/test.49.html> |
| 18:18 |
jeffdavis |
last couple of comments on bug 1820381 are interesting to see |
| 18:18 |
pinesol |
Launchpad bug 1820381 in Evergreen "Staff login, Admin menu shows but. Login windows reamain" [Undecided,Invalid] https://launchpad.net/bugs/1820381 |