# select found\_rows() returns always 0 if 2 members are up

**URL:** https://forums.percona.com/t/select-found-rows-returns-always-0-if-2-members-are-up/4990
**Category:** Percona XtraDB Cluster 5.x
**Created:** [July 22, 2016, 3:50am UTC](https://forums.percona.com/t/select-found-rows-returns-always-0-if-2-members-are-up/4990 "2016-07-22T03:50:38Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![HenryTheSir](https://avatars.discourse-cdn.com/v4/letter/h/f475e1/32.png) [@HenryTheSir](https://forums.percona.com/u/HenryTheSir)
#### Post date: [July 22, 2016, 3:50am UTC](https://forums.percona.com/t/select-found-rows-returns-always-0-if-2-members-are-up/4990/1 "2016-07-22T03:50:38Z")

</div>

Hello,

i got Problems with our Wordpressblog and the Pagination function which uses a SQL Function: SELECT FOUND\_ROWS(); This functions returns always 0 if both Clustermembers are up. It is no difference if the Statements are balanced to both Servers or only to one server - they will return 0 if they are both up. If I stop one of the members and the cluster\_size is 1 the SQL Statement returns the correct numbers.

Any suggestions?  
[LIST]  
[_]  
[_]  
[/LIST]

Thanks!