X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:to:from:subject:date:message-id:references
	:mime-version:content-type:content-transfer-encoding; q=dns; s=
	default; b=Ok2FEBWV8WCd1owBR0wFnw0PjJrQ+iDf5+ZzpD5UzX0UHfYH6vk3+
	HXoLbjjPgS2d/u3rl6BRoxPki+5qDhcxUzg1jdQoR3LvT3YI6XUh8RynavXa7CDc
	UQFwDATfIQ2g3Dh9UuEb7oQBFwEEzNkIveoGqkaSsOQKwx0pbY/nGM=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:to:from:subject:date:message-id:references
	:mime-version:content-type:content-transfer-encoding; s=default;
	bh=mIdct15618eIpKpyKnJQ4Tbtt2s=; b=lRdZsz8RMb7Vy3vrv11TJVUOR/+A
	vPpC0m9XLGnMT1AT8RH5QQ00gNuQUz0uS41Coq+hKtVnVe6i0G0PnepHLZtCZ0mm
	rHTIIGE0b9z9HXf7g6Vo6Tn+gLBEwMCjPfyiclfloVcJerC8lWzqZPCc5z2f84SP
	7zGdIxitKZUD7ww=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
X-Spam-SWARE-Status:	No, score=-1.4 required=5.0 tests=AWL,BAYES_00,FSL_HELO_BARE_IP_2,KHOP_THREADED,RCVD_IN_DNSWL_NONE,RCVD_NUMERIC_HELO,RP_MATCHES_RCVD,SPF_HELO_PASS,SPF_PASS autolearn=no version=3.3.1
To:	cygwin AT cygwin DOT com
From:	Achim Gratz <Stromeko AT NexGo DOT DE>
Subject:	Re: sqlite3: bug with monotone
Date:	Fri, 31 May 2013 08:51:23 +0000 (UTC)
Lines:	43
Message-ID:	<loom.20130531T102650-571@post.gmane.org>
References:	<51A6B6EB DOT 6050309 AT users DOT sourceforge DOT net> <loom DOT 20130530T122354-144 AT post DOT gmane DOT org> <51A7862F DOT 1070507 AT etr-usa DOT com> <51A7D47E DOT 3050502 AT users DOT sourceforge DOT net>
Mime-Version:	1.0
User-Agent:	Loom/3.14 (http://gmane.org/)

Yaakov (Cygwin/X <yselkowitz <at> users.sourceforge.net> writes:
> Yes, I can now confirm that (the lack of) SQLITE_OS_UNIX is the culprit.
[...]
> If it's a choice between Cygwin programs functioning correctly (in this 
> case, mtn clone), and allowing interoperability with Windows programs, 
> there is NO QUESTION that the former MUST take priority.  Add a `mount 
> -o mand' feature if you wish (or get someone who cares about this to do 
> so), but DON'T BREAK Cygwin programs for the sake of those NOT USING Cygwin.

We've had this discussion before, please re-read the arguments made there if
you haven't done so already.

I've been running my own sqlite3 package for a while that treats Cygwin as
UNIX, but I don't use TortoiseSVN and other programs that would lead to
concurrent access from the Windows side (or from the Cygwin side, really). 
I do use (not often) temporary tables that are large and should not be held
in memory, so the even if that option was used to fix the temp table issue I
would still rather use my own package.

> Please fix sqlite3 accordingly.

I've looked into this situation a few times (and Warren has been doing that
more than just once, too).  Things aren't as clear cut as you seem to
believe.  For starters, upstream doesn't seem to give much thought about
Cygwin at all.  I've tried to find where to fix things and the situation is
that the test suite doesn't run at all when sqlite3 is compiled like
upstream wants (i.e. SQLITE_OS_WIN) and fails quite a few of its own
concurrency tests when compiled with SQLITE_OS_UNIX.  A few of these test
fails are simply of the sort that you are seeing with monotone (DB access
fails), but some of them look like database corruptions.  A "fixed" sqlite3
should not fail its own test suite I suppose.

I haven't had time yet to build sqlite3 and run the tests on a UNIX box to
get a baseline from which to work.  But whichever way you compile sqlite3 on
Cygwin, you can either not test it at all or you produce test failures, so
you can only chose which way to break it.  I agree that it would be a good
thing to fix this, but it takes a bit more work than just using a different
switch.


Regards,
Achim.



--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple

- Raw text -