Details
-
Bug
-
Resolution: Fixed
-
Critical
-
None
-
None
-
None
-
AWS 4 node cluster
kv:query:index:fts-kv:query:index:fts-kv-kv
Enterprise Edition 7.0.0 build 4960
query node with internal/ext IP (Addresses: 172.31.25.170 (int) | ec2-****.compute.amazonaws.com :8091 (ext))
-
1
Description
Get fetch error with simple transaction in CBQ
cbq> begin work;
|
{
|
"requestID": "b48471cc-2644-4af5-92f8-1239d6c833af", |
"signature": "json", |
"results": [ |
{
|
"txid": "e50378ff-ffc6-4aef-93ff-b214b9bbfc6f" |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "1.371195ms", |
"executionTime": "1.26857ms", |
"resultCount": 1, |
"resultSize": 62, |
"serviceLoad": 6, |
"transactionElapsedTime": "36.454µs", |
"transactionRemainingTime": "1m59.999955067s" |
}
|
}
|
cbq> select * from `travel-sample` use keys 'airline_10'; |
{
|
"requestID": "9bb63a15-1bc6-4636-b3a9-356b7ed2aab5", |
"signature": { |
"*": "*" |
},
|
"results": [ |
],
|
"errors": [ |
{
|
"cause": { |
"cause": { |
"-": { |
"InnerError": { |
"InnerError": {}, |
"Message": "unambiguous timeout" |
}
|
},
|
"i": "0x0", |
"s": "LookupIn", |
"t": 2500211 |
},
|
"raise": "failed", |
"retry": true, |
"rollback": true |
},
|
"code": 17017, |
"msg": "Transaction fetch error" |
}
|
],
|
"status": "errors", |
"metrics": { |
"elapsedTime": "2.502387725s", |
"executionTime": "2.502298048s", |
"resultCount": 0, |
"resultSize": 0, |
"serviceLoad": 1, |
"transactionElapsedTime": "4.822848308s", |
"transactionRemainingTime": "1m55.177101543s", |
"errorCount": 1 |
}
|
}
|
Note that only 1 node has alternate address if I had ec2 hostname alternate address to all nodes it works.
nodeService info:
{
|
"rev": 1207, |
"nodesExt": [ |
{
|
"services": { |
"capi": 8092, |
"capiSSL": 18092, |
"kv": 11210, |
"kvSSL": 11207, |
"mgmt": 8091, |
"mgmtSSL": 18091, |
"projector": 9999 |
},
|
"hostname": "172.31.16.84" |
},
|
{
|
"services": { |
"capi": 8092, |
"capiSSL": 18092, |
"fts": 8094, |
"ftsGRPC": 9130, |
"ftsGRPCSSL": 19130, |
"ftsSSL": 18094, |
"indexAdmin": 9100, |
"indexHttp": 9102, |
"indexHttps": 19102, |
"indexScan": 9101, |
"indexStreamCatchup": 9104, |
"indexStreamInit": 9103, |
"indexStreamMaint": 9105, |
"kv": 11210, |
"kvSSL": 11207, |
"mgmt": 8091, |
"mgmtSSL": 18091, |
"n1ql": 8093, |
"n1qlSSL": 18093, |
"projector": 9999 |
},
|
"hostname": "172.31.20.118" |
},
|
{
|
"services": { |
"capi": 8092, |
"capiSSL": 18092, |
"fts": 8094, |
"ftsGRPC": 9130, |
"ftsGRPCSSL": 19130, |
"ftsSSL": 18094, |
"indexAdmin": 9100, |
"indexHttp": 9102, |
"indexHttps": 19102, |
"indexScan": 9101, |
"indexStreamCatchup": 9104, |
"indexStreamInit": 9103, |
"indexStreamMaint": 9105, |
"kv": 11210, |
"kvSSL": 11207, |
"mgmt": 8091, |
"mgmtSSL": 18091, |
"n1ql": 8093, |
"n1qlSSL": 18093, |
"projector": 9999 |
},
|
"thisNode": true, |
"hostname": "172.31.25.170", |
"alternateAddresses": { |
"external": { |
"hostname": "ec2-18-222-204-158.us-east-2.compute.amazonaws.com", |
"ports": { |
"mgmt": 8091, |
"mgmtSSL": 18091, |
"fts": 8094, |
"ftsSSL": 18094, |
"ftsGRPC": 9130, |
"ftsGRPCSSL": 19130, |
"indexAdmin": 9100, |
"indexScan": 9101, |
"indexHttp": 9102, |
"indexStreamInit": 9103, |
"indexStreamCatchup": 9104, |
"indexStreamMaint": 9105, |
"indexHttps": 19102, |
"kv": 11210, |
"kvSSL": 11207, |
"capi": 8092, |
"capiSSL": 18092, |
"projector": 9999, |
"n1ql": 8093, |
"n1qlSSL": 18093 |
}
|
}
|
}
|
},
|
{
|
"services": { |
"capi": 8092, |
"capiSSL": 18092, |
"kv": 11210, |
"kvSSL": 11207, |
"mgmt": 8091, |
"mgmtSSL": 18091, |
"projector": 9999 |
},
|
"hostname": "172.31.31.117" |
}
|
],
|
"clusterCapabilitiesVer": [ |
1, |
0 |
],
|
"clusterCapabilities": { |
"n1ql": [ |
"enhancedPreparedStatements" |
]
|
}
|
}
|