gfsh query running on a replicate proxy region returns NULL
search cancel

gfsh query running on a replicate proxy region returns NULL

book

Article ID: 293997

calendar_today

Updated On:

Products

VMware Tanzu Gemfire

Issue/Introduction

This article is applicable to all versions of

VMware Tanzu GemFire and VMware GemFire.

A gfsh query running on a replicate proxy region returns zero results.

Here is an example:
gfsh>query --query="select count *  from /TestRegion"
Result : true
Rows : 1
Result
------
0
gfsh>query --query="select Name, id from /TestRegion limit 10"
Result : true
Rows : 0


Resolution

This is a known issue and will be addressed in future versions of VMware GemFire and VMware Tanzu GemFire.

When there are both proxy nodes and replicate nodes hosting a region, gfsh queries against that region may returns zero entries depending on whether the query is running on a proxy node or a replicate node. 

As a workaround, GemFire Pulse can be used instead of the gfsh, as this issue does not affect Pulse queries.