We should compile sqlite with HAVE_USLEEP=1 You may read more detail here:
https://beets.io/blog/sqlite-nightmare.html
sqlite.org HAVE_USLEEP
If the HAVE_USLEEP option is true, then the default unix VFS uses the usleep() system call to implement the xSleep method. If this option is undefined or false, then xSleep on unix is implemented using sleep() which means that sqlite3_sleep() will have a minimum wait interval of 1000 milliseconds regardless of its argument.