Time |
Nick |
Message |
04:17 |
|
dtmoore joined #evergreen |
07:08 |
|
kworstell-isl joined #evergreen |
07:22 |
|
collum joined #evergreen |
07:28 |
|
kworstell_isl joined #evergreen |
07:51 |
|
BDorsey joined #evergreen |
08:33 |
|
mmorgan joined #evergreen |
08:35 |
|
Dyrcona joined #evergreen |
08:38 |
|
rfrasur joined #evergreen |
09:04 |
|
kworstell-isl joined #evergreen |
09:19 |
|
Christineb joined #evergreen |
09:41 |
pinesol |
News from commits: LP #1998494: Angular Holdings Editor: Cannot create empty call numbers <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=53c962f7394bf63cb1941396ac4abca4a05ec32a> |
10:10 |
|
montgoc1 joined #evergreen |
10:36 |
|
kworstell_isl joined #evergreen |
10:41 |
pinesol |
News from commits: LP1940662: Add a --pipe option to marc_export <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=eda46923facdd678fdd45661009ef6073855db84> |
10:41 |
pinesol |
News from commits: LP1814978 Keyboard support for bib record actions <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=3b598ee150ee9b9631a3b3d7a202e3099728e0a0> |
10:46 |
Bmagic |
@karma |
10:46 |
pinesol |
Bmagic: Highest karma: "Dyrcona" (102), "JBoyer" (92), "berick" (76), "gmcharlt" (55), and "mmorgan" (51). Lowest karma: "typos" (-9), "npm" (-2), "oclc" (-2), "irc_memes" (-1), and "errors" (-1). You (Bmagic) are ranked 9 out of 108. |
10:47 |
JBoyer |
Pays to run meetings, I guess. :p |
10:48 |
|
mmorgan1 joined #evergreen |
10:48 |
Dyrcona |
JBoyer++ |
10:48 |
* Dyrcona |
tries to figure out what to break next.... |
10:49 |
Dyrcona |
Maybe Lp 1996818.... |
10:49 |
Bmagic |
@karma Bmagic |
10:49 |
pinesol |
Launchpad bug 1996818 in Evergreen "Issues Placing Holds from the Patron Record, Angular and AngularJS" [High,Confirmed] https://launchpad.net/bugs/1996818 - Assigned to Jason Stephenson (jstephenson) |
10:49 |
pinesol |
Bmagic: Karma for "Bmagic" has been increased 32 times and decreased 0 times for a total karma of 32. |
10:49 |
Bmagic |
just curious :) |
10:49 |
Bmagic |
JBoyer++ |
10:49 |
Dyrcona |
:) |
10:49 |
|
mmorgan2 joined #evergreen |
10:50 |
Dyrcona |
We usually reset the karma at the end of the conference. bshum sent me instructions on how to do it. |
10:51 |
Dyrcona |
@karma bshum |
10:51 |
pinesol |
Dyrcona: Karma for "bshum" has been increased 7 times and decreased 0 times for a total karma of 7. |
10:51 |
Dyrcona |
bshum++ |
10:52 |
* Dyrcona |
rebases a dev branch and gets back to work. |
10:58 |
|
terranm joined #evergreen |
11:24 |
|
BDorsey joined #evergreen |
11:41 |
pinesol |
News from commits: Lp 2008925: Patch Templates Adversely Affected by Lp 1992490 <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=c63403de805049a47f8f43747c492c8a99b78534> |
11:44 |
Dyrcona |
Hmm... I thought pg_dump had an option to truncate tables with --data-only but I don't see it. I'll try with --inserts and --on-conflict-do-nothing. |
11:45 |
berick |
-a / --data-only should work |
11:45 |
* berick |
grabs 1358 |
11:45 |
|
dtmoore joined #evergreen |
11:46 |
Dyrcona |
berick: I'll give it a whirl. |
11:46 |
Dyrcona |
I really only need a few rows from a few tables, but I don't want to build an elaborate qurey. |
11:46 |
Dyrcona |
query.. |
11:48 |
Dyrcona |
hmm.. this is already too big... |
11:48 |
Dyrcona |
And, I should use a non-replica db: pg_dump: detail: Error message from server: ERROR: canceling statement due to conflict with recovery |
11:50 |
Dyrcona |
I'll just see about pulling the data that I need. I've been asked to delete some data from acquisitions and I think I need to modify the function that I wrote for that, so I want to pull the data into a test database to try it out there first. |
12:05 |
|
jihpringle joined #evergreen |
12:11 |
pinesol |
News from commits: LP1989284 Input labels for Manage Authorities <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=582ba4e9761461606db7459360376ac01ca97a91> |
12:11 |
pinesol |
News from commits: LP1997098 Stamping DB Upgrade: PG 15 <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=cce04dcc77309d86ee6a241e8487750e0ef43c60> |
12:11 |
pinesol |
News from commits: LP1997098: Add Support for PostgreSQL 15 <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=d171d708e5f3aae10952912a063db95048f28f28> |
12:14 |
Stompro |
I'm curious if any of you have frozen holds with an expire_time set in your production data? I found a few in mine, but just a handful (19 out of 3000), and bug 1744341 would cause them to be canceled once the date passes. |
12:14 |
pinesol |
Launchpad bug 1744341 in Evergreen "Long-frozen holds skew hold queue position calculation" [Medium,Confirmed] https://launchpad.net/bugs/1744341 - Assigned to Josh Stompro (u-launchpad-stompro-org) |
12:16 |
berick |
Stompro: all expire times for frozen holds are null for us |
12:18 |
Dyrcona |
What berick said goes for us too. |
12:18 |
jeffdavis |
192 frozen holds with non-null expire_time here |
12:19 |
Dyrcona |
berick: I think I'll just use copy with queries to dump only the rows that I need to do my test. |
12:19 |
Stompro |
Great, it probably isn't an issue then, just some strange data in our system. |
12:20 |
Dyrcona |
It might not hurt to add something to the db upgrade to null the expire_time on frozen holds. |
12:20 |
Dyrcona |
jeffdavis just reported having some. |
12:20 |
Stompro |
Sorry, hit enter too soon on that. |
12:22 |
Dyrcona |
There's possibly a different bug there if freezing a hold doesn't update the expire time. |
12:23 |
Stompro |
jeffdavis, what version are you on? |
12:23 |
jeffdavis |
3.9.1 |
12:23 |
berick |
fwiw i only counted non-canceled, non-fulfilled holds |
12:24 |
Dyrcona |
I ran this and got 0: select count(*) from action.hold_request where frozen and expire_time is not null; |
12:24 |
berick |
heh, yeah, 0 with that query too |
12:27 |
jeffdavis |
Still 24 examples if I exclude canceled/fulfilled. The majority are from Nov 2019-Mar 2020 which makes me wonder if a bug got introduced and was then fixed by a subsequent patch? Since then it's only happened once, to a half-dozen holds that were all placed at the same time. |
12:28 |
Stompro |
jeffdavis, I'm also seeing it on a group of holds, customer placed at the same time, so from a book bag most likely. |
12:30 |
Stompro |
But our production DB is on an old version, working on moving to 3.10 here soon. So most likely a bug that has been fixed. I'll look at adding an update script to catch the old instances. |
12:33 |
Stompro |
Thank you all for checking. |
12:41 |
pinesol |
News from commits: LP#1980142: adjust styling of patron message body in Bootstrap OPAC <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=98a5ae9121704f07a13f400c3560c3d79b2e6225> |
12:51 |
Dyrcona |
yeahp. I have to update my purchase_order delete function to remove fund_debits associated with invoice_items. |
12:54 |
Dyrcona |
Bleh... Non-deferred triggers..... |
12:57 |
Dyrcona |
TABLE "acq.invoice_item" CONSTRAINT "invoice_item_fund_debit_fkey" FOREIGN KEY (fund_debit) REFERENCES acq.fund_debit(id) <- Ought to be deferred or "on delete set null...." |
13:18 |
Dyrcona |
Lp 1175740 and Lp 2009066 could possibly be the same bug? |
13:18 |
pinesol |
Launchpad bug 1175740 in Evergreen "Acq: Certain workflows produce orphaned fund debits" [Undecided,Incomplete] https://launchpad.net/bugs/1175740 |
13:18 |
pinesol |
Launchpad bug 2009066 in Evergreen "Can't delete acq.fund-debit linked to acq.invoice_item" [Undecided,New] https://launchpad.net/bugs/2009066 |
13:21 |
|
kworstell-isl joined #evergreen |
13:32 |
Dyrcona |
Also, it seems almost like acq.invoice_item and acq.po_item are redundant, as if maybe they could be combined into 1 table. |
14:29 |
Stompro |
Help me out, AngularJS = older = /eg/ , right? |
14:30 |
Dyrcona |
yeah, AngularJS is older. It's in /eg/staff/ |
14:30 |
Dyrcona |
Angular is in /eg2/ |
14:30 |
Stompro |
Thanks |
15:00 |
|
mmorgan joined #evergreen |
15:13 |
|
terranm joined #evergreen |
15:14 |
|
sleary joined #evergreen |
15:21 |
csharp_ |
@decide eg1 or eg2 |
15:21 |
pinesol |
csharp_: go with eg1 |
15:35 |
Dyrcona |
@decide bug or feature |
15:35 |
pinesol |
Dyrcona: go with feature |
15:40 |
terranm |
lol |
17:04 |
|
mmorgan left #evergreen |
17:07 |
berick |
grep "authtoken" | cut -d':' -f2 | |
17:07 |
berick |
cut -d'"' -f2 |
17:07 |
berick |
heh |
17:08 |
berick |
whatever could I be doing... |
20:30 |
|
dtmoore joined #evergreen |
20:43 |
pinesol |
News from commits: LP2002977 release note <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=839e841300e8b87d03373d407821ca3a6accc2e3> |
20:43 |
pinesol |
News from commits: LP2002977 Flip position of LI alert boxes <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=07490eec1feef745634806828cc6e8cf7ff69715> |