Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-19 Thread Tim Bradshaw
On 19 Jun 2009, at 06:36, hiral wrote: > I am running application which uses the db over the NFS. If I move > the db > over the local drive then it's working fine. > So I m observing this bug in NFS environment frequently. > In the same test environment (in which I am getting db corrupted), >

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-19 Thread Simon Davies
2009/6/19 hiral : > Hi Simon / John, > > Thank you for replies. > >> You are able to repeatably corrupt the db under SQLite 3.5.9? It would >> be worthwhile publishing a script that can do that. >  > "was getting error often" or "did get error ONCE"?? > I am running application which uses the db ov

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-18 Thread hiral
Hi Simon / John, Thank you for replies. > You are able to repeatably corrupt the db under SQLite 3.5.9? It would > be worthwhile publishing a script that can do that. > "was getting error often" or "did get error ONCE"?? I am running application which uses the db over the NFS. If I move the db o

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-18 Thread John Machin
On 18/06/2009 10:40 PM, hiral wrote: > Hi Simon, > > Thank you for your quick reply. > > I am sorry for more general questions. > > As I mentioned I was getting corrupted db error with sqlite-3.5.9, "was getting error often" or "did get error ONCE"?? > but when > I tried with sqlite-3.6.4 it

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-18 Thread Simon Davies
2009/6/18 hiral : > Hi Simon, > > Thank you for your quick reply. > > I am sorry for more general questions. > > As I mentioned I was getting corrupted db error with sqlite-3.5.9, but when > I tried with sqlite-3.6.4 it is no more corrupting the db. > -- so was it a bug with sqlite-3.5.9 ? and got

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-18 Thread hiral
Hi Simon, Thank you for your quick reply. I am sorry for more general questions. As I mentioned I was getting corrupted db error with sqlite-3.5.9, but when I tried with sqlite-3.6.4 it is no more corrupting the db. -- so was it a bug with sqlite-3.5.9 ? and got fixed in sqlite-3.6.4 -- is it sa

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-18 Thread Simon Davies
2009/6/17 hiral : > Hi Simon, > >  I looked into it but couldn't find the exact reason for my bug. > >  If you have any idea please let me know. Sorry, other than the link, I can not help. > >  Also I would appreciate, if you can let me know what does this error mean > in terms of btree/pager mod

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-17 Thread hiral
Hi Simon, I looked into it but couldn't find the exact reason for my bug. If you have any idea please let me know. Also I would appreciate, if you can let me know what does this error mean in terms of btree/pager module of sqlite >> sqlite> PRAGMA integrity_check; >> *** in database main

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-17 Thread Simon Davies
2009/6/17 hiral : > Any suggestion on this !!! Your database has been corrupted. http://www.sqlite.org/lockingv3.html#how_to_corrupt Rgds, Simon > > On Tue, Jun 16, 2009 at 4:34 PM, h o wrote: > >> Hi, >> >> I am using sqlite-3.5.9 and observing a 'disk image malformed' error >> nfs, on doing '

Re: [sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-17 Thread hiral
Any suggestion on this !!! On Tue, Jun 16, 2009 at 4:34 PM, h o wrote: > Hi, > > I am using sqlite-3.5.9 and observing a 'disk image malformed' error > nfs, on doing 'PRAGMA integrity_check' I got following messages... > > SQLite version 3.5.9 > Enter ".help" for instructions > sqlite> PRAGMA in

[sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-16 Thread h o
Hi, I am using sqlite-3.5.9 and observing a 'disk image malformed' error nfs, on doing 'PRAGMA integrity_check' I got following messages... SQLite version 3.5.9 Enter ".help" for instructions sqlite> PRAGMA integrity_check; *** in database main *** Page 5275 is never used wrong # of entries in in

[sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-12 Thread Oza, Hiral_Dineshbhai
Hi, I am using sqlite-3.5.9 and observing a 'disk image malformed' error after executing several sql statements on nfs after running 'PRAGMA integrity_check' got following messages... SQLite version 3.5.9 Enter ".help" for instructions sqlite> PRAGMA integrity_check; *** in database main *** Page

[sqlite] Sqlite-3.5.9: getting sqlite_autoindex error

2009-06-12 Thread Oza, Hiral_Dineshbhai
Hi, I am using sqlite-3.5.9 and observing a 'disk image malformed' error after executing several sql statements on nfs after running 'PRAGMA integrity_check' got following messages... SQLite version 3.5.9 Enter ".help" for instructions sqlite> PRAGMA integrity_check; *** in database main *** Page