Evergreen ILS Website

IRC log for #evergreen, 2023-03-02

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

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=E​vergreen.git;a=commitdiff;h=53c962​f7394bf63cb1941396ac4abca4a05ec32a>
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=E​vergreen.git;a=commitdiff;h=eda469​23facdd678fdd45661009ef6073855db84>
10:41 pinesol News from commits: LP1814978 Keyboard support for bib record actions <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=3b598e​e150ee9b9631a3b3d7a202e3099728e0a0>
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=E​vergreen.git;a=commitdiff;h=c63403​de805049a47f8f43747c492c8a99b78534>
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=E​vergreen.git;a=commitdiff;h=582ba4​e9761461606db7459360376ac01ca97a91>
12:11 pinesol News from commits: LP1997098 Stamping DB Upgrade: PG 15 <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=cce04d​cc77309d86ee6a241e8487750e0ef43c60>
12:11 pinesol News from commits: LP1997098: Add Support for PostgreSQL 15 <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=d171d7​08e5f3aae10952912a063db95048f28f28>
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=E​vergreen.git;a=commitdiff;h=98a5ae​9121704f07a13f400c3560c3d79b2e6225>
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=E​vergreen.git;a=commitdiff;h=839e84​1300e8b87d03373d407821ca3a6accc2e3>
20:43 pinesol News from commits: LP2002977 Flip position of LI alert boxes <https://git.evergreen-ils.org/?p=E​vergreen.git;a=commitdiff;h=07490e​ec1feef745634806828cc6e8cf7ff69715>

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat