Inconsistency in get_root_timestamps

[bdpedigo]

client = CAVEclient("minnie65_phase3_v1")
root_ids = [
    864691136137805181,
    864691136237725199,
    864691135778700477,
    864691137055175542,
]
timestamps = client.chunkedgraph.get_root_timestamps(root_ids, latest=True)
print(timestamps)

gives

[datetime.datetime(2024, 10, 25, 20, 13, 10, 925000, tzinfo=<UTC>)
 datetime.datetime(2024, 12, 16, 7, 14, 45, 712000, tzinfo=<UTC>)
 datetime.datetime(2024, 12, 20, 21, 1, 7, 458073, tzinfo=<UTC>)
 datetime.datetime(1969, 12, 31, 23, 59, 59, 999000, tzinfo=<UTC>)]

Note that for the last ID the year is 1969...

But if I just query that one,

client = CAVEclient("minnie65_phase3_v1")
root_id = 864691137055175542
client.chunkedgraph.get_root_timestamps(root_id, latest=True)

I get something reasonable

[datetime.datetime(2024, 10, 15, 22, 17, 53, 503000, tzinfo=<UTC>)]

[bdpedigo]

based on the milliseconds column, I bet this has to do with the timestamp shifting (so may be a caveclient issue)

EDIT: it looks like even before the shift the timestamp is 1970

[akhileshh]

Reading directly from the chunkedgraph (minnie3_v1) yields these timestamps, do they look correct?

[datetime.datetime(2024, 1, 30, 20, 22, 44, 689000, tzinfo=datetime.timezone.utc),
 datetime.datetime(2023, 5, 16, 23, 6, 11, 459000, tzinfo=datetime.timezone.utc),
 datetime.datetime(2024, 7, 9, 19, 27, 37, 99000, tzinfo=datetime.timezone.utc),
 datetime.datetime(2024, 6, 13, 19, 58, 8, 870000, tzinfo=datetime.timezone.utc)]

[bdpedigo]

they look at least like more plausible dates - is this with latest=True?

[akhileshh]

No, these are just the raw timestamps, when these IDs were actually created.

[akhileshh]

Using the logic to determine latest, the last one gives 0 so this bug is on server.