| Time |
Nick |
Message |
| 02:45 |
|
dbwells_ joined #evergreen |
| 05:38 |
|
Dyrcona joined #evergreen |
| 05:38 |
Dyrcona |
Good morning, Evergreen! |
| 06:02 |
Dyrcona |
Hmm... I should probably remove the pg_sleep()s from this old db update script. |
| 06:02 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 06:09 |
Dyrcona |
Some of these queries could probably be made faster. |
| 06:30 |
Dyrcona |
Heh: "ON COMMIT DROP" seems like a lack of commitment. |
| 06:33 |
Dyrcona |
No wonder our db eventually ends up with 330GB of junk. We have daily updates that truncate tables, insert 8 million+ rows, update 11 million+ rows.... and so on. |
| 06:38 |
Dyrcona |
Yeah, 1GB of cruft, and so far, I'm the only one doing anything. |
| 06:39 |
Dyrcona |
@blame Dusty Titles |
| 06:39 |
pinesol |
Dyrcona: Dusty Titles stole bshum's tux doll! |
| 06:40 |
Dyrcona |
True dat! |
| 07:19 |
|
rjackson_isl_hom joined #evergreen |
| 07:45 |
bshum |
I've been looking for him. It's been such a quiet year ;) |
| 07:48 |
Dyrcona |
bshum++ |
| 07:49 |
|
collum joined #evergreen |
| 07:58 |
|
mantis1 joined #evergreen |
| 08:16 |
|
rfrasur joined #evergreen |
| 08:37 |
|
mmorgan joined #evergreen |
| 08:39 |
|
rfrasur_ joined #evergreen |
| 08:46 |
|
alynn26 joined #evergreen |
| 11:06 |
|
Cocopuff2018 joined #evergreen |
| 11:57 |
|
rfrasur joined #evergreen |
| 12:11 |
|
jihpringle joined #evergreen |
| 12:16 |
|
nfBurton joined #evergreen |
| 12:36 |
rjackson_isl_hom |
seeing a lot of patron accounts in limbo that are very old (expired pre 2013), have no bills and the reason they appear to be hanging around is non-closed circulations with no fines owed |
| 12:37 |
rjackson_isl_hom |
has anyone developed a script to catch these - possibly closing circs that can be closed so the accounts can then be purged by the automated processing from cron? |
| 12:48 |
mmorgan |
rjackson_isl_hom: We dealt with this a while back, I'll see if I can dig up those notes. |
| 12:49 |
rjackson_isl_hom |
mmorgan++ - was just reading back thru possible/probably cause since the one example I just pulled up is pre-2011 |
| 12:49 |
rjackson_isl_hom |
https://bugs.launchpad.net/evergreen/+bug/758982 |
| 12:49 |
pinesol |
Launchpad bug 758982 in Evergreen "2.0, 1.6, Transactions not closing for LOST items once xact has been re-opened for modified billings. " [High,Fix released] |
| 12:56 |
Dyrcona |
rjackson_isl_hom: It's could be a rounding error and they do owe some microscopic amount. There was a bug for this and it was patched at some point. |
| 13:01 |
rjackson_isl_hom |
Dyrcona for the circ I saw as being open and the account expired pre 2013 all entries in money.billing had been voided |
| 13:19 |
mmorgan |
rjackson_isl_hom: Maybe bug 1781274 |
| 13:19 |
pinesol |
Launchpad bug 1781274 in Evergreen 3.4 "Web Client: Transactions Do Not Always Close When Bill Fully Paid" [Medium,Fix released] https://launchpad.net/bugs/1781274 |
| 13:20 |
mmorgan |
That was the most recent one, I think. There were other older ones about transactions not closing that were patched too. |
| 13:23 |
rjackson_isl_hom |
mmorgon - no doubt impacted EI patron accounts - looking for a way to close those accounts via script(s) as opposed to reviewing hundreds if not thousands of accounts and transactions |
| 13:24 |
rjackson_isl_hom |
actually should be close the transactions so the accounts can be auto-deleted via cron |
| 13:25 |
mmorgan |
rjackson_isl_hom: Found an example of a db query I used to close transactions. This was a couple years ago. Not my best work to be sure :-( but I'll share it in a paste. |
| 13:25 |
pastebot |
"mmorgan" at 168.25.130.30 pasted "Inelegant query for closing fully paid transactions" (11 lines) at http://paste.evergreen-ils.org/10074 |
| 13:25 |
rjackson_isl_hom |
mmorgan++ |
| 13:30 |
rjackson_isl_hom |
the driver set of circ IDs for EI is 7977 - sounds plausible! |
| 13:45 |
alynn26 |
mmorgan++ |
| 13:56 |
|
Cocopuff2018 joined #evergreen |
| 14:40 |
rjackson_isl_hom |
mmorgan - now to see after closing 7997 transactions how many extra accounts fall off in the nightly purge! |
| 14:52 |
mmorgan |
rjackson_isl_hom++ |
| 14:55 |
rjackson_isl_hom |
mmorgan some branches might see this as a negative thing depending on reporting being performed locally |
| 15:02 |
rfrasur |
abneiman, gmcharlt, jboyer, just noting that my meeting ended. I think it was the whole thing rather than me crashing. |
| 15:03 |
gmcharlt |
rfrasur: yeah, same |
| 15:03 |
rfrasur |
okay. that's one way to rush the conversation :-) |
| 15:08 |
|
collum joined #evergreen |
| 15:32 |
|
mantis1 left #evergreen |
| 16:19 |
|
rfrasur_ joined #evergreen |
| 16:27 |
|
cesardv joined #evergreen |
| 16:46 |
|
sandbergja joined #evergreen |
| 17:21 |
|
jvwoolf left #evergreen |
| 17:27 |
|
mmorgan left #evergreen |
| 18:01 |
pinesol |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 19:06 |
|
Cocopuff2018 joined #evergreen |
