search

axonops / axonops-workbench

AxonOps™ Workbench for Apache Cassandra® - Desktop application for Mac, Windows and Linux
https://axonops.com
Apache License 2.0
11 stars 0 forks source link

[bug]: Executing "select * system.compaction_history;" in notebook view does not display any rows #393

Closed hshimizu closed 1 month ago

hshimizu commented 2 months ago

Do I have the most recent version of AxonOps Workbench installed?

AxonOps Workbench Version

1.0.0-beta-20240910-01

Is there an existing issue for this?

Operating System

Windows

Operating System Version

Windows 11

Apache Cassandra Version(s)

5.0.0

Bug Description

Running the above query in the terminal view shows some rows. image

Notebook view shows none. image

Steps to Reproduce

Execute "select * from system.compaction_history;" in notebook view.

Expected Behavior

Executing the query should show some rows.

Actual Behavior

Executing the query shows no rows.

Severity

High

Further Information

No response

millerjp commented 2 months ago

@mhmdkrmabd I have tested this on MacOs v1.0.0-beta-20240909-01 and it returns ok

hshimizu commented 2 months ago

image


CREATE TABLE system.compaction_history (
    id timeuuid PRIMARY KEY,
    bytes_in bigint,
    bytes_out bigint,
    columnfamily_name text,
    compacted_at timestamp,
    compaction_properties frozen<map<text, text>>,
    keyspace_name text,
    rows_merged map<int, bigint>
) WITH additional_write_policy = '99p'
    AND bloom_filter_fp_chance = 0.01
    AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
    AND comment = 'week-long compaction history'
    AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
    AND compression = {'chunk_length_in_kb': '16', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND crc_check_chance = 1.0
    AND default_time_to_live = 604800
    AND gc_grace_seconds = 0
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 3600000
    AND min_index_interval = 128
    AND read_repair = 'BLOCKING'
    AND speculative_retry = '99p';
millerjp commented 2 months ago

@mhmdkrmabd It looks like its specific to this table and its data times and windows

mhmdkrmabd commented 2 months ago

@millerjp @hshimizu confirmed this bug, only happen on Windows (10/11), not confirmed yet if it's only for the table system.compaction_history; or it's about the data type in it image

digiserg commented 2 months ago

Fixed in the latest beta

digiserg commented 2 months ago

@mhmdkrmabd I'm reopening this issue as it seems to happen still but not always. I get the problem always the first time though. See video.

https://github.com/user-attachments/assets/33f37ab6-8f1e-482c-aaa0-5db312670aef

mhmdkrmabd commented 2 months ago

Am working on that

mhmdkrmabd commented 2 months ago

@millerjp @hshimizu @digiserg

Image