We are getting below error while truncating table. And truncate failed.
Jul 10 12:16:20 Ubuntu-2204-jammy-amd64-base scylla: [shard 29:stat] database - Truncating databasename.tablename with auto-snapshot
Jul 10 12:27:36 Ubuntu-2204-jammy-amd64-base scylla: [shard 0:stat] mutation_partition - Memory usage of unpaged query exceeds soft limit of 1048576 (configured via max_memory_for_unlimited_query_soft_limit)
Please suggest solution around it.
@sachinkumar
So tips when truncating - make sure you have BIG --request-timeout if you use cqlsh to run it (or in client set request timeout to be > 60s )
If it fails(times out), run it AGAIN until it succeeds.
Once it’s done, on all nodes clear the snapshot it created (or all of them, or if you don’t need the safety check disable auto snapshot feature)
hth
L
OH and " mutation_partition - Memory usage of unpaged query exceeds soft limit of 1048576 (configured via max_memory_for_unlimited_query_soft_limit) " is unrelated and basically about your queries and has nothing to do with truncate, as you see it’s a warning that one of your queries was unpaged and its result was bigger than 1MB, which certainly impacts performance - you should page in your queries, unpaged queries are antipattern