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

[hshimizu]

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

• I am using the most recent beta release

AxonOps Workbench Version

1.0.0-beta-20240910-01

Is there an existing issue for this?

• I have searched the existing issues

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.

Notebook view shows none.

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]

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

[hshimizu]

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]

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

[mhmdkrmabd]

@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

[digiserg]

Fixed in the latest beta

[digiserg]

@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.

Screen.Recording.2024-09-11.at.14.35.09.mov

[mhmdkrmabd]

Am working on that

[mhmdkrmabd]

@millerjp @hshimizu @digiserg