UnamSanctam / UnamWebPanel

MIT License
164 stars 60 forks source link

Potential database error ⚠️ ⚠️⚠️⚠️⚠️ #344

Open DerXanRam opened 4 months ago

DerXanRam commented 4 months ago

starting from last night, my web panel starts showing database error when I login and filter offline miners. There isn't anything new I done. the error just suddenly started appearing. new thing happened is, my miners number increased almost 2X.

Screenshot (3)

is there a way i can recover from this issue without losing the previous data? because I have many configurations for different CPU types and countries, and it will be very hard to rebuild from scratch.

UnamSanctam commented 4 months ago

It can happen if the server hosting your website suddenly stops/crashes while it's writing some data. Some precautions are disabled for better concurrency (for those with a lot of miners). You can try opening the database file with some SQLite database explorer to see if it's still readable. If not then it might still be possible to get your configurations by editing the database file as text (with something like notepad++)-

DerXanRam commented 4 months ago

It can happen if the server hosting your website suddenly stops/crashes while it's writing some data. Some precautions are disabled for better concurrency (for those with a lot of miners). You can try opening the database file with some SQLite database explorer to see if it's still readable. If not then it might still be possible to get your configurations by editing the database file as text (with something like notepad++)-

Very sorry for my late response. I tries but the db is completely corrupted.

UnamSanctam commented 4 months ago

If you want me to take a look at it then you can send me the db/unamwebpanel.db file (and any other files in there) to me at unams@protonmail.com.