import re
question_suggestion_dict={"Unable to open
underlying table which is differently defined or of non-MyISAM type
or doesn't
exist":"merge表底层的MyISAM表不存在,建议删除merge表,或者重建merge表引用的底层MyISAM表!并检查实例内所有merge表的可用性"}
for
(err,suggestion) in question_suggestion_dict.items():
err_info =
re.compile(err)
flag =
err_info.search(question)
其中:
err = “Unable
to open underlying table which is differently defined or of
non-MyISAM type or doesn't exist ”
question =
"Errno:5, Error:Dump failed, g_data: mysqldump: Couldn't execute
'show create table `achievement_20160826`': Unable to open
underlying table which is differently defined or of non-MyISAM type
or doesn't exist (1168) CMySQLBackup::Backup(system mysqldump is
error: 512,errno: 0)
from
xxx"
如果question变量的内容中,有匹配到 ”Unable
to open underlying table which is differently defined or of
non-MyISAM type or doesn't exist ”
,那么question就是符合我的条件的