mysqldump hangs forever...... #397

Closed
opened 2021-03-10 20:13:06 +00:00 by TCr · 5 comments

I have problem to backup all or just a single db.

The last thing I can see on the console with --verbosity 2 is:

check_free_space: few segments, not requiring a full free segment
check_free_space: calculated working space for compact as 305020206 bytes
check_free_space: required bytes 326000764, free bytes 5342625603584
security: saving state for cbf03bffcf7c96d0af6c88aa6ac6cffe08dfb2096eaf002c3c21c8d90627057b to /home/thomas/.config/borg/security/cbf03bffcf7c96d0af6c88aa6ac6cffe08dfb2096eaf002c3c21c8d90627057b
security: current location   /backup/local.borg
security: key type           3
security: manifest timestamp 2021-03-10T19:41:33.876449
terminating with success status, rc 0

but than nothing elso happens.

grafik

I can only see, that mysqldump is still running and that borgmatic uses 100% cpu.

I also used the find /my/backup/paths/ -type c,b,p to find and exclude all special files.

My borgmatic version is: 1.5.12

I have problem to backup all or just a single db. The last thing I can see on the console with `--verbosity 2` is: ``` check_free_space: few segments, not requiring a full free segment check_free_space: calculated working space for compact as 305020206 bytes check_free_space: required bytes 326000764, free bytes 5342625603584 security: saving state for cbf03bffcf7c96d0af6c88aa6ac6cffe08dfb2096eaf002c3c21c8d90627057b to /home/thomas/.config/borg/security/cbf03bffcf7c96d0af6c88aa6ac6cffe08dfb2096eaf002c3c21c8d90627057b security: current location /backup/local.borg security: key type 3 security: manifest timestamp 2021-03-10T19:41:33.876449 terminating with success status, rc 0 ``` but than nothing elso happens. ![grafik](/attachments/62b47a4a-7dae-41a4-aa93-447d42a0e29e) I can only see, that mysqldump is still running and that borgmatic uses 100% cpu. I also used the `find /my/backup/paths/ -type c,b,p` to find and exclude all special files. My borgmatic version is: 1.5.12
Author

I just want to add the current state:

The task is still running on the same condition for now over 10 hours

grafik

I just want to add the current state: The task is still running on the same condition for now over 10 hours ![grafik](/attachments/9834e786-13a7-47d4-b03d-025b98b6c232)
Author

Now after killing mysqldump:

grafik

Now after killing mysqldump: ![grafik](/attachments/9fddbdd1-a54e-4a06-a996-c448dbedc2ed)
Author

I created a command to easly enumerate all special files from borgmatic config. Thats the way I used to search for them.....

for folder in $(cat /etc/borgmatic/config.yaml | yq e '.location.source_directories' -|sed 's/^- //g'); do find $folder -type c,b,p; done

all pointed folders with thouse files I put in exclude_patterns

I created a command to easly enumerate all special files from borgmatic config. Thats the way I used to search for them..... `for folder in $(cat /etc/borgmatic/config.yaml | yq e '.location.source_directories' -|sed 's/^- //g'); do find $folder -type c,b,p; done` all pointed folders with thouse files I put in `exclude_patterns`
Owner

First of all, I apologize for the lengthy delay in getting to this ticket. Do you have the list of folders that you added to exclude_patterns corresponding to the above command? After you added those excludes, did borgmatic work without hanging? I'm wondering if there's a named pipe that wasn't deleted by some previous borgmatic run that should've been. If so, #360 might be a potential fix.

First of all, I apologize for the lengthy delay in getting to this ticket. Do you have the list of folders that you added to `exclude_patterns` corresponding to the above command? After you added those excludes, did borgmatic work without hanging? I'm wondering if there's a named pipe that wasn't deleted by some previous borgmatic run that should've been. If so, #360 might be a potential fix.
witten added the
waiting for response
label 2022-03-08 05:53:04 +00:00
Owner

I'm closing this ticket due to inactivity. But please feel free to reopen if you have any follow-up comments.

I'm closing this ticket due to inactivity. But please feel free to reopen if you have any follow-up comments.
Sign in to join this conversation.
No Milestone
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: borgmatic-collective/borgmatic#397
No description provided.