Hi, I am on starrocks 3.3 and suddenly getting the...
# questions-and-troubleshooting
s
Hi, I am on starrocks 3.3 and suddenly getting the following error on the query-
select COUNT(*) from shs  where to_date(shs.created_at) >= '2025-09-24' LIMIT 2;
Copy code
ERROR 1064 (HY000): load_segments failed tablet:271529807 rowset:366 segid:0: starlet err [RequestID=18748A228868A193][StatusCode=404]Get object <s3://starrocks-data-store/data-science/39a98ed0-4905-48eb-b4fd-6543f3264afa/db437986/563781/271529802/data/000000000d2ef076_1a66197f-245f-406a-9258-2fc98c3ec249.dat> error: The specified key does not exist.:
Common causes for this error are:
1. A schema change has been made to the table
2. The current query is a slow query
For the first case, you can retry the current query.
For the
However, the query works fine-
select COUNT(*) from shs  where to_date(shs.created_at) >= '2025-09-25' LIMIT 2;
I think something happened with the data on
'2025-09-24'
. Can someone help on debugging this?
j
please show me the table schema
s
@jeff.ding Here is the create table command-
Copy code
CREATE TABLE `service_history_summarization` (
  `created_at` datetime NULL COMMENT "",
  `registration_number` varchar(65533) NULL COMMENT "",
  `make` varchar(65533) NULL COMMENT "",
  `status` varchar(65533) NULL COMMENT "",
  `message` varchar(65533) NULL COMMENT "",
  `input_path` varchar(65533) NULL COMMENT "",
  `output` json NULL COMMENT "",
  `env` varchar(65533) NULL COMMENT ""
) ENGINE=OLAP 
DUPLICATE KEY(`created_at`, `registration_number`, `make`, `status`)
COMMENT "OLAP"
PARTITION BY date_trunc('DAY', created_at)
DISTRIBUTED BY HASH(`registration_number`)
PROPERTIES (
"replication_num" = "1",
"datacache.partition_duration" = "3 days",
"datacache.enable" = "true",
"storage_volume" = "starrocks_prod_ds",
"enable_async_write_back" = "false",
"enable_persistent_index" = "true",
"persistent_index_type" = "LOCAL",
"compression" = "LZ4"
);
"storage_volume" = "starrocks_prod_ds" is our minio bucket.
@jeff.ding can you please help
Hi @jeff.ding can you please help?