[
https://issues.apache.org/jira/browse/ASTERIXDB-3455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peeyush Gupta updated ASTERIXDB-3455:
-------------------------------------
Description:
Delete statement that deletes a lot of entries from a dataset can get stuck.
{noformat}
2024-07-02T05:48:56.828+00:00 WARN CBAS.impls.LSMHarness
[SA:JID:0.42:TAID:TID:ANID:ODID:1:2:0:0:0] couldn't enter component:
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0, "pendingFlushes":0,
"id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_1/Default/Default/stock/0/stock_virtual_1"}},
isCompFull=true, isFull=false, flushingComponents=
[{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0, "pendingFlushes":0,
"id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_65/Default/Default/stock/0/stock_virtual_1"}},
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
"pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_57/Default/Default/stock/0/stock_virtual_1"}},
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
"pendingFlushes":0, "id":"[71,71]", "index":{"class": "BTree", "file":
"storage/partition_41/Default/Default/stock/0/stock_virtual_0"}},
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
"pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_1/Default/Default/stock/0/stock_virtual_1"}},
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
"pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_113/Default/Default/stock/0/stock_virtual_1"}}],
Page size = 131072
Page budget = 67008
Used pages = 8042
Used large pages = 0
Available free pages = 58966 {noformat}
was:
Delete statement that deletes a lot of entries from a dataset can get stuck.
{noformat}
2024-07-02T05:48:56.828+00:00 WARN CBAS.impls.LSMHarness
[SA:JID:0.42:TAID:TID:ANID:ODID:1:2:0:0:0] couldn't enter component:
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0, "pendingFlushes":0,
"id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_1/Default/Default/stock/0/stock_virtual_1"}},
isCompFull=true, isFull=false,
flushingComponents=[{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
"pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_65/Default/Default/stock/0/stock_virtual_1"}},
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0, "pendingFlushes":0,
"id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_57/Default/Default/stock/0/stock_virtual_1"}},
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0, "pendingFlushes":0,
"id":"[71,71]", "index":{"class": "BTree", "file":
"storage/partition_41/Default/Default/stock/0/stock_virtual_0"}},
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0, "pendingFlushes":0,
"id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_1/Default/Default/stock/0/stock_virtual_1"}},
{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0, "pendingFlushes":0,
"id":"[72,72]", "index":{"class": "BTree", "file":
"storage/partition_113/Default/Default/stock/0/stock_virtual_1"}}],
Page size = 131072
Page budget = 67008
Used pages = 8042
Used large pages = 0
Available free pages = 58966 {noformat}
> Delete statement gets stuck
> ---------------------------
>
> Key: ASTERIXDB-3455
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3455
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: RT - Runtime
> Reporter: Peeyush Gupta
> Priority: Major
>
> Delete statement that deletes a lot of entries from a dataset can get stuck.
>
> {noformat}
> 2024-07-02T05:48:56.828+00:00 WARN CBAS.impls.LSMHarness
> [SA:JID:0.42:TAID:TID:ANID:ODID:1:2:0:0:0] couldn't enter component:
> {"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
> "pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
> "storage/partition_1/Default/Default/stock/0/stock_virtual_1"}},
> isCompFull=true, isFull=false, flushingComponents=
> [{"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
> "pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
> "storage/partition_65/Default/Default/stock/0/stock_virtual_1"}},
> {"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
> "pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
> "storage/partition_57/Default/Default/stock/0/stock_virtual_1"}},
> {"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
> "pendingFlushes":0, "id":"[71,71]", "index":{"class": "BTree", "file":
> "storage/partition_41/Default/Default/stock/0/stock_virtual_0"}},
> {"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
> "pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
> "storage/partition_1/Default/Default/stock/0/stock_virtual_1"}},
> {"state":"READABLE_UNWRITABLE", "writers":0, "readers":0,
> "pendingFlushes":0, "id":"[72,72]", "index":{"class": "BTree", "file":
> "storage/partition_113/Default/Default/stock/0/stock_virtual_1"}}],
> Page size = 131072
> Page budget = 67008
> Used pages = 8042
> Used large pages = 0
> Available free pages = 58966 {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
