In CrateDB 5.5.2, snapshot creation for a 5-row table takes over an hour. What might cause this?
cr> select count(*) from xxaps.cs_test;
+----------+
| count(*) |
+----------+
| 5 |
+----------+
SELECT 1 row in set (0.003 sec)
cr> CREATE SNAPSHOT repo_cratedb001.snapshot_20250327_cs_test TABLE xxaps.cs_test WITH (wait_for_completion=true);
CREATE OK, 1 row affected (4041.797 sec)
cr> select * from sys.snapshots;
+-------------------+----------+---------------+---------------------------+-----------------+---------------+---------+------------------+-------------------+---------+
| concrete_indices | failures | finished | name | repository | started | state | table_partitions | tables | version |
+-------------------+----------+---------------+---------------------------+-----------------+---------------+---------+------------------+-------------------+---------+
| ["xxaps.cs_test"] | [] | 1743058299042 | snapshot_20250327_cs_test | repo_cratedb001 | 1743056839779 | SUCCESS | [] | ["xxaps.cs_test"] | 5.5.2 |
+-------------------+----------+---------------+---------------------------+-----------------+---------------+---------+------------------+-------------------+---------+
SELECT 1 row in set (0.092 sec)