DB2 - Problem description
Problem IT39262 | Status: Closed |
WIRELISTENER THROWS EXCEPTION WHEN AGGREGATE PIPELINE CONTAINS $INDEXSTATS | |
product: | |
DB2 CONNECT / DB2CONNCT / B50 - DB2 | |
Problem description: | |
WireListener throws exception when aggregate pipeline contains $indexStats as in below command: db.runCommand({"aggregate":"mapicsGroup","pipeline":[{"$indexSta ts":{}}],"cursor":{"batchSize":1000}}) For above command, wire listener logs below exception message: An exception has been thrown: java.lang.RuntimeException : CDJSN0101E Execution failed in the following expression: "$indexStats" at com.ibm.nosql.json.api.DBQueryAnalyzer.handleJSONTask(DBQueryAna lyzer.java:126) at com.ibm.nosql.json.api.DBQueryAnalyzer.makeSQLQueryTasks(DBQuery Analyzer.java:58) at com.ibm.nosql.json.api.DBQueryBuilder.buildQuery(DBQueryBuilder. java:269) at com.ibm.nosql.json.api.DBCursorAggregate.find(DBCursorAggregate. java:189) at com.ibm.nosql.json.api.DBCursor.hasNext(DBCursor.java:278) at com.ibm.nosql.json.api.DBCollection.aggregate(DBCollection.java: 4537) at com.ibm.nosql.db2wire.server.DB2AggregationHelper.pipeline(DB2Ag gregationHelper.java:90) at com.ibm.nosql.db2wire.server.DB2Plugin.query(DB2Plugin.java:468) at com.ibm.nosql.driver.opMessage.Message(opMessage.java:183) at com.ibm.nosql.socket.channel.NoSQLInboundLink.handleMessage(NoSQ LInboundLink.java:430) at com.ibm.nosql.socket.channel.NoSQLInboundLink.complete(NoSQLInbo undLink.java:196) at com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.requestComplete( WorkQueueManager.java:551) at com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQu eueManager.java:601) at com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.workerRun(WorkQu eueManager.java:948) at com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQ ueueManager.java:1027) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec utor.java:1156) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe cutor.java:626) at com.ibm.ws.objectgrid.thread.XSThreadPool$Worker.run(XSThreadPoo l.java:282) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * When mongo clients communicate with IBM JSON/NoSQL Wire * * Listener. * **************************************************************** * PROBLEM DESCRIPTION: * * WireListener throws exception when aggregate pipeline * * contains * * $indexStats as in below command: * * * * db.runCommand({"aggregate":"mapicsGroup","pipeline":[{"$inde * * xSta * * ts":{}}],"cursor":{"batchSize":1000}}) * * * * For above command, wire listener logs below exception * * message: * * * * An exception has been thrown: java.lang.RuntimeException : * * CDJSN0101E Execution failed in the following expression: * * "$indexStats" * * at * * com.ibm.nosql.json.api.DBQueryAnalyzer.handleJSONTask(DBQuer * * yAna * * lyzer.java:126) * * at * * com.ibm.nosql.json.api.DBQueryAnalyzer.makeSQLQueryTasks(DBQ * * uery * * Analyzer.java:58) * * at * * com.ibm.nosql.json.api.DBQueryBuilder.buildQuery(DBQueryBuil * * der. * * java:269) * * at * * com.ibm.nosql.json.api.DBCursorAggregate.find(DBCursorAggreg * * ate. * * java:189) * * at * * com.ibm.nosql.json.api.DBCursor.hasNext(DBCursor.java:278) * * at * * com.ibm.nosql.json.api.DBCollection.aggregate(DBCollection.j * * ava: * * 4537) * * at * * com.ibm.nosql.db2wire.server.DB2AggregationHelper.pipeline(D * * B2Ag * * gregationHelper.java:90) * * at * * com.ibm.nosql.db2wire.server.DB2Plugin.query(DB2Plugin.java: * * 468) * * at * * com.ibm.nosql.driver.opMessage.Message(opMessage.java:183) * * at * * com.ibm.nosql.socket.channel.NoSQLInboundLink.handleMessage( * * NoSQ * * LInboundLink.java:430) * * at * * com.ibm.nosql.socket.channel.NoSQLInboundLink.complete(NoSQL * * Inbo * * undLink.java:196) * * at * * com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.requestCompl * * ete( * * WorkQueueManager.java:551) * * at * * com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.attemptIO(Wo * * rkQu * * eueManager.java:601) * * at * * com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.workerRun(Wo * * rkQu * * eueManager.java:948) * * at * * com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager$Worker.run(W * * orkQ * * ueueManager.java:1027) * * at * * java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool * * Exec * * utor.java:1156) * * at * * java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo * * lExe * * cutor.java:626) * * at * * com.ibm.ws.objectgrid.thread.XSThreadPool$Worker.run(XSThrea * * dPoo * * l.java:282) * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.5.7.1 or later versions. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * When mongo clients communicate with IBM JSON/NoSQL Wire * * Listener. * **************************************************************** * PROBLEM DESCRIPTION: * * WireListener throws exception when aggregate pipeline * * contains * * $indexStats as in below command: * * * * db.runCommand({"aggregate":"mapicsGroup","pipeline":[{"$inde * * xSta * * ts":{}}],"cursor":{"batchSize":1000}}) * * * * For above command, wire listener logs below exception * * message: * * * * An exception has been thrown: java.lang.RuntimeException : * * CDJSN0101E Execution failed in the following expression: * * "$indexStats" * * at * * com.ibm.nosql.json.api.DBQueryAnalyzer.handleJSONTask(DBQuer * * yAna * * lyzer.java:126) * * at * * com.ibm.nosql.json.api.DBQueryAnalyzer.makeSQLQueryTasks(DBQ * * uery * * Analyzer.java:58) * * at * * com.ibm.nosql.json.api.DBQueryBuilder.buildQuery(DBQueryBuil * * der. * * java:269) * * at * * com.ibm.nosql.json.api.DBCursorAggregate.find(DBCursorAggreg * * ate. * * java:189) * * at * * com.ibm.nosql.json.api.DBCursor.hasNext(DBCursor.java:278) * * at * * com.ibm.nosql.json.api.DBCollection.aggregate(DBCollection.j * * ava: * * 4537) * * at * * com.ibm.nosql.db2wire.server.DB2AggregationHelper.pipeline(D * * B2Ag * * gregationHelper.java:90) * * at * * com.ibm.nosql.db2wire.server.DB2Plugin.query(DB2Plugin.java: * * 468) * * at * * com.ibm.nosql.driver.opMessage.Message(opMessage.java:183) * * at * * com.ibm.nosql.socket.channel.NoSQLInboundLink.handleMessage( * * NoSQ * * LInboundLink.java:430) * * at * * com.ibm.nosql.socket.channel.NoSQLInboundLink.complete(NoSQL * * Inbo * * undLink.java:196) * * at * * com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.requestCompl * * ete( * * WorkQueueManager.java:551) * * at * * com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.attemptIO(Wo * * rkQu * * eueManager.java:601) * * at * * com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager.workerRun(Wo * * rkQu * * eueManager.java:948) * * at * * com.ibm.ws.xs.tcp.channel.impl.WorkQueueManager$Worker.run(W * * orkQ * * ueueManager.java:1027) * * at * * java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool * * Exec * * utor.java:1156) * * at * * java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo * * lExe * * cutor.java:626) * * at * * com.ibm.ws.objectgrid.thread.XSThreadPool$Worker.run(XSThrea * * dPoo * * l.java:282) * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.5.7.1 or later versions. * **************************************************************** | |
Comment | |
db2_v11571 contains fix of this issue. After the fix, error no longer exist. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.11.2021 15.12.2021 24.10.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |