RetroBBS - comp.databases.ingres - Re: [Info-ingres] x100 transaction

Re: [Info-ingres] x100 transaction

<mailman.26.1620397541.1681.info-ingres@lists.planetingres.org>

https://www.rocksolidbbs.com/devel/article-flat.php?id=80&group=comp.databases.ingres#80

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!aioe.org!feeder1.feed.usenet.farm!feed.usenet.farm!tr3.eu1.usenetexpress.com!feeder.usenetexpress.com!tr1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 07 May 2021 09:26:03 -0500
Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.6\))
From: schendel@kbcomputer.com (Karl Schendel)
In-Reply-To: <3d80aac9cb7e47b3ab7938d663951fa0@ndph.ox.ac.uk>
Date: Fri, 7 May 2021 10:25:38 -0400
Content-Transfer-Encoding: quoted-printable
References: <3d80aac9cb7e47b3ab7938d663951fa0@ndph.ox.ac.uk>
To: Martin Bowes <martin.bowes@ndph.ox.ac.uk>
Cc: "info-ingres@lists.planetingres.org" <info-ingres@lists.planetingres.org>
Subject: Re: [Info-ingres] x100 transaction
Precedence: list
Newsgroups: comp.databases.ingres
Message-ID: <mailman.26.1620397541.1681.info-ingres@lists.planetingres.org>
Lines: 39

by: Karl Schendel - Fri, 7 May 2021 14:25 UTC

> On May 7, 2021, at 6:43 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:
>
> Hi All,
>
> On an x100 enabled database I did:
>
> drop table if exists base;
> create table base(…) with structure = x100;
>
> The base table does not exist, I only added the drop command in case I need to rerun this creation script.
>
> So I was somewhat surprised to be confronted with error:
> E_US250E X100 statements are not allowed in this transaction.
> Create or access an X100 table at the start of a new transaction
> to enable X100 statement processing.
>

You can put a commit after the drop if exists.

What's going on is that the delay_txn_start config parameter is probably set to ON.
That tells the DBMS server to not bother starting an X100 transaction when an
Ingres transaction starts, unless something x100-y is being done. The initial drop
table doesn't force an x100 transaction start because there's no x100 work to do.
The create table does an explicit check to see if it's in an Ingres transaction but
no x100 transaction and throws that error. Once X100 tables exist, the check is
a little different and you don't get the error.

Karl

Anything cut to length will be too short.

devel / comp.databases.ingres / Re: [Info-ingres] x100 transaction

Subject	Author
Re: [Info-ingres] x100 transaction	Karl Schendel