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] After restoring data with myloader, some tables are empty #562

Closed
peng19832 opened this issue Jan 28, 2022 · 1 comment · Fixed by #565
Closed

[BUG] After restoring data with myloader, some tables are empty #562

peng19832 opened this issue Jan 28, 2022 · 1 comment · Fixed by #565

Comments

@peng19832
Copy link

peng19832 commented Jan 28, 2022

Describe the bug
After restoring data with myloader, some tables are empty, and there is no warning or error for the table in the log.
e.g. :
jwell_fms.ac_at_account

options:
-v 3 --set-names utf8 -e -o --purge-mode=TRUNCATE -t 8 --max-threads-per-table 8 -r 50000 --innodb-optimize-keys -B jwell_fms -L /tmp/impdata.log -d

Log
2022-01-28 09:44:32 [INFO] - Thread 1 restoring table jwell_fms.ac_at_account from /data/dumpdir/20220128020001/jwell_fms.ac_at_account-schema.sql.gz
2022-01-28 09:45:37 [INFO] - Thread 1 restoring jwell_fms.ac_at_account part 0 of 0 from jwell_fms.ac_at_account.00000.sql.gz. Progress 72 of 445 .
2022-01-28 09:47:43 [INFO] - Thread 1 restoring indexes jwell_fms.ac_at_account
image
impdata.log

Backup
ls -l file:
[root@mysqldevtest02 20220128020001]# ls -lhrt jwell_fms.ac_at_account.*
-rw-rw-r-- 1 mysql mysql 14M 1月 28 02:03 jwell_fms.ac_at_account.00000.sql.gz
[root@mysqldevtest02 20220128020001]# ls -lhrt jwell_fms.ac_at_account-schema.sql.gz
-rw-rw-r-- 1 mysql mysql 1.8K 1月 28 02:00 jwell_fms.ac_at_account-schema.sql.gz
ls-lhrt.txt

Environment (please complete the following information):

  • OS version: [ CentOS Linux release 7.5.1804 (Core), 3.10.0-862.el7.x86_64 ]
  • MyDumper version: [ mydumper 0.11.5, built against MySQL 5.7.34-37 ]
  • MySQL version: [ 8.0.25-15 ]
@peng19832 peng19832 changed the title [BUG] [BUG] After restoring data with myloader, some tables are empty Jan 28, 2022
@samiahlroos
Copy link

Hi,
I just saw something similar when using --rows (-r) parameter with myloader. Try without -r 50000.
More details of what I saw are in #564.

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