|
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) |
