Forum: Too Lazy BBS

[Info-ingres] Error from auditdb

From Martin Bowes@martin.bowes@ndph.ox.ac.uk to info-ingres@lists.planetingres.org on Wed May 5 08:39:02 2021

From Newsgroup: comp.databases.ingres

--_000_517bc3e3cd814863b31d454a52d862c9ndphoxacuk_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-WatchGuard-AntiVirus: part scanned. clean action=allow

Hi All,

So I needed to run auditdb on a database...

Wed May 5 09:36:30 2021 E_DM1206_ATP_TOO_MANY_TX Too many simultaneous t= ransactions.
...
Lots and lots of these, and no transaction details whatsoever.

Never seen that one before!

I tried to restrict it to a specific table of interest, but got the same re= sult.

Ideas?

Marty

--_000_517bc3e3cd814863b31d454a52d862c9ndphoxacuk_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-WatchGuard-AntiVirus: part scanned. clean action=allow

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:= //www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=

<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style>
</head>
<body lang=3D"EN-GB" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
Hi All,<o:p></o:p>=

<o:p> </o:p><=

So I needed to run auditd=
b on a database…<o:p></o:p>
<o:p> </o:p><=

Wed May  5 09:36:30 = 2021 E_DM1206_ATP_TOO_MANY_TX   Too many simultaneous transaction= s.<o:p></o:p>
…<o:p></o:p>
Lots and lots of these, and no transaction details w= hatsoever.<o:p></o:p>
<o:p> </o:p>
Never seen that one before!<o:p></o:p>
<o:p> </o:p>
I tried to restrict it to a specific table of intere= st, but got the same result.<o:p></o:p>
<o:p> </o:p>
Ideas?<o:p></o:p>
<o:p> </o:p>
Marty<o:p></o:p>
<o:p> </o:p>
</div>
</body>
</html>

--_000_517bc3e3cd814863b31d454a52d862c9ndphoxacuk_--
--- Synchronet 3.21b-Linux NewsLink 1.2

From Martin Bowes@martin.bowes@ndph.ox.ac.uk to info-ingres@lists.planetingres.org on Wed May 5 09:06:57 2021

From Newsgroup: comp.databases.ingres

--_000_d39f95b7a3cf43e5a5feed6d1a112605ndphoxacuk_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-WatchGuard-AntiVirus: part scanned. clean action=allow

Hi All,

Some very narrow -b and -e restrictions managed to crack the nut.

Marty

From: Martin Bowes
Sent: 05 May 2021 09:39
To: info-ingres@lists.planetingres.org
Subject: Error from auditdb

Hi All,

So I needed to run auditdb on a database...

Wed May 5 09:36:30 2021 E_DM1206_ATP_TOO_MANY_TX Too many simultaneous t= ransactions.
...
Lots and lots of these, and no transaction details whatsoever.

Never seen that one before!

I tried to restrict it to a specific table of interest, but got the same re= sult.

Ideas?

Marty

--_000_d39f95b7a3cf43e5a5feed6d1a112605ndphoxacuk_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-WatchGuard-AntiVirus: part scanned. clean action=allow

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr= osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:= //www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=

<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"> <style>
</head>
<body lang=3D"EN-GB" link=3D"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
Hi All,<o:p></o:p></sp= an>
<o:p> </o:p></spa= n>
Some very narrow &#821= 1;b and –e restrictions managed to crack the nut.<o:p></o:p></=

<o:p> </o:p></spa= n>
Marty<o:p></o:p></span= >
<o:p> </o:p></spa= n>
<div>
<div style=3D"border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm = 0cm 0cm">
From: Martin Bowes

Sent: 05 May 2021 09:39 
To: info-ingres@lists.planetingres.org 
Subject: Error from auditdb<o:p></o:p>
</div>
</div>
<o:p> </o:p>
Hi All,<o:p></o:p>=

<o:p> </o:p><=

So I needed to run auditd=
b on a database…<o:p></o:p>
<o:p> </o:p><=

Wed May  5 09:36:30 = 2021 E_DM1206_ATP_TOO_MANY_TX   Too many simultaneous transaction= s.<o:p></o:p>
…<o:p></o:p>
Lots and lots of these, and no transaction details w= hatsoever.<o:p></o:p>
<o:p> </o:p>
Never seen that one before!<o:p></o:p>
<o:p> </o:p>
I tried to restrict it to a specific table of intere= st, but got the same result.<o:p></o:p>
<o:p> </o:p>
Ideas?<o:p></o:p>
<o:p> </o:p>
Marty<o:p></o:p>
<o:p> </o:p>
</div>
</body>
</html>

--_000_d39f95b7a3cf43e5a5feed6d1a112605ndphoxacuk_--
--- Synchronet 3.21b-Linux NewsLink 1.2

From Roy Hann@specially@processed.almost.meat to comp.databases.ingres on Wed May 5 09:44:49 2021

From Newsgroup: comp.databases.ingres

Paul White wrote:

it is a new feature.a 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
--- Synchronet 3.21b-Linux NewsLink 1.2

From Martin Bowes@martin.bowes@ndph.ox.ac.uk to Roy Hann (roy.hann@rationalcommerce.com) on Wed May 5 10:00:36 2021

From Newsgroup: comp.databases.ingres

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.a 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
--- Synchronet 3.21b-Linux NewsLink 1.2

Who's Online
Recent Visitors
- Geek2
  Tue Mar 3 10:26:12 2026
  from Euclid, Oh via Telnet
- Geek2
  Mon Mar 2 11:22:09 2026
  from Euclid, Oh via Telnet
- Geek2
  Mon Mar 2 07:52:57 2026
  from Euclid, Oh via Telnet
- Geek2
  Sun Mar 1 19:00:04 2026
  from Euclid, Oh via Telnet

System Info

Sysop:	Amessyroom
Location:	Fayetteville, NC
Users:	59
Nodes:	6 (0 / 6)
Uptime:	18:02:52
Calls:	810
Calls today:	1
Files:	1,287
D/L today:	10 files (21,017K bytes)
Messages:	193,396

[Info-ingres] Error from auditdb

Who's Online

Recent Visitors

System Info