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

Problem for table creations when running against some non fresh started node #149

Open
jun0tpyrc opened this issue Aug 19, 2021 · 1 comment

Comments

@jun0tpyrc
Copy link

jun0tpyrc commented Aug 19, 2021

Tried on different mainnet/testnet , when pruned subscan mysql to start against an already in sync rpc node

some calculation will make them just create table without those number before / the one without _{number} suffix

e.g.  just having these on testnet westend 

mysql> show tables;
+--------------------+
| Tables_in_subscan  |
+--------------------+
| chain_blocks_5     |
| chain_events_5     |
| chain_extrinsics_5 |
| chain_logs_5       |
| runtime_versions   |
+--------------------+

and these on mainnet 

mysql> show tables;
+--------------------+
| Tables_in_subscan  |
+--------------------+
| chain_blocks_7     |
| chain_events_7     |
| chain_extrinsics_7 |
| chain_logs_7      |
| runtime_versions   |
+--------------------+

api component will fail for

2021/08/19 15:31:48 start watch filepath: ../configs
panic: Error 1146: Table 'subscan.chain_blocks' doesn't exist

too

@jun0tpyrc jun0tpyrc changed the title Bug for table creations when running against some non fresh started node Problem for table creations when running against some non fresh started node Aug 19, 2021
@jun0tpyrc
Copy link
Author

seem to be a new feature that only index from last batch of blocks , in that case seem ok to expect creating tables by self , how do that param got tuned to re-index all blocks?

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

1 participant