| Time |
Nick |
Message |
| 00:03 |
|
sandbergja joined #evergreen |
| 01:14 |
|
haishu joined #evergreen |
| 01:18 |
haishu |
hello |
| 01:29 |
|
haishu joined #evergreen |
| 03:18 |
|
haishu_ joined #evergreen |
| 03:20 |
|
haishu joined #evergreen |
| 03:21 |
|
haishu joined #evergreen |
| 03:25 |
|
haishu joined #evergreen |
| 03:37 |
|
haishu joined #evergreen |
| 03:38 |
haishu |
Hello! I was wondering, can you install evergreen as a client-side only application, and not as a server application? |
| 03:44 |
|
haishu joined #evergreen |
| 04:02 |
|
haishu joined #evergreen |
| 05:21 |
|
haishu joined #evergreen |
| 05:57 |
csharp |
haishu: you can install the server on the same machine as you would be accessing the client, but no, Evergreen is a server-side app |
| 06:18 |
|
haishu joined #evergreen |
| 06:26 |
|
haishu joined #evergreen |
| 06:48 |
|
haishu joined #evergreen |
| 07:10 |
|
rjackson_isl joined #evergreen |
| 07:42 |
|
Dyrcona joined #evergreen |
| 07:56 |
Dyrcona |
Well, disabling user triggers may have helped. I'm not sure. It's still going on an update of action.aged_circulation, which has no user triggers to disable IIRC. I may have to disable all triggers to get a real performance boost. I will try that next. |
| 07:56 |
csharp |
Dyrcona: yeah - same here - it's still running (since 2pm yesterday) |
| 07:56 |
csharp |
the action.circulation update completed, but it's still chewing on aged circ |
| 07:58 |
Dyrcona |
Yeah, mine has been going about the same length of time. I'm going to disable all triggers on both tables for my next test when this one finishes. |
| 08:05 |
Dyrcona |
I'm tempted to just stop this one and start over. I have more databases I can "break." :) |
| 08:08 |
Dyrcona |
Mine had been going 18h 41m before I stopped it just now. |
| 08:12 |
Dyrcona |
'Cause, honestly, if it doesn't knock 6 or more hours off the run time, it's not worth it. |
| 08:13 |
csharp |
I'm already updating prod circs with the change in batches |
| 08:13 |
csharp |
also considering whether or not I care about applying the default/not null change to the aged table |
| 08:15 |
Dyrcona |
If you report on aged circs, then you probably will. We noticed it through reports not being right. |
| 08:15 |
csharp |
oh - ok |
| 08:16 |
Dyrcona |
I mean it's easier to report on true/false, versus true/false/null. :) |
| 08:16 |
csharp |
makes sense |
| 08:18 |
Dyrcona |
So, my next test has started on an "optimized" 9.6 instance on my test db server. |
| 08:21 |
csharp |
another factor in my situation is that my staging/testing DB is under-specced compared to production - a consequence of our new environment |
| 08:21 |
csharp |
I can probably change it without trouble, but that comes with overhead |
| 08:22 |
Dyrcona |
Well, I have 128GB of RAM and 6TB of spinning rust on my test db server. Production is 768GB of RAM and 1.3TB of NVMe SSD, mirrored in a ZFS pool. So, yeah, test is slower for me, too. :) |
| 08:23 |
Dyrcona |
Not sure what the RAID is on the test db server. It's configured via hardware, and I never checked. The "joy" of leftover hardware. |
| 08:23 |
csharp |
yeah |
| 08:24 |
Dyrcona |
I put optimized in quotes, 'cause optimizing Postgres still feels like voodoo to me. |
| 08:24 |
csharp |
it's definitely voodoo |
| 08:25 |
Dyrcona |
I'm tempted to use sed on the raw data files.... j/k. |
| 08:41 |
|
mmorgan joined #evergreen |
| 08:57 |
Dyrcona |
Well, the two set desk_renewal = false updates are done, but they only touch about 1 million rows in total. |
| 09:05 |
|
jonadab joined #evergreen |
| 09:40 |
|
jvwoolf joined #evergreen |
| 09:41 |
|
yboston joined #evergreen |
| 09:43 |
csharp |
yeah - we have 0 to do there, so that's an upside :-) |
| 09:50 |
Dyrcona |
You do that already? |
| 09:57 |
csharp |
we just don't have any with autorenewal = true |
| 10:23 |
Dyrcona |
Well, probably because of the other bug about aged circulation. We patched that already. |
| 10:51 |
|
sandbergja joined #evergreen |
| 11:02 |
pinesol |
News from qatests: Failed Installing Angular web client <http://testing.evergreen-ils.org/~live/test.29.html#2019-11-01T11:00:50,114348425-0400 -0> |
| 11:23 |
csharp |
yeah 162M rows in aged_circulation... I will *not* be applying that update during the upgrade window |
| 11:24 |
csharp |
paraphrasing Sonny in the Godfather: "Reports will just have to suffer!" |
| 11:25 |
csharp |
and actually, I plan to run these in batches before the upgrade happens so it won't be an issue |
| 11:30 |
csharp |
and, as expected, removing that from the upgrade reduces what would have been at least a day to 0m0.843s |
| 11:30 |
Dyrcona |
Well, of course. |
| 11:30 |
csharp |
still fun to say :-) |
| 11:30 |
Dyrcona |
:) |
| 11:32 |
Dyrcona |
Using --link has a similar effect on pg_upgrade, btw. :) |
| 11:35 |
|
sandbergja joined #evergreen |
| 11:36 |
Dyrcona |
Spam bug reports.... |
| 11:38 |
* miker |
attempts to use the debian-buster prereqs on kubuntu 19.04 ... will report back ;) |
| 11:40 |
miker |
csharp: I haven't read all the scrollback, so pardon if this has already been covered, but you can apply the DEFAULT FALSE clause without the NOT NULL clause now, and continue with updates in batches over time. then decide if you want to add NOT NULL at all later... |
| 11:40 |
|
haishu joined #evergreen |
| 11:41 |
|
alynn26 joined #evergreen |
| 11:57 |
|
Christineb joined #evergreen |
| 12:07 |
|
alynn26_away joined #evergreen |
| 12:10 |
gmcharlt |
berick: sandbergja: next week I'm planning on putting together an Angular file upload component for extracting a set of record identifiers as part of the Angular acquisitions search form |
| 12:10 |
gmcharlt |
of course, since such a component would also be part of (e.g.) an Angular record or copy bucket interface (or an Angular item status interface), I want to double-check whether either of you already have something like that as a WIP |
| 12:15 |
berick |
gmcharlt: /eg2/staff/cat/vandelay/export has a CSV file upload bit. it's not really the same as what you are proposing, but there could be something useful there (it's not much code). |
| 12:15 |
berick |
in the vandelay case, the file's just posted via form, it's not inspected |
| 12:16 |
|
jihpringle joined #evergreen |
| 12:19 |
stephengwills |
what do people use for IRC on android? any consensus? |
| 12:19 |
gmcharlt |
berick: thanks |
| 12:25 |
gmcharlt |
berick: yeah, at first blush I suspect what I'll come up with is something akin to the AngularJS egFileReader, though i'm tempted to make the Angular version have some smarts about whitespace normalization |
| 12:28 |
* berick |
nods |
| 13:17 |
csharp |
miker: oh - good idea |
| 13:28 |
csharp |
stephengwills: pretty sure I used to use androIRC but it's been a while since I used IRC on anything other than a PC/laptop |
| 13:36 |
Dyrcona |
Yeah, I was going to say that I don't use IRC on my phone/tablet. |
| 13:41 |
* eady |
always runs the irc client in a gnu screen session so as to maintain a continuous presence and be able to attach to it from _wherever_. Though I suppose a proxy ("bouncer" in IRC parlance) like znc could be used to accomplish much the same thing. |
| 13:42 |
eady |
But anyway, at that point all the Android device needs is an ssh client. |
| 13:43 |
Dyrcona |
Quassel works much the same. You run a server that maintains always on presence and connect whenever you want. |
| 13:43 |
Dyrcona |
I still use Pidgin out of habit. |
| 13:43 |
eady |
Though using IRC without a physical keyboard would be kind of suboptimal unless you're mainly lurking. |
| 13:44 |
eady |
Freenode _has_ a web interface, but it is pain and sorrow. |
| 13:44 |
Dyrcona |
:) |
| 13:44 |
Dyrcona |
Bluetooth keyboards work with phone or tablet. |
| 13:44 |
eady |
True. |
| 13:45 |
jeff |
USB keyboards also :-) |
| 13:49 |
Dyrcona |
I suppose. |
| 13:50 |
eady |
In practice people who make heavy use of an android device _usually_ don't carry around a keyboard with it. |
| 13:51 |
* jeff |
nods |
| 14:00 |
* phasefx |
tries to send an emoji |
| 14:02 |
phasefx |
not supported :) glad it didn't try to downgrade into an emoticon or ascii art |
| 14:02 |
stephengwills |
I rely heavily on voice - text, I’ve suspendered to technology. |
| 14:03 |
jeffdavis |
stephengwills: I use irccloud for $5/mo, web-based interface or android client depending on my device. I've been pleased with it. Not free though. |
| 14:04 |
jeffdavis |
Previously I was running irssi on a virtual server that I basically never used for anything else. |
| 14:06 |
stephengwills |
really the use case is: I throw out a question and then realize it’s lunch time and I don’t have m answer yet. I’m trying IRC Vitamin right now. Thanks all. |
| 14:24 |
|
serflog joined #evergreen |
| 14:24 |
|
Topic for #evergreen is now Welcome to the #evergreen library system channel! | We are publicly logged: http://irc.evergreen-ils.org/evergreen | Large pastes at http://paste.evergreen-ils.org | Can't speak? Make sure your nickname is registered and that you are identified to freenode services: https://freenode.net/kb/answer/registration |
| 14:25 |
jeff |
i am amused that Dyrcona's comment about public logs is going to be absent from the public logs. |
| 14:25 |
Dyrcona |
Ha! |
| 14:25 |
jeff |
(because serflog timed out) |
| 14:26 |
Dyrcona |
Well timed.... |
| 15:42 |
pinesol |
[evergreen|Kyle Huckins] lp1437103 - Suppress Popups based on OU Setting - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=b4caf69> |
| 15:42 |
pinesol |
[evergreen|Kyle Huckins] lp1437103 Suppress Popups on Patron Items Out Checkin - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=eba1ec4> |
| 15:42 |
pinesol |
[evergreen|Kyle Huckins] lp1437103 Allow Receipts to Print when Suppressing Popups - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=7f92a4d> |
| 15:45 |
|
haishu joined #evergreen |
| 16:03 |
|
sandbergja_ joined #evergreen |
| 16:05 |
devted |
Hi everyone, what is the state of the new Angular interface for Cataloging -> Marc Batch Import/Export for acquisitions? |
| 16:06 |
devted |
Is it a bug that "Acquisitions Records" is an option for "Record Type", when people may use Acquisitions -> Load MARC Order Records? |
| 16:07 |
|
haishu joined #evergreen |
| 16:09 |
devted |
If an acquisions load isn't supported from the Cataloging menu, some people could get confused and try an acquisitions import from Cataloging -> MARC Batch Import/Export |
| 16:14 |
jihpringle |
devted: if staff want to create a purchase order or selection list from the MARC file it needs to be loaded via the Acquisitions -> Load MARC Order Records interface |
| 16:15 |
jihpringle |
the MARC Batch Import/Export interface doesn't have the additional acquisitions options that the Load MARC Order Records interface has |
| 16:15 |
devted |
jihpringle: Thank you! |
| 16:16 |
jihpringle |
np |
| 16:31 |
|
jvwoolf left #evergreen |
| 17:00 |
|
mmorgan left #evergreen |
| 17:11 |
|
sandbergja_ joined #evergreen |
| 18:02 |
|
sandbergja_ joined #evergreen |
| 20:15 |
|
haishu joined #evergreen |
| 20:36 |
|
sandbergja_ joined #evergreen |
| 21:37 |
|
sandbergja_ joined #evergreen |
| 22:44 |
|
haishu joined #evergreen |
| 22:48 |
|
sandbergja_ joined #evergreen |
| 23:01 |
pinesol |
News from qatests: Failed Installing Angular web client <http://testing.evergreen-ils.org/~live/test.29.html#2019-11-01T23:01:06,384001843-0400 -0> |
| 23:31 |
|
haishu joined #evergreen |
