Php tools/upgrade.php version (Error) DB Error: View 'information_schema.COLUMNS' references invalid table(s)

Software Support
1

Upgrading OJS 2.4.8 when i do the upgrade on Ubuntu 18 works perfectly
when i do it on Ubuntu 21.1 i get the following issue when upgrading :

Server 1 : Ubuntu 21.1
php tools/upgrade.php version

DB Error: View 'information_schema.COLUMNS' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

ojs2: DB Error: View 'information_schema.COLUMNS' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

tail -f /var/log/apache2/error.log
ojs2: DB Error: Unknown column ‘context_id’ in ‘on clause’

Both I am trying to upgrade to OJS 3.1.2 currently, both i run the exact same upgrade process
both have php 7.4 and works before the upgrade process only the ubuntu 21.1 fails , serached for the above error but cannot find a solution