[6614] in Moira
Re: weird "use" data in newly created host record
daemon@ATHENA.MIT.EDU (Mark Silis)
Sat May 21 13:06:43 2022
MIME-Version: 1.0
In-Reply-To: <bea56e4-47f4-6c57-d79-a38a5c878c1@mit.edu>
From: Mark Silis <mark@mit.edu>
Date: Sat, 21 May 2022 10:06:02 -0700
Message-ID: <CAFNAk-k8iJjmELGML4fThKE3zxLZFHv0qqw_9=V0_gqZBqx38A@mail.gmail.com>
To: Jonathon Weiss <jweiss@mit.edu>
Cc: Ron Hoffmann <hoffmann@mit.edu>, bug-moira@mit.edu
Content-Type: multipart/alternative; boundary="000000000000d7a90b05df889f14"
--000000000000d7a90b05df889f14
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Jonathon is correct, this data was updated periodically via a manual
process that dumped the router ARP caches and then for any active IP
addresses updated the use data timestamp via SQL. Since that process
stopped, it was since re-purposed and is now being updated any time the
host's opt status is changed. Hope that helps..
Best,
-- Mark
On Fri, May 20, 2022 at 9:39 AM Jonathon Weiss <jweiss@mit.edu> wrote:
> Hi Ron,
>
> I think it's always been the case that new records get their use data
> set to 01-jan-1970. I assume this is approximately 0 UNIX time,
> though I'm fairly certain it's stored as type 'DATE' in the Oracle DB.
> I have a vague recollection that the Use Data is only set by some sort
> of external to moira process, that I think is run manually, and uses
> data from MITnet switches. Anyhow, I'm not terribly concerned, unless
> we see some other more serious symptom.
>
> Jonathon
>
> On Thu, 19 May 2022, Ron Hoffmann wrote:
>
> > I just created this record, yet the use data lists 1/1/1970=E2=80=A6
> >
> > Not an operational issue, but maybe a canary for something else going o=
n?
> >
> > % stella -C msm-spd-02.mit.edu -A sloan-440:18.4.40.233 -V vmware -M pc
> -o win2k8r2 -L oc11 -c ops@sloan.mit.edu -bc pshaughn@mit.edu -an 1508509
> -ac INC0855441
> > I-fear-reorgs%
> > I-fear-reorgs% stella msm-spd-02.mit.edu
> > Machine: MSM-SPD-02.MIT.EDU
> >
> > Address: IPV4:18.4.40.233* Network: SLOAN-440
> >
> > Owner: NONE Use data: 01-jan-1970 00:00:00
> > Status: Active (1) Changed: 19-may-2022 07:54:19
> >
> > Vendor: VMWARE Location: OC11
> > Model: PC Contact: ops@sloan.mit.ed=
u
> > OS: WIN2K8R2 Billing Contact: pshaughn@mit.edu
> > Opt: 0 Account Number: 1508509
> >
> > Adm cmt: INC0855441
> > Op cmt:
> >
> > Created by hoffmann/root@ATHENA.MIT.EDU on 19-may-2022 07:54:19
> > Last mod by hoffmann/root@ATHENA.MIT.EDU at 19-may-2022 07:54:19 with
> stella.
> >
> >
> > Looking at a an existing record which I renamed a couple of days ago,
> > msm-spd-01, a more expected use date:
> >
> > % stella msm-spd-01.mit.edu
> > Machine: MSM-SPD-01.MIT.EDU
> >
> > Address: IPV4:18.4.40.232* Network: SLOAN-440
> >
> > Owner: NONE Use data: 15-aug-2012 10:00:27
> > Status: Active (1) Changed: 15-aug-2012 10:00:27
> >
> > Vendor: VMWARE Location: OC11
> > Model: PC Contact: ops@sloan.mit.ed=
u
> > OS: WIN2K8R2 Billing Contact: pshaughn@mit.edu
> > Opt: 0 Account Number: 1508509
> >
> > Adm cmt:
> > Op cmt:
> >
> > Created by dlogcher@ATHENA.MIT.EDU on 15-aug-2012 10:00:27
> > Last mod by hoffmann/root@ATHENA.MIT.EDU at 16-may-2022 17:17:30 with
> stella.
> >
> > Ron
--000000000000d7a90b05df889f14
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">Jonathon is correct, this data was updated periodically vi=
a a manual process that dumped the router ARP caches and then for any activ=
e IP addresses updated the use data timestamp via SQL. Since that process s=
topped, it was since re-purposed and is now being updated any time the host=
's opt status is changed. Hope that helps..<div><br></div><div>Best,<br=
><div><br clear=3D"all"><div><div dir=3D"ltr" class=3D"gmail_signature" dat=
a-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div=
><span style=3D"font-size:12.7272720336914px">-- Mark</span><br></div></div=
></div></div></div></div><br></div></div></div><br><div class=3D"gmail_quot=
e"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, May 20, 2022 at 9:39 AM Jo=
nathon Weiss <<a href=3D"mailto:jweiss@mit.edu">jweiss@mit.edu</a>> w=
rote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0p=
x 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Ron,<br=
>
<br>
I think it's always been the case that new records get their use data<b=
r>
set to 01-jan-1970.=C2=A0 I assume this is approximately 0 UNIX time,<br>
though I'm fairly certain it's stored as type 'DATE' in the=
Oracle DB.<br>
I have a vague recollection that the Use Data is only set by some sort<br>
of external to moira process, that I think is run manually, and uses<br>
data from MITnet switches.=C2=A0 Anyhow, I'm not terribly concerned, un=
less<br>
we see some other more serious symptom.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 Jonathon<br>
<br>
On Thu, 19 May 2022, Ron Hoffmann wrote:<br>
<br>
> I just created this record, yet the use data lists 1/1/1970=E2=80=A6<b=
r>
><br>
> Not an operational issue, but maybe a canary for something else going =
on?<br>
><br>
> % stella -C <a href=3D"http://msm-spd-02.mit.edu" rel=3D"noreferrer" t=
arget=3D"_blank">msm-spd-02.mit.edu</a> -A sloan-440:18.4.40.233 -V vmware =
-M pc -o win2k8r2 -L oc11 -c <a href=3D"mailto:ops@sloan.mit.edu" target=3D=
"_blank">ops@sloan.mit.edu</a> -bc <a href=3D"mailto:pshaughn@mit.edu" targ=
et=3D"_blank">pshaughn@mit.edu</a> -an 1508509 -ac INC0855441<br>
> I-fear-reorgs%<br>
> I-fear-reorgs% stella <a href=3D"http://msm-spd-02.mit.edu" rel=3D"nor=
eferrer" target=3D"_blank">msm-spd-02.mit.edu</a><br>
> Machine:=C2=A0 <a href=3D"http://MSM-SPD-02.MIT.EDU" rel=3D"noreferrer=
" target=3D"_blank">MSM-SPD-02.MIT.EDU</a><br>
><br>
> Address:=C2=A0 IPV4:18.4.40.233*=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0Network:=C2=A0 =C2=A0 SLOAN-440<br>
><br>
> Owner:=C2=A0 =C2=A0 NONE=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Use data:=C2=A0 =C2=A001-jan-1970 00=
:00:00<br>
> Status:=C2=A0 =C2=A0Active (1)=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 Changed:=C2=A0 =C2=A0 19-may-2022 07:54:19<br>
><br>
> Vendor:=C2=A0 =C2=A0VMWARE=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Location:=C2=A0 =C2=A0 =C2=A0 =C2=A0 OC1=
1<br>
> Model:=C2=A0 =C2=A0 PC=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Contact:=C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0<a href=3D"mailto:ops@sloan.mit.edu" target=3D"_blank">ops@sloan.=
mit.edu</a><br>
> OS:=C2=A0 =C2=A0 =C2=A0 =C2=A0WIN2K8R2=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Billing Contact: <a href=3D"mailto:p=
shaughn@mit.edu" target=3D"_blank">pshaughn@mit.edu</a><br>
> Opt:=C2=A0 =C2=A0 =C2=A0 0=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Account Number:=C2=
=A0 1508509<br>
><br>
> Adm cmt: INC0855441<br>
> Op cmt:<br>
><br>
> Created=C2=A0 by hoffmann/<a href=3D"mailto:root@ATHENA.MIT.EDU" targe=
t=3D"_blank">root@ATHENA.MIT.EDU</a> on 19-may-2022 07:54:19<br>
> Last mod by hoffmann/<a href=3D"mailto:root@ATHENA.MIT.EDU" target=3D"=
_blank">root@ATHENA.MIT.EDU</a> at 19-may-2022 07:54:19 with stella.<br>
><br>
><br>
> Looking at a an existing record which I renamed a couple of days ago,<=
br>
> msm-spd-01, a more expected use date:<br>
><br>
> % stella <a href=3D"http://msm-spd-01.mit.edu" rel=3D"noreferrer" targ=
et=3D"_blank">msm-spd-01.mit.edu</a><br>
> Machine:=C2=A0 <a href=3D"http://MSM-SPD-01.MIT.EDU" rel=3D"noreferrer=
" target=3D"_blank">MSM-SPD-01.MIT.EDU</a><br>
><br>
> Address:=C2=A0 IPV4:18.4.40.232*=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0Network:=C2=A0 =C2=A0 SLOAN-440<br>
><br>
> Owner:=C2=A0 =C2=A0 NONE=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Use data:=C2=A0 =C2=A015-aug-2012 10=
:00:27<br>
> Status:=C2=A0 =C2=A0Active (1)=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 Changed:=C2=A0 =C2=A0 15-aug-2012 10:00:27<br>
><br>
> Vendor:=C2=A0 =C2=A0VMWARE=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Location:=C2=A0 =C2=A0 =C2=A0 =C2=A0 OC1=
1<br>
> Model:=C2=A0 =C2=A0 PC=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Contact:=C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0<a href=3D"mailto:ops@sloan.mit.edu" target=3D"_blank">ops@sloan.=
mit.edu</a><br>
> OS:=C2=A0 =C2=A0 =C2=A0 =C2=A0WIN2K8R2=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Billing Contact: <a href=3D"mailto:p=
shaughn@mit.edu" target=3D"_blank">pshaughn@mit.edu</a><br>
> Opt:=C2=A0 =C2=A0 =C2=A0 0=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Account Number:=C2=
=A0 1508509<br>
><br>
> Adm cmt:<br>
> Op cmt:<br>
><br>
> Created=C2=A0 by <a href=3D"mailto:dlogcher@ATHENA.MIT.EDU" target=3D"=
_blank">dlogcher@ATHENA.MIT.EDU</a> on 15-aug-2012 10:00:27<br>
> Last mod by hoffmann/<a href=3D"mailto:root@ATHENA.MIT.EDU" target=3D"=
_blank">root@ATHENA.MIT.EDU</a> at 16-may-2022 17:17:30 with stella.<br>
><br>
> Ron</blockquote></div>
--000000000000d7a90b05df889f14--