network_status_entry with identical values except for the digest and network_status
Working on tpo/network-health/team#313, i realized there're rows in network_status_entry table with different digests for the same fingerprint, published and network_status digest, eg:
select published,fingerprint,digest,network_status,microdedescriptor_digest from network_status_entry where fingerprint='000A10D43011EA4928A35F610405F92B4433B4DC' and published='2024-03-31 02:29:50';
published | fingerprint | digest | network_status | microdedescriptor_digest
---------------------+------------------------------------------+---------------------------------------------+---------------------------------------------+--------------------------
2024-03-31 02:29:50 | 000A10D43011EA4928A35F610405F92B4433B4DC | iWiIp6Bi26GriDHV3f2877o3pykDt1v7BoVSq03KQz8 | +aAYTCiir3DOmdlk589Lb7zGjmSL521DqbTuSf+j/xY | null
2024-03-31 02:29:50 | 000A10D43011EA4928A35F610405F92B4433B4DC | PhGoaqQGlsZYtq4lma7z40L9fMReYFAlZBG0yyBcYzk | pNXFTltzqXeAVWXZCSF8ctS44fx/iq3aH+8K8aD6zaU | null
Then i realized that 1 of the network_status.digest doesn't exists:
select count(*) from network_status where digest='pNXFTltzqXeAVWXZCSF8ctS44fx/iq3aH+8K8aD6za';
count
-------
0
I don't know if this is due old data still in the database or something else with the parser or collector.