clickhouse Backup and Restore issue - tables are empty after the restore.

[core-ai-bot]

Issue by kishorer00
Friday Jun 18, 2021 at 16:39 GMT
Originally opened as adobe/brackets#15360

---

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

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

==================

1. Deploy click-house docker container on CentOS 7 using the link: https://dzone.com/articles/clickhouse-made-easy-getting-started-with-a-few-cl
2. Create some Databases and tables
3. 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 ...

[kishorer00]

• After the Click house Backup, the Backup folder "New-backup" size is not accurate, its 12 MB.
• Once we cd to the backup folder, i can see the backup size is 200 GB.-Is the actual one.
• Any fix for this ? using OS version: CentOS Linux release 7.6 (Core)

[pavan-datazip]

@kishorer00 did you find solutions to this problem ? I am facing the same issue now and have no leads.

[kishorer00]

Backups are creating the Hard links ,while generating the backups, once you copy the backup its showing the full size .. its already resolved in CH Foram