IDS Forum

RE: 12204:RSAM error:Long transaction detected

Posted By: Gregory S. Williamson
Date: Wednesday, 19 October 2005, at 8:35 a.m.

In Response To: 12204:RSAM error:Long transaction detected (YUNUS RAZA)

Yunus,

I can't say much without more information, but a couple of points: adding space to rootdbs is almost always undesirable -- that space want to be "lean and mean" since it can be very active and shouldn't have much in it (at least on 9.x series -- I don't have any experience with 10.). But that wouldn't be causing your problem directly. But 2 gigs in a root db space seems odd.

A long transaction happens when you don't have enough active log space and Informix detects a situation in which it can't do more processing of a transaction because it would then not have enough log space to allow for a proper roll back (since roll backs take log space as well). The oldest transaction that is still not committed determines the log which can't be reused. Making sure that all transactions are promptly commited might help ...

Try posting details of "onstat -l" (to show log spaces) and some details about your Informix instance -- in particular the config variables relating to logs and high water marks on logs.

With recent versions of Informix (well, recent in the 9.x series anyway) you can add logs dynamically as long as you have disk space, which is a tremendous thing to be able to do compared to the gotcha that older Informix systems would face in this.

You might also post some details on what you are trying to do -- on the surface you should have enough space allocated for quite significant tasks. It is possible that you could take advantage of non-logged space for your work ...

HTH,

Greg Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From: forum.subscriber@iiug.org on behalf of YUNUS RAZA
Sent: Wed 10/19/2005 4:12 AM
To: ids@iiug.org
Cc:
Subject: 12204:RSAM error:Long transaction detected [5851]
Hi,

I have installed IDS 10 on Sun Sparc server with Solaris 9. Installation went fine and now when i am creating databases after some time i am getting this error :

"458:Long transaction aborted:
12204:RSAM error:Long transaction detected"

I could make out that this is space problem. so i did the following. I added one more chunk to the "rootdbs" of more size, then i could create databases and populate it with data, but after server restart the second chunk is disappearing, even after adding that info for second chunk in the ONCONFIG file is not helping.

I have the following space allocation:
rootdbs- 2GB
logdbs- 1 GB
physdsb-1 GB
sbspace-2 MB
tempdbs-500 MB.

Please help.

Yunus


!DSPAM:4356336e19581488961653!

Messages In This Thread

• 12204:RSAM error:Long transaction detected
  YUNUS RAZA -- Wednesday, 19 October 2005, at 7:12 a.m.
  • RE: 12204:RSAM error:Long transaction detected
    Gregory S. Williamson -- Wednesday, 19 October 2005, at 8:35 a.m.
  • RE: 12204:RSAM error:Long transaction detected
    Gregory S. Williamson -- Wednesday, 19 October 2005, at 9:16 a.m.
  • AW: 12204:RSAM error:Long transaction detected
    Andreas.KUTSCHE@spar.at -- Wednesday, 19 October 2005, at 10:00 a.m.
    • Re: AW: 12204:RSAM error:Long transaction detected
      YUNUS RAZA -- Friday, 21 October 2005, at 6:17 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.