Ara.T.Howard wrote:
On Tue, 4 Jan 2005, Steve Milner wrote:
Hello List,
I am having a problem with SQLite erroring out on Mac OS X. I am using 3.0.8. The problem happens when it tries to access a SAMBA/CIFS shared database. In my testing Windows to Linux and Linux to Windows worked fine, but Mac to Windows fails with the following:
Traceback (most recent call last):
File "dbclassqascript.py", line 14, in ?
db.query(sys.argv[2])
File "/Volumes/TUX-NET;W/database.py", line 25, in query
cu.execute(query)
File "/System/Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3/site-packages/sqlite/main.py", line 244, in execute
self.rs = self.con.db.execute(SQL)
_sqlite.OperationalError: database is locked
All help is greatly apreciated!
Steve
this is (probably) simply saying that another process is accessing the
database. can you confirm that no other process (sqlite command line tool
included) is accessing the db?
cheers.
-a
Good Day Ara,
Yes. I have two laptops (a OS X and a Windows 2k) sitting side by side. They can share files fine with eachother on the network, reading and writing no problem. If I share a sqlite database on the Windows system Mac OS X can not access it even for reading under any circumstance. On the Windows end nothing is accessing the database, and on the Mac end it just has the share mounted and tries to access the database. I can open the database in VIM and 'edit' it by hand (did to make sure I could read and write to it outside of sqlite).
Now going the oppisite direction is no problem. Windows can read and write to a sqlite database share via CIFS/SAMBA in the same manner.
Thanks, Steve
