stoneatom / stonedb

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)
https://stonedb.io/
GNU General Public License v2.0
867 stars 141 forks source link

bug: If stonedb is closed by mistake, the meta information of stonedb may not be persisted correctly and stonedb will not be able to be restarted at this point. #1275

Open duanfuxiang0 opened 1 year ago

duanfuxiang0 commented 1 year ago

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

Describe the problem

If you mistakenly shut down stonedb, for example due to a power failure or unknown server crash, the meta information stored in rocksdb may not be persisted correctly and stonedb may not be possible to restart correctly IMG_0812 you can delete the rocksdb storage directory to temporarily fix this problem.

rm -r /stonedb57/install/data/.index

Data already persisted in TIANMU will not be lost, but data in insert_buffer will be lost, so this abnormal shutdown needs to be fixed.

Expected behavior

No response

How To Reproduce

No response

Environment

No response

Are you interested in submitting a PR to solve the problem?

RingsC commented 1 year ago

Do you know why rocksdb can not recovery from failure? it's a transactional storage engine.