clickhouse Backup and Restore issue - tables are empty after the restore.
kishorer00 opened this issue · 0 comments
kishorer00 commented
Prerequisites
- Can you reproduce the problem with
Debug -> Reload Without Extensions
? YES - Did you perform a cursory search to see if your bug or enhancement is already reported? Yes. Nowhere reported
- Did you read the Troubleshooting guide? YES
For more information on how to write a good bug report read here
For more information on how to contribute read here
Description
click house Backup and Restore issue - tables are empty after the restore.
Click-house deployed using : https://dzone.com/articles/clickhouse-made-easy-getting-started-with-a-few-cl
Trying Backup and Restore by checking Article: https://github.com/AlexAkulov/clickhouse-backup/releases/tag/v1.0.0
[Description of the bug or feature]
- Unable to restore complete data from the Backup data
- Backup data is 150 GB
- Performed Restore - Able to restore databases, tables but tables are Empty.
- Backupedup the Restore Data size is 5.9 MB
- ======================
- 1.Copied the Backup Date: 151GB (Size)
2.Restored to Newly deployed Clichouse server
./clickhouse-backup restore -c config.yml 'BACKUPDATA'
- A lot of data is missing in Restore. Tables are created but no data
- Created the Backup again
./clickhouse-backup create -c config.yml
Backup fie Size 5.9M - File size comes down & a lot of tables are
empty. Attachment for your reference.
Tried Below scenario as well ..
- Deployed Clickhouse container
- Create couple of tables
- Copied the version v1 click house-back tool
-Tried backup and restore ..it no content restoring from to tables.
Steps to Reproduce
==================
- Deploy click-house docker container on CentOS 7 using the link: https://dzone.com/articles/clickhouse-made-easy-getting-started-with-a-few-cl
- Create some Databases and tables
- Try Backup and re-store ..After the Re-store verify the tables and content (rows/columns)
Expected behavior: [What you expected to happen]
- After the Restore, all Databases, tables, row/column should be Restored.
Actual behavior: [What actually happened]
- Restore is happening with Databases , tables .. Content rows/column are missing.Empty tables
- Also, the Size comes down from 150 GB to 5 MB.
Versions
Please include the OS and what version of the OS you're running.
Please include the version of Brackets. You can find it under Help -> About Brackets
(Windows and Linux) or Brackets -> About Brackets
(macOS)
- Running Click-house on Docker Environment
- Running Docker container on CentOS 7
- Click-house deployed using the link : https://dzone.com/articles/clickhouse-made-easy-getting-started-with-a-few-cl
- Tried Backup and Restore using the link : https://github.com/AlexAkulov/clickhouse-backup/releases/tag/v1.0.0
Please help me with this ...