On Wed, Apr 23, 2014 at 3:34 PM, Steve Wills <[email protected]> wrote:
> On Wed, Apr 23, 2014 at 02:06:33PM -0400, Richard Hipp wrote: > > On Wed, Apr 23, 2014 at 12:20 AM, Steve Wills <[email protected]> > wrote: > > I think http://www.sqlite.org/src/info/1bbb4be1a25 addresses your > problem. > > That change is in all 3.8.* versions of SQLite. > > I am using 3.8.4.3 and was still seeing issues until I set > HAVE_POSIX_FALLOCATE=0 in configure. > In 3.8.4.3, posix_fallocate() is only called as a hint to the filesystem that the database is about to grow to the indicated size. (Many filesystems appreciate this hint as it helps them to avoid fragmentation.) Any error returned from posix_fallocate() is ignored. So what problem are you seeing, exactly? Is the fact that posix_fallocate() is being called at all causing some kind of problem for ZFS? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
