Getting errors after mysql_upgrade

[Camouflage]

hi dudes,

after upgrading from 5.1.58 to 5.1.60 and running mysql_upgrade I’m getting these errors:

Quote:

Looking for ‘mysql’ as: mysql
Looking for ‘mysqlcheck’ as: mysqlcheck
Running ‘mysqlcheck’ with connection arguments: ‘–socket=/home/mysql/mysql.sock’ ‘–port=3306’
Running ‘mysqlcheck’ with connection arguments: ‘–socket=/home/mysql/mysql.sock’ ‘–port=3306’
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log
Error : You can’t use locks with log tables.
status : OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log
Error : You can’t use locks with log tables.
status : OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK

Repairing tables
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed
test.HAUq6
Error : Table ‘test.HAUq6’ doesn’t exist
status : Operation failed

in addition the file “mysql_upgrade_info” is not updated with the new version-nr.

anyone have any idea?
cya Alex

[xaprb]

You probably have some junk in your data directory, such as an orphaned .frm file.

[mcubedpe]

Hmm… Did anyone figure this out?

I just migrated from - Community 5.1.66 - to Percona Server 5.1.67 - and I can’t get the “mysql_upgrade” to finish.

Same style errors as reported above.

…
(table_name).H1uË3
Error : Table ‘(table_name).H1uË3’ doesn’t exist
status : Operation failed
(table_name).H1uË3
Error : Table ‘(table_name).H1uË3’ doesn’t exist
status : Operation failed
(table_name).H1uË3
Error : Table ‘(table_name).H1uË3’ doesn’t exist
status : Operation failed
…

Oddly - I also notice this appears to only be happening on some Wordpress databases - yet other Wordpress databases are check Ok properly.

Thoughts?

-Michael