数据源中，调用储存过程报错{0}

调用储存过程时，概率性报{0}错误。有时能正确查询出数据，有时报错{0}

错误日志：[2023-06-01 12:12:26.284] |-[ERROR] |-[6f6e9521c4dd4a4d9fbbcb3635cb74ec] |-[admin] |-[g5.qry.queryPool.QueryRunnable.run(QueryRunnable.java:81)] |-[QUERY: [收费日报(储存过程版)20230601121208-1198<医付通-连锁版--生产/收费日报/收费日报(储存过程版)>][ErrCode: 0]  执行SQL失败：“{0}”]java.sql.SQLException: 执行SQL失败：“{0}”        at g5.qry.jdbc.JDBCExecutor.convertException(JDBCExecutor.java:1550) ~[product.jar:?]        at g5.qry.jdbc.JDBCExecutor$SQLRunnable.run(JDBCExecutor.java:275) ~[product.jar:?]        at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:219) ~[product.jar:?]        at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:319) ~[product.jar:?]Caused by: java.sql.SQLException        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[?:?]        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[?:?]        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[?:?]        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~[?:?]        at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.executeMetadataQuery(DatabaseMetaDataUsingInfoSchema.java:71) ~[?:?]        at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.getProcedureColumns(DatabaseMetaDataUsingInfoSchema.java:794) ~[?:?]        at com.mysql.cj.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:795) ~[?:?]        at com.mysql.cj.jdbc.CallableStatement.<init>(CallableStatement.java:588) ~[?:?]        at com.mysql.cj.jdbc.CallableStatement.getInstance(CallableStatement.java:487) ~[?:?]        at com.mysql.cj.jdbc.ConnectionImpl.parseCallableStatement(ConnectionImpl.java:1496) ~[?:?]        at com.mysql.cj.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:1521) ~[?:?]        at com.mysql.cj.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:1512) ~[?:?]        at g5.qry.jdbc.JDBCExecutor.prepare0(JDBCExecutor.java:1289) ~[product.jar:?]        at g5.qry.jdbc.JDBCExecutor.prepare(JDBCExecutor.java:1079) ~[product.jar:?]        at g5.qry.jdbc.JDBCExecutor.init0(JDBCExecutor.java:1040) ~[product.jar:?]        at g5.qry.sql.SQLExecutor.init0(SQLExecutor.java:454) ~[product.jar:?]        at g5.qry.jdbc.JDBCExecutor$SQLRunnable.run(JDBCExecutor.java:271) ~[product.jar:?]        ... 2 moreCaused by: java.lang.NullPointerException        at com.mysql.cj.protocol.a.NativeProtocol.checkForOutstandingStreamingData(NativeProtocol.java:1981) ~[?:?]        at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:662) ~[?:?]        at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051) ~[?:?]        at com.mysql.cj.NativeSession.execSQL(NativeSession.java:665) ~[?:?]        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:893) ~[?:?]        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~[?:?]        at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.executeMetadataQuery(DatabaseMetaDataUsingInfoSchema.java:71) ~[?:?]        at com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.getProcedureColumns(DatabaseMetaDataUsingInfoSchema.java:794) ~[?:?]        at com.mysql.cj.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:795) ~[?:?]        at com.mysql.cj.jdbc.CallableStatement.<init>(CallableStatement.java:588) ~[?:?]        at com.mysql.cj.jdbc.CallableStatement.getInstance(CallableStatement.java:487) ~[?:?]        at com.mysql.cj.jdbc.ConnectionImpl.parseCallableStatement(ConnectionImpl.java:1496) ~[?:?]        at com.mysql.cj.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:1521) ~[?:?]        at com.mysql.cj.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:1512) ~[?:?]        at g5.qry.jdbc.JDBCExecutor.prepare0(JDBCExecutor.java:1289) ~[product.jar:?]        at g5.qry.jdbc.JDBCExecutor.prepare(JDBCExecutor.java:1079) ~[product.jar:?]        at g5.qry.jdbc.JDBCExecutor.init0(JDBCExecutor.java:1040) ~[product.jar:?]        at g5.qry.sql.SQLExecutor.init0(SQLExecutor.java:454) ~[product.jar:?]        at g5.qry.jdbc.JDBCExecutor$SQLRunnable.run(JDBCExecutor.java:271) ~[product.jar:?]        ... 2 more[2023-06-01 12:12:26.285] |-[INFO] |-[a8f4ef08ab2b4991b70ea2d49366aa11] |-[SYSTEM] |-[g5.thread.ThreadMeta.reg(ThreadMeta.java:184)] |-[OTHER:   Thread is cancelled when registering cancellable: MSGConsumer[3be46fd3]][2023-06-01 12:12:26.292] |-[INFO] |-[6f6e9521c4dd4a4d9fbbcb3635cb74ec] |-[admin] |-[g5.audit.holder.RunSQLHolder$1.handle(RunSQLHolder.java:189)] |-[QUERY: [收费日报(储存过程版)20230601121208-1198<医付通-连锁版--生产/收费日报/收费日报(储存过程版)>]  Add run sql item: {runSqlId=1d28a9824fbf40e8a7e6891810e5e8ed, endTime=1685592746285}][2023-06-01 12:12:26.292] |-[ERROR] |-[6f6e9521c4dd4a4d9fbbcb3635cb74ec] |-[admin] |-[g5.qry.queryPool.QueryRunnable.run(QueryRunnable.java:81)] |-[QUERY: [收费日报(储存过程版)20230601121208-1198<医付通-连锁版--生产/收费日报/收费日报(储存过程版)>][ErrCode: 0]  null]java.lang.NullPointerException: null        at g5.qry.jdbc.JDBCExecutor.load(JDBCExecutor.java:192) ~[product.jar:?]        at g5.qry.queryPool.QueryRunnable.load(QueryRunnable.java:174) ~[product.jar:?]        at g5.qry.queryPool.QueryRunnable2.load(QueryRunnable2.java:66) ~[product.jar:?]        at g5.qry.queryPool.QueryRunnable.run(QueryRunnable.java:77) ~[product.jar:?]        at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:219) ~[product.jar:?]        at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:319) ~[product.jar:?][2023-06-01 12:12:26.292] |-[INFO] |-[be4f02fa43d54a3ca0c4ee8213c3f373] |-[SYSTEM] |-[g5.thread.ThreadMeta.reg(ThreadMeta.java:184)] |-[OTHER:   Thread is cancelled when registering cancellable: MSGConsumer[774be608]]

日志暂无法定位问题，看你的描述偶发的情况大概率跟数据本身有关系

yhdata_yzm 发表于 2023-6-1 13:55
日志暂无法定位问题，看你的描述偶发的情况大概率跟数据本身有关系

关闭数据库连接池就没报错了，所以怀疑是数据库连接池的问题

SET NOCOUNT ON exec 在加上存储过程试试

yhdata_cMcMJJHQ 发表于 2023-6-1 21:04
关闭数据库连接池就没报错了，所以怀疑是数据库连接池的问题

好的