MySQL Bugs: #95902: mysqlpump crashes in varying ways when trying to dump Amazon RDS for

Bug #95902	mysqlpump crashes in varying ways when trying to dump Amazon RDS for
Submitted:	20 Jun 2019 15:40	Modified:	25 Jul 2019 23:27
Reporter:	Cara Selvio	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: mysqlpump Command-line Client	Severity:	S3 (Non-critical)
Version:	5.7.26	OS:	Linux (AWS Linux 2)
Assigned to:	MySQL Verification Team	CPU Architecture:	x86 (model name : Intel(R) Xeon(R) CPU E5-2686 v4 @ 2.30GHz)

Description:
In order to be able to migrate from / backup an Amazon MySQL 5.7 database I would like to be able to dump it quickly with mysqlpump.

When I try this mysqlpump crashes.  

I currently have this reproduced only on a private database; I will attempt to do it on another where I can more easily give full details / backtraces etc.  

Testing the same on using myslpump 8 also fails but differently: 

mysqlpump: [ERROR] (1193) Unknown system variable 'information_schema_stats_expiry'
Dump process encountered error and will not continue.

How to repeat:
* Create MySQL RDS on Aurora
* create a large database with multiple tables in that RDS
* run mysqlpump 

the command line is approximately 

/home/ec2-user/mysql-5.7.26-linux-glibc2.12-x86_64/bin/mysqlpump --host somename.someprefix.us-east-2.rds.amazonaws.com --port 3306 --user master_user --password=SOME_PASS  --set-gtid-purged=ON my_database

Suggested fix:
propose testing against RDS.

There are various bug reports (like https://bugs.mysql.com/bug.php?id=83145) which report crashes due to failed connections.  Since I have a direct connection with the RDS and the EC2 instance in the same subnet I think that it's very unlikely that network connections are failing, however there are likely permissions problems and so the different bugs may have the same root cause.

Thank you for the bug report. Bugs needs to be filed when MySQL Oracle binaries are used so we test against MySQL Oracle products, so please test against our binaries. Thanks in advance.

Hi; @Miguel Solorzano

These tests _were_ carried out on Oracle MySQL binaries downloaded direct from the site here.  This was running on AWS Linux 2 but I used the generic linux binaries so that should not make a difference.

Hi Cara Selvio,

You are using mysqlpump/mysqldump from our binary package but you are connecting to the non mysql server, so the behavior is unpredictable. 

Now, please show us exactly how did you invoke mysqldump/mysqlpump and how they failed so we can try to help but this really is a support question for RDS people in Amazon, not our bug.

thanks
Bogdan

The mysqlpump 8. failing to dump is a duplicate of bug https://bugs.mysql.com/bug.php?id=95541 where it is trying to read that variable that does not exist on server, but please show how your 5.7 mysqldump/mysqlpump failed.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".