Skip to content
This repository has been archived by the owner on Sep 6, 2021. It is now read-only.

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

Open
3 tasks
kishorer00 opened this issue Jun 18, 2021 · 0 comments
Open
3 tasks

Comments

@kishorer00
Copy link

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
  1. 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)

Please help me with this ...

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant