网易评论数据库宕机了……

 

可怜的Mysql数据库，在关键的时刻宕机了……

 

从页面看到的错误源代码：

 

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1000]; error code [1016];   
--- The error occurred in com/netease/reply/dao/ibatis/maps/post.xml.  
--- The error occurred while applying a parameter map.  
--- Check the post.getPostDataListWithIndexUK-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLException: General error: Can't open file: 'post_news_junshi_bbs.MYI'. (errno: 145); nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/netease/reply/dao/ibatis/maps/post.xml.  
--- The error occurred while applying a parameter map.  
--- Check the post.getPostDataListWithIndexUK-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLException: General error: Can't open file: 'post_news_junshi_bbs.MYI'. (errno: 145)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/netease/reply/dao/ibatis/maps/post.xml.  
--- The error occurred while applying a parameter map.  
--- Check the post.getPostDataListWithIndexUK-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLException: General error: Can't open file: 'post_news_junshi_bbs.MYI'. (errno: 145)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:268)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:193)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:219)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:266)
	at com.netease.reply.dao.ibatis.PostDaoImpl.getPostDataListWithIndexSupport(PostDaoImpl.java:129)
	at com.netease.reply.business.impl.PostManagerImpl.getPostDataList(PostManagerImpl.java:32)
	at com.netease.reply.web.controllers.ListPostController.handleRequest(ListPostController.java:403)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:115)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
	at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
	at com.netease.reply.web.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:45)
	at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
	at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:173)
	at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
	at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
	at com.caucho.server.port.TcpConnection.run(TcpConnection.java:511)
	at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
	at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
	at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: General error: Can't open file: 'post_news_junshi_bbs.MYI'. (errno: 145)
	at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)
	at com.mysql.jdbc.Connection.execSQL(Unknown Source)
	at com.mysql.jdbc.PreparedStatement.execute(Unknown Source)
	at com.caucho.sql.UserPreparedStatement.execute(UserPreparedStatement.java:126)
	at com.caucho.sql.UserPreparedStatement.execute(UserPreparedStatement.java:126)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
	... 28 more

 

 

 

评论

1 楼 poplar1986 2009-03-04  

怎么不贴个link和截个图啊？