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

Re: [Info-ingres] x100 transaction

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

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

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!news.neodome.net!feeder1.feed.usenet.farm!feed.usenet.farm!tr2.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: Tue, 11 May 2021 05:12:03 -0500
From: martin.b...@ndph.ox.ac.uk (Martin Bowes)
To: Karl Schendel <schendel@kbcomputer.com>
Date: Tue, 11 May 2021 10:09:43 +0000
References: <3d80aac9cb7e47b3ab7938d663951fa0@ndph.ox.ac.uk> <15D3C0FD-54C2-4A8A-8591-AE35EB34CD01@kbcomputer.com>
In-Reply-To: <15D3C0FD-54C2-4A8A-8591-AE35EB34CD01@kbcomputer.com>
Content-Language: en-US
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
MIME-Version: 1.0
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.27.1620727835.1681.info-ingres@lists.planetingres.org>
Lines: 22

by: Martin Bowes - Tue, 11 May 2021 10:09 UTC

Hi Karl,
> What's going on is that the delay_txn_start config parameter is probably set to ON.
Yes.
> 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.
Seems fair.
> Once X100 tables exist, the check is a little different and you don't get the error.
Whoa! An initialisation condition.
So starting with an empty database...
The drop table if exists / create table with structure = x100 fails as before.
However, if we ensure we have at least one existing x100 table first...:
create table dummy(id integer4 not null not default) with structure = x100;
commit;
drop table if exists base;
create table base(id integer4 not null not default) with structure = x100;
commit;
That now works as expected.
Marty
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

Brain off-line, please wait.

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

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

Subject	Author
Re: [Info-ingres] x100 transaction	Martin Bowes