Loading...

XML

Word

Printable

JSON

Type: Bug
Resolution: Works as Designed
Priority: Major - P3
Fix Version/s: None
Affects Version/s: 3.4.2
Component/s: Aggregation Framework
Labels:
None

Assigned Teams:

Query
Operating System:
ALL
Steps To Reproduce:

Hide

1. execute any query with a dot in $group aggregation field as shown in e.g. below on v3.2 and v3.4
db.MyCollection.aggregate({$group: {"_id":
{ "d.N" : "$N"}
}})

2. Observe that the query executes successfully on v3.2 but fails on v3.4 with following error.
{ ok: 0.0, errmsg: \"FieldPath field names may not contain '.'.\", code: 16412, codeName: \"Location16412\", $gleStats:
{ lastOpTime: Timestamp 0|0, electionId: ObjectId('000000000000000000000000') }
}" }

Show
1. execute any query with a dot in $group aggregation field as shown in e.g. below on v3.2 and v3.4 db.MyCollection.aggregate({$group: {"_id": { "d.N" : "$N"} }}) 2. Observe that the query executes successfully on v3.2 but fails on v3.4 with following error. { ok: 0.0, errmsg: \"FieldPath field names may not contain '.'.\", code: 16412, codeName: \"Location16412\", $gleStats: { lastOpTime: Timestamp 0|0, electionId: ObjectId('000000000000000000000000') } }" }
Case:
Confidence Status:
None
Work Order:
3

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name:
None
Goal Link:
None

$group aggregate field names can contain dots as of v3.2. However, such queries fail in v3.4 with exception provided below.
Also, this incompatibility is not listed here - https://docs.mongodb.com/manual/release-notes/3.4-compatibility/

com.mongodb.MongoCommandException: Command failed with error 16412: 'sharded pipeline failed on shard analytics1-1: { ok: 0.0, errmsg: "FieldPath field names may not contain '.'.", code: 16412, codeName: "Location16412", $gleStats: { lastOpTime: Timestamp 0|0, electionId: ObjectId('000000000000000000000000') } }' on server localhost:27017. The full response is { "code" : 16412, "ok" : 0.0, "errmsg" : "sharded pipeline failed on shard analytics1-1: { ok: 0.0, errmsg: \"FieldPath field names may not contain '.'.\", code: 16412, codeName: \"Location16412\", $gleStats: { lastOpTime: Timestamp 0|0, electionId: ObjectId('000000000000000000000000') } }" }
	at com.mongodb.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:115) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.connection.CommandProtocol.execute(CommandProtocol.java:114) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:159) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:286) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.connection.DefaultServerConnection.command(DefaultServerConnection.java:173) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:215) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:206) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:112) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.AggregateOperation$1.call(AggregateOperation.java:227) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.AggregateOperation$1.call(AggregateOperation.java:223) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:239) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:212) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:223) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:65) ~[mongodb-driver-core-3.2.2.jar:?]
	at com.mongodb.Mongo.execute(Mongo.java:772) ~[mongodb-driver-3.2.2.jar:?]
	at com.mongodb.Mongo$2.execute(Mongo.java:759) ~[mongodb-driver-3.2.2.jar:?]
	at com.mongodb.OperationIterable.iterator(OperationIterable.java:47) ~[mongodb-driver-3.2.2.jar:?]
	at com.mongodb.AggregateIterableImpl.iterator(AggregateIterableImpl.java:102) ~[mongodb-driver-3.2.2.jar:?]
	at net.nativo.mongo.dao.MongoDAO.executeAggregate(MongoDAO.java:101) ~[classes/:?]
	at net.nativo.mongo.dao.MongoDAO.aggregate(MongoDAO.java:70) ~[classes/:?]
	at net.nativo.reporting.generator.AbstractReportGenerator.executeMongoQuery(AbstractReportGenerator.java:402) ~[classes/:?]
	at net.nativo.reporting.generator.AbstractReportGenerator.generateReport(AbstractReportGenerator.java:161) ~[classes/:?]
	at net.nativo.reporting.generator.AbstractReportGenerator.generate(AbstractReportGenerator.java:124) [classes/:?]
	at net.nativo.reporting.controller.ReportController.getPerformanceReport(ReportController.java:113) [classes/:?]
	at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) ~[?:?]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_111]
	at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_111]
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215) [spring-web-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) [spring-web-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:685) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) [tomcat7-servlet-3.0-api.jar:?]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829) [spring-webmvc-3.2.10.RELEASE.jar:3.2.10.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) [tomcat7-servlet-3.0-api.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) [catalina.jar:7.0.70]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.70]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat7-websocket.jar:7.0.70]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) [catalina.jar:7.0.70]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) [catalina.jar:7.0.70]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) [catalina.jar:7.0.70]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) [catalina.jar:7.0.70]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) [catalina.jar:7.0.70]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) [catalina.jar:7.0.70]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) [catalina.jar:7.0.70]
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) [catalina.jar:7.0.70]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) [catalina.jar:7.0.70]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442) [catalina.jar:7.0.70]
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1082) [tomcat-coyote.jar:7.0.70]
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:623) [tomcat-coyote.jar:7.0.70]
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) [tomcat-coyote.jar:7.0.70]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_111]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_111]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-coyote.jar:7.0.70]
	at java.lang.Thread.run(Thread.java:745) [?:1.7.0_111]

Found an old ticket for v2.2 which looks related in case it helps - https://jira.mongodb.org/browse/SERVER-6198

Assignee:: Backlog - Query Team (Inactive)

Reporter:: Bijith Kumar

Participants:: Backlog - Query Team, Bijith Kumar, Charlie Swanson, Mark Agarunov

Votes:: 0 Vote for this issue

Watchers:: 12 Start watching this issue

Created:: Feb 10 2017 03:19:39 AM UTC

Updated:: Oct 27 2023 01:54:35 PM UTC

Resolved:: Feb 17 2017 08:18:36 PM UTC

Details

Description

Attachments

Activity

People

Dates