algorand / algorand/go-algorand

Report on trackerdb schema upgrade progress.

Abierto
#5,418 0 comentarios 0 reacciones 0 asignados Ver en GitHub
Team Lamprey
Lenguaje dominante
Go
Estrellas
1.4k
Forks
537
Merge medio
1 d 7 h
PR fusionados (30 d)
18

Descripción

## 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.

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.