| Time |
Nick |
Message |
| 00:08 |
|
sandbergja joined #evergreen |
| 00:15 |
|
sandbergja joined #evergreen |
| 00:17 |
|
sandbergja joined #evergreen |
| 04:06 |
|
JBoyer_alt joined #evergreen |
| 04:09 |
|
drigney joined #evergreen |
| 06:32 |
pinesol_green |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 06:55 |
|
Dyrcona joined #evergreen |
| 07:19 |
|
JBoyer joined #evergreen |
| 07:25 |
|
dwgreen joined #evergreen |
| 07:31 |
|
agoben joined #evergreen |
| 07:32 |
|
bdljohn joined #evergreen |
| 07:40 |
|
dwgreen joined #evergreen |
| 07:56 |
|
rlefaive joined #evergreen |
| 08:01 |
|
rlefaive_ joined #evergreen |
| 08:11 |
|
jvwoolf joined #evergreen |
| 08:23 |
|
kmlussier joined #evergreen |
| 08:41 |
Dyrcona |
Whee! Using a feature that I wrote 5 years ago! |
| 08:43 |
|
mmorgan joined #evergreen |
| 08:47 |
|
rlefaive joined #evergreen |
| 09:17 |
|
lsach joined #evergreen |
| 09:20 |
|
terran joined #evergreen |
| 09:27 |
|
collum joined #evergreen |
| 09:42 |
Dyrcona |
Figures a simple CStore search times looking for all not deleted copies at an org unit. Time for streaming results. |
| 09:45 |
Dyrcona |
And while I'm thinking of it, maybe I should have added an IDL entry for a particular custom table and possibly another custom view. |
| 09:45 |
Dyrcona |
At the time I figured I'd only use them via SQL and the Perl DBI. |
| 09:46 |
|
yboston joined #evergreen |
| 09:46 |
Dyrcona |
Think I'll add the IDL entries and try them out. |
| 09:56 |
Dyrcona |
Eh, maybe not. #lazy |
| 10:00 |
Dyrcona |
I should...Maybe I will later....for our next upgrade. |
| 10:00 |
|
sandbergja joined #evergreen |
| 10:16 |
|
dwgreen joined #evergreen |
| 10:31 |
|
BAMkubasa joined #evergreen |
| 10:55 |
|
khuckins joined #evergreen |
| 11:13 |
|
yboston joined #evergreen |
| 11:33 |
|
rlefaive joined #evergreen |
| 11:43 |
|
Christineb joined #evergreen |
| 11:45 |
|
rlefaive joined #evergreen |
| 11:46 |
|
idjit joined #evergreen |
| 11:46 |
|
dwgreen joined #evergreen |
| 11:52 |
Dyrcona |
recv timeout doesn't seem to be working for me. I must be doing something wrong. |
| 11:52 |
|
jvwoolf joined #evergreen |
| 11:53 |
Dyrcona |
Ayup. Error at a different point just above that. |
| 11:54 |
|
rlefaive joined #evergreen |
| 12:31 |
|
khuckins joined #evergreen |
| 12:38 |
|
stephengwills joined #evergreen |
| 12:40 |
|
bdljohn joined #evergreen |
| 13:17 |
|
kmlussier joined #evergreen |
| 13:25 |
|
khuckins joined #evergreen |
| 13:59 |
|
dwgreen joined #evergreen |
| 14:06 |
Bmagic |
Anyone seen Webby somehow circumventing the deleted flag on copies in order to put them in transit? We are finding examples of deleted copies going into transit well after they were deleted. |
| 14:10 |
|
rlefaive joined #evergreen |
| 14:10 |
JBoyer |
Bmagic, do you have any patches loaded related to checking in deleted items (usually for removing them from patron's accounts)? I don't have the bug number handy but I thought I saw some talk about it in the last few weeks. |
| 14:11 |
Bmagic |
Stock EG code running for this example |
| 14:11 |
berick |
what's the command to show a commit in here? |
| 14:12 |
berick |
~commit 23a21e4e529ac2215962f419ed9bb486a5096e84 |
| 14:12 |
pinesol_green |
berick: [evergreen|Bill Erickson] LP#1751368 Items-out checkin of deleted copies - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=23a21e4> |
| 14:12 |
berick |
hah |
| 14:12 |
Bmagic |
and there you go? |
| 14:12 |
berick |
that's in master, btw |
| 14:12 |
Bmagic |
JBoyer: select * from action.transit_copy atc,asset.copy ac where atc.target_copy =ac.id and ac.deleted and atc.dest_recv_time is null and atc.source_send_time > ac.status_changed_time and atc.cancel_time is null |
| 14:14 |
JBoyer |
That Q gives me 6 results. They're all from 2010 and 2011 though. |
| 14:18 |
|
kmlussier joined #evergreen |
| 14:28 |
jeff |
status_changed_time doesn't get bumped by trigger when a copy is deleted. |
| 14:28 |
Dyrcona |
A lot of things don't touch status_changed_time. |
| 14:29 |
jeff |
Bmagic: can you consult the auditor tables to determine if the copy was really deleted when it went into transit? |
| 14:29 |
Bmagic |
ok, I'll craft a new query |
| 14:31 |
jeff |
But I suspect checkin of a deleted copy at a non-home library might still put a deleted copy in transit. |
| 14:31 |
|
jvwoolf joined #evergreen |
| 14:35 |
JBoyer |
Bmagic, if you switch status_update_time for edit_date (which is actually a timestamp, despite the name) I get 0 results and I suspect you may also. (or at least closer to 0). |
| 14:36 |
Bmagic |
Still get 5 examples |
| 14:36 |
JBoyer |
recent? |
| 14:37 |
JBoyer |
(Not saying its impossible, just that edit_date is more likely more regularly changed, though it's not connected to a specific trigger) |
| 14:40 |
jeff |
fairly certain it's quite possible currently. nothing seems to force a noop checkin for those checkins, and very few things care about the copy being deleted in Circ/Circulate.pm |
| 14:41 |
jeff |
something else that used to be easy and then became less-easy and perhaps became more-easy in the web client would be the ability to delete a circulating copy. |
| 15:03 |
|
mmorgan1 joined #evergreen |
| 15:30 |
|
mmorgan joined #evergreen |
| 16:13 |
|
khuckins_ joined #evergreen |
| 16:22 |
|
yboston joined #evergreen |
| 16:37 |
Bmagic |
JBoyer: Yep, just a month or two old and the item was deleted YEARS ago |
| 16:38 |
Bmagic |
But I have yet to check auditor to get a solid deletion date |
| 16:39 |
|
yboston joined #evergreen |
| 16:39 |
jeff |
If the item went in transit a month or two ago and you suspect it was because the item was checked in from a patron's Items Out tab, there would likely be a circulation for that item with a checkin_time or checkin_scan_time around the time of the transit. |
| 16:40 |
Bmagic |
ah yes, deleted items that are shown in the items out on patron account is the only case where I can think of deleted items surfacing in any UI |
| 16:41 |
jeff |
short of taking more steps to prevent the situation where you have a checked out item that is deleted, teaching the circ ML to force noop on a checkin of a deleted copy might also be good. |
| 16:46 |
|
mmorgan1 joined #evergreen |
| 16:56 |
|
khuckins joined #evergreen |
| 16:58 |
|
khuckins joined #evergreen |
| 17:01 |
|
mmorgan1 left #evergreen |
| 17:12 |
|
bdljohn joined #evergreen |
| 17:28 |
Bmagic |
jeff: weird, 0 rows in action.circulation and 0 rows in action.aged_circulation for those..... the plot thickens |
| 17:44 |
|
lsach joined #evergreen |
| 18:32 |
pinesol_green |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 19:25 |
|
bdljohn joined #evergreen |
| 19:44 |
|
beanjammin joined #evergreen |
| 20:46 |
|
sandbergja joined #evergreen |
| 21:32 |
|
rlefaive joined #evergreen |
