Evergreen ILS Website

IRC log for #evergreen, 2020-12-03

| 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
00:40 michelle joined #evergreen
01:13 jonadab joined #evergreen
02:42 abowling left #evergreen
04:55 pinesol News from qatests: Failed Installing OpenSRF pre-requisites <http://testing.evergreen-ils.org/~live//arch​ive/2020-12/2020-12-03_04:00:03/test.7.html>
06:09 dbwells joined #evergreen
06:59 alynn26 joined #evergreen
08:08 rfrasur joined #evergreen
08:19 alynn26 good mornign
08:20 collum joined #evergreen
08:39 rfrasur g'morning.
08:42 mantis2 joined #evergreen
08:42 mmorgan joined #evergreen
09:00 rhamby morning
09:02 Dyrcona joined #evergreen
09:13 mmorgan @coffee [someone]
09:13 * pinesol brews and pours a cup of Panama Elida Estate, and sends it sliding down the bar to rhamby
09:13 rhamby coffee good
09:14 mmorgan @coffee
09:14 * pinesol brews and pours a cup of Belle Espresso, and sends it sliding down the bar to mmorgan
09:14 mmorgan Espresso better!
09:17 Dyrcona :)
09:26 rhamby I'd have to go to the kitchen for espresso....
09:29 rjackson_isl_hom joined #evergreen
09:54 berick @dessert
09:54 * pinesol grabs some candy from krvmga's desk for berick
09:55 Cocopuff2018 joined #evergreen
10:18 abowling joined #evergreen
10:23 csharp @seen krvmga
10:23 pinesol csharp: krvmga was last seen in #evergreen 1 year, 35 weeks, 1 day, 1 hour, 3 minutes, and 25 seconds ago: <krvmga> i'm not sure if i'm missing something or if it's just not possible
10:23 csharp @tea [someone]
10:23 * pinesol brews and pours a pot of Bangkok, and sends it sliding down the bar to awitter (http://ratetea.com/tea/harney/bangkok/2217/)
10:25 awitter I'll take it :-)
11:14 collum joined #evergreen
11:16 pinesol [evergreen|Dan Briem] LP#1778522 Precat item creation should be more intentional - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=d0a04a6>
11:24 Dyrcona csharp: Looking for krvmga for some reason?
11:28 csharp Dyrcona: nah - just hadn't seen him in a while :-)
11:33 Dyrcona He retired in 2019.
11:46 Dyrcona Hmm.. Got this from autogen.sh: Bad arg length for Socket::pack_sockaddr_in, length is 0, should be 4 at /usr/lib/x86_64-linux-gnu/perl/5.22/Socket.pm line 156.
11:49 Dyrcona Services are running, and I can connect to the database.
11:51 Dyrcona It' blowing up on this line: perl -MOpenILS::Utils::Configure -e "OpenILS::Utils::Configure::org_tree_js('$JSDIR', 'OrgTree.js');"
11:53 Dyrcona Oh. I suspect that I need to fix the memcached info in opensrf.xml.
11:54 Dyrcona Yeah. What works in production doesn't work here. :)
12:00 rhamby just throwing this out there,, I'm tempted to say google analytics should be moved to an org unit seting instead of a being in config.tt2, not worth it due to upgrade hassles?
12:00 rhamby thoughts?
12:03 JBoyer rhamby, seems like a +1 to me. GA and Matomo might still be worth keeping in a separate .tt2 in case there's cause to customize them, but they may as well always be included and then enabled/disabled according to a setting most admins can actually reach.
12:39 rhamby that was my thought as well, I'll file the bug and plan to work on it but not really high priority
12:58 sandbergja joined #evergreen
13:30 terranm joined #evergreen
13:44 rjackson_isl_hom Sorry to come here with my troubles but our consortium just upgraded to 3.4 and we now are seeing issues with old reports as follows
13:44 rjackson_isl_hom DBD::Pg::st execute failed: ERROR:  could not access file "$libdir/plperl": No such file or directory at /openils/bin/clark-kent.pl line 255.
13:44 rjackson_isl_hom is this because the report templates need to be recreated as a result of the upgrade or something is broken in our install?
13:47 csharp rjackson_isl_hom: select * from pg_language ; - does that show plperl?
13:48 csharp if not, create or replace language plperl; should do it I think
13:48 rjackson_isl_hom shows plperl and 5 others
13:49 rjackson_isl_hom including plperlu
13:49 csharp if that doesn't work, verify that postgresql-plperl-<version> (postgresql-plperl-9.6 in our case) is installed
13:49 csharp dpkg -l | grep plperl
13:50 csharp (from bash, not psql, of course :-))
13:50 Dyrcona rjackson_isl_hom: Do you have a separate db server for reports? If so, check both them.
13:51 rjackson_isl_hom that returns nada on reporter-prod server
13:52 Dyrcona Well, you need to install the plperl package. Did you upgrade the O/S at the same time?
13:52 Dyrcona I've seen that happen when upgrading Ubuntu with the PGDG repositories.
13:52 rjackson_isl_hom I think alynn26 did
13:53 rjackson_isl_hom so the perl pack needs installed most likely
13:53 rjackson_isl_hom ++ everyone in the big wide Evergreen support/community!
13:53 Dyrcona postgresql-plperl-$version
13:53 csharp yeah, you may need to update /etc/apt/sources.list.d/pgdg.list (or whatever the file is actually named) to the version of ubuntu you're on and uncomment the line
13:54 Dyrcona Oh, yeah. That, too....
13:56 Dyrcona DB upgrades are the funnest.
14:01 dluch Reminder for anyone coming to the DIG meeting today that we're on Zoom this time!
14:01 csharp @who's zoomin' [who]
14:01 pinesol csharp: Have you confirmed your ISBN SPIDs with your service provider?
14:02 csharp @who 's zoomin' [who]
14:02 pinesol abneiman 's zoomin' (who [<channel>] <question>) -- Answers <question> with a random nick from <channel>. <channel> is only necessary if the message isn't sent in the channel itself.
14:03 abneiman oh man I am actually literally zoomin' with the DIG people RIGHT NOW
14:03 dluch lol
14:03 berick @who 's zoomin DIG
14:03 pinesol jonadab 's zoomin DIG.
14:05 csharp can't believe it took me until today to connect that song to this year
15:18 Dyrcona Ha! A song called "3:15" just started playing on my playlist.
15:18 rhamby heh
15:18 Dyrcona "It's 3:15 in the afternoon. It's my only passion."
15:46 mantis2 left #evergreen
16:32 dbwells joined #evergreen
16:35 dbwells joined #evergreen
16:40 sandbergja joined #evergreen
17:12 mmorgan left #evergreen
17:22 dbwells joined #evergreen
17:23 dbwells joined #evergreen
17:42 dbwells joined #evergreen
18:01 dbwells joined #evergreen
18:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
18:13 dbwells joined #evergreen
18:18 rjackson_isl_hom for any late night owls still on here having a terrible time trying to get triggered events created for our Daily autorenewals after upgrade to 3.4
18:19 rjackson_isl_hom looking t the logs I see the creates rolling by for the event definitions related to autorenewals
18:19 rjackson_isl_hom but the action_trigger.event keys being shown are not actually created in the db?
18:19 rjackson_isl_hom no errors AFAIK in log file for this run
18:21 rjackson_isl_hom should the ids shown be created simultaneously, or, are they in a transaction awaiting commit (would be huge I would think if so)
18:25 rjackson_isl_hom sorry guess I needed to wait it out - they now show in the db - must have been a big commit!
20:04 sandbergja joined #evergreen
20:45 csharp rjackson_isl_hom: if you're still around, I have found this query to be helpful: https://pastebin.com/UjU1t3hc
20:45 csharp you can throw that in a file with the correct event_def ID in the where clause, and use "watch" to track progress through the DB
20:46 csharp e.g. "watch psql -U evergreen -f watch_at_events.sql"
20:47 csharp but yeah, there's a big query at the start of the run that can take a while, then it should start creating events, then batching them together ("collecting"/"collected"), then finally processed ("complete"/"invalid")
21:35 sandbergja joined #evergreen
22:19 rjackson_isl_hom csharp++ - there are over 14k to process for today
22:21 rjackson_isl_hom whoops - I meant 34K! Don't think they are going to finish before midnight either
22:53 sandbergja joined #evergreen

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