[MDEV-18419] mariabackup fails to backup any databases Created: 2019-01-29 Updated: 2020-07-01 Resolved: 2019-01-29 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Configuration, mariabackup |
| Affects Version/s: | 10.3.11 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Steven M Castano | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
2 Ubuntu 18.04.1 virtual machines under VMware with MariaDB 10.3.11 install in a galera cluster with a 3 VM in the Amazon cloud for async replication. |
||
| Issue Links: |
|
||||||||
| Description |
|
When attempting to do a backup with the mariabackup, which I wanted to use for it's ability to create incremental backups, the initial full backup fails to even begin. Here is the error output:
|
| Comments |
| Comment by Elena Stepanova [ 2019-01-29 ] | |||
|
It complains about the lack of memory. Do you have enough memory on the machine? | |||
| Comment by Steven M Castano [ 2019-01-29 ] | |||
|
I do.. InnoDB buffer pool is set to 16G, memory in the VM is 32G and reports that plenty is free:
| |||
| Comment by Elena Stepanova [ 2019-01-29 ] | |||
|
MariaBackup runs its own instance of InnoDB. If you just run it without providing any specific options, it will use the configuration from your config file, and thus will also want 16G for InnoDB buffer pool alone. | |||
| Comment by Steven M Castano [ 2019-01-29 ] | |||
|
I'm looking into that not and testing some settings, it does appear that this will work... I'm just letting a full backup run, then I'll test an incremental and everything should be good! | |||
| Comment by Steven M Castano [ 2019-01-29 ] | |||
|
It looks like the advice given was exactly correct, specifying the memory size on the command line and/or adding more memory for another large pool works great. All databases completed both full and minor incremental backups. Thanks for the help! | |||
| Comment by Elena Stepanova [ 2019-01-29 ] | |||
|
No problem. Good luck! |