| Time |
Nick |
Message |
| 01:02 |
|
sandbergja__ joined #evergreen |
| 07:06 |
|
rjackson_isl_hom joined #evergreen |
| 07:37 |
|
Dyrcona joined #evergreen |
| 07:45 |
Dyrcona |
https://xkcd.com/2030/ |
| 08:05 |
|
mantis1 joined #evergreen |
| 08:36 |
Dyrcona |
csharp: I'm modifying a copy of that check_notconnected script to check for "no children available" this morning. |
| 08:37 |
csharp |
nice |
| 08:38 |
csharp |
I've applied berick's fix for the settings calls and am watching hopefully |
| 08:40 |
Dyrcona |
Good to know. That's on the batch actions bug, right? |
| 08:41 |
Dyrcona |
I was thinking of trying the patch from bug 1848550 at some point before we upgrade to 3.6. |
| 08:41 |
pinesol |
Launchpad bug 1848550 in Evergreen "Cache settings more aggressively in web client" [Undecided,Fix released] https://launchpad.net/bugs/1848550 |
| 08:45 |
|
tlittle joined #evergreen |
| 08:46 |
|
mmorgan joined #evergreen |
| 08:48 |
|
rfrasur joined #evergreen |
| 08:48 |
Dyrcona |
Results of running the new script on the log file from yesterday at 4PM: CRIT: 20739 no children availables returned this hour: (Top server this hour: 12177 bd1-bh6) |
| 08:52 |
Dyrcona |
!!:$++ :) |
| 08:53 |
Dyrcona |
@karma !!:$ |
| 08:53 |
pinesol |
Dyrcona: Karma for "!!:$" has been increased 1 time and decreased 0 times for a total karma of 1. |
| 08:53 |
Dyrcona |
@karma |
| 08:53 |
pinesol |
Dyrcona: Highest karma: "gmcharlt" (184), "JBoyer" (135), "csharp" (133), "berick" (119), and "Dyrcona" (91). Lowest karma: "comcast" (-3), "typos" (-3), "autogen" (-3), "windows" (-2), and "^" (-2). You (Dyrcona) are ranked 5 out of 189. |
| 09:08 |
|
jvwoolf joined #evergreen |
| 09:12 |
|
nfBurton joined #evergreen |
| 09:22 |
csharp |
comcast-- |
| 09:24 |
|
collum joined #evergreen |
| 09:24 |
|
dbwells joined #evergreen |
| 09:32 |
Dyrcona |
:) |
| 09:48 |
csharp |
berick: so far so good on keeping the open-ils.actor drones tamed - watching carefully over the next couple of hours |
| 09:53 |
berick |
csharp: which patches are installed? |
| 09:54 |
csharp |
just the volcopy one at this point |
| 09:56 |
berick |
k |
| 09:56 |
berick |
csharp++ |
| 09:56 |
csharp |
berick++ |
| 09:58 |
Dyrcona |
csharp | berick: I'm lost. Which patches (link please) are installed? |
| 09:59 |
csharp |
https://bugs.launchpad.net/evergreen/+bug/1896285/comments/8 |
| 09:59 |
pinesol |
Launchpad bug 1896285 in Evergreen "Use batch methods for multi-row grid actions" [Medium,Confirmed] |
| 09:59 |
Dyrcona |
Also, why do we (humans) have to complicate everything? Software just makes it worse. |
| 09:59 |
Dyrcona |
csharp: Muchas gracias! |
| 09:59 |
* csharp |
opens a wishlist bug on Dyrcona's behalf asking that we Simplify Everything |
| 10:00 |
csharp |
Dyrcona: de nada |
| 10:00 |
Dyrcona |
:) |
| 10:00 |
mmorgan |
:) |
| 10:00 |
Dyrcona |
My comment is tangentially related to Evergreen. I'm having a dickens of a time getting Nagios to recognize and report on my new test. |
| 10:00 |
csharp |
ah - yeah |
| 10:01 |
Dyrcona |
But, it's also a more general observation on life. |
| 10:03 |
csharp |
Dyrcona: 42 |
| 10:04 |
mmorgan |
:) |
| 10:05 |
Dyrcona |
csharp++ douglas_adams++ |
| 10:05 |
csharp |
Douglas Adams was a frickin' genius - so absurd and so profound at the same time |
| 10:05 |
Dyrcona |
OK. I think I've figured it out. Looks like there are two configuration files on the nagios server and I edited the bogus one. |
| 10:06 |
mmorgan |
csharp++ |
| 10:07 |
Dyrcona |
Bingo! We have a winner! |
| 10:08 |
|
Cocopuff2018 joined #evergreen |
| 10:12 |
Dyrcona |
csharp: I was recently thinking of writing some parody of the world today but came to the conclusion that reality is now a parody of itself, so writing parody would be redundant. |
| 10:13 |
Dyrcona |
Heh. And, what song just started playing on shuffle: Weid Al's "Dare to be Stupid." Coincidence? |
| 10:16 |
csharp |
Dyrcona: ha! |
| 10:16 |
|
collum joined #evergreen |
| 10:27 |
csharp |
berick: FYI, I've applied the other two fixes too. Watching everything and so far so good |
| 10:27 |
Dyrcona |
csharp++ berick++ |
| 10:28 |
berick |
cool |
| 10:28 |
csharp |
we're seeing high open-ils.circ counts, so we'll see what happens now |
| 10:30 |
csharp |
we really need to make SIPServer report the source IP address - would be so useful when troubleshooting misconfigured clients |
| 10:31 |
berick |
csharp: *cough* bug 1901930 *cough* |
| 10:31 |
pinesol |
Launchpad bug 1901930 in Evergreen "Evergreen SIP2Mediator Support" [Wishlist,New] https://launchpad.net/bugs/1901930 |
| 10:31 |
csharp |
berick: heh - I honestly wasn't thinking about that at all :-) |
| 10:33 |
csharp |
I'll install that on my master server this week and put it through a test |
| 10:35 |
berick |
that would be awesome |
| 10:50 |
Dyrcona |
Hmm. A email from one of my favorite restaurants, sent from a domain with no A nor C record, and a return email address in a Sao Tome and Principe domain whos MX points to mailgun.com....Looks legit! :) |
| 10:54 |
Dyrcona |
Ah, sendgrid.... You're too clever for your own good. :) |
| 10:54 |
berick |
i think a Mail Trebuchet would be better for large boxes |
| 10:55 |
Dyrcona |
:) |
| 11:01 |
Dyrcona |
It's probably not worth the 56 mile round trip to order Christmas dinner. |
| 11:13 |
csharp |
berick: after about 45 minutes of running all three patches, logs are clear and not seeing high drone counts anywhere at the moment |
| 11:14 |
csharp |
if things hold through this afternoon, I'll sign off on all three |
| 11:19 |
Dyrcona |
I'm also looking at those patches, and some of them don't apply to 3.2.10, but that's to be expected. |
| 11:20 |
Dyrcona |
Also, we can go a long time without having issues. I'm not sure 45 minutes is a valid test, though it is long enough to determine if the patches are causing other issues. |
| 11:20 |
csharp |
agreed |
| 11:21 |
csharp |
it appears that our major issues were being caused by batch add of copies to a volume, which doesn't happen constantly at the scale that causes a problem |
| 11:22 |
csharp |
which is why this has been hard to troubleshoot |
| 11:23 |
Dyrcona |
Yeah. |
| 11:23 |
Dyrcona |
That volcopy patch applies cleanly to 3.2.10. Doesn't mean it actually works, but I'm setting up a test VM so someone can see if stuff is broken after. |
| 11:24 |
berick |
also note the batch copy scenario only comes into play when adding copies whose circ lib is not the workstation org unit |
| 11:25 |
csharp |
oh good to know |
| 11:25 |
csharp |
and why it would affect PINES and maybe not others since we enforce centralized cataloging at every system |
| 11:26 |
Dyrcona |
We have some libraries that do that, I think. |
| 11:26 |
Dyrcona |
The person who would know for sure is out this week. :) |
| 12:00 |
Dyrcona |
And the new no children available script is working already. |
| 12:04 |
|
jihpringle joined #evergreen |
| 12:08 |
Dyrcona |
I suspect that I will find out that this occurs more frequently than I thought. |
| 12:16 |
Dyrcona |
So, the patron bucket patch appears to work on 3.2.10. I just added 138 patrons to a bucket and only 1 extra circ drone was started. |
| 12:16 |
Dyrcona |
berick++ |
| 12:17 |
Dyrcona |
I'm going to compare this on an unpatched VM. |
| 12:24 |
Dyrcona |
Ah, interesting. The unpatched VM didn't get more circ drones running, but it did get 31 cstore drones whereas the patched VM still has our minimum of 5. |
| 12:24 |
Dyrcona |
Looks good to me. |
| 12:32 |
mmorgan |
berick++ csharp++ Dyrcona++ |
| 12:43 |
Dyrcona |
Actually, I think I'll just go ahead and test patron bucket add on 3.6.1 and do a signoff branch if it works. Hope I'm not stepping on csharp's toes! |
| 12:54 |
Dyrcona |
I wonder how much difference that patch makes on 3.6.1. I'm at 29 cstore drones after the patch. |
| 12:54 |
Dyrcona |
Circ drones remains unchanged at 1 pre and post patch. |
| 12:55 |
Dyrcona |
And, yeahp, I cleared all site data between the two tests, not just the cache. |
| 12:56 |
Dyrcona |
I'll leave things as they are. I still think the patch can make a difference. |
| 12:57 |
* Dyrcona |
decides to finally break for lunch by taking the dog for a walk. |
| 13:11 |
|
eady joined #evergreen |
| 13:16 |
csharp |
Dyrcona: I haven't gotten there yet - my toes are safe :-) |
| 13:42 |
Dyrcona |
:) |
| 14:06 |
|
sandbergja_ joined #evergreen |
| 14:09 |
Dyrcona |
And, yes, we're getting no children available more often than I thought. |
| 14:16 |
|
rlefaive joined #evergreen |
| 14:36 |
|
nfBurton joined #evergreen |
| 14:49 |
rlefaive |
Hi evergreeners, just a big thank you to Dyrcona for the forgive_fines.pl script (2020-03-18) and mmorgan for the queries for forgiving fines with staging tables (2020-03-08). |
| 14:51 |
mmorgan |
rlefaive: Glad they were useful! |
| 14:51 |
rlefaive |
To also apply the changs to ongoing transactions, I’m looking in action.circulation and there’s redundant info - the recurring_fine column names the recurring amount, but there’s a column also for the recurring_fine_rule. If i edit these, uh, how likely will things explode? ;) |
| 14:51 |
Dyrcona |
rlefaive++ |
| 14:53 |
jihpringle |
rlefaive - complete guess but could the recurring_fine column be recording the actual fine being assessed and the recurring_fine_rule be listing the rule itself which has 3 values for the different fine levels? |
| 14:53 |
rlefaive |
jihpringle++ yes, that’s it. thank you! |
| 14:53 |
jihpringle |
np :) |
| 14:53 |
* mmorgan |
has edited the recurring_fine column in action.circulation without a problem. Would not expect a problem editing recurring_fine_rule either. |
| 14:54 |
Dyrcona |
jihpringle and mmorgan are correct. You can change the recurring_fine value and nothing blows up. |
| 14:54 |
Dyrcona |
It is used to calculate fines. The rule column is mostly ignored. |
| 14:55 |
mmorgan |
recurring_fine_rule is actually the name of the rule. It's not necessary to change that, unless you like things tidy. Er, what Dyrcona said :) |
| 14:59 |
rlefaive |
lol, thank you Dyrcona and mmorgan. The ‘three fine levels’ thing clued me in - theres only one case where we have them different. |
| 15:11 |
|
Cocopuff2018 joined #evergreen |
| 15:29 |
|
nfBurton28 joined #evergreen |
| 15:41 |
|
jvwoolf left #evergreen |
| 15:42 |
csharp |
berick: I think you've Saved Christmas with those batch action fixes |
| 15:42 |
csharp |
berick++ |
| 15:43 |
* csharp |
writes script for claymation family special where we all learn the value of Evergreen |
| 15:43 |
csharp |
I guess Community already did that joke, but it's still funny |
| 16:12 |
|
mantis1 left #evergreen |
| 16:32 |
Bmagic |
what does it mean when you have an EDI INVOIC message that is recorded into acq.edi_message and clearly shows the purchase order to which it belongs but there are no matching acq.invoice_entry ? |
| 16:34 |
|
nfBurton88 joined #evergreen |
| 16:36 |
Bmagic |
nvm, I found the invoice in acq.invoice but it's attached to a completely wrong PO... how is that possible? The PO ID number that the invoice is attached to is not the same PO number that is recorded in edi_message... The ID number IS however suspiciously the same ID number as the provider.... |
| 16:39 |
Bmagic |
It seems that Evergreen decided to write the rows to acq.invoice as a result of processing the EDI INVOIC, but attached to the wrong PO (one from 2013, bizarely baring the same ID number as the provider ID number) |
| 16:53 |
Dyrcona |
Bmagic: Bad data from the vendor or the original PO, maybe? |
| 16:54 |
Bmagic |
The JEDI indicates the correct PO though |
| 16:55 |
Bmagic |
as does the purchase_order column in acq.edi_message |
| 16:56 |
Bmagic |
in other words: it seems that the EDI message did get translated to the right PO number, but for some reason, the rows in acq.invoice_entry were not recorded onto the same PO as edi_message would indicate (correctly) |
| 16:57 |
Dyrcona |
Is this Baker & Taylor? |
| 16:57 |
Bmagic |
ingram |
| 16:57 |
Dyrcona |
Dunno, then. |
| 16:58 |
Dyrcona |
B&T has a limit on numbers. |
| 16:58 |
pastebot |
"Bmagic" at 168.25.130.30 pasted "Query to find mis-matched EDI invoices to POs" (11 lines) at http://paste.evergreen-ils.org/10066 |
| 16:58 |
Bmagic |
Dyrcona: ^^ does that query return anything for you? |
| 17:00 |
Dyrcona |
I'm actually clocked out and don't feel like firing up a tunnel to a db server. |
| 17:00 |
Bmagic |
haha! no problem, "a tomorrow thing" |
| 17:00 |
Bmagic |
Thanks for listening :) |
| 17:01 |
Dyrcona |
I think we may have had this issue reported to us once in the past, but not very often. |
| 17:01 |
Bmagic |
it started with "I've recieved my stuff and I have an invoice in hand, but Evergreen doesn't have it...." |
| 17:11 |
|
mmorgan left #evergreen |
| 17:58 |
|
nfBurton28 joined #evergreen |
| 18:01 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 18:04 |
|
sandbergja_ joined #evergreen |
| 18:43 |
|
jihpringle joined #evergreen |
| 20:01 |
|
sandbergja joined #evergreen |
| 21:04 |
|
sandbergja joined #evergreen |
| 23:44 |
|
mrisher joined #evergreen |
