{"id":25,"date":"2026-03-12T06:45:11","date_gmt":"2026-03-12T14:45:11","guid":{"rendered":"https:\/\/satchnet.io\/?p=25"},"modified":"2026-03-19T05:34:42","modified_gmt":"2026-03-19T13:34:42","slug":"the-great-uptime-kuma-upgrade-a-tale-of-stuck-migrations-and-io-domain-betrayal","status":"publish","type":"post","link":"https:\/\/satchnet.io\/?p=25","title":{"rendered":"The Great Uptime Kuma Upgrade: A Tale of Stuck Migrations and .io Domain Betrayal"},"content":{"rendered":"\n

tl;dr:<\/strong> Upgraded Uptime Kuma from v1 to v2, got stuck in a migration bootloop, fixed it with some SQLite surgery, then upgraded Portainer because apparently I hate stability.<\/p>\n\n\n\n\n\n\n\n

Act I: “Wait, What Version Am I On?”<\/h2>\n\n\n\n

Me: “I should update Uptime Kuma.”<\/p>\n\n\n\n

UI: “You’re on v1.23.17”<\/p>\n\n\n\n

Logs after restarting: “Uptime Kuma Version: 2.2.1”<\/p>\n\n\n\n

Me: “…wat”<\/p>\n\n\n\n

Turns out I’d already upgraded at some point but the UI was living in the past. Cool. Cool cool cool.<\/p>\n\n\n\n

Act II: The Bootloop of Doom<\/h2>\n\n\n\n

Tried to start the container. Got this instead:<\/p>\n\n\n\n

[DB] WARN: Aggregate table migration is already in progress, or it was interrupted\n[DB] ERROR: Database migration failed\n[SERVER] ERROR: Failed to prepare your database<\/code><\/pre>\n\n\n\n
Repeat ad infinitum<\/em><\/p>\n\n\n\n
Classic “migration started, never finished, now refuses to do anything” situation. The container was crashing faster than my confidence.<\/p>\n\n\n\n
Act III: SQLite to the Rescue<\/h2>\n\n\n\n
Stopped the container (well, it stopped itself repeatedly, I just made it stay stopped), popped into the database:<\/p>\n\n\n\n
bash<\/p>\n\n\n\n
cd \/data\/compose\/14\/data\nsqlite3 kuma.db<\/code><\/pre>\n\n\n\n
Found the culprit:<\/p>\n\n\n\n
sql<\/p>\n\n\n\n
SELECT * FROM setting WHERE key = 'migrateAggregateTableState';\n-- Returns: \"migrating\"<\/code><\/pre>\n\n\n\n
But wait! Did the migration actually fail, or did it just forget to update the flag? Time for some forensics:<\/p>\n\n\n\n
sql<\/p>\n\n\n\n
SELECT COUNT(*) FROM stat_minutely;  -- 80 rows\nSELECT COUNT(*) FROM stat_hourly;    -- 54 rows  \nSELECT COUNT(*) FROM stat_daily;     -- 73 rows<\/code><\/pre>\n\n\n\n
The migration had completed<\/em> – it just failed to clear its own flag. Like finishing a marathon and forgetting to cross the finish line.<\/p>\n\n\n\n
The fix:<\/strong><\/p>\n\n\n\n
sql<\/p>\n\n\n\n
UPDATE setting SET value = '\"migrated\"' WHERE key = 'migrateAggregateTableState';\n```\n\nRestarted the container. No more bootloop. Victory!\n\n## Act IV: Domain Expiry Monitoring (LOL)\n\nGot all excited about v2's new domain expiry monitoring feature. You know, the thing that warns you before your domain registration expires.\n\nChecked the logs:\n```\n[DOMAIN_EXPIRY] WARN: Domain expiry unsupported for '.io' because its RDAP endpoint \nis not listed in the IANA database.<\/code><\/pre>\n\n\n\n
My primary domain is satchnet.io<\/code>.<\/p>\n\n\n\n
The feature doesn’t work for .io<\/code> domains.<\/p>\n\n\n\n
\ud83d\ude10<\/p>\n\n\n\n
Act V: Portainer Upgrade (Because Why Not)<\/h2>\n\n\n\n
Having successfully upgraded one thing, I decided to tempt fate and upgrade Portainer too.<\/p>\n\n\n\n
This one was anticlimactic:<\/p>\n\n\n\n
bash<\/p>\n\n\n\n
docker pull portainer\/portainer-ce:lts\ndocker stop portainer && docker rm portainer\ndocker run -d ... # (same flags as before)<\/code><\/pre>\n\n\n\n
Migrated cleanly from 2.33.7 to 2.39.0. No drama. No stuck migrations. No existential database crises.<\/p>\n\n\n\n
Honestly kind of disappointing after the Uptime Kuma adventure.<\/p>\n\n\n\n
Lessons Learned<\/h2>\n\n\n\n
    \n
  1. LXC snapshots before upgrades<\/strong> – always, every time, no exceptions<\/li>\n\n\n\n
  2. Database migrations can lie<\/strong> – if it says “in progress,” check if it actually finished<\/li>\n\n\n\n
  3. Not all upgrades are created equal<\/strong> – some are smooth (Portainer), some require SQLite wizardry (Uptime Kuma)<\/li>\n\n\n\n
  4. .io<\/code> domains are second-class citizens<\/strong> in the domain expiry monitoring world<\/li>\n\n\n\n
  5. “If it ain’t broke, don’t fix it”<\/strong> is good advice I will continue to ignore<\/li>\n<\/ol>\n\n\n\n
    The End<\/h2>\n\n\n\n
    Everything works now. Uptime Kuma is on v2.2.1, Portainer is on 2.39.0, and I have exactly zero domain expiry monitoring for my .io<\/code> domains.<\/p>\n\n\n\n
    10\/10 would troubleshoot stuck migrations again.<\/p>\n\n\n\n
    \n\n\n\n
    P.S. – Huge thanks to Claude for the SQLite forensics. Without the “check if the tables actually have data” step, I’d probably still be in that bootloop.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
    tl;dr: Upgraded Uptime Kuma from v1 to v2, got stuck in a migration bootloop, fixed it with some SQLite surgery, then upgraded Portainer because apparently I hate stability.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7],"tags":[],"class_list":["post-25","post","type-post","status-publish","format-standard","hentry","category-docker","category-monitoring"],"_links":{"self":[{"href":"https:\/\/satchnet.io\/index.php?rest_route=\/wp\/v2\/posts\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/satchnet.io\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/satchnet.io\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/satchnet.io\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/satchnet.io\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=25"}],"version-history":[{"count":4,"href":"https:\/\/satchnet.io\/index.php?rest_route=\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":37,"href":"https:\/\/satchnet.io\/index.php?rest_route=\/wp\/v2\/posts\/25\/revisions\/37"}],"wp:attachment":[{"href":"https:\/\/satchnet.io\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/satchnet.io\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/satchnet.io\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}