曲演杂坛--权限不足引发的错误提示“服务器无法继续执行该事务”

同事传过来一个存储过程和一个异常信息，让帮忙查找原因

异常信息：

com.microsoft.sqlserver.jdbc.SQLServerException: 服务器无法继续执行该事务。说明: bc00000002。
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(Unknown Source)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection$1ConnectionCommand.doExecute(Unknown Source)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown Source)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(Unknown Source)
    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:597)
    at com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:958)
    at $Proxy0.rollback(Unknown Source)
    at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.rollback(JdbcTransaction.java:72)
    at com.ibatis.sqlmap.engine.transaction.TransactionManager.end(TransactionManager.java:105)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:782)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:176)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:154)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.autoEndTransaction(SqlMapExecutorDelegate.java:883)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:512)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:90)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.update(SqlMapSessionImpl.java:94)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.update(SqlMapClientImpl.java:71)
    at com.cdel.advc.dao.QuestionStatDao.statUser(QuestionStatDao.java:53)
    at com.cdel.advc.manager.StatQuestionManager.stat(StatQuestionManager.java:36)
    at com.cdel.advc.ReportServer.run(ReportServer.java:36)
    at com.cdel.advc.ReportServer.main(ReportServer.java:62)
    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:597)
    at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:58)

原因分析步骤：

1. 查看存储过程，排查循环嵌套导致的异常情况

2. 检查存储过程中锁修改的表，排查触发器导致的异常情况

3. 检查链接池

 

在排查过程中，同事找到了原因，由于在存储过程中使用了truncate，而程序对数据库只有读写权限，因此无法运行truncate语句，导致异常。。。

 

一般DBA在排查问题时，都会使用自己拥有的权限而非程序拥有的权限，因此很少会优先考虑权限问题

 

至于程序为什么要truncate表 就是其他研究的问题啦