Not the answer you need?
Register and ask your own question!

Issue after update to 5.7.31-34?

Jeff WardJeff Ward EntrantCurrent User Role Contributor

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?

Tagged:

Answers

  • Jeff WardJeff Ward Entrant Current User Role Contributor

    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.

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.