Summary
I’d like to do write/read to aerospike cluster through the load balance. But it does not go well. Could you take an advice?
Conditions
- aerospike version: aerospike server community edition v3.15.01
- OS: CentOS 7.4.1708
The aerospike access image is like the below.
remote client (VIP) =>load balancer => aerospike cluster
Symptom
When C or PHP client would access to aerospike cluster through the load balancer, there is no connection error, but getting data or putting data would be failed.
Instead of C or PHP client, using aerospike-tool(like aql or adadm), the access itself is succeeded, but AQL execution would be failed.
When using aerospike-tool from the remote client, the access itself was succeeded like the below. *aerospike_vip means the vip of the load balancer.
[cocoamaemae@remote_client ~]$ aql -h aerospike_vip
Aerospike Query Client
Version 3.15.0.3
C Client Version 4.2.0
Copyright 2012-2017 Aerospike. All rights reserved.
aql>
However, aql was failed like the below.
aql> select * from hoge.hogehoge
Error: (7) AEROSPIKE_ERR_CLUSTER_CHANGE
When the aql query was failed, the below log was confirmed in the aerospike server side.
Nov 10 2017 09:27:41 GMT: WARNING (job): (job_manager.c:513) job with trid 2327940182733486773 already active
Nov 10 2017 09:27:41 GMT: WARNING (scan): (scan.c:622) basic scan job 2327940182733486773 failed to start (4)
The aerospike.conf is like the below. Only shows network.service conf
network {
service {
address any
port 3000
reuse-address
access-address ****(node ip address)
alternate-access-address ****(ip address entering into node )
}
Why C or PHP client could not get or put data?
Why aerospike-tool could access but aql execution would be failed?