From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 2483 invoked by alias); 15 Mar 2012 21:14:06 -0000 Received: (qmail 2475 invoked by uid 22791); 15 Mar 2012 21:14:05 -0000 X-SWARE-Spam-Status: No, hits=-1.9 required=5.0 tests=AWL,BAYES_00,SPF_HELO_PASS,TW_LQ,T_RP_MATCHES_RCVD X-Spam-Check-By: sourceware.org Received: from plane.gmane.org (HELO plane.gmane.org) (80.91.229.3) by sourceware.org (qpsmtpd/0.43rc1) with ESMTP; Thu, 15 Mar 2012 21:13:50 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1S8HzX-0002bc-RT for cygwin@cygwin.com; Thu, 15 Mar 2012 22:13:47 +0100 Received: from pd9eb45b1.dip.t-dialin.net ([217.235.69.177]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 15 Mar 2012 22:13:47 +0100 Received: from Stromeko by pd9eb45b1.dip.t-dialin.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 15 Mar 2012 22:13:47 +0100 To: cygwin@cygwin.com From: Achim Gratz Subject: Re: [bug] Something fishy going on with sqlite3... Date: Thu, 15 Mar 2012 21:14:00 -0000 Message-ID: <871uotd0ub.fsf@Rainer.invalid> References: <87aa3hd4a5.fsf@Rainer.invalid> <8762e5d3le.fsf@Rainer.invalid> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.0.94 (gnu/linux) X-IsSubscribed: yes Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com X-SW-Source: 2012-03/txt/msg00464.txt.bz2 René Berber writes: > Right. Problem is I can't reproduce the error. I don't have any better information at the moment. > I'm not using a snapshot, I'm at "1.7.11(0.260/5/3) 2012-02-24", and the > operation you show, using mintty: I've switched to snapshots due to other problems (no Ctrl-C in console) and have just been updating them whenever a new one came out. I can't say for sure it has to do with the snapshot, but since you can't reproduce it I might have to revert the installation to the release version and try again. > $ sqlite3 test I doubt it makes any difference, but I didn't give any file name when invoking SQLite. [...]> SQLite version 3.7.3 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> > seq name file > --- --------------- --------------------------------------- > 0 main C:\Cygwin\home\rberber\test > 1 temp If the temp table is really not associated with a file, then this test didn't trigger the bug most likely. In my test case the temporary file supposedly should be named etilqs-. > sqlite> .schema two > CREATE TABLE two ( > id INTEGER NOT NULL, > name CHAR (64) NOT NULL > ); > > No access denied. The file test is created in the same directory, also > .sqlite_history . In case it wasn't clear in my first posting, I can create a new table (not marked TEMPORARY) just fine. Before or after getting the "access denied" error I can create "real" tables as much as I want, it is only the temporary ones that give trouble and only when they are set to go to files, not memory. I didn't see anything that jumped out on me in the strace. Regards, Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ SD adaptation for Waldorf microQ V2.22R2: http://Synth.Stromeko.net/Downloads.html#WaldorfSDada -- 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