I'm running into a strange problem with MySQL. Searched everywhere for a fix but cannot find anything. Running Ubuntu 14.04.
I have a database running on
Percona MySQL 5.7.18-16. I want to update this to
Percona Server 5.7.19-17. I run a script that performs a
mysqldump through Ruby on Rails in a
When I use the updated
Percona and get to the
mysqldump stage, I get the error as stated in the title. The table that it refers to is the internal
mysql.proc table. I have no idea why this is occurring.
I noticed that if I run
mysql_upgrade --force before the dump, it works (although
mysql_upgrade runs into the same error but seems to ignore it). I do however want to get to the root cause so that I do not have to run
mysql_upgrade. I ran a
diff on my database
.sql files before and after
mysql_upgrade, and there was no change.
Does anybody have any ideas as to how to get to the root of this problem and fix it? Any and all suggestions will be greatly appreciated!