sqlite - SQLite VACUUM 使用哪个临时目录

Question

以编程方式运行 SQLite VACUUM 命令时，如何在执行命令时查找使用了哪个临时目录。我正在使用 sqlite 版本 3.6.7 我有这个问题，因为我得到以下异常。所以我想检查一下，如果可能的话，更改 VACUUM 使用的临时目录。

java.sql.SQLException: [SQLITE_FULL]  Insertion failed because database is full (database or disk is full)

I tried monitoring the following directories (using java WatchService), but no files where changed in those directories by the VACUUM.
/var/tmp
/usr/tmp
/tmp
current directory

I tried executing PRAGMA temp_store_directory on the database, but go the following error(as it is not set/available):
java.sql.SQLException: query does not return ResultSet

标签： sqlitevacuum