python 通过subprocess.Popen进行命令调用时,脚本超时
pipe = subprocess.Popen(executeCommonStr, stdout=subprocess.PIPE, stderr=subprocess.PIPE,stdin=subprocess.PIPE, shell=True,encoding="utf-8")
#设置超时时间
out,err = pipe.communicate(timeout= 30)
executeCommonStr的命令对应的selectedIp(IP地址)、selectedPort(端口号)、selectedUser(帐号)、selectedPassword(密码)、dnName数据库名称、executeFile(执行脚本文件),此处分别对应着三种数据库调用脚本命令
if dataBaseType == 'mysql':
executeCommon = "mysql -h" + selectedIp + " -P" + selectedPort + " -u" + selectedUser + " -p" + selectedPassword + " --default-character-set=utf8 " + dnName + " < " + executeFile;
elif dataBaseType == 'dmeng':
executeCommon = "disql "+selectedUser+"/"+selectedPassword+"@"+selectedIp+":"+selectedPort +" `"+executeFile
else:
executeCommon = "sqlplus -S "+selectedUser+"/"+selectedPassword+"@"+selectedIp+":"+selectedPort+"/"+dnName+" @"+executeFile
但是通过命令调用的时候只有mysql不会超时,其它都会超时,是因为调本命令中不存在退出命令,exit|quit,所以需要在脚本文件中增加退出命令即可,特此记号。