| Time |
Nick |
Message |
| 07:12 |
|
kworstell-isl joined #evergreen |
| 07:41 |
|
kworstell_isl joined #evergreen |
| 07:44 |
|
kworstell-isl joined #evergreen |
| 07:51 |
|
BDorsey joined #evergreen |
| 07:52 |
|
mantis1 joined #evergreen |
| 07:54 |
mantis1 |
Did anyone see the latest South Park? |
| 07:54 |
mantis1 |
Had an interesting take on open source/open AI text generating |
| 08:03 |
|
collum joined #evergreen |
| 08:36 |
|
mmorgan joined #evergreen |
| 09:49 |
|
rfrasur joined #evergreen |
| 09:52 |
|
Dyrcona joined #evergreen |
| 10:03 |
Dyrcona |
I've got 45 auto-renewal events that have a state of 'reacting' from Wednesday morning. The renewals were successful. I'd like to trigger the events to send the emails before noon if I can. Has anyone done that before or have any suggestions? I am looking through the trigger code but don't have a solution, yet. |
| 10:07 |
Dyrcona |
Hmm. Looks like I might be able to do it with some Perl, but it will be kind of complicated. I probably won't be able to complete it in less than 2 hours, particularly with a call coming up at 10:30. |
| 10:07 |
mmorgan |
Dyrcona: so there were no Autorenew notify events created? |
| 10:08 |
Dyrcona |
mmorgan: Y'know, that's a good question, I didn't actually check. Perhaps I should. |
| 10:09 |
Dyrcona |
I just assumed there weren't any because the events were "reacting" and not "complete." |
| 10:11 |
Dyrcona |
mmorgan++ |
| 10:12 |
Dyrcona |
One of them is there, I'll have to check the others. Looks like I may just have to update the autorenew events to state='complete'. |
| 10:13 |
mmorgan |
Easy fix! |
| 10:16 |
Dyrcona |
Yeah. I'll set complete_time to the create_time of the corresponding autorenewnotify event. |
| 10:17 |
Dyrcona |
Thanks, mmorgan! I was probably going to get there eventually, but your suggestion got me there sooner. |
| 10:17 |
Dyrcona |
I also have a query to check for the notify events for when this happens again. In the past, the events have usually been stuck at 'collected' state. |
| 10:18 |
* mmorgan |
was going to suggest inserting Autorenew notify events directly into the table, but that's not necessary in your case. |
| 10:31 |
Dyrcona |
Well, if I had to do that, I was going to use Perl with DBI to figure out the user data for the autorenew notify events, and then use open-ils.trigger.event.autocreate to make the notify events. |
| 10:31 |
|
ahazaril joined #evergreen |
| 10:32 |
ahazaril |
I'm having difficulty to import MARC Records. Evergreen version that I used are 3.9.1. I follow the manual exactly. I tried on test server (https://bugsquash.mobiusconsortium.org/eg/staff) seems successfully, but when I tried using our Library Server, its shown error. |
| 10:32 |
ahazaril |
Any advice regarding this problems? |
| 10:32 |
ahazaril |
Here the osrfsys.log file |
| 10:32 |
ahazaril |
[2023-03-10 20:30:14] open-ils.vandelay [INFO:6795:CStoreEditor.pm:155:1678451399712214] editor[1|1] request en-US open-ils.cstore.json_query.atomic {"select":{"au":[{"column":"id","transform":"permission.usr_has_object_perm","params":["CREATE_BIB_IMPORT_QUEUE","vbq",4,"1"],"alias":"has_perm"}]},"where":{"id":"1"},"from":"au"} |
| 10:32 |
ahazaril |
open-ils.cstore 2023-03-10 20:30:14 [INFO:6996:osrf_application.c:1075:1678451399712214] CALL: open-ils.cstore open-ils.cstore.json_query.atomic {"from":"au","where":{"id":"1"},"select":{"au":[{"transform":"permission.usr_has_object_perm","column":"id","alias":"has_perm","params":["CREATE_BIB_IMPORT_QUEUE","vbq",4,"1"]}]}} |
| 10:32 |
ahazaril |
open-ils.cstore 2023-03-10 20:30:14 [INFO:6996:osrf_app_session.c:1181:1678451399712214] [open-ils.cstore] sent 385 bytes of data to opensrf private.localhost/open-ils.vandelay_drone_at_localhost_6795 |
| 10:32 |
ahazaril |
open-ils.cstore 2023-03-10 20:30:14 [INFO:6996:osrf_stack.c:163:1678451399712214] Message processing duration 0.006715 |
| 10:32 |
ahazaril |
[2023-03-10 20:30:14] open-ils.vandelay [INFO:6795:CStoreEditor.pm:155:1678451399712214] editor[1|1] json_query : returned 1 result(s) |
| 10:32 |
ahazaril |
[2023-03-10 20:30:14] open-ils.vandelay [ERR :6795:Vandelay.pm:272:1678451399712214] unable to read MARC file /tmp/bc98fed09b3081514035f98464280b7c.mrc |
| 10:32 |
ahazaril |
[2023-03-10 12:30:14] open-ils.vandelay [INFO:6795:Transport.pm:163:1678451399712214] Message processing duration: 0.137 |
| 10:32 |
ahazaril |
open-ils.cstore 2023-03-10 20:30:14 [INFO:6996:osrf_stack.c:163:1678451399712214] Message processing duration 0.000004 |
| 10:33 |
berick |
ahazaril: see this https://bugs.launchpad.net/evergreen/+bug/1855199 |
| 10:33 |
pinesol |
Launchpad bug 1855199 in Evergreen "Vandelay record queuing can fail if spool directory is /tmp" [Medium,Confirmed] |
| 10:34 |
ahazaril |
tq berick & pinesol! |
| 11:11 |
Dyrcona |
ahazaril: I usually set the temp directory to /openils/var/tmp. |
| 11:11 |
Dyrcona |
Oops. |
| 11:11 |
* Dyrcona |
was distracted. |
| 11:15 |
|
Christineb joined #evergreen |
| 11:25 |
* Dyrcona |
installs updates on the laptop. |
| 12:21 |
|
Dyrcona joined #evergreen |
| 13:59 |
Dyrcona |
Bmagic: Ping |
| 13:59 |
Bmagic |
pong |
| 14:07 |
Dyrcona |
Bmagic++ :) |
| 14:07 |
* Dyrcona |
had a question about some monitoring and got a satisfactory answer. |
| 14:15 |
Bmagic |
mantis1: funny you should mention South Park, I was just re-watching the first episode last night! And I've not seen one in many many years. Still good. |
| 14:34 |
* Dyrcona |
scratches his head at how offline mode is going to use an org. unit setting that it can't look up if the system truly is offline. |
| 14:37 |
Dyrcona |
It might be cached, I suppose. |
| 14:40 |
jeffdavis |
Yes, I believe the expectation is that you've previously loaded the regular checkout UI in order for offline to work, since that gets the necessary settings into local storage. |
| 14:42 |
Dyrcona |
Yeah. It doesn't work unless you do that anyway. |
| 14:50 |
scottangel |
Dyrcona, I wondered that too! The way I figured it would work is the setting gets cached in the localStorage so the user will have to successfully login at least 1 time for that org setting to get cached. |
| 14:53 |
Dyrcona |
We get a lot of complaints about offline mode not working because of cache issues anyway. |
| 14:53 |
Dyrcona |
I say go for it. |
| 14:54 |
scottangel |
What's the worst that could happen? I loose more hair? mehh... |
| 14:54 |
jeffdavis |
FWIW we no longer advise our libraries to use the offline UI due to this kind of fragility. |
| 14:55 |
mmorgan |
Just fyi: bug 1943486, bug 1981841 |
| 14:55 |
pinesol |
Launchpad bug 1943486 in Evergreen "Offline Circulation interface may not load under certain circumstances" [Undecided,Confirmed] https://launchpad.net/bugs/1943486 |
| 14:55 |
pinesol |
Launchpad bug 1981841 in Evergreen "Offline Circulation Non-functional after Clearing Cache" [Undecided,Confirmed] https://launchpad.net/bugs/1981841 |
| 14:59 |
Dyrcona |
I sometimes threaten myself with writing a stand-alone offline circulation program, but nobody wants to install anything these days. |
| 15:00 |
jeffdavis |
I think Bill or somebody has a prototype already. |
| 15:12 |
berick |
https://github.com/berick/eg-offline-jfx -- my offline java experiment. got pretty far, but paused once I knew we didn't need it locally. |
| 15:13 |
* Dyrcona |
was thinking of using Qt, but JavaFX would work, too. |
| 15:14 |
|
jihpringle joined #evergreen |
| 15:14 |
Dyrcona |
I'm spinning too many plates already, and I'm not very good at it besides. :) |
| 15:15 |
Bmagic |
what about a browser extension! For the offline thing. We already have an extension. Mayb extend the extension to do the offline interface? |
| 15:15 |
Bmagic |
would it be subject to the same limitation that we have for the block list I wonder? |
| 15:18 |
Dyrcona |
Bmagic: Which blocklist limitation are you thinking of? I can think of two: it can be so big that the OpenSRF times out downloading it and it also needs to be retrieved when the client is online. I'm not sure an extension would address either of those. |
| 15:18 |
Bmagic |
I was thinking of the too-large to download issue |
| 15:19 |
Dyrcona |
The blocklist could be exposed via a password-protected URL instead of being retrieved via OpenSRF. That should solve the too large to download problem. |
| 15:20 |
Dyrcona |
You can configure a URL to use an Evergreen login, but it would be cooler if it could recognize an Evergreen authtoken. My hunch is that would require a new Apache auth module, but I've never looked into it. |
| 15:24 |
berick |
it's served from a auth'ed URL now, no opensrf |
| 15:25 |
berick |
async, in a separate worker thread |
| 15:25 |
berick |
IIR it's the "cram megabytes of data into IndexedDB" that breaks down |
| 15:28 |
Bmagic |
yeah, I thought it was the local browser storage limit |
| 15:28 |
Bmagic |
There's another thing that times out for large downloads: Checkout history CSV, and Hold history CSV |
| 15:28 |
Dyrcona |
OK. I stand corrected. |
| 15:28 |
Bmagic |
That might be what you were thinking of |
| 15:29 |
Dyrcona |
Yeah, those are OpenSRF, though I "fixed" one of them at one point. |
| 15:29 |
Dyrcona |
I thought this was the same problem, but it isn't. |
| 15:30 |
Dyrcona |
A stand-alone app could cram it into SQLite or HSQLDB and probably get away with it. |
| 15:31 |
Dyrcona |
I did some JavaFX tutorials 5 to 7 years ago and would have to brush up, particularly on fxml. |
| 15:32 |
scottangel |
There's also H2 for Java |
| 15:33 |
scottangel |
assuming you're wanting to embed sql into the app |
| 15:34 |
berick |
my jfx app used sqlite |
| 15:34 |
Dyrcona |
Is H2 an updated version of HSQLDB? The latter is all Java and is the default engine for LibreOffice and OpenOffice.org Base. (That's another thing I threaten myself with, making a Base app to connect to Evergreen to have forms for some common things I do.) |
| 15:36 |
Dyrcona |
“I feel thin, sort of stretched, like butter scraped over too much bread.” |
| 15:41 |
jeffdavis |
huh, Bilbo is a surprisingly good analogy for burnout/overwork |
| 15:42 |
Bmagic |
Dyrcona: You're due some good old fashion movie watching |
| 15:42 |
Dyrcona |
Heh. |
| 15:42 |
Bmagic |
That's what works for me :) |
| 15:42 |
Dyrcona |
My problem is I want to learn/do ALL THE THINGS!!! |
| 15:44 |
Bmagic |
get a subscription to Linux Magazine. I can't brag about that enough. https://www.linux-magazine.com/ |
| 15:44 |
Dyrcona |
I just looked up H2, and it's not an updated HSQLDB (HyperSQLDB). It's different. |
| 15:45 |
scottangel |
Yea, it's basically a mysql clone in java that you can embed. I honestly couldn't tell you which is best. I've used H2 a bit tho and liked it. |
| 15:45 |
Dyrcona |
I used to subscribe ti Linux Magazine but I let the subscription lapse many years ago. |
| 15:46 |
scottangel |
Get crazy and use MongoDB! lol |
| 15:46 |
Dyrcona |
Well, according to a PDF full of charts, Hybernate with HSQLDB is faster than Hybernate with H2, but I don't know what that really means.... :) |
| 15:47 |
Dyrcona |
Heh. People don't realize you can just throw blobs at PostgreSQL and it will return an OID that you can store somewhere and get that blob back later. It is an object/relational database though most projects only use the latter. |
| 15:51 |
Dyrcona |
Oof. Now, I'm starting down a hobbit hole of looking up different database technologies. I think I'll get out before it turns into a rabbit warren. |
| 15:52 |
Bmagic |
good call |
| 16:12 |
Dyrcona |
mantis1++ |
| 16:16 |
Dyrcona |
Twenty-six years in fourth grade is a hard way to go. |
| 17:04 |
|
mmorgan left #evergreen |
| 18:26 |
jeffdavis |
Short of looking in Postgres logs on the database server, is there a way to find out the generated SQL for a json_query request? |
| 18:26 |
jeffdavis |
(What a question for 6:30 Eastern on a Friday!) |
| 23:04 |
csharp_ |
jeffdavis: check out /openils/bin/test_json_query |
| 23:05 |
csharp_ |
usage would be something like "cat file_with_json_query.json | test_json_query" |
| 23:43 |
jeffdavis |
Nice, thanks very much! |
