No data in link tx table

[myrho]

see #!eth/addresslink/0xd551234ae421e3bcba99a0da6d736074f22192ff/0xe344e4b209e8eabaa2a6ddd1b0aa120b7599af25

[myrho]

@defconst is this a data inconsistency?

SELECT no_transactions FROM address_outgoing_relations WHERE src_address_id_group = 1582 AND src_address_id_secondary_group in (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18)  AND src_address_id = 39559755 AND dst_address_id = 50404330;

 no_transactions
-----------------

(0 rows)

whereas the counter part yields a result

SELECT no_transactions FROM address_incoming_relations WHERE dst_address_id_group = 2016 AND dst_address_id_secondary_group in (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18)  AND src_address_id = 39559755 AND dst_address_id = 50404330;

 no_transactions
-----------------
               1

(1 rows)

[defconst]

src_address_id_secondary_group is 21 for outgoing relations

CQL

cqlsh:eth_transformed_20220624_lq> SELECT no_transactions FROM address_outgoing_relations WHERE src_address_id_group = 1582 AND src_address_id_secondary_group=21  AND src_address_id = 39559755 AND dst_address_id = 50404330;

 no_transactions
-----------------
               1

Spark

In [14]: addr_in_rel.filter((col("src_address_id")==39559755) & (col("dst_address_id") == 50404330)).show(20)
+--------------------+------------------------------+--------------+--------------+---------------+--------------------+
|dst_address_id_group|dst_address_id_secondary_group|dst_address_id|src_address_id|no_transactions|               value|
+--------------------+------------------------------+--------------+--------------+---------------+--------------------+
|                2016|                             0|      50404330|      39559755|              1|{6522050900000000...|
+--------------------+------------------------------+--------------+--------------+---------------+--------------------+

In [15]: addr_out_rel.filter((col("src_address_id")==39559755) & (col("dst_address_id") == 50404330)).show(20)
+--------------------+------------------------------+--------------+--------------+---------------+--------------------+
|src_address_id_group|src_address_id_secondary_group|src_address_id|dst_address_id|no_transactions|               value|
+--------------------+------------------------------+--------------+--------------+---------------+--------------------+
|                1582|                            21|      39559755|      50404330|              1|{6522050900000000...|
+--------------------+------------------------------+--------------+--------------+---------------+--------------------+

[myrho]

Then this should be 21?

cqlsh:eth_transformed_20220624_lq> select max_secondary_id FROM address_transacti
ons_secondary_ids WHERE address_id_group = 1582;

 max_secondary_id
------------------
               18

(1 rows)

[behas]

close or postpone?

[defconst]

postpone

[defconst]

Example above no longer reproducible, but observed again for address https://app.ikna.io/graph/eth/address/0xe1e890c8464db729ca3c52f8409107835c2ca2bf#0

• no tx found between 0x8f22f2063d253846b53609231ed80fa571bc0c8f (159494003) and 0xe1e890c8464db729ca3c52f8409107835c2ca2bf (172691167)
• no tx found between 0xd551234ae421e3bcba99a0da6d736074f22192ff (39559755) and 0xe1e890c8464db729ca3c52f8409107835c2ca2bf (172691167)

Keyspace eth_transformed_20220815_lq (height 15342780)

[myrho]

With keyspace eth_transformed_20220826_lq the latter one yields txs. The first one still is empty (verified through Rest API).

[myrho]

seems to be solved