I had an issue and just wanted to post this here. I do not have all the proper info at this point. Just some symptoms.
Our stuff is in AWS, I am switching our db servers from m5 to r5 instance types.
I have had 1 r5 running for several months, the AMI was taken from it.
The current servers are:
Ubuntu 18.04.4
mysql Ver 14.14 Distrib 5.7.29-32, for debian-linux-gnu (x86_64) using 7.0
I created an AMI, brought up the new server and everything is fine.
I then updated it and that is where the problem comes in.
sudo apt update && sudo apt dist-upgrade
It went through with no issues.
Updates to:
Ubuntu 18.04.5
mysql Ver 14.14 Distrib 5.7.31-34, for debian-linux-gnu (x86_64) using 7.0
After doing this update, I noticed queries were running slow. Almost like it wasn’t using indexes.
It was bad enough where I had to kill my new boxes and start over.
It is reproducible. I can bring up a box from that image, it’s fine, do the update, and same thing.
I have not spent much if any time at this point trying to diagnose exactly what is happening because I can use the un-updated image to get this working.
At this time, I only really have one symptom. And it may not in any way help, just something I had happen…
I use a program called Navicat to browse my dbs.
You can right click a table and select Design Table from ther menu. This bring up a ui to alter the table.
On all the 5.7.29-32 servers, this has always come up with no issues.
After the update, all the 5.7.31-34 server had this error selecting Design Table for all tables:
1227 - Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
That’s all I have at this time
Wondering if anyone else has seen anything like this?
I still have the image. I still have one small server up to test. I can pop this over and over to test.
Is there anything specific I can run to get better info on the problem?