如果文件位于远程文件夹(如共享文件夹)中，则可能引发此错误。我将数据库更改为本地目录，它工作得很好。

我的Linux环境上的lsof命令帮助我弄清楚一个进程挂起并保持文件打开。 终止了这个过程，问题就解决了。

如果一个进程在SQLite DB上有一个锁，并且崩溃了，那么这个DB将永远处于锁定状态。这就是问题所在。并不是其他进程有锁。

这个环节解决了问题。:当Sqlite给出:数据库锁定错误 它解决了我的问题也许对你有用。

并且可以使用开始事务和结束事务来避免将来数据库被锁定。

有些函数，比如INDEX'ing，可能会花费很长时间——而且在运行时它会锁定整个数据库。在这种情况下，它甚至可能不使用日志文件!

因此，最好/唯一的方法来检查您的数据库是否被锁定，因为一个进程正在积极地写入它(因此你应该让它独自呆着，直到它完成它的操作)是md5(或md5sum在某些系统)文件两次。 如果你得到一个不同的校验和，数据库正在被写入，你真的真的真的不想杀死这个进程，因为如果你这样做，你很容易得到一个损坏的表/数据库。

我要重申一下，因为这很重要——解决方案不是找到锁程序并杀死它——而是找出数据库是否有一个很好的写锁，然后从那里开始。有时候正确的解决方法就是喝杯咖啡休息一下。

The only way to create this locked-but-not-being-written-to situation is if your program runs BEGIN EXCLUSIVE, because it wanted to do some table alterations or something, then for whatever reason never sends an END afterwards, and the process never terminates. All three conditions being met is highly unlikely in any properly-written code, and as such 99 times out of 100 when someone wants to kill -9 their locking process, the locking process is actually locking your database for a good reason. Programmers don't typically add the BEGIN EXCLUSIVE condition unless they really need to, because it prevents concurrency and increases user complaints. SQLite itself only adds it when it really needs to (like when indexing).

Finally, the 'locked' status does not exist INSIDE the file as several answers have stated - it resides in the Operating System's kernel. The process which ran BEGIN EXCLUSIVE has requested from the OS a lock be placed on the file. Even if your exclusive process has crashed, your OS will be able to figure out if it should maintain the file lock or not!! It is not possible to end up with a database which is locked but no process is actively locking it!! When it comes to seeing which process is locking the file, it's typically better to use lsof rather than fuser (this is a good demonstration of why: https://unix.stackexchange.com/questions/94316/fuser-vs-lsof-to-check-files-in-use). Alternatively if you have DTrace (OSX) you can use iosnoop on the file.

由于某种原因，数据库被锁定了。以下是我的解决方法。

我将sqlite文件下载到我的系统(FTP) 删除在线sqlite文件 将文件上传到主机提供商

现在可以正常工作了。