[JAVA-3356] Getting no data at all Created: 12/Jul/19 Updated: 27/Oct/23 Resolved: 15/Jul/19 |
|
| Status: | Closed |
| Project: | Java Driver |
| Component/s: | Query Operations |
| Affects Version/s: | 3.8.2, 3.10.2 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Marek Mizeracki | Assignee: | Unassigned |
| Resolution: | Works as Designed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
MongoDB 4.0.10, Java 1.8, Spring Boot |
||
| Description |
|
I am using Java Spring Boot to search BG_event collection in MongoDB Atlas. Example below shows one specific query but other queries also behave the same way.
Here is configuration: logging.level.org.springframework: INFO logging.level.org.springframework.web: DEBUG logging.level.org.springframework.security: DEBUG logging.level.org.springframework.data.mongodb.core.MongoTemplate=DEBUG
spring.data.mongodb.uri= mongodb://platformUser:xyz@platform-mongo-prod-shard-00-00-ebkt8.gcp.mongodb.net Here is the query: { "reference1" : "ONEYTPEV36802700", "reference2" : "0020", "reference3" : "TLLU5489950", "reference4" : null, "timestamp" : \{ "$gt" : "2019-07-11 12:20.00", "$lt" : "2019-07-12 23:00.00" }, "sourceCategory" : "EDI", "sourceId" : "ONEY", "organizationId" : "874b5fcd-4774-11e9-bdf4-42010a732002" } This query results with 0 documents retrieved despite the fact I can see the document in Studio 3T and exact query executed from this IDE brings correct document. Here is the log from the server when no records are retrieved: EDT2019-07-12 09:21:17.563 DEBUG 1 — [nio-5013-exec-3] o.s.data.mongodb.core.MongoTemplate : find using query: { "reference1" : "ONEYTPEV36802700", "reference2" : "0020", "reference3" : "TLLU5489950", "reference4" : null, "timestamp" : { "$gt" : "2019-07-11 12:20.00", "$lt" : "2019-07-12 23:00.00" }, "sourceCategory" : "EDI", "sourceId" : "ONEY", "organizationId" : "874b5fcd-4774-11e9-bdf4-42010a732002" } fields: Document{{}} for class: class com.blumeglobal.eventmanager.entity.Event in collection: BG_event Expand all | Collapse all 2019-07-12 09:21:17.567 DEBUG 1 — [nio-5013-exec-3] m.m.a.RequestResponseBodyMethodProcessor : Using 'application/json', given [*/*] and supported [application/json, application/*+json, application/json, application/*+json] 019-07-12 05:21:17.568 EDT2019-07-12 09:21:17.568 DEBUG 1 — [nio-5013-exec-3] m.m.a.RequestResponseBodyMethodProcessor : Writing [[]] 2019-07-12 05:21:17.569 EDT2019-07-12 09:21:17.569 DEBUG 1 — [nio-5013-exec-3] o.s.web.servlet.DispatcherServlet : Completed 200 OK |
| Comments |
| Comment by John Meagher [ 15/Jul/19 ] |
|
Customer was able to resolve |