2010-03-05 02:56:59     sqlite3, database is locked under 2009R1.1-RC4

Document created by Aaronwu Employee on Aug 22, 2013
Version 1Show Document
  • View in full screen mode

2010-03-05 02:56:59     sqlite3, database is locked under 2009R1.1-RC4

w w (CHINA)

Message: 86826   

 

hi,all

 

I download the latest uClinux Distribution uClinux-dist-2009R1.1-RC4.tar.bz2 and compiled ok, and run well on my bf533 stamp board. But when I run sqlite3, I get an error like this:

 

root:/> sqlite3 mydb

SQLite version 3.6.14.1

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

sqlite> .table

Error: database is locked

sqlite>

 

what's the matter ?

 

IS there something wrong about linux kernel 2.6.28 and sqlite3 ?

 

I can use sqlite3 well under uClinux Distribution 2008R1-RC8.

 

Can you help me? Thank you!

QuoteReplyEditDelete

 

 

2010-03-05 17:02:10     Re: sqlite3, database is locked under 2009R1.1-RC4

w w (CHINA)

Message: 86883   

 

Any suggestions ?

 

Thank you !

QuoteReplyEditDelete

 

 

2010-03-07 21:17:53     Re: sqlite3, database is locked under 2009R1.1-RC4

w w (CHINA)

Message: 86926   

 

Is there no one known the question?

QuoteReplyEditDelete

 

 

2010-03-08 10:35:04     Re: sqlite3, database is locked under 2009R1.1-RC4

Robin Getz (UNITED STATES)

Message: 86953   

 

ww:

 

Can you run things through strace to see where the error is coming from?

 

Thanks

 

-Robin

QuoteReplyEditDelete

 

 

2010-08-12 04:16:38     Re: sqlite3, database is locked under 2009R1.1-RC4

Strelkov Nick (RUSSIAN FEDERATION)

Message: 92365   

 

This problem is caused by unsetting of CONFIG_FILE_LOCKING in kernel by default in uClinux distro.

 

SQLite uses fcntl for database locking. Therefore the CONFIG_FILE_LOCKING must be set to CONFIG_FILE_LOCKING=y (File systems -> [*] Enable POSIX file locking API).

Attachments

    Outcomes