qc又出问题啦，这次是登陆不上qc，但可以登录站点管理

cabrite

错误提示如下


Messages:
Failed to Connect Project;
Failed to connect user 'wujun' to project shresource in domain DEFAULT;
SQL error executing statement SELECT USERS_PROJECTS.USER_ID FROM USERS_PROJECTS WHERE USERS_PROJECTS.USER_ID = 252 AND USERS_PROJECTS.PROJECT_ID = 2;
[Mercury][Oracle JDBC Driver][Oracle]ORA-01115: IO error reading block from file 6 (block # 549)
ORA-01110: data file 6: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SHRESOURCE'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) 数据错误(循环冗余检查)。
;

Stack Trace:
java.sql.SQLException: [Mercury][Oracle JDBC Driver][Oracle]ORA-01115: IO error reading block from file 6 (block # 549)
ORA-01110: data file 6: 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\SHRESOURCE'
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) 数据错误(循环冗余检查)。

at com.mercury.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.mercury.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplStatement.fetchNext(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplStatement.fetchNext2(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.mercury.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.mercury.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at com.mercury.optane.core.db.CTdPreparedStatement.executeQuery(CTdPreparedStatement.java:510)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:554)
        wrapped in com.mercury.optane.core.db.CTdDbException: SQL error executing statement SELECT USERS_PROJECTS.USER_ID FROM USERS_PROJECTS WHERE USERS_PROJECTS.USER_ID = 252 AND USERS_PROJECTS.PROJECT_ID = 2
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:560)
at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:442)
at com.mercury.td.saserver.api.logics.CUsersProjectsLogic.isUserInProject(CUsersProjectsLogic.java:1508)
at com.mercury.td.saserver.session.CSessionManager.connectProject(CSessionManager.java:412)
at com.mercury.td.saserver.api.logics.CSessionLogic.connectProject(CSessionLogic.java:393)
at com.mercury.td.saserver.sadispatcher.CSaRemoteDispatcher.doConnectProject(CSaRemoteDispatcher.java:639)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.mercury.optane.core.jndiproxy.CAbsJndiProxy.callRemoteMethod(CAbsJndiProxy.java:117)
at com.mercury.optane.core.jndiproxy.CAbsJndiProxy.callRemoteMethod(CAbsJndiProxy.java:75)
at com.mercury.td.saserver.sadispatcher.CSaJndiDispatcher.doConnectProject(CSaJndiDispatcher.java:370)
at com.mercury.td.saserver.saapi.CRemoteSiteAdminAppProxy.connectPrivate(CRemoteSiteAdminAppProxy.java:128)
at com.mercury.td.saserver.saapi.CAbsSiteAdminAppProxy.connectProject(CAbsSiteAdminAppProxy.java:150)
at com.mercury.td.tdserver.api.logics.CConnectionLogic.connectProject(CConnectionLogic.java:227)
        wrapped in com.mercury.optane.core.CTdException: Failed to connect user 'wujun' to project shresource in domain DEFAULT
at com.mercury.td.tdserver.api.logics.CConnectionLogic.connectProject(CConnectionLogic.java:235)
at com.mercury.td.web.server.CTdServlet.redirectConnectProject(CTdServlet.java:357)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:554)
        wrapped in com.mercury.optane.core.CTdException: Failed to Connect Project
at com.mercury.optane.core.web.CAbsServlet.executeFunction(CAbsServlet.java:560)
at com.mercury.optane.core.web.CAbsServlet.processRequest(CAbsServlet.java:535)
at com.mercury.td.web.server.CTdServlet.processRequest(CTdServlet.java:319)
at com.mercury.optane.core.web.CAbsServlet.doPost(CAbsServlet.java:418)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)

cabrite

没人知道答案啊

archonwang

回复 1# cabrite


    估计是最近新处理的数据出了问题。需要找到出问题的数据。