Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
None
-
0
Description
I ran the update query with transaction (set -tximplicit true), and I kept getting "Transaction timeout" errors. I enabled debug logging and collected logs.
cbq> begin work;
|
{
|
"requestID": "8e112894-e055-4388-8a96-cf4f90f21fe0",
|
"signature": "json",
|
"results": [
|
{
|
"txid": "91ea67a4-68e3-48a4-82d8-3f91cbefdaad"
|
}
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "1.829679ms",
|
"executionTime": "1.530905ms",
|
"resultCount": 1,
|
"resultSize": 62,
|
"serviceLoad": 6,
|
"transactionElapsedTime": "101.038µs",
|
"transactionRemainingTime": "1m59.999881593s"
|
}
|
}
|
cbq> UPDATE default:`bucket-1`.`scope-1`.`collection-1` AS d SET d.comment = d.comment WHERE d.c0 BETWEEN 0 AND 0 AND d.cid BETWEEN 0 AND 99;
|
{
|
"requestID": "eedca46d-2b90-487b-989e-019daba6ff9f",
|
"signature": null,
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "31.970647ms",
|
"executionTime": "31.683456ms",
|
"resultCount": 0,
|
"resultSize": 0,
|
"serviceLoad": 1,
|
"mutationCount": 100,
|
"transactionElapsedTime": "7.546097577s",
|
"transactionRemainingTime": "1m52.453884635s"
|
}
|
}
|
cbq> commit;
|
{
|
"requestID": "e8f0641e-90cd-4e01-a096-173b1b1d39f2",
|
"signature": "json",
|
"results": [
|
],
|
"errors": [
|
{
|
"cause": {
|
"cause": "the expiry for the attempt was reached: attempt expired",
|
"raise": "expired",
|
"retry": false,
|
"rollback": false
|
},
|
"code": 17007,
|
"msg": "Commit Transaction statement error: Transaction timeout"
|
}
|
],
|
"status": "errors",
|
"metrics": {
|
"elapsedTime": "1m50.198297509s",
|
"executionTime": "1m50.198037492s",
|
"resultCount": 0,
|
"resultSize": 0,
|
"serviceLoad": 1,
|
"transactionElapsedTime": "2m1.926789336s",
|
"errorCount": 1
|
}
|
}
|