Re: Data integrity problem with sqlite3

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!border1.nntp.ams1.giganews.com!nntp.giganews.com!newsfeed.xs4all.nl!newsfeed8.news.xs4all.nl!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<rosuav@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.027
X-Spam-Evidence	'H': 0.95; 'S': 0.00; 'postgresql': 0.07; 'subject:sqlite3': 0.07; 'cc:addr:python-list': 0.09; 'grep': 0.09; 'postgresql,': 0.09; 'server,': 0.15; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'inaccessible': 0.16; 'logging,': 0.16; 'rather,': 0.16; 'sqlite3': 0.16; 'wrote:': 0.16; '2015': 0.20; 'cc:2**0': 0.20; 'cc:addr:python.org': 0.20; 'aug': 0.20; 'subject:problem': 0.22; 'insert': 0.23; 'header:In- Reply-To:1': 0.24; "doesn't": 0.26; 'message-id:@mail.gmail.com': 0.27; 'btw,': 0.29; 'transaction': 0.30; "can't": 0.32; 'statement': 0.32; 'tue,': 0.34; 'info': 0.34; 'received:google.com': 0.35; 'machines': 0.35; 'expected': 0.35; 'but': 0.36; 'others.': 0.36; 'pm,': 0.36; 'subject:: ': 0.37; 'anything': 0.38; 'sure': 0.39; 'does': 0.39; 'enough': 0.39; 'subject:with': 0.40; 'back': 0.62; 'hints': 0.66; 'subject:Data': 0.66; 'offer': 0.66; '8bit%:21': 0.70; 'frank': 0.72; '\xe2\x80\x93': 0.72; 'around,': 0.84; 'chrisa': 0.84; 'to:none': 0.91; 'thing,': 0.93
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc :content-type:content-transfer-encoding; bh=FrAKFwc5XsxrYdqkUOpL64GuNI5/z9UAhlqAavKQiHo=; b=iYD69ZXJ4uJOMFBh3hY7QHK75weF0SDkFnN15YSqhOZ+RgX3Yau9ArBGrp1f3jiwcx 88sttHnSrUCVbF/NTuHwTwDirurMri2eTyMwRda3jFHkCGYF8UuAiRNk0skzVxJGXnOD ZIyQx1ujR0R0ctf5kW9W6AANknqXdeDBr4xAfx/brYLJfCJW43p1wNWwptBAIqqkavD9 TXXujOL/s7Ji9C9P7oE4FbKRXeUzUy3qAF3rbF+zTTidWWv/D7WyQEZvasXZzPITcpoQ FJYyhIvAMhGTIEggimxhJHjzGBMmI85ZWkco0D26jkIx3JL80QTDOaWMcbnH8DomZ/kI J7Aw==
MIME-Version	1.0
X-Received	by 10.107.31.134 with SMTP id f128mr25340031iof.19.1439297046114; Tue, 11 Aug 2015 05:44:06 -0700 (PDT)
In-Reply-To	<mqcqav$m0b$1@ger.gmane.org>
References	<mqcmie$po9$1@ger.gmane.org> <CAPTjJmrHmj2bsdSm4CQ=oRGxuTmycTk3W3e3n-QXoLg2TVQMbA@mail.gmail.com> <mqcqav$m0b$1@ger.gmane.org>
Date	Tue, 11 Aug 2015 22:44:06 +1000
Subject	Re: Data integrity problem with sqlite3
From	Chris Angelico <rosuav@gmail.com>
Cc	"python-list@python.org" <python-list@python.org>
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	quoted-printable
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.20+
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.81.1439297048.3627.python-list@python.org> (permalink)
Lines	22
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1439297048 news.xs4all.nl 2887 [2001:888:2000:d::a6]:57822
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:95259

Show key headers only | View raw

On Tue, Aug 11, 2015 at 10:37 PM, Frank Millman <frank@chagford.com> wrote:
> My PostgreSQL is inaccessible at the moment as I am moving machines around,
> but I have tested it with MS SQL Server, and it behaves as expected – the
> transaction is fully rolled back and nothing is committed to the database.

Does MS SQL offer any hints in its logs? Can you enable full statement
logging, and then grep it for anything that doesn't begin INSERT or
UPDATE or SELECT?

> BTW, I am not using sqlite3 ‘in production’. Rather, I offer a choice of 3
> databases to my users – PostgreSQL, SQL Server, and sqlite3, so I have to
> make sure that my program works with all of them.

Ah. Comes to the same thing, anyway; if you can't get enough info out
of one backend, verify it with the others.

ChrisA

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Data integrity problem with sqlite3 Chris Angelico <rosuav@gmail.com> - 2015-08-11 22:44 +1000

csiph-web