Hi
I tested with aerospike-server-community-3.5.9-el6 on both servers and aerospike-server-community-3.5.12-el6 too.
I used default /etc/aerospike/aerospike.conf
I put 10 records into the test.demoset.
The issue is very consistent, when I query “aql> select * from test”, it seems like it is popping all the master records + the replica records in the same node.
If I get 15 records result on server#1, I also get 15 records on server#2,
If I get 17 on server#1, 13 on server#2… and so on.
(The results are consistent until I reset the servers and put the data again.)
=========================================================================
FYI
When I test with 3 node cluster
I get multiple(5) results when I query namespaces/sets.
aql> show namespaces
±-----------+
| namespaces |
±-----------+
| “test” |
| “bar” |
±-----------+
2 rows in set (0.000 secs)
±-----------+
| namespaces |
±-----------+
| “test” |
| “bar” |
±-----------+
2 rows in set (0.000 secs)
±-----------+
| namespaces |
±-----------+
| “test” |
| “bar” |
±-----------+
2 rows in set (0.001 secs)
±-----------+
| namespaces |
±-----------+
| “test” |
| “bar” |
±-----------+
2 rows in set (0.000 secs)
±-----------+
| namespaces |
±-----------+
| “test” |
| “bar” |
±-----------+
2 rows in set (0.000 secs)
OK
aql> show sets
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| n_objects | set-enable-xdr | set-stop-write-count | ns_name | set_name | set-delete | set-evict-hwm-count
|
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| 5 | “use-default” | 0 | “test” | “event” | “false” | 0 |
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
1 row in set (0.000 secs)
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| n_objects | set-enable-xdr | set-stop-write-count | ns_name | set_name | set-delete | set-evict-hwm-count
|
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| 10 | “use-default” | 0 | “test” | “event” | “false” | 0 |
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
1 row in set (0.000 secs)
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| n_objects | set-enable-xdr | set-stop-write-count | ns_name | set_name | set-delete | set-evict-hwm-count
|
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| 10 | “use-default” | 0 | “test” | “event” | “false” | 0 |
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
1 row in set (0.000 secs)
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| n_objects | set-enable-xdr | set-stop-write-count | ns_name | set_name | set-delete | set-evict-hwm-count
|
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| 5 | “use-default” | 0 | “test” | “event” | “false” | 0 |
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
1 row in set (0.000 secs)
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| n_objects | set-enable-xdr | set-stop-write-count | ns_name | set_name | set-delete | set-evict-hwm-count
|
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
| 5 | “use-default” | 0 | “test” | “event” | “false” | 0 |
±----------±---------------±---------------------±--------±---------±-----------±--------------------+
1 row in set (0.000 secs)
OK