Hi Richard, It seems that my version is not accept the command. By the way, what is the version that you are referring to?
Here is my operation: /home # sqlite3 --help Usage: sqlite3 [OPTIONS] FILENAME [SQL] FILENAME is the name of an SQLite database. A new database is created if the file does not previously exist. OPTIONS include: -help show this message -init filename read/process named file -echo print commands before execution -[no]header turn headers on or off -bail stop after hitting an error -interactive force interactive I/O -batch force batch I/O -column set output mode to 'column' -csv set output mode to 'csv' -html set output mode to HTML -line set output mode to 'line' -list set output mode to 'list' -separator 'x' set output field separator (|) -nullvalue 'text' set text string for NULL values -version show SQLite version /home # sqlite3 -version 3.6.23.1 /home # sqlite3 -vfs unix-none ex1 sqlite3: Error: unknown option: -vfs Use -help for a list of options. Regards, David J. Choi -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, February 19, 2013 1:44 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] database is locked with create On Tue, Feb 19, 2013 at 4:39 PM, Choi, David <david.c...@micrel.com> wrote: > Hi Richard, > > I think your guess is highly possible because the error comes from > sqliteErrorFromPosixError(). In that case, how can I fix the issue? > Try adding the -vfs unix-none command-line option: sqlite3 -vfs unix-none ex1 That will disable file locking. Be warned, however, that with file locking disabled, two processes trying to access the database at the same time can lead to problems.-- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users