Skip to content

Inconsistencies in some `server_status` columns data format

Most of the inconsistencies involve columns that should contain an array of strings:

  • verified_hostname, unverified_host_names should contain an array of strings but some rows contain "null", we should make those values NULL or [].

  • diff_or_addresses should contain an array of strings but some rows contain NULL, [] and empty strings, we should standardize the column so that it's easier to parse.

  • unreachable_or_address should contain an array of strings but a lot of rows contain an empty string, we should make those empty string NULL or [].

  • effective_family, declared_family should contain an array of strings but some rows contain a single effective family value, we should standardize that column so that it's easier to parse (i.e 1111111111111111111111111111111111111111 should be ["1111111111111111111111111111111111111111"]).

Edited by Mattia Righetti