pocketnetteam / pocketnet.core

Decentralized social network based on the blockchain
https://pocketnet.app
Apache License 2.0
115 stars 28 forks source link

0.22.0-beta1 No meaningful info about updating the DB to NEW SQL DB - TLDR; A stage X of Y display would be nice. #629

Closed the-real-vortex-v closed 10 months ago

the-real-vortex-v commented 10 months ago

I'm using the 0.22.0-beta1 version. I'm updating the database. All I see are lines like this:

2023-11-29T08:27:14Z init message: Loading Pocket DB... 2023-11-29T08:27:14Z SQLite usage version: 3042000 2023-11-29T08:27:14Z scheduler thread start 2023-11-29T08:27:14Z init message: Updating Pocket DB main.sqlite3 structure.. 2023-11-29T08:27:14Z Updating Pocket DB main.sqlite3 structure.. 2023-11-29T08:27:14Z init message: Updating Pocket DB newdb.sqlite3 structure.. 2023-11-29T08:27:14Z Updating Pocket DB newdb.sqlite3 structure.. 2023-11-29T08:27:14Z Fulfilling Registry... 2023-11-29T08:43:47Z took 993 seconds 2023-11-29T08:43:47Z Fulfilling Chain... 2023-11-29T09:27:15Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T10:27:15Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T11:27:15Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T11:29:16Z took 9929 seconds 2023-11-29T11:29:16Z Fulfilling Lists... 2023-11-29T11:30:45Z took 89 seconds 2023-11-29T11:30:45Z Fulfilling Last... 2023-11-29T12:12:10Z took 2485 seconds 2023-11-29T12:12:10Z Fulfilling First... 2023-11-29T12:27:15Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T12:37:47Z took 1537 seconds 2023-11-29T12:37:47Z Fulfilling Transactions... 2023-11-29T13:27:15Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T14:27:15Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T15:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T16:09:39Z took 12712 seconds 2023-11-29T16:09:39Z Fulfilling TxOutputs... 2023-11-29T16:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T17:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T18:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T19:27:15Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T20:27:15Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T21:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T21:51:21Z took 20502 seconds 2023-11-29T21:51:21Z Fulfilling TxInputs... 2023-11-29T22:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-29T23:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-30T00:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-30T01:13:56Z took 12155 seconds 2023-11-30T01:13:56Z Fulfilling Balances... 2023-11-30T01:16:22Z took 146 seconds 2023-11-30T01:16:22Z Fulfilling Ratings... 2023-11-30T01:16:38Z took 16 seconds 2023-11-30T01:16:38Z Fulfilling Payload... 2023-11-30T01:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-30T02:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-30T03:24:01Z took 7643 seconds 2023-11-30T03:24:01Z Fulfilling other tables (BlockingLists, Jury, Badgets)... 2023-11-30T03:26:19Z took 138 seconds 2023-11-30T03:26:19Z Total migrating time: 68345s 2023-11-30T03:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-30T03:53:44Z init message: Updating Pocket DB main.sqlite3 structure.. 2023-11-30T03:53:44Z Updating Pocket DB main.sqlite3 structure.. 2023-11-30T04:27:14Z GUI: Check updates result: error: QNetworkReply::NetworkError(ProtocolUnknownError) 2023-11-30T04:41:18Z SQLite database version: 0 2023-11-30T04:41:18Z init message: Updating Pocket DB web.sqlite3 structure.. 2023-11-30T04:41:18Z Updating Pocket DB web.sqlite3 structure..


What I'd like is A basic progress bar that has "Stage X of Y". Percent is misleading as each stage is not the same amount of time so a percent is not a good idea.

As it currently stands I have no idea howlong/how many more "Fulfilling" stages are left. All this would need is some debuglog printfs to update the debuglong with where the database update/convert progress is upto and a little fancy progress bar for the UI.

When you do the UI progress bar you should have something that give vague feedback that shows the system isn't hung like moving a spinner or a progress bar pallet rotate or something. A raw number like "transaction X of y" that gets updated every 2 or so secs would be good as well.


It finally finished updating/resyncing etc. only took about 20hrs, I seriously hope you add a progress bar/status bar (maybe an eta?) so people don't think their node is frozen.