Thank you pratyyy!
Yes, namespace is the same for both the sets.
Aerospike.conf:
namespace test {
replication-factor 2
memory-size 4G
default-ttl 30d
storage-engine memory
}
SETS are “users” and “tweets”.
AQL output when I connect to localhost:
aql> select * from test.users
±-----------±-----------±---------±-------±--------------±-----------±------------±-------+
| key | username | password | region | lasttweeted | tweetcount | interests | gender |
±-----------±-----------±---------±-------±--------------±-----------±------------±-------+
| “pietro” | “pietro” | “qwerty” | “n” | 1430984773607 | 1 | [“inter”] | “m” |
| “pietro” | “pietro” | “qwerty” | “n” | 1430984773607 | 1 | [“inter”] | “m” |
| “pietro” | “pietro” | “qwerty” | “n” | 1430984773607 | 1 | [“inter”] | “m” |
| “giuseppe” | “giuseppe” | “qwerty” | “s” | 1430984928958 | 1 | [“sicilia”] | “f” |
| “moreno” | “moreno” | “qwerty” | “n” | 1430984519751 | 1 | [“juve”] | “m” |
| “giuseppe” | “giuseppe” | “qwerty” | “s” | 1430984928958 | 1 | [“sicilia”] | “f” |
| “moreno” | “moreno” | “qwerty” | “n” | 1430984519751 | 1 | [“juve”] | “m” |
±-----------±-----------±---------±-------±--------------±-----------±------------±-------+
7 rows in set (1.392 secs)
(7 rows when I inserted 3)
If I connect to another host in the cluster:
aql -h 10.100.0.4
aql> select * from test.users
±-----------±-----------±---------±-------±-------±--------------±-----------±------------+
| key | username | password | gender | region | lasttweeted | tweetcount | interests |
±-----------±-----------±---------±-------±-------±--------------±-----------±------------+
| “giuseppe” | “giuseppe” | “qwerty” | “f” | “s” | 1430984928958 | 1 | [“sicilia”] |
| “moreno” | “moreno” | “qwerty” | “m” | “n” | 1430984519751 | 1 | [“juve”] |
| “pietro” | “pietro” | “qwerty” | “m” | “n” | 1430984773607 | 1 | [“inter”] |
| “pietro” | “pietro” | “qwerty” | “m” | “n” | 1430984773607 | 1 | [“inter”] |
| “pietro” | “pietro” | “qwerty” | “m” | “n” | 1430984773607 | 1 | [“inter”] |
±-----------±-----------±---------±-------±-------±--------------±-----------±------------+
5 rows in set (1.563 secs)
The same when I use a python client:
./users.10.100.0.3.py
(‘test’, ‘users’, u’pietro’, bytearray(b’\xc8_\xf85\xd1\xfe\x00&\xfc\xe1\x0ctO,\x83\xf17!\xe3\xcf’)) {‘gen’: 13, ‘ttl’: 2589144} {‘username’: u’pietro’}
(‘test’, ‘users’, u’giuseppe’, bytearray(b’\xbf\x90\x01\xdf\x8c=\xf1\xfe\xda\xfa\nL\xaf\xec\nQ\xa4xE\x97’)) {‘gen’: 4, ‘ttl’: 2528163} {‘username’: u’giuseppe’}
(‘test’, ‘users’, u’moreno’, bytearray(b’t]87X\xb2\x82\x01\xf9\xc7P\xbcW\x81\xffKO\xd4\xd0\x18’)) {‘gen’: 2, ‘ttl’: 1901527} {‘username’: u’moreno’}
(‘test’, ‘users’, u’giuseppe’, bytearray(b’\xbf\x90\x01\xdf\x8c=\xf1\xfe\xda\xfa\nL\xaf\xec\nQ\xa4xE\x97’)) {‘gen’: 4, ‘ttl’: 2528163} {‘username’: u’giuseppe’}
(‘test’, ‘users’, u’moreno’, bytearray(b’t]87X\xb2\x82\x01\xf9\xc7P\xbcW\x81\xffKO\xd4\xd0\x18’)) {‘gen’: 2, ‘ttl’: 1901527} {‘username’: u’moreno’}
5 records.
If I use a client python that connect to hosts 10.100.0.3 and 10.100.0.4 the result is OK:
./users.10.100.0.3e4.py
(Here are the first rows of python script:
Configure the client
config = {
‘hosts’: [ (‘10.100.0.3’, 3000), (‘10.100.0.4’, 3000)]
}
and its execution:
(‘test’, ‘users’, u’pietro’, bytearray(b’\xc8_\xf85\xd1\xfe\x00&\xfc\xe1\x0ctO,\x83\xf17!\xe3\xcf’)) {‘gen’: 13, ‘ttl’: 2589074} {‘username’: u’pietro’}
(‘test’, ‘users’, u’giuseppe’, bytearray(b’\xbf\x90\x01\xdf\x8c=\xf1\xfe\xda\xfa\nL\xaf\xec\nQ\xa4xE\x97’)) {‘gen’: 4, ‘ttl’: 2528094} {‘username’: u’giuseppe’}
(‘test’, ‘users’, u’moreno’, bytearray(b’t]87X\xb2\x82\x01\xf9\xc7P\xbcW\x81\xffKO\xd4\xd0\x18’)) {‘gen’: 2, ‘ttl’: 1901458} {‘username’: u’moreno’}
3 records.
The hosts have Linux Centos as their operating system:
CentOS release 6.5 (Final)
uname -a
Linux couchbase-1 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
)