Timeout error with AQL


#1

Hi running 3.6.1 community on Ubuntu 14.04

When I run AQL I keep getting this time out error. I can still run commands. But the error just keeps printing…

2015-11-04 10:21:23 WARN AEROSPIKE_ERR_TIMEOUT Socket write error: 113
2015-11-04 10:21:25 WARN AEROSPIKE_ERR_TIMEOUT Socket write error: 113
2015-11-04 10:21:27 WARN AEROSPIKE_ERR_TIMEOUT Socket write error: 113
2015-11-04 10:21:29 WARN AEROSPIKE_ERR_TIMEOUT Socket write error: 113
aql> show index2015-11-04 10:21:31 WARN AEROSPIKE_ERR_TIMEOUT Socket write error: 113
es
+-----------+------------------+-----------+-----------+----------+-------+---------------------+------------------+------------+-----------+
| ns        | bins             | indextype | set       | num_bins | state | indexname           | path             | sync_state | type      |
+-----------+------------------+-----------+-----------+----------+-------+---------------------+------------------+------------+-----------+
| "myspace" | "xxxxxx"          | "NONE"    | "MyModel" | 1        | "RW"  | "xxxxxxIdx"          | "xxxxxx"          | "synced"   | "STRING"  |

2015-11-04 10:21:32 WARN AEROSPIKE_ERR_TIMEOUT Socket write error: 113
2015-11-04 10:21:33 WARN AEROSPIKE_ERR_TIMEOUT Socket write error: 113

#2

Has anyone experienced this?


#3

Is this a vm env, virtual box, vagrant?

I’ve seen this when a node has multiple NICs and lets say the first nic is a NAT address.

What could happen is aerospike is publishing multiple IPs for that node.

Try running the following on the node to see IPs being published:

asinfo -v service

Adding the access-address setting to your config file with the correct IP address should help.

http://www.aerospike.com/docs/operations/configure/network/general/