Re: [sqlite] Cross-compiled sqlite3 tool runs into segmentation fault when creating a table

On Mon, Dec 12, 2011 at 10:41 PM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Dec 12, 2011 at 11:34 PM, imin imup <imini...@gmail.com> wrote: > > > Hello, > > > > I'm cross-compiling SQLite 3.6.12 onto Fedora 14 on MIPS cpu. The command > > line tool

[sqlite] Cross-compiled sqlite3 tool runs into segmentation fault when creating a table

Hello, I'm cross-compiling SQLite 3.6.12 onto Fedora 14 on MIPS cpu. The command line tool sqlite3 runs into segmentation fault when I tried to create a table: # sqlite3_mipsel test.db SQLite version 3.6.12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>

Re: [sqlite] sqlite error: database is locked

> Thanks for clarification. I assumed the error message of error code > > SQLITE_BUSY is something like "databased is busy". > > http://www.sqlite.org/c3ref/c_abort.html > Also in sqlite3.h file - comments on the right are almost exactly > reflect the corresponding error message. > You are

Re: [sqlite] sqlite error: database is locked

nection per function can be error prone. One long-lived connection per thread might be better. Another newbie question. Is it safe for 2 threads to share 1 connection when the connection is protected by my own mutex? Thanks a lot. > > Pavel > > On Wed, Mar 17, 2010 at 1:35 PM, imin imup &

Re: [sqlite] sqlite error: database is locked

more than 1 database connections are held (in nested function calls). Will this cause any issue? On Wed, Mar 17, 2010 at 11:05 AM, Pavel Ivanov <paiva...@gmail.com> wrote: > http://www.sqlite.org/faq.html#q5 > http://www.sqlite.org/lockingv3.html > > Pavel > > On Wed

[sqlite] sqlite error: database is locked

Hello users, I'm using sqlite 3.6.12 in muti-threaded application. I'm getting sqlite errors occasionally. The error message is *sqlite error: database is locked* could someone explain to me what happened and what to be done? or point me to a document on how to fix this? Best Imin