algorand / algorand/go-algorand
Report on trackerdb schema upgrade progress.
- 主要言語
- Go
- スター
- 1.4k
- フォーク
- 537
- 平均マージ
- 1日 7時間
- マージ済み PR(30日)
- 18
説明
## Problem
During a schema upgrade the node appears unresponsive for several minutes. The only status report is in the node.log file. This happens after a fast catchup and occasionally during algod software updates.
Relevant logs:
```
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema5.func1","level":"info","line":354,"msg":"upgradeDatabaseSchema5 upgraded 1 out of 102 accounts [ 1.0% ]","name":"","time":"2023-05-25T17:49:54.632777Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 1 out of 17615390 accounts [ 0.0% ]","name":"","time":"2023-05-25T17:50:20.554150Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 2051034 out of 17615390 accounts [ 11.6% ]","name":"","time":"2023-05-25T17:50:25.554157Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 4105939 out of 17615390 accounts [ 23.3% ]","name":"","time":"2023-05-25T17:50:30.554158Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 6174967 out of 17615390 accounts [ 35.1% ]","name":"","time":"2023-05-25T17:50:35.554172Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 8211770 out of 17615390 accounts [ 46.6% ]","name":"","time":"2023-05-25T17:50:40.554166Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 10219007 out of 17615390 accounts [ 58.0% ]","name":"","time":"2023-05-25T17:50:45.554162Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 11999598 out of 17615390 accounts [ 68.1% ]","name":"","time":"2023-05-25T17:50:50.554164Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 13407661 out of 17615390 accounts [ 76.1% ]","name":"","time":"2023-05-25T17:50:55.554201Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 14490394 out of 17615390 accounts [ 82.3% ]","name":"","time":"2023-05-25T17:51:00.554192Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 15594884 out of 17615390 accounts [ 88.5% ]","name":"","time":"2023-05-25T17:51:05.554196Z"}
{"file":"trackerdbV2.go","function":"github.com/algorand/go-algorand/ledger/store/trackerdb/sqlitedriver.(*trackerDBSchemaInitializer).upgradeDatabaseSchema6.func1","level":"info","line":421,"msg":"upgradeDatabaseSchema6 upgraded 16711406 out of 17615390 accounts [ 94.9% ]","name":"","time":"2023-05-25T17:51:10.554218Z"}
```
## Solution
Add upgrade progress to `goal node status` and related REST APIs.
コントリビューションガイド
評価
この issue はまだ評価されていません。