3.1版本兼容2.7版本环境，sql语句卡住，数据库卡死

ghj

语句如下：
show processlist后，有若干如下sql语句，基本是sort data或sending data
SELECT  CASE WHEN UPPER(p.SLOGINNAME) =  ?  THEN ? WHEN UPPER(p.SCODE) =  ?  THEN ? ELSE ? END  AS odr, mo.sID, mo.sFID AS sFID, mo.sFName AS sFName, mo.SFCODE AS sFCode, p.sID AS p, p.SNAME AS sName, p.SCODE AS sCode, p.SIDCARD AS sIDCard, p.SNUMB AS sNumb, p.SLOGINNAME AS sLoginName, p.SPASSWORD AS sPassword, p.SPASSWORDTIMELIMIT AS sPasswordTimeLimit, p.SPASSWORDMODIFYTIME AS sPasswordModifyTime, p.SMAINORGID AS sMainOrgID, p.SSAFELEVELID AS sSafeLevelID, p.SSEQUENCE AS sSequence, p.SVALIDSTATE AS sValidState, p.SDESCRIPTION AS sDescription, p.SPHOTO AS sPhoto, p.SPHOTOLASTMODIFIED AS sPhotoLastModified, p.SSEX AS sSex, p.SBIRTHDAY AS sBirthday, p.SJOINDATE AS sJoinDate, p.SHOMEPLACE AS sHomePlace, p.SCOUNTRY AS sCountry, p.SPROVINCE AS sProvince, p.SCITY AS sCity, p.SDEGREE AS sDegree, p.SGRADUATESCHOOL AS sGraduateSchool, p.SSPECIALITY AS sSpeciality, p.SSCHOOLLENGTH AS sSchoolLength, p.STITLE AS sTitle, p.SMARRIAGE AS sMarriage, p.SCARDNO AS sCardNO, p.SCARDKIND AS sCardKind, p.SFAMILYADDRESS AS sFamilyAddress, p.SZIP AS sZip, p.SMSN AS sMsn, p.SQQ AS sQQ, p.SMAIL AS sMail, p.SMOBILEPHONE AS sMobilePhone, p.SFAMILYPHONE AS sFamilyPhone, p.SOFFICEPHONE AS sOfficePhone, p.SENGLISHNAME AS sEnglishName, p.VERSION AS version FROM SA_OPPerson p JOIN SA_OPOrg mo ON p.SMAINORGID = mo.sID  WHERE  ( (UPPER(p.SLOGINNAME) =  ? ) OR (UPPER(p.SCODE) =  ? ) ) AND (p.SVALIDSTATE = ?)   ORDER BY odr ASC

请问如何解决？

jishuang

具体什么现象不能登录？

ghj

jishuang 发表于 2016-11-17 09:37
具体什么现象不能登录？

是的，数据库卡死了。

jishuang

安装一下tomcat的监测工具看一下数据库连接的使用情况
http://docs.wex5.com/wex5-deploy-question-list-0004/