Select statement not showing all bins at client aql

I have install aerospike on one server and client on another server and insert a record from server side AQL. Inserted record have 55 bins, when i query it from server side aql it shows all 55 bins for that record, but if when i query the same record from client side it shows only 32 bins.

Not sure what is the issue, can someone please suggest.

Server version - aerospike-server-enterprise-3.14.1.4-1.el7.x86_64 Client version - aerospike-client-c-devel-4.1.5-1.el7.x86_64

Can you please show the select statements, host target, and output from both AQL and the client code? Is there a “WHERE” clause, or is this purely a scan? You are using aerospike-client-c-devel-4.1.5-1.el7.x86_64 for your own code, correct?

Hello,

I confirm, using “aerospike-client-c-devel-4.1.5-1.el7.x86_64” for my C code Further, the Select is based on PK.

Attached snaps for both the output: (1) First one is server output

(2) Second shows client output.

Further, following are the packages at server end: aerospike-client-c-devel-4.1.5-1.el7.x86_64 aerospike-tools-3.13.0.1-1.el7.x86_64 aerospike-amc-community-4.0.12-1.x86_64 aerospike-server-enterprise-3.14.1.4-1.el7.x86_64

Can you run the AQL statement with the same -h option from the server?

I resolve the problem, it happen because of the server and client version mismatch, after upgrading the client version (3.12.0) to server version (3.13.0.1) it’s working fine.

1 Like