[GEODE-2211] OQL query shows partial results when data is inserted through REST POST api.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Do
• Affects Version/s: 1.0.0-incubating
• Component/s: gfsh
• Labels: gfsh
• Assignee: Unassigned
• Reporter: Amey Barve
• Created: 14/Dec/16 09:05
• Updated: 20/Apr/18 19:57
• Resolved: 29/Mar/18 17:18

Description

Steps to Reproduce the Issue
Start a locator
Configure pdx
Start server1 with Developer Rest Enabled.
Start server2
Create Geode Region PARTIONED_PERSISTENENT
Using Swagger UI enter some Key and Values in the Region.
using mash run query "Select * /Region"

Executing - query --query="Select * from /test"

Result : true
startCount : 0
endCount : 20
Rows : 4

1 | 3 | deserializedForReading | stringForm | DSFID | serializedValue | sizeInBytes | serialized | valueSizeInBytes | value
---- | ---- | --------------------------------------------- | -------------------------- | ----- | ------------------ | ----------- | ---------- | ---------------- | ------------------
A | C | org.apache.geode.pdx.internal.PdxInstanceImpl | PDX[2,__GEMFIRE_JSON]

{2=B}

| -65 | org.json.JSONArray | 37 | true | 25 | org.json.JSONArray
null | null | org.apache.geode.pdx.internal.PdxInstanceImpl | PDX[4,__GEMFIRE_JSON]

{4=D}

| -65 | org.json.JSONArray | 37 | true | 25 | org.json.JSONArray
null | null | null | null | null | null | null | null | null | null
null | null | null | null | null | null | null | null | null | null

NEXT_STEP_NAME : END

It only shows first 2 entries and other as null.

The below script reproduces the issue:

#!/usr/bin/env bash

GEODE_HOME=./geode-assembly/build/install/apache-geode

$GEODE_HOME/bin/gfsh -e "start locator --name=l1 --port=10339" \
-e "configure pdx --read-serialized=true --disk-store" \
-e "start server --name=s1 --server-port=40408 --J=-Dgemfire.start-dev-rest-api=true --J=-Dgemfire.http-service-port=8080 --J=-Dgemfire.http-service-bind-address=localhost" \
-e "start server --name=s2 --server-port=40409 " \
-e "create region --name=test --type=PARTITION_PERSISTENT"

tput setaf 3; echo "Inserting the values in persisten region test"
`curl -s -H 'Content-Type: application/json' -H 'Accept: application/json' -X POST -d '

{"1":"A"}

' http://localhost:8080/gemfire-api/v1/test?key=1`
`curl -s -H 'Content-Type: application/json' -H 'Accept: application/json' -X POST -d '

{"2":"B"}

' http://localhost:8080/gemfire-api/v1/test?key=2`
`curl -s -H 'Content-Type: application/json' -H 'Accept: application/json' -X POST -d '

{"3":"C"}

' http://localhost:8080/gemfire-api/v1/test?key=3`
`curl -s -H 'Content-Type: application/json' -H 'Accept: application/json' -X POST -d '

{"4":"D"}

' http://localhost:8080/gemfire-api/v1/test?key=4`

tput setaf 3; echo "The values inserted into the region test are as"
echo `curl -X GET http://localhost:8080/gemfire-api/v1/test?limit=50 2>/dev/null`

$GEODE_HOME/bin/gfsh -e "connect --locator=localhost[10339]" \
-e "query --query=\"Select * from /test\""
-e "stop server --name=s1 " \
-e "stop server --name=s2 " \
-e "stop locator --name=l1 "