Summary

Differences against disputed indexer entity state:

Entity states

Disputed Indexer DB

select * from sgd7.deregistered_service_provider_event where lower(block_range) = 11273929;

-[ RECORD 1 ]--+-------------------------------------------
id             | creator-node::4
type           | creator-node
sp_id          | 4
node           | creator-node::4
owner          | 0xccd0855b67f89ed9058e3bf2926d5380182bbbfc
endpoint       | <https://content-node.audius.co/>
unstake_amount | 200000000000000000000000
block_number   | 11273929
vid            | 4
block_range    | [11273929,)

select * from sgd7.user where lower(block_range) = 11273929;

-[ RECORD 1 ]------------------------+-------------------------------------------
id                                   | 0xccd0855b67f89ed9058e3bf2926d5380182bbbfc
balance                              | 200000000000000000000000
total_claimable_amount               | 200000000000000000000000
claimable_stake_amount               | 200000000000000000000000
claimable_delegation_received_amount | 0
claimable_delegation_sent_amount     | 0
stake_amount                         | 200000000000000000000000
delegation_received_amount           | 0
delegation_sent_amount               | 0
has_stake_or_delegation              | t
valid_bounds                         | t
deployer_cut                         | 100
min_account_stake                    | 200000000000000000000000
max_account_stake                    | 10000000000000000000000000
pending_decrease_stake               |
pending_remove_delegator             |
pending_update_deployer_cut          |
pending_undelegate_stake             |
created_at                           | 1604017727
vid                                  | 40665
block_range                          | [11273929,11273945)

Reference Indexers

select * from deregistered_service_provider_event where lower(block_range) = 11273929;

-[ RECORD 1 ]--+-------------------------------------------
id             | creator-node::4
type           | creator-node
sp_id          | 4
node           | creator-node::4
owner          | 0xccd0855b67f89ed9058e3bf2926d5380182bbbfc
endpoint       | <https://content-node.audius.co>
unstake_amount | 200000000000000000000000
block_number   | 11273929
vid            | 4
block_range    | [11273929,)

select * from sgd10.user where lower(block_range) = 11273929;

-[ RECORD 1 ]------------------------+-------------------------------------------
id                                   | 0xccd0855b67f89ed9058e3bf2926d5380182bbbfc
balance                              | 200000000000000000000000
total_claimable_amount               | 0
claimable_stake_amount               | 0
claimable_delegation_received_amount | 0
claimable_delegation_sent_amount     | 0
stake_amount                         | 200000000000000000000000
delegation_received_amount           | 0
delegation_sent_amount               | 0
has_stake_or_delegation              | t
valid_bounds                         | t
deployer_cut                         | 100
min_account_stake                    | 0
max_account_stake                    | 0
pending_decrease_stake               | 3
pending_remove_delegator             | 
pending_update_deployer_cut          | 
pending_undelegate_stake             | 
created_at                           | 1604017727
vid                                  | 40665
block_range                          | [11273929,11273945)

select * from sgd10.decrease_stake_event where lower(block_range) = 11273929;

-[ RECORD 1 ]--------+-------------------------------------------
id                   | 3
status               | Requested
owner                | 0xccd0855b67f89ed9058e3bf2926d5380182bbbfc
expiry_block         | 11320452
created_block_number | 11273929
ended_block_number   | 
decrease_amount      | 200000000000000000000000
new_stake_amount     | 
vid                  | 1
block_range          | [11273929,11329125)