2.0.3 to 2.0.6 database migration again.

Example log output?

*** Database migration in progress ***

2025-09-09 10:55:33 INF syncthing v2.0.8 "Hafnium Hornet" (go1.25.1 linux-amd64) docker@github.syncthing.net 2025-09-08 06:55:04 UTC [noupgrade, stnoupgrade] (log.pkg=main)
2025-09-09 10:55:36 INF Applying database migration (path=folder.0003-ik3p45ha.db script=04-alter-blocks-tables.sql log.pkg=db/sqlite)
2025-09-09 10:55:38 INF Starting temporary GUI/API during migration (address=0.0.0.0:8384 log.pkg=main)

That’s it. There is nothing else in the TrueNAS logs, and no improvement vice the earliest forum reports for the syncthing-2.0.0 release.

On my test machine, only folder.0003-ik3p45ha.db (14 GB) is large enough to choke the system. I/O and CPU utilization fall to nearly zero soon after Syncthing begins applying the database migration.

# cd /mnt/.ix-apps/app_mounts/syncthing/ix-syncthing_config/config/index-v2
# ls -la

total 17414591
total 17957365
drwx------ 3 apps apps          36 Sep  9 09:45 .
drwx------ 4 apps apps          11 Aug 14 11:58 ..
drwx------ 2 apps apps           2 Sep  9 09:46 .tmp
-rw-r--r-- 1 apps apps   231985152 Sep  9 09:46 folder.0001-aeqmczwu.db
-rw-r--r-- 1 apps apps       32768 Sep  9 10:55 folder.0001-aeqmczwu.db-shm
-rw-r--r-- 1 apps apps       32992 Sep  9 10:55 folder.0001-aeqmczwu.db-wal
-rw-r--r-- 1 apps apps   110718976 Sep  9 09:46 folder.0002-kwgwezrc.db
-rw-r--r-- 1 apps apps       32768 Sep  9 10:55 folder.0002-kwgwezrc.db-shm
-rw-r--r-- 1 apps apps       32992 Sep  9 10:55 folder.0002-kwgwezrc.db-wal
-rw-r--r-- 1 apps apps 14733357056 Sep  9 09:47 folder.0003-ik3p45ha.db
-rw-r--r-- 1 apps apps     1605632 Sep  9 11:29 folder.0003-ik3p45ha.db-shm
-rw-r--r-- 1 apps apps   816229712 Sep  9 11:29 folder.0003-ik3p45ha.db-wal
-rw-r--r-- 1 apps apps   120639488 Sep  9 04:15 folder.0004-ubljofsc.db
-rw-r--r-- 1 apps apps       65536 Sep  9 04:15 folder.0004-ubljofsc.db-shm
-rw-r--r-- 1 apps apps           0 Sep  9 04:15 folder.0004-ubljofsc.db-wal
-rw-r--r-- 1 apps apps     3354624 Sep  9 04:15 folder.0005-fsgz4kbm.db
-rw-r--r-- 1 apps apps       32768 Sep  9 04:15 folder.0005-fsgz4kbm.db-shm
-rw-r--r-- 1 apps apps           0 Sep  9 04:15 folder.0005-fsgz4kbm.db-wal
-rw-r--r-- 1 apps apps       94208 Sep  9 04:15 folder.0006-rnsbsmkx.db
-rw-r--r-- 1 apps apps       32768 Sep  9 04:15 folder.0006-rnsbsmkx.db-shm
-rw-r--r-- 1 apps apps           0 Sep  9 04:15 folder.0006-rnsbsmkx.db-wal
-rw-r--r-- 1 apps apps    16973824 Sep  9 04:15 folder.0007-xohivt9i.db
-rw-r--r-- 1 apps apps       32768 Sep  9 09:38 folder.0007-xohivt9i.db-shm
-rw-r--r-- 1 apps apps     2401992 Sep  9 09:38 folder.0007-xohivt9i.db-wal
-rw-r--r-- 1 apps apps     9007104 Sep  9 04:15 folder.0008-3dbvdreq.db
-rw-r--r-- 1 apps apps       32768 Sep  9 04:15 folder.0008-3dbvdreq.db-shm
-rw-r--r-- 1 apps apps           0 Sep  9 04:15 folder.0008-3dbvdreq.db-wal
-rw-r--r-- 1 apps apps   525053952 Sep  9 04:15 folder.0009-rjzd6kge.db
-rw-r--r-- 1 apps apps       65536 Sep  9 04:15 folder.0009-rjzd6kge.db-shm
-rw-r--r-- 1 apps apps           0 Sep  9 04:15 folder.0009-rjzd6kge.db-wal
-rw-r--r-- 1 apps apps  1827475456 Sep  9 04:36 folder.000a-yxukkrve.db
-rw-r--r-- 1 apps apps      491520 Sep  9 04:36 folder.000a-yxukkrve.db-shm
-rw-r--r-- 1 apps apps           0 Sep  9 04:36 folder.000a-yxukkrve.db-wal
-rw-r--r-- 1 apps apps       36864 Sep  9 08:22 main.db
-rw-r--r-- 1 apps apps       32768 Sep  9 10:55 main.db-shm
-rw-r--r-- 1 apps apps     4128272 Sep  9 10:55 main.db-wal

Per other threads, this might actually be a Docker bug, but it always happens on TrueNAS.

What’s weird is my other machine, which is much beefier, completed the migration so fast I didn’t even notice.

My othere sever did finish after 4 days, however, now there is a 2.0.8 update, so I guess I will see what happens. The new server I built did beat it as well. It only took 2 days to sync all the files over the internet, although it seemed slow. The main server is on a 40gb Wan connection, and the new server is on a 2GB connection, but it never transferred faster than about 115mbps. I can actually SMB over this connection with Tailscale, and its 400-500 Mbps, and SMB is not known for speed and isn’t multithreaded.

2025-09-05 19:59:08.911882+00:002025-09-05 12:59:08 INF Changed package log level (package=all level=DEBUG log.pkg=slogutil)
2025-09-05 19:59:08.928599+00:002025-09-05 12:59:08 INF Changed package log level (package=all level=DEBUG log.pkg=slogutil)
2025-09-05 19:59:08.928644+00:002025-09-05 12:59:08 INF syncthing v2.0.7 "Hafnium Hornet" (go1.25.1 linux-amd64) docker@github.syncthing.net 2025-09-05 09:51:15 UTC [noupgrade, stnoupgrade] (log.pkg=main)
2025-09-05 19:59:08.992219+00:002025-09-05 12:59:08 INF Applying database migration (path=folder.0001-gipznhxj.db script=04-alter-blocks-tables.sql log.pkg=db/sqlite)
2025-09-05 19:59:13.971317+00:002025-09-05 12:59:13 INF Starting temporary GUI/API during migration (address=0.0.0.0:20910 log.pkg=main)
2025-09-09 15:15:21.827394+00:002025-09-09 08:15:21 INF Temporary GUI/API closed (address=0.0.0.0:20910 error="http: Server closed" log.pkg=main)
2025-09-09 15:15:21.839232+00:002025-09-09 08:15:21 INF Calculated our device ID (device=2ANIYLC-DJJLBLA-GRXUJES-IH3TCS5-DY6V3CW-PARQCAZ-W5VHVIL-IKDGHAI log.pkg=syncthing)
2025-09-09 15:15:22.302025+00:002025-09-09 08:15:22 INF Measured hashing performance (perf="2181.78 MB/s" log.pkg=syncthing)
2025-09-09 15:15:22.302277+00:002025-09-09 08:15:22 INF Detected upgrade (from=v2.0.3 to=v2.0.7 log.pkg=syncthing)
2025-09-09 15:15:22.384431+00:002025-09-09 08:15:22 INF Overall rate limit in use (send="is unlimited" recv="is unlimited" log.pkg=connections)

Here are some logs after it finished. There is nothing between it starting the migration and just being done.

Yeah, that migration is effectively a single SQL clause, so there isn’t much for us to log partway, unfortunately.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.