Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-17 Thread Larry Knibb
Just wanted to say thanks to everyone for the help... I've decided to use MySQL for this particular setup rather than go down the route of custom builds. SQLite remains my preference for exclusive scenarios and it's only because I have to support scaling to simultaneous connections that I'm

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-16 Thread Clemens Ladisch
Keith Medcalf wrote: > Note that according to the Microsoft documentation opportunistic > locking is only used when overlapped I/O is enabled. That applies only to oplocks that are requested manually by an application through FSCTL_ control codes:

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-15 Thread Keith Medcalf
Note that according to the Microsoft documentation opportunistic locking is only used when overlapped I/O is enabled. Of course, this is from Microsoft documentation, so it has to be taken with a really huge boulder of salt. Anyway, long and short is that you may be able to get windows to

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-15 Thread Yuriy Kaminskiy
Larry Knibb wrote: > On 15 October 2012 12:32, Keith Medcalf wrote: >> Define "clients". Do you mean multiple client processes running on a single >> computer against a database hosted on an attached local device, such as on a >> Terminal Server for example? Or do you

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-15 Thread Clemens Ladisch
Larry Knibb wrote: > On 15 October 2012 16:35, Clemens Ladisch wrote: >> Which network protocol? And what are the OSes on the clients and on the >> file server? > > The server and clients are Windows machines so I guess (not my area of > expertise) that the protocol is

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-15 Thread Larry Knibb
On 15 October 2012 16:35, Clemens Ladisch wrote: > Which network protocol? And what are the OSes on the clients and on the > file server? The server and clients are Windows machines so I guess (not my area of expertise) that the protocol is SMB/CIFS? Cheers, Larry

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-15 Thread Clemens Ladisch
Larry Knibb wrote: > On 15 October 2012 12:32, Keith Medcalf wrote: >> Define "clients". Do you mean multiple client processes running on >> a single computer against a database hosted on an attached local >> device, such as on a Terminal Server for example? Or do you mean

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-14 Thread Larry Knibb
On 15 October 2012 12:32, Keith Medcalf wrote: > > Define "clients". Do you mean multiple client processes running on a single > computer against a database hosted on an attached local device, such as on a > Terminal Server for example? Or do you mean multiple clients

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-14 Thread Larry Knibb
On 15 October 2012 11:54, Simon Slavin wrote: > > I think you need someone who is more familiar with the 'malformed' error > indication than I am. I really can't guess what's faking this response, > assuming that it is a byproduct of networking and the database really

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-14 Thread Keith Medcalf
> On Sunday, 14 October, 2012, at 20:28, Larry Knibb said: > I'm trialling a centralised SQLite database to store process > automation metadata with a known, small, fixed number clients (around > 10) as part of a Jenkins CI system running on Windows. The clients > connect occasionally and run

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-14 Thread Simon Slavin
On 15 Oct 2012, at 3:58am, Larry Knibb wrote: > On 15 October 2012 10:48, Simon Slavin wrote: >> > > Thanks Simon. > > I'm new to Python so not sure how to call this C API from my Python > script.

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-14 Thread Larry Knibb
On 15 October 2012 10:48, Simon Slavin wrote: > > On 15 Oct 2012, at 3:28am, Larry Knibb wrote: > What you can do is introduce your own timeout and see if this changes anything, just as something to try. > >

Re: [sqlite] DatabaseError: database disk image is malformed

2012-10-14 Thread Simon Slavin
On 15 Oct 2012, at 3:28am, Larry Knibb wrote: > Recently, I've started > seeing these errors related to some of the INSERT calls: > > DatabaseError: database disk image is malformed > StorageError: database disk image is malformed > > Given the scenario (and being

[sqlite] DatabaseError: database disk image is malformed

2012-10-14 Thread Larry Knibb
I'm trialling a centralised SQLite database to store process automation metadata with a known, small, fixed number clients (around 10) as part of a Jenkins CI system running on Windows. The clients connect occasionally and run simple, quick (sub-second) SELECT queries and even less frequent

Re: [sqlite] 'DatabaseError: database disk image is malformed'

2010-04-10 Thread Simon Slavin
On 10 Apr 2010, at 3:32pm, D. Richard Hipp wrote: > none of that should be in the first page of the database file. Nor > does that text appear to be in a format that would appear anywhere in > a valid SQLite database. So I'm guessing that some other process has > decided to open the

Re: [sqlite] 'DatabaseError: database disk image is malformed'

2010-04-10 Thread exarkun
On 02:21 pm, rut...@cs.vu.nl wrote: >[I first posted this on the Trac user list. There, I was referred to >the >sqlite mailing lists.] > >I am running 3 trac instances on a FreeBSD server; trac 0.11b, sqlite3 >3.4.1, pysqlite-2.3.5. More or less simultaneously (at least within a >few days) all

Re: [sqlite] 'DatabaseError: database disk image is malformed'

2010-04-10 Thread D. Richard Hipp
On Apr 10, 2010, at 10:21 AM, Rutger Hofman wrote: > [I first posted this on the Trac user list. There, I was referred to > the > sqlite mailing lists.] > > I am running 3 trac instances on a FreeBSD server; trac 0.11b, sqlite3 > 3.4.1, pysqlite-2.3.5. More or less simultaneously (at least

[sqlite] 'DatabaseError: database disk image is malformed'

2010-04-10 Thread Rutger Hofman
[I first posted this on the Trac user list. There, I was referred to the sqlite mailing lists.] I am running 3 trac instances on a FreeBSD server; trac 0.11b, sqlite3 3.4.1, pysqlite-2.3.5. More or less simultaneously (at least within a few days) all three trac databases got corrupted. You can