[644] in Tooltime
More acurate list of duplicate logs
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Wed Dec 3 14:51:28 1997
Date: Wed, 3 Dec 1997 14:51:27 -0500
To: dho@MIT.EDU
From: Debi Fuchs <debi@MIT.EDU>
Cc: tooltime@MIT.EDU
Okay, here is a more accurate list of logs which seem to be
duplicates. Note that this is going to be difficult to
track down, as the duplication seems to happen
very sporadically (see below) and in clumps.
(Duplicates are defined by the fact that at least one other log
exists with the same client and creation time/stamp...except for the
seconds...and whose apparent creation date differs from the date
listed in the mit_logs_activity_table by more than 15 seconds)
Cheers,
-Debi
-----
SQL> break on Last skip 1
SQL> select substr(mit_pri_lastname,1,10) "Last", mit_log_id "Log",
substr(to_char(mit_created_ts, 'MM/DD/YYYY HH:MI:SS'),1,20) "Apparent
Creation Date" from mit_logs where mit_pri_lastname IS NOT NULL and
mit_pri_lastname || to_char(mit_created_ts, 'MM/DD/YYYY HH:MI') IN (select
l.mit_pri_lastname || to_char(l.mit_created_ts, 'MM/DD/YYYY HH:MI') from
mit_logs_activity a, mit_logs l where l.mit_log_id=a.mit_log_id and
a.action_text LIKE '%mit_logs_frm%' and abs(l.mit_created_ts -
a.action_ts)>(15/(24*60*60))) order by substr(mit_pri_lastname,1,10),
mit_log_id;
Last Log Apparent Creation Date
---------- ---------- --------------------
AOU 100013 11/16/1997 06:32:39
100350 11/16/1997 06:32:00
100351 11/16/1997 06:32:00
100357 11/16/1997 06:32:00
BAKER 100906 11/26/1997 01:12:06
100948 11/26/1997 01:12:00
BAMBERGER 100244 11/18/1997 04:26:38
100253 11/18/1997 04:26:00
BOWSER 101165 12/02/1997 02:53:55
101247 12/02/1997 02:53:00
101249 12/02/1997 02:53:00
BURKE 100556 11/21/1997 10:19:10
100566 11/21/1997 10:19:00
CHARBONNEA 100808 11/25/1997 11:49:00
FLYNN 101058 12/01/1997 01:53:59
101114 12/01/1997 01:53:00
101115 12/01/1997 01:53:00
101116 12/01/1997 01:53:00
101119 12/01/1997 01:53:00
101120 12/01/1997 01:53:00
FOLEY 100149 11/18/1997 09:10:01
100310 11/18/1997 09:10:00
100312 11/18/1997 09:10:00
100314 11/18/1997 09:10:00
100318 11/18/1997 09:10:00
FORD 100899 11/26/1997 12:13:24
100907 11/26/1997 12:13:00
FREEMAN 100255 11/18/1997 05:00:38
100624 11/18/1997 05:00:00
LOVETT 100124 11/17/1997 04:01:57
100131 11/17/1997 04:01:00
MULLOWNEY 87370 11/13/1997 09:15:00
100716 11/13/1997 09:15:00
ONISHI 101052 12/01/1997 01:38:40
101100 12/01/1997 01:38:00
PAULSON 100323 11/19/1997 12:12:36
100352 11/19/1997 12:12:00
PERAULT 100308 11/19/1997 10:55:23
100502 11/19/1997 10:55:00
SCHARMER 100021 11/17/1997 09:30:46
100094 11/17/1997 09:30:00
100095 11/17/1997 09:30:00
WAX 100557 11/21/1997 10:21:48
101156 11/21/1997 10:21:00
101157 11/21/1997 10:21:00
101159 11/21/1997 10:21:00
101160 11/21/1997 10:21:00
WELLENS 100822 11/25/1997 01:27:57
101151 11/25/1997 01:27:00
101152 11/25/1997 01:27:00
101153 11/25/1997 01:27:00
101154 11/25/1997 01:27:00
WOODRUFF 100623 11/21/1997 04:09:47
100731 11/21/1997 04:09:00
SQL> select mit_log_id "Log", to_char(action_ts, 'MM/DD/YYYY HH:MI:SS')
"Actual Creation Date of Duplicate" from mit_logs_activity where
action_text LIKE '%mit_logs_frm%' and mit_log_id IN (select l.mit_log_id
from mit_logs_activity a, mit_logs l where l.mit_log_id=a.mit_log_id and
a.action_text LIKE '%mit_logs_frm%' and abs(l.mit_created_ts -
a.action_ts)>(6/(24*60*60))) order by mit_log_id, to_char(action_ts,
'MM/DD/YYYY HH:MI:SS');
Log Actual Creation Date of Duplicate
----------
---------------------------------------------------------------------
100094 11/17/1997 01:41:28
100095 11/17/1997 01:43:41
100131 11/17/1997 04:32:59
100253 11/18/1997 04:58:11
100310 11/19/1997 11:06:53
100312 11/19/1997 11:08:03
100314 11/19/1997 11:15:45
100318 11/19/1997 11:25:46
100350 11/19/1997 12:59:52
100351 11/19/1997 01:12:23
100352 11/19/1997 01:23:09
100357 11/19/1997 01:56:08
100362 11/19/1997 02:35:56
100368 11/19/1997 03:09:45
100369 11/19/1997 03:14:58
100502 11/20/1997 02:54:49
100566 11/21/1997 11:08:31
100624 11/21/1997 04:29:36
100670 11/24/1997 09:55:55
100674 11/24/1997 10:19:29
100716 11/24/1997 01:27:39
100731 11/24/1997 02:25:09
100808 11/25/1997 11:57:59
100907 11/26/1997 01:21:24
100948 11/26/1997 05:16:17
101100 12/01/1997 04:38:52
101114 12/02/1997 08:38:52
101115 12/02/1997 08:54:56
101116 12/02/1997 09:00:41
101119 12/02/1997 09:14:29
101120 12/02/1997 09:18:26
101151 12/02/1997 01:08:55
101152 12/02/1997 01:11:10
101153 12/02/1997 01:12:51
101154 12/02/1997 01:16:29
101156 12/02/1997 01:35:50
101157 12/02/1997 01:41:10
101159 12/02/1997 01:43:42
101160 12/02/1997 01:45:45
101247 12/03/1997 01:24:09
101249 12/03/1997 01:28:58
-------------
Debi Fuchs, Consultant
MIT Information Systems
Computing Help Desk Group
77 Massachusetts Avenue, 11-319
Cambridge, MA 02139
(617) 253-7812
debi@mit.edu
