| Time |
Nick |
Message |
| 01:45 |
|
dluch_ joined #evergreen |
| 01:50 |
|
degraafk joined #evergreen |
| 06:50 |
|
collum joined #evergreen |
| 08:49 |
|
mmorgan joined #evergreen |
| 08:52 |
|
redavis joined #evergreen |
| 09:16 |
|
Dyrcona joined #evergreen |
| 09:17 |
|
smayo joined #evergreen |
| 09:36 |
|
smayo joined #evergreen |
| 10:02 |
|
mmorgan1 joined #evergreen |
| 10:16 |
Dyrcona |
One bug appears to be a symptom of another bug.....Wish I could reliably reproduce the latter. |
| 10:27 |
|
redavis_reloaded joined #evergreen |
| 10:28 |
|
_collum joined #evergreen |
| 10:38 |
|
smayo joined #evergreen |
| 10:38 |
|
Dyrcona joined #evergreen |
| 10:38 |
|
degraafk joined #evergreen |
| 10:39 |
|
redavis joined #evergreen |
| 10:56 |
|
sandbergja joined #evergreen |
| 11:03 |
|
Christineb joined #evergreen |
| 11:06 |
|
collum joined #evergreen |
| 11:07 |
|
mmorgan joined #evergreen |
| 11:30 |
|
jihpringle joined #evergreen |
| 12:17 |
pinesol |
News from commits: Port forward 3.14 3.15 db upgrade scripts <http://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=a91e7bc38f8aecd2ac3c0a615e85c21b1c05a43b> |
| 13:02 |
Dyrcona |
A union with 56 tables joined to actor.usr in each union. That won't take long to run or anything like that. |
| 13:02 |
Dyrcona |
Well it's 56 unions each with actor.usr and one other table, not 56 tables per union. |
| 13:04 |
|
smayo joined #evergreen |
| 13:17 |
Dyrcona |
Wow! That query finds over 193,000 users with some unpurged data in our database. |
| 13:31 |
jeff |
I am Jack's complete lack of surprise. |
| 13:34 |
Dyrcona |
jeff: A refinement to the query that was meant to find fewer users turned up four more than the original.... |
| 13:35 |
Dyrcona |
I made the program that writes the query more precise in how it finds fields from updates in the usr_purge_data function text. |
| 13:35 |
Dyrcona |
I've got a 3rd iteration that does the same for deletes. I'll see how many it turns up. |
| 13:36 |
Dyrcona |
@who wants a 94MB csv file |
| 13:36 |
pinesol |
scottangel_ wants a 94MB csv file. |
| 13:37 |
Dyrcona |
The query is the same size as the refined one, so I suspect it will produce identical results. |
| 13:45 |
Dyrcona |
Huh. That one also found more than the previous 2 runs. Of course, 1 of the new ones was just deleted..... |
| 13:50 |
mmorgan |
redavis++ gmcharlt++ Bmagic++ mdriscoll++ |
| 13:51 |
redavis |
mmorgan++ gmcharlt++ Bmagic++ mdriscoll++ # just like butta |
| 13:56 |
Dyrcona |
mmorgan++ gmcharlt++ Bmagic++ mdriscoll++ redavis++ |
| 13:57 |
|
smayo joined #evergreen |
| 14:28 |
|
sandbergja joined #evergreen |
| 14:51 |
|
smayo joined #evergreen |
| 14:58 |
Dyrcona |
I can't figure out how sorting the output by tables makes it seven bytes smaller than not sorting the output. It also gives different results. The unsorted union gets more results and different results every time i run it. |
| 15:00 |
Dyrcona |
Ok. I can see what it might be longer, since I'm adding a number to every alias of actor.usr, could be that some tables with multiple fields get joined later with a double digit number. |
| 15:43 |
Dyrcona |
Wild.... The order of union clauses matters when it doesn't seem like it should..... |
| 15:52 |
|
jihpringle joined #evergreen |
| 17:02 |
|
mmorgan left #evergreen |
| 18:08 |
|
jihpringle joined #evergreen |
| 18:49 |
|
JBoyer_ joined #evergreen |
| 18:53 |
|
phasefx joined #evergreen |
| 19:15 |
|
degraafk joined #evergreen |
| 19:27 |
|
phasefx_ joined #evergreen |
| 20:07 |
|
sandbergja joined #evergreen |
| 20:18 |
pinesol |
News from commits: Docs: Updated org unit terminology in circulation_patron_records_web_client.adoc <http://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=211acdc2c96b2049c5e7060219eaad6ea3c6a9f4> |
| 20:18 |
pinesol |
News from commits: Docs: Updated org unit terminology in triggered_events.adoc <http://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=a68d4f7287b0e26a960ffd0bcdcde83fa862cada> |
| 20:18 |
pinesol |
News from commits: Docs: Updated org unit terminology in basic_holds.adoc <http://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=77fa85969600ac9cc4c9412c41e7573590c4b63c> |
| 21:13 |
|
phasefx joined #evergreen |
| 21:19 |
|
sandbergja|2 joined #evergreen |
