Re: [sqlite] sqlite3.OperationalError: disk I/O error

2011-10-04 Thread Dungan, Kerry
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Roger Binns [rog...@rogerbinns.com] Sent: Monday, October 03, 2011 6:47 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3.OperationalError: disk I/O error

Re: [sqlite] sqlite3.OperationalError: disk I/O error

2011-10-04 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/04/2011 06:34 AM, Dungan, Kerry wrote: At this point, I guess my next step is to figure out how to get this fixed (any suggestions). Do not use SQLite with a networked file system. If there will only be one client so locking is not a big

Re: [sqlite] sqlite3.OperationalError: disk I/O error

2011-10-04 Thread Dungan, Kerry
: disk I/O error -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/04/2011 06:34 AM, Dungan, Kerry wrote: At this point, I guess my next step is to figure out how to get this fixed (any suggestions). Do not use SQLite with a networked file system. If there will only be one client so locking

Re: [sqlite] sqlite3.OperationalError: disk I/O error

2011-10-04 Thread Richard Hipp
: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Roger Binns [rog...@rogerbinns.com] Sent: Tuesday, October 04, 2011 11:05 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite3.OperationalError: disk I/O error -BEGIN PGP SIGNED MESSAGE- Hash: SHA1

[sqlite] sqlite3.OperationalError: disk I/O error

2011-10-03 Thread Dungan, Kerry
Hello, I have a piece of code that works fine on my desktop in cygwin, but fails on our server. I am creating a simple database using the sqlite3 module in python. I open a connection con=sqlite3.connect(./file.db) #works cur=con.cursor() #works cur.execute(create table test(name, age)) #fails

Re: [sqlite] sqlite3.OperationalError: disk I/O error

2011-10-03 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/03/2011 03:05 PM, Dungan, Kerry wrote: the result: An empty file.db is created, and I get sqlite3.OperationalError: disk I/O error on the execute command. There could be any number of reasons. The message is coming from the SQLite library