You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2024/07/13 12:29:00 UTC
[jira] [Commented] (ASTERIXDB-3455) Delete statement gets stuck
[ https://issues.apache.org/jira/browse/ASTERIXDB-3455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17865678#comment-17865678 ]
ASF subversion and git services commented on ASTERIXDB-3455:
------------------------------------------------------------
Commit 27f72040c4ba84783084157be7f04b2e1af3ee31 in asterixdb's branch refs/heads/master from Peeyush Gupta
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=27f72040c4 ]
[ASTERIXDB-3455][RT] Delete statement stuck indefinitely
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Use LSMPrimaryInsertNodePushable instead of
LSMInsertDeleteOperatorNodePushable for deletes.
Change-Id: I07c61009bd7bdce507151db7dccca195a6544c7f
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18465
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Peeyush Gupta <pe...@couchbase.com>
Reviewed-by: Murtadha Hubail <mh...@apache.org>
> 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
> Labels: triaged
>
> 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)