| Time |
Nick |
Message |
| 03:55 |
|
jmurray-isl joined #evergreen |
| 04:05 |
|
jmurray-isl joined #evergreen |
| 08:40 |
|
mmorgan joined #evergreen |
| 10:23 |
|
Dyrcona joined #evergreen |
| 10:50 |
Dyrcona |
Does anyone have postgresql optimization suggestions to speed up search? |
| 10:58 |
|
Christineb joined #evergreen |
| 11:25 |
* Dyrcona |
tries configuring hugepages. |
| 11:28 |
Dyrcona |
Whoa... 66966... |
| 11:32 |
Dyrcona |
That one takes a long time to take effect |
| 11:34 |
Dyrcona |
c. 132GB of huge tables... |
| 11:34 |
Dyrcona |
Sounds about right. :) |
| 11:38 |
Dyrcona |
And, search still times out |
| 11:39 |
abneiman |
Announcing that there will be a merge pause starting at 11pm ET this evening, in order to build & cut point releases tomorrow for 3.15, . I have talked with gmcharlt about the forthcoming security fixes and he will be assisting witl |
| 11:39 |
abneiman |
nah |
| 11:39 |
abneiman |
*3.15, 3.16, and 3.17 |
| 11:39 |
abneiman |
and Galen will be assiting with all three releases |
| 11:42 |
Dyrcona |
abneiman++ gmcharlt++ |
| 11:42 |
Dyrcona |
Gah! why is search slow? |
| 11:45 |
Dyrcona |
It's getting to be too hot out here. I'm going back inside. |
| 11:48 |
|
jihpringle joined #evergreen |
| 12:58 |
Dyrcona |
Plain old multiclass search call times out at 70 seconds.... |
| 12:59 |
Dyrcona |
I've optimized the server as much as I think I can. Not sure what other buttons to push. |
| 13:03 |
Dyrcona |
Ah.. open-ils.search.biblio.multiclass.query returns in 3 seonds with results. |
| 13:05 |
Dyrcona |
It returns an object... I thought it was an array of arrays. |
| 13:06 |
jeff |
ah, one of history's classic blunders. |
| 13:07 |
Dyrcona |
Documentation lies... Comments lie. |
| 13:15 |
Dyrcona |
Well... maybe it's not the documentation that lies. It's my mind playing tricks. I had it configured correctly in the upgrade script. |
| 13:17 |
Dyrcona |
So mutliclass.query is faster than plain old open-ils.search.biblio.multiclass |
| 13:21 |
Dyrcona |
Ooh. I'm geting an internal server error when logging out. I wonder if I broke something. |
| 13:28 |
Dyrcona |
I don't think it is my fault: {"errors":[{"message":"Expected object - got string.","path":"\/body"}],"status":500} |
| 13:32 |
Dyrcona |
Ok. fixed it. Think this might be a bug. |
| 13:35 |
Dyrcona |
Yeahp. I'll add it to Lp later. |
| 13:39 |
Dyrcona |
And "fixing" that reveals another potential bug. |
| 14:00 |
Dyrcona |
OMG... Change vm.overcommit_memory while a pingest is running and it blows up.... "error out of memory" |
| 14:01 |
Dyrcona |
ugh... |
| 14:01 |
Dyrcona |
can't run anything: "fork: cannot allocate memory" |
| 14:02 |
Dyrcona |
Guess vm.overcommit_memory really does need to be 1, not 2. |
| 14:03 |
Dyrcona |
Can't even reboot it or stop anything. |
| 14:04 |
Dyrcona |
Guess I just have to wait. |
| 14:08 |
Dyrcona |
If it ain't broke, don't fix it..... |
| 14:13 |
Dyrcona |
It's hosed.... |
| 15:41 |
Dyrcona |
@later tell goood Here's a branch with a cleanup commit of the "final" product: https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/dyrcona/lp2150148-openapi-search-apis |
| 15:41 |
pinesol |
Dyrcona: The operation succeeded. |
| 15:45 |
goood |
Dyrcona++ |
| 17:03 |
|
mmorgan left #evergreen |
