MySQL Forums
Forum List  »  MySQL & Kubernetes

mysql backup fails: failed to get summary
Posted by: Johannes Trattner
Date: July 04, 2023 12:04AM

Hi guys,

I'm facing this problem and can't figure out what might be causing this error. I hope you guys can help me.

I set up an InnoDb Cluster in Kubernetes (2 Routers, 3 Instances) and created a TestDB. Then I wanted to create a Cron Backup Job and save the backup in a minio bucket.
When the backup job is triggered i always get this error:

---
.
.
.
Writing schema metadata - done
ERROR: [Worker016]: Error while dumping `testdb`.`testtable`: Failed to get summary for object 'mysql-testjt-hourly230704050004/testdb@testtable.tsv.zst': Forbidden
ERROR: [Worker020]: Error while dumping `mysql_innodb_cluster_metadata`.`router_rest_accounts`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@router_rest_accounts.tsv.zst': Forbidden
ERROR: [Worker027]: Error while dumping `mysql_innodb_cluster_metadata`.`async_cluster_views`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@async_cluster_views.tsv.zst': Forbidden
ERROR: [Worker022]: Error while dumping `mysql_innodb_cluster_metadata`.`clustersets`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@clustersets.tsv.zst': Forbidden
ERROR: [Worker025]: Error while dumping `mysql_innodb_cluster_metadata`.`routers`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@routers.tsv.zst': Forbidden
ERROR: [Worker011]: Error while dumping `mysql_innodb_cluster_metadata`.`async_cluster_members`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@async_cluster_members.tsv.zst': Forbidden
ERROR: [Worker030]: Error while dumping `mysql_innodb_cluster_metadata`.`clusters`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@clusters.tsv.zst': Forbidden
ERROR: [Worker017]: Error while dumping `mysql_innodb_cluster_metadata`.`instances`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@instances.tsv.zst': Forbidden
ERROR: [Worker029]: Error while dumping `mysql_innodb_cluster_metadata`.`clusterset_members`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@clusterset_members.tsv.zst': Forbidden
ERROR: [Worker023]: Error while dumping `mysql_innodb_cluster_metadata`.`clusterset_views`: Failed to get summary for object 'mysql-testjt-hourly230704050004/mysql_innodb_cluster_metadata@clusterset_views.tsv.zst': Forbidden
2023-07-04T05:09:26 - [ERROR] [backup] dump_instance failed: Shell Error (52006): Util.dump_instance: While 'Writing DDL': Fatal error during dump
Traceback (most recent call last):
File "/usr/lib/mysqlsh/python-packages/mysqloperator/backup_main.py", line 291, in command_do_create_backup
info = do_backup(backup, job_name, start, backup_dir, logger)
File "/usr/lib/mysqlsh/python-packages/mysqloperator/backup_main.py", line 207, in do_backup
return execute_dump_instance(backup_source, profile.dumpInstance, backupdir, job_name, logger)
File "/usr/lib/mysqlsh/python-packages/mysqloperator/backup_main.py", line 92, in execute_dump_instance
util.dump_instance(output, options)
mysqlsh.Error: Shell Error (52006): Util.dump_instance: While 'Writing DDL': Fatal error during dump
2023-07-04T05:09:26 - [ERROR] [backup] Backup failed with an exception: Shell Error (52006): Util.dump_instance: While 'Writing DDL': Fatal error during dump
2023-07-04T05:09:26 - [INFO] [backup] Command execute-backup finished with code False
---



this is my cluster manifest:

---

apiVersion: mysql.oracle.com/v2
kind: InnoDBCluster
metadata:
name: mysql-testjt
spec:
tlsUseSelfSigned: true
secretName: mypwds
instances: 3
router:
instances: 2
datadirVolumeClaimTemplate:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 2Gi
storageClassName: myStorageClass
backupSchedules:
- name: hourly
enabled: true
schedule: "0 * * * *"
backupProfileName: mysql-minio-backup
backupProfiles:
- name: mysql-minio-backup
dumpInstance:
storage:
s3:
endpoint: <myMinioEndpoint>
bucketName: test-app-bucket
config: minio-secret
profile: default

---


Some files were written to the bucket and the bucket user used for this backup has read/write access.
I also get this error when connecting to the cluster and creating the backup manually (via util.dumpInstance())

What can be done?


Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
mysql backup fails: failed to get summary
July 04, 2023 12:04AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.