I can create a backup but when I try to list the backups i get the error:
sdb-admin list-backups -r azure://memsql/database
no selection options specified, selecting latest backups
✓ successfully listed backups
The following information is generated from the local backup cache. Use the --no-cache flag if you want to get the latest information from the remote repository.
WARNING: Warning: list-backup command shows only full and split backups.
panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0x998238]
After updating tools to 1.12.2 i can list the backups but when trying to create incremental backups i get some errors. Full backups seems to work ok.
Creating the init backup is successful:
sdb-admin create-backup -r azure://memsql/database database --backup-type init --backup-suffix first_backup
Toolbox will perform the following actions:
· backup "database" to azure://memsql/database/database_first_backup
Would you like to continue? [y/N]: y
✓ successfully backed up "database" to azure://memsql/database/database_first_backup
Operation completed successfully
But when i try to do the incremental:
sdb-admin create-backup -r azure://memsql/database database --backup-type differential --backup-suffix first_backup
Toolbox will perform the following actions:
· backup "database" to azure://memsql/database/database_first_backup
Would you like to continue? [y/N]: y
✘ failed to backup "database" to azure://memsql/database/database_first_backup:
error running memsqlctl: error running command: `/bin/ssh -oBatchMode=yes -q -tt -oControlPath=/tmp/singlestoredb-toolbox697379285/1.socket 10.242.242.164 memsqlctl --json --yes query --memsql-id B2DA1ED8B81F77EE4E69374A8A0B5890955A40E6 --sql $1`
where $1 = `BACKUP DATABASE `database` WITH DIFFERENTIAL TO AZURE "memsql/database/database_first_backup" CREDENTIALS {"account_name":"*****","account_key":"*****"}--row-timeout 24h0m0s --strict-mode`: exit status 1:
stdout: could not process query results: Error 2297: Attempting to get the size of the backup target failed. Stderr tail:
freya-worker/memsql/go/src/memsqld/backup/util/util.go:37 +0x149
main.(*Azure).listBlobs(0xc0004b7da0, 0x7fff5b1b6e41, 0x6, 0x7fff5b1b6e48, 0x33, 0x0, 0x0)
/data/freya-worker/memsql/go/src/memsqld/backup/azure.go:267 +0x5c2
main.(*Azure).Handle(0xc000171da0, 0xc000171cf0, 0xc0000251e0, 0x5)
/data/freya-worker/memsql/go/src/memsqld/backup/azure.go:974 +0xa2a
main.main()
/data/freya-worker/memsql/go/src/memsqld/backup/main.go:226 +0x650
stderr: (empty)
failed to create 1 backup(s) out of 1
What version of SingleStoreDB are you on and do you happen to be using ADLS Gen2 or is it just plain Azure Blob storage? Incremental backups currently do not work with ADLS Gen2, but a planned fix is in the road map.