Hi Richard,
Thank you Richard.
I get the latest source(sqlite-amalgamation-3071502.zip) and cross-compile. And
follow your instruction:
sqlite3 -vfs unix-none ex1
That issue is gone.
Really appreciated for your quick and exact response.
David J. Choi
-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of Richard Hipp
Sent: Tuesday, February 19, 2013 4:04 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] database is locked with create
On Tue, Feb 19, 2013 at 6:37 PM, Choi, David <[email protected]> wrote:
> Hi Richard,
>
> It seems that my version is not accept the command. By the way, what
> is the version that you are referring to?
>
Get the latest: 3.7.15.1. There is no reason not 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: [email protected] [mailto:
> [email protected]] 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 <[email protected]>
> 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
> [email protected]_______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
