algorand / algorand/go-algorand

Report on trackerdb schema upgrade progress.

オープン
#5,418 コメント 0 件 リアクション 0 件 担当者 0 名 GitHub で見る
Team Lamprey
主要言語
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 はまだ評価されていません。

新しい issue をメールで受け取る

初心者向けの GitHub issue を短くまとめたダイジェスト。