summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2025-02-15 10:53:15 +0100
committerTor Andersson <tor@ccxvii.net>2025-02-15 10:53:15 +0100
commit94060bfa5f58b3715c38b36b5c110061ca12bea4 (patch)
tree5154a0ff63814e33f32ec0a5d2baec70b4fd2537
parent09b8fb93b5b459d3442d0cd3abe58e2010fb0d86 (diff)
downloadserver-94060bfa5f58b3715c38b36b5c110061ca12bea4.tar.gz
Add busy timeout to purge script.
-rw-r--r--tools/purge.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/tools/purge.sql b/tools/purge.sql
index add6e2d..8249f01 100644
--- a/tools/purge.sql
+++ b/tools/purge.sql
@@ -1,5 +1,7 @@
-- Prune game snapshot and game state data to save database space.
+pragma busy_timeout=10000;
+
attach database 'db' as live;
create temporary view prune_snap_list as