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

Could not execute query: Unknown error #335

Closed
DevOpserzhao opened this issue May 6, 2021 · 10 comments
Closed

Could not execute query: Unknown error #335

DevOpserzhao opened this issue May 6, 2021 · 10 comments

Comments

@DevOpserzhao
Copy link

Could not execute query: Unknown error

@DevOpserzhao
Copy link
Author

Broken table detected, please review: sys.x$schema_table_statistics_with_buffer

@davidducos
Copy link
Member

Can you share more information? At least we need the command executed and the log file

@DevOpserzhao
Copy link
Author

nohup mydumper --regex '^(?!(mysql|test|performance_schema|sys|information_schema))' -u root -p g -h 127.0.0.1 -P 3306 -G -E -R -t 16 -o /data/mydumper/ &

@DevOpserzhao
Copy link
Author

This database instance is recovered from alicloud RDS physical files

@davidducos
Copy link
Member

And the mydumper log file?

@DevOpserzhao
Copy link
Author

And the mydumper log file?

Broken table detected, please review: sys.x$schema_table_statistics_with_buffer

@DevOpserzhao
Copy link
Author

if (!is_view && row[ecol] == NULL) {
g_warning("Broken table detected, please review: %s.%s", database,
row[0]);
dump = 0;
}

@DevOpserzhao
Copy link
Author

I have used regular expressions to block the sys database, but why do I still report sys errors?

@davidducos
Copy link
Member

Can you test with latest version?

@davidducos davidducos added this to the Release 0.10.11 milestone Jul 19, 2021
@davidducos
Copy link
Member

@DevOpserzhao, please let us know if you need more help on it.

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

No branches or pull requests

2 participants