Issue after update to 5.7.31-34?

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?

UPDATE: I was over reacting on the slowness part of this. That was just a new aws server with gb files taking a long time to first load.