Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Epochs with no transactions list 0 blocks #296

Closed
disassembler opened this issue Sep 17, 2020 · 3 comments
Closed

Epochs with no transactions list 0 blocks #296

disassembler opened this issue Sep 17, 2020 · 3 comments

Comments

@disassembler
Copy link
Contributor

disassembler commented Sep 17, 2020

This is best guess what's happening here. This appears to only be an issue with extended and the epoch table. Rest of the data is correct.

Below is from testnet:

cexplorer=# SELECT COUNT(*) FROM block WHERE epoch_no = 42;
-[ RECORD 1 ]
count | 21600

cexplorer=# SELECT * FROM epoch WHERE no = 42;
-[ RECORD 1 ]--------------------------
id         | 43
out_sum    | 0
tx_count   | 0
blk_count  | 0
no         | 42
start_time | 2020-09-15 14:03:14.248069
end_time   | 2020-09-15 14:03:14.248069
fees       | 0
@erikd
Copy link
Contributor

erikd commented Sep 17, 2020

This worked before I got Shelley support working. What network is this and how do I connect to it?

@erikd
Copy link
Contributor

erikd commented Mar 2, 2021

Ah, so this is about epochs with a non-zero number of blocks but a no transactions!

@erikd
Copy link
Contributor

erikd commented Mar 3, 2021

Ok, this is better:

testnet-tmp=# select * from epoch where no > 40 and no < 44 ; 
 id |     out_sum     |  fees   | tx_count | blk_count | no |     start_time      |      end_time       
----+-----------------+---------+----------+-----------+----+---------------------+---------------------
 42 |    830643812428 | 4460137 |       25 |     21600 | 41 | 2020-02-14 20:20:16 | 2020-02-19 20:19:56
 43 |               0 |       0 |        0 |     21600 | 42 | 2020-02-19 20:20:16 | 2020-02-24 20:19:56
 44 | 337136891243771 | 4859236 |       28 |     21600 | 43 | 2020-02-24 20:20:16 | 2020-02-29 20:19:56
(3 rows)

erikd added a commit that referenced this issue Mar 3, 2021
This really only happens on test nets, but previously, for epochs
with zero transactions, the `blk_count` was incorrectly set to
zero.

Closes: #296
erikd added a commit that referenced this issue Mar 3, 2021
This really only happens on test nets, but previously, for epochs
with zero transactions, the `blk_count` was incorrectly set to
zero.

Closes: #296
@erikd erikd closed this as completed in 7442c66 Mar 3, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants