https://sqlite.org/forum/forumpost/c16ef8b9ea According to discussion here, it's not recoverable. This is why I ask a reliable way to handle this issue. Discovering free space on filesystems is not reliable unfortunately as it may change any moment, e.g another process deletes something, or sqlite tries to allocate 2 mb and fails, then I check free space, it says there is 1 mb, so how can I decide if disk is full then? Thanks, for max_page_count pragma and page_count pragma suggestions, yes, it looks like the best approach for case b. So, as a result, I was expecting there is a way to get that return code somehow to decide how to proceed.