Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] Mydumper hangs if --rows is specified #829

Closed
IvoGoman opened this issue Sep 21, 2022 · 1 comment · Fixed by #830
Closed

[BUG] Mydumper hangs if --rows is specified #829

IvoGoman opened this issue Sep 21, 2022 · 1 comment · Fixed by #830
Labels

Comments

@IvoGoman
Copy link

Describe the bug
Mydumper hangs on table mysql.time_zone_name if --rows is specified.
The dump finishes if

  1. mysql schema is excluded with the regex option
  2. --rows is not specified

Looking at the processlist on my mariadb it shows these two lines from time to time:
SELECT /*!40001 SQL_NO_CACHE */ MAX(Name) FROM 'mysql'.'time_zone_name' WHERE BINARY Name like 'H%'
SELECT /*!40001 SQL_NO_CACHE */ MIN(Name) FROM 'mysql'.'time_zone_name' WHERE BINARY Name > 'HST'

I am running mariadb 10.5.12 in a docker container locally on an M1 macbook.
I have tried different values for --rows such as 1, 1820(# of rows in this table), 50000 but it will always hang.
I have tried with a fresh docker container.

To Reproduce
Command executed:
mydumper --port=3306 --host=127.0.0.1 --user=root --password=test --outputdir=backup/2022-09-21T11:06:11+02:00 --compress --trx-consistency-only --compress-protocol --rows=50000 --verbose=3

What mydumper and myloader version has been used?
mydumper: mydumper 0.12.7-1, built against MySQL 8.0.30

Expected behavior
Dump finishing.

Log
emptydb.log

Backup
If applicable, add the list of content of the database path, an ls -l will be enough

Environment (please complete the following information):

  • OS version: MacOS 12.5.1 on M1
  • MyDumper version: mydumper 0.12.7-1, built against MySQL 8.0.30
@IvoGoman IvoGoman added the bug label Sep 21, 2022
@davidducos davidducos added this to the Release 0.12.7-3 milestone Sep 21, 2022
@davidducos davidducos linked a pull request Sep 21, 2022 that will close this issue
@IvoGoman
Copy link
Author

Thank you 👍

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

Successfully merging a pull request may close this issue.

2 participants