Sync error：from linux server to windows client

[nixwl]

trilium server build in docker：

output:
Sending message to all clients: {"type":"sync-pull-in-progress"}

Got error  SqliteError: disk I/O error

    at /usr/src/app/main.cjs:817:1214

    at Zk (/usr/src/app/main.cjs:817:1591)

    at Fue (/usr/src/app/main.cjs:817:1204)

    at HXt (/usr/src/app/main.cjs:816:22)

    at Object.Kei [as replace] (/usr/src/app/main.cjs:816:103)

    at cbi (/usr/src/app/main.cjs:1479:60629)

    at ubi (/usr/src/app/main.cjs:1479:60061)

    at Object.obi [as updateEntities] (/usr/src/app/main.cjs:1479:59935)

    at Function.<anonymous> (/usr/src/app/main.cjs:1728:576)

    at Function.sqliteTransaction (/usr/src/app/node_modules/better-sqlite3/lib/methods/transaction.js:65:24) {

  code: 'SQLITE_IOERR_GETTEMPPATH'

}

I have check sqllite database use： sqlite3 document.db "PRAGMA integrity_check;" result is OK
how can i fix it ?

[eliandoran]

From what I see you are having an issue with the SQLite not being able to obtain a temporary directory.

From https://www.sqlite.org/rescode.html#ioerr_gettemppath:

(6410) SQLITE_IOERR_GETTEMPPATH

The SQLITE_IOERR_GETTEMPPATH error code is an extended error code for SQLITE_IOERR indicating that the VFS is unable to determine a suitable directory in which to place temporary files.

Can you double-check your TMPDIR and disk space?

[nixwl]

The Trilium data directory is located at /vol2/1000/Trilium/trilium-data, with ample available storage space. I don’t know whether what I did helps in identifying the problem.

[nixwl]

I fixed it in docker:

/usr/src/app # ls -ld /tmp
drwxr-xr-t    2 root     root          4096 Oct 13 13:24 /tmp
/usr/src/app # chmod 1777 /tmp
/usr/src/app # ls -ld /tmp
drwxrwxrwt    1 root     root          4096 Oct 13 13:24 /tmp