Extra dreps in drep_hash

[mesudip]

Versions
The db-sync version (eg cardano-db-sync --version):

• ghcr.io/intersectmbo/cardano-db-sync:13.6.0.4 (upgraded over time)

PostgreSQL version:

• docker.io/postgres:15.0

Additional context
Network: mainnet

Problem Report
Suprisingly there are drep_hash entries in dbsync that were never registered.

SELECT *
    FROM drep_hash
    left join public.drep_registration dr on drep_hash.id = dr.drep_hash_id
    WHERE  dr.id is NULL and raw is not NULL

+-----+----------------------------------------------------------+--------------------------------------------------------+----------+----+-----+----------+-------+------------+----------------+
|id   |raw                                                       |view                                                    |has_script|id  |tx_id|cert_index|deposit|drep_hash_id|voting_anchor_id|
+-----+----------------------------------------------------------+--------------------------------------------------------+----------+----+-----+----------+-------+------------+----------------+
|14348|0x2BCCC3B22A9D63FE5F85EA1F48536CC434FF17E8A8917111119159F4|drep190xv8v32n43luhu9ag05s5mvcs6079lg4zghzyg3j9vlgsm80cs|false     |null|null |null      |null   |null        |null            |
|34428|0x5CB9FD8D69FABFCA98A13E8756C8A67557B08B38F30EAD6396DDC491|drep1tjulmrtfl2lu4x9p86r4dj9xw4tmpzec7v826cukmhzfzf3dk49|false     |null|null |null      |null   |null        |null            |
|20477|0x32F7AA072565ED1F83836263248365E3C689CE324C16751E78B372C6|drep1xtm65pe9vhk3lqurvf3jfqm9u0rgnn3jfst828nckdevv6ze8qg|false     |null|null |null      |null   |null        |null            |
|25347|0xB8CCB4404439F714153E572843E2D7DCB3517AB65C484914A6E299CE|drep1hrxtgszy88m3g9f72u5y8ckhmje4z74kt3yyj99xu2vuutu9d50|true      |null|null |null      |null   |null        |null            |
|17048|0x7BE42D7ED352A5F3D1125158BFB9CD1B56BD98676F3FA0E48E4709E7|drep100jz6lkn22jl85gj29vtlwwdrdttmxr8dul6peywguy7waev0hz|false     |null|null |null      |null   |null        |null            |
|18783|0xCE103AAEA98C17B8691A3232665651B8BECF257415F6C64B0F1123E6|drep1ecgr4t4f3stms6g6xgexv4j3hzlv7ft5zhmvvjc0zy37vzg0ell|false     |null|null |null      |null   |null        |null            |
|125  |0xE5AB37261B3D63600D566564879370AEA031EA3108B0A6BD8CEF58AA|drep1uk4nwfsm843kqr2kv4jg0yms46srr633pzc2d0vvaav25ncwj8g|false     |null|null |null      |null   |null        |null            |
|22436|0x8DFEB1386C8520EDA55F556A9727F23C7B5DA6446826D9AA4E20C6D1|drep13hltzwrvs5swmf2l244fwflj83a4mfjydqndn2jwyrrdzp54a7q|false     |null|null |null      |null   |null        |null            |
|26096|0x429B12461640CEFD3A4A192F7C531D8F6C6D33610B727F481EB22D39|drep1g2d3y3skgr806wj2ryhhc5ca3akx6vmppde87jq7kgknjmv589e|false     |null|null |null      |null   |null        |null            |
|22343|0x77AD23DEEF7941BF5279B759E2BF924EC55E7668757C40FB708D3E7E|drep1w7kj8hh009qm75nekav790ujfmz4uangw47yp7ms35l8u3qt8wk|false     |null|null |null      |null   |null        |null            |
|7063 |0x5F14B5B5CDDB0839DF02696194268EF48673836D7777A7C05FFD2F3E|drep1tu2ttdwdmvyrnhczd9segf5w7jr88qmdwam60szll5hnut06n7t|false     |null|null |null      |null   |null        |null            |
|1328 |0x0000000000000000000000000000000000000000000000000000BEEF|drep1qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqzlw7l2kzct|true      |null|null |null      |null   |null        |null            |
|22345|0x766FEA13963A6C27A98D4C48221548CC3E2D10AD7C085C5FB9936DFA|drep1weh75yuk8fkz02vdf3yzy92geslz6y9d0sy9chaejdkl58vqq6w|false     |null|null |null      |null   |null        |null            |
|21164|0x026BC61887FEC595F457AEF1DFA8D118533E512B6C41553B9523F8AB|drep1qf4uvxy8lmzetazh4mcal2x3rpfnu5ftd3q42wu4y0u2kaj2c2n|false     |null|null |null      |null   |null        |null            |
|27077|0x89C36B1D78BB70AD750ECC33331A6BA73A52159BB76B1D1F162813EB|drep138pkk8tchdc26agwesenxxnt5ua9y9vmka4368ck9qf7k8ptzzq|false     |null|null |null      |null   |null        |null            |
|20186|0xF99DF562D33EFF5D2CB07B3B2EBCD0AFFE3CBBD5976EABB94B102BD4|drep1lxwl2ckn8ml46t9s0vaja0xs4llrew74jah2hw2tzq4ag8ef64h|false     |null|null |null      |null   |null        |null            |
|3348 |0x598876EE91EF4D9E10F9482CC81E0DDB3DBD5E92D7440F0D3466714C|drep1txy8dm53aaxeuy8efqkvs8sdmv7m6h5j6azq7rf5vec5ccrs5e8|false     |null|null |null      |null   |null        |null            |
|20710|0xEB8A7CF53E349AF978E81C64CEEFCEA659A05559B83C384CF938E0CA|drep1aw98eaf7xjd0j78gr3jvam7w5ev6q42ehq7rsn8e8rsv57tgr87|false     |null|null |null      |null   |null        |null            |
|13496|0x199AD2959C8C4E4D50A04A0F3D873B692FF86FBC6A195DD44D17B746|drep1rxdd99vu338y659qfg8nmpemdyhlsmaudgv4m4zdz7m5vd9p2hm|false     |null|null |null      |null   |null        |null            |
|42345|0x8960A6E435EE79631D858A2C652E41B6FD9B93199C17148C0C846AEE|drep139s2dep4aeukx8v93gkx2tjpkm7ehycenst3frqvs34wupn8ya2|false     |null|null |null      |null   |null        |null            |
|16952|0x732E7985F23CC1CD6FEDF9FD1E2AF5D0806B34149B95506F81BB3CD6|drep1wvh8np0j8nqu6mldl873u2h46zqxkdq5nw24qmuphv7dvjx825z|false     |null|null |null      |null   |null        |null            |
|12187|0x2FD2B7998DD8A5E29FD012D224B596938FCC5A30E64261FF666A92CD|drep19lft0xvdmzj7987sztfzfdvkjw8uck3suepxrlmxd2fv6lfcrel|false     |null|null |null      |null   |null        |null            |
|22330|0xB7EE2A7939E658D2DBFC8A21F8AA9B2ABCF32BF7FE585B7F3B2058FA|drep1klhz57feuevd9klu3gsl325m9270x2lhlev9klemypv05whrd67|false     |null|null |null      |null   |null        |null            |
|40849|0xB96897B866EC26F4B93D93B2792E496BA9369CEF6BFD175D5FFB0D6A|drep1h95f0wrxasn0fwfajwe8jtjfdw5nd880d073wh2llvxk54rvnus|false     |null|null |null      |null   |null        |null            |
|37210|0x349E9C83F204A8509A741DCF7229C9C28993B6002BB0FD4D6B375798|drep1xj0feqljqj59pxn5rh8hy2wfc2ye8dsq9wc06nttxatesu0myru|false     |null|null |null      |null   |null        |null            |
+-----+----------------------------------------------------------+--------------------------------------------------------+----------+----+-----+----------+-------+------------+----------------+

[kderme]

This is not wrong by itself.
There could be some vote delegation to these dreps. Or it could be the result of the rollback. An entry to this table doesn't mean anything by itself, if there is no reference to it.