novaBBS - comp.databases.ingres - Re: [Info-ingres] Error from auditdb

Re: [Info-ingres] Error from auditdb

<s6tpeh$dvt$1@gioia.aioe.org>

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

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!aioe.org!CxO6h/Ihb67nLVrRkGjZ3g.user.gioia.aioe.org.POSTED!not-for-mail
From: specia...@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: [Info-ingres] Error from auditdb
Date: Wed, 5 May 2021 09:44:49 +0000 (UTC)
Organization: Aioe.org NNTP Server
Lines: 19
Message-ID: <s6tpeh$dvt$1@gioia.aioe.org>
References: <517bc3e3cd814863b31d454a52d862c9@ndph.ox.ac.uk> <mailman.12.1620206228.1681.info-ingres@lists.planetingres.org>
NNTP-Posting-Host: CxO6h/Ihb67nLVrRkGjZ3g.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2

by: Roy Hann - Wed, 5 May 2021 09:44 UTC

Paul White wrote:

> it is a new feature. I generated the situation accidentally by messing
> with journals involved DR syncronisation to another server.
>
> Level 2 support mentioned there is a hard coded maximum number of open
> transactions.

Did they mention what the limit is?

It sounds odd since there really can't be many more simultaneous
transactions than sessions (even including internal sessions). In the
21st century surely we'd have to be talking absolutely bazillions to
be 'too many'.

Or does the word "simultaneous" have special and surprising meaning in
this context...?

Roy

Re: [Info-ingres] Error from auditdb

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

copy mid

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

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!paganini.bofh.team!news.dns-netz.com!news.freedyn.net!newsfeed.xs4all.nl!newsfeed8.news.xs4all.nl!tr1.eu1.usenetexpress.com!feeder.usenetexpress.com!tr3.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: Wed, 05 May 2021 05:02:03 -0500
Return-Path: <martin.bowes@ndph.ox.ac.uk>
X-Original-To: info-ingres@lists.planetingres.org
Delivered-To: info-ingres@mort.croker.net
From: martin.b...@ndph.ox.ac.uk (Martin Bowes)
To: "Roy Hann (roy.hann@rationalcommerce.com)" <roy.hann@rationalcommerce.com>, "info-ingres@lists.planetingres.org" <info-ingres@lists.planetingres.org>
Date: Wed, 5 May 2021 10:00:36 +0000
References: <517bc3e3cd814863b31d454a52d862c9@ndph.ox.ac.uk> <mailman.12.1620206228.1681.info-ingres@lists.planetingres.org> <s6tpeh$dvt$1@gioia.aioe.org>
In-Reply-To: <s6tpeh$dvt$1@gioia.aioe.org>
Content-Language: en-US
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-WatchGuard-AntiVirus: part scanned. clean action=allow
Subject: Re: [Info-ingres] Error from auditdb
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>, <mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.13.1620208895.1681.info-ingres@lists.planetingres.org>
Lines: 39
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-DHZmpC2WbBgSXrJD6ogBLeOA3ElEm/Wg2fOrzHn0Wuj+ZmiNPFjPHhmvZH+e85VGpGKUDkGMtzR6ciy!nw+rUOcqyotDW1idHgbBsGwTVBMF/8P9l4jZ0EN3VxJ4ZG9qcVrGC/YaZZVd9MySYB6T1rJbBKvY!6tT6nrs2H44glxZeR1g7Fw==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 3654

by: Martin Bowes - Wed, 5 May 2021 10:00 UTC

Those messages all ended up in my errlog as well.

This is a web server so I suspect there are lots of little transactions going on. Nonetheless, given a 254 inbound connection limit and a tx_limit of 2379, I'm hard pressed to see how that could possibly generate a shit storm of transactions at any instant.

I too would be interested to hear what the transaction limit was!

Marty

-----Original Message-----
From: Roy Hann <specially@processed.almost.meat>
Sent: 05 May 2021 10:45
To: info-ingres@lists.planetingres.org
Subject: Re: [Info-ingres] Error from auditdb

Paul White wrote:

> it is a new feature. I generated the situation accidentally by
> messing with journals involved DR syncronisation to another server.
>
> Level 2 support mentioned there is a hard coded maximum number of open
> transactions.

Did they mention what the limit is?

It sounds odd since there really can't be many more simultaneous transactions than sessions (even including internal sessions). In the 21st century surely we'd have to be talking absolutely bazillions to be 'too many'.

Or does the word "simultaneous" have special and surprising meaning in this context...?

Roy
_______________________________________________
Info-ingres mailing list
Info-ingres@lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres

I am the wandering glitch -- catch me if you can.

devel / comp.databases.ingres / Re: [Info-ingres] Error from auditdb

devel / comp.databases.ingres / Re: [Info-ingres] Error from auditdb

Subject	Author
Re: [Info-ingres] Error from auditdb	Roy Hann
Re: [Info-ingres] Error from auditdb	Martin Bowes