Re: sqlite defect

2013-07-19 Thread Corinna Vinschen
On Jul 19 21:36, jojelino wrote: > On 2013-07-19 PM 9:08, jojelino wrote: > >On 2013-07-19 PM 9:02, Corinna Vinschen wrote: > >>There *is* a workaround: > >> > >> export CYGWIN_SQLITE_LOCKING=posix > >> > >>See http://cygwin.com/ml/cygwin-announce/2013-06/msg00014.html > >> > >It's very good work

Re: sqlite defect

2013-07-19 Thread jojelino
On 2013-07-19 PM 9:08, jojelino wrote: On 2013-07-19 PM 9:02, Corinna Vinschen wrote: There *is* a workaround: export CYGWIN_SQLITE_LOCKING=posix See http://cygwin.com/ml/cygwin-announce/2013-06/msg00014.html It's very good workaround instead of rebuild sqlite3. thanks for the point. Also

Re: sqlite defect

2013-07-19 Thread jojelino
On 2013-07-19 PM 9:02, Corinna Vinschen wrote: There *is* a workaround: export CYGWIN_SQLITE_LOCKING=posix See http://cygwin.com/ml/cygwin-announce/2013-06/msg00014.html It's very good workaround instead of rebuild sqlite3. thanks for the point. -- Regards. -- Problem reports: http

Re: sqlite defect

2013-07-19 Thread Corinna Vinschen
On Jul 19 20:53, jojelino wrote: > On 2013-07-19 PM 8:30, Corinna Vinschen wrote: > >A valid testcase would help a lot, though. What you meant to do > >was calling flock with LOCK_EX|LOCK_NB. > > > that's what exactly sqlite3 that uses the mandatory-locking did. > reproducing the behavior was i me

Re: sqlite defect

2013-07-19 Thread jojelino
On 2013-07-19 PM 8:30, Corinna Vinschen wrote: A valid testcase would help a lot, though. What you meant to do was calling flock with LOCK_EX|LOCK_NB. that's what exactly sqlite3 that uses the mandatory-locking did. reproducing the behavior was i meant to do. And then again, your testcase wor

Re: sqlite defect

2013-07-19 Thread Corinna Vinschen
On Jul 19 19:28, jojelino wrote: > On 2013-07-19 PM 7:08, Corinna Vinschen wrote: > > ...and, btw., fcntl(fd, F_SETOWN) is only supported on sockets. > > > > > > Corinna > > > 28 55977555 [main] python 5616 open: 9 = > open(/home/Administrator/../..sqlite, 0x58202) > .. > .. > 4680

Re: sqlite defect

2013-07-19 Thread jojelino
On 2013-07-19 PM 7:08, Corinna Vinschen wrote: > ...and, btw., fcntl(fd, F_SETOWN) is only supported on sockets. > > > Corinna > 28 55977555 [main] python 5616 open: 9 = open(/home/Administrator/../..sqlite, 0x58202) .. .. 4680 55982813 [main] python 5616 flock: 0 = flock(9, 6)

Re: sqlite defect

2013-07-19 Thread Corinna Vinschen
On Jul 19 12:03, Corinna Vinschen wrote: > On Jul 19 10:56, jojelino wrote: > > On 2013-07-18 PM 5:59, Corinna Vinschen wrote:> On Jul 18 17:11, > > jojelino wrote: > > >> On 2013-07-18 AM 10:53, Warren Young wrote: > > >>> Nothing so simple. Locking is handled at the OS and/or Cygwin DLL > > >>>

Re: sqlite defect

2013-07-19 Thread Corinna Vinschen
On Jul 19 10:56, jojelino wrote: > On 2013-07-18 PM 5:59, Corinna Vinschen wrote:> On Jul 18 17:11, > jojelino wrote: > >> On 2013-07-18 AM 10:53, Warren Young wrote: > >>> Nothing so simple. Locking is handled at the OS and/or Cygwin DLL > >>> level. The build change between 3.7.16.2 and 3.7.17-

Re: sqlite defect

2013-07-18 Thread jojelino
On 2013-07-18 PM 5:59, Corinna Vinschen wrote:> On Jul 18 17:11, jojelino wrote: >> On 2013-07-18 AM 10:53, Warren Young wrote: >>> Nothing so simple. Locking is handled at the OS and/or Cygwin DLL >>> level. The build change between 3.7.16.2 and 3.7.17-3 is that we're now >>> relying on new f

Re: sqlite defect

2013-07-18 Thread Corinna Vinschen
On Jul 18 17:11, jojelino wrote: > On 2013-07-18 AM 10:53, Warren Young wrote: > >Nothing so simple. Locking is handled at the OS and/or Cygwin DLL > >level. The build change between 3.7.16.2 and 3.7.17-3 is that we're now > >relying on new features in the Cygwin DLL to do Windows-style locking b

Re: sqlite defect

2013-07-18 Thread jojelino
On 2013-07-18 AM 10:53, Warren Young wrote: Nothing so simple. Locking is handled at the OS and/or Cygwin DLL level. The build change between 3.7.16.2 and 3.7.17-3 is that we're now relying on new features in the Cygwin DLL to do Windows-style locking by default. Older versions of Cygwin SQLit

Re: sqlite defect

2013-07-17 Thread Warren Young
On 7/17/2013 17:15, fger...@gmx.de wrote: Von: "Warren Young" try setting the new CYGWIN_SQLITE_LOCKING environment variable to "posix". Why isn't it the default? Because there are more native Windows programs based on SQLite than there are Cygwin programs based on SQLite. Since we canno

Re: sqlite defect

2013-07-12 Thread David Rothenberger
These kinds of questions belong on the main mailing list. Responding there. fger...@gmx.de wrote: > I never had problems with sqlite before. > > But since 3.7.17-3 I cannot read my databases any more > "unable to open datase file". I remember there was a discussion > on the cygwin general mailin