RE: SQLERROR -346 ISAM -121

Posted in 2000

Watson, Paul — Thu, 24 Aug 2000 12:15:44 +0100 — source: Informix-list mailing list archive (1991-1998)

Is the logfile full? Paul Watson WF Software Ltd Tel: +44 1436 674729 Fax: +44 1436 678693 www.wfsoftware.com/informix > -----Original Message----- > From: Dirk Niemeier [mailto:dirk.niemeier@stueken.de] > Sent: Monday, August 21, 2000 12:31 > To: informix-list@iiug.org > Subject: Re: SQLERROR -346 ISAM -121 > > > Add on : > > In some cases the current locks at the entries that where > changed are away > without any errormessages. It's shown by other users who are > waiting for the > records get it at unended transaction. > > > Dirk Niemeier schrieb: > > > Hi, > > I get the error SQLERROR -346, ISAM -121 (cannot write log > record) after > > a few updates and a few tables on SE-Database with transactions. I > > checked the disk but it's not full. Is there perhaps an > other reason to > > get this error ? Maybe to many locks ? > > > > TIA > > Dirk >

↪ replying to Watson, Paul

Dirk Niemeier — Thu, 24 Aug 2000 13:56:32 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi Paul, "Watson, Paul" schrieb: > Is the logfile full? We are using Informix-SE database and I only know about the transaction-logfile. This is only full if the disk is full. And there are enough space left. Dirk > > Paul Watson > WF Software Ltd > Tel: +44 1436 674729 > Fax: +44 1436 678693 > www.wfsoftware.com/informix > > > -----Original Message----- > > From: Dirk Niemeier [mailto:dirk.niemeier@stueken.de] > > Sent: Monday, August 21, 2000 12:31 > > To: informix-list@iiug.org > > Subject: Re: SQLERROR -346 ISAM -121 > > > > > > Add on : > > > > In some cases the current locks at the entries that where > > changed are away > > without any errormessages. It's shown by other users who are > > waiting for the > > records get it at unended transaction. > > > > > > Dirk Niemeier schrieb: > > > > > Hi, > > > I get the error SQLERROR -346, ISAM -121 (cannot write log > > record) after > > > a few updates and a few tables on SE-Database with transactions. I > > > checked the disk but it's not full. Is there perhaps an > > other reason to > > > get this error ? Maybe to many locks ? > > > > > > TIA > > > Dirk > >

↪ replying to Dirk Niemeier

Art S. Kagel — Thu, 24 Aug 2000 08:55:42 -0400 — source: Informix-list mailing list archive (1991-1998)

Dirk Niemeier wrote: > > Hi Paul, > > "Watson, Paul" schrieb: > > > Is the logfile full? > > We are using Informix-SE database and I only know about the > transaction-logfile. This is only full if the disk is full. Or if the transaction-logile reaches the hard or soft ulimit or the hard filesize limit of the OS.... Art S. Kagel > And there are > enough space left. > > Dirk > > > > > Paul Watson > > WF Software Ltd > > Tel: +44 1436 674729 > > Fax: +44 1436 678693 > > www.wfsoftware.com/informix > > > > > -----Original Message----- > > > From: Dirk Niemeier [mailto:dirk.niemeier@stueken.de] > > > Sent: Monday, August 21, 2000 12:31 > > > To: informix-list@iiug.org > > > Subject: Re: SQLERROR -346 ISAM -121 > > > > > > > > > Add on : > > > > > > In some cases the current locks at the entries that where > > > changed are away > > > without any errormessages. It's shown by other users who are > > > waiting for the > > > records get it at unended transaction. > > > > > > > > > Dirk Niemeier schrieb: > > > > > > > Hi, > > > > I get the error SQLERROR -346, ISAM -121 (cannot write log > > > record) after > > > > a few updates and a few tables on SE-Database with transactions. I > > > > checked the disk but it's not full. Is there perhaps an > > > other reason to > > > > get this error ? Maybe to many locks ? > > > > > > > > TIA > > > > Dirk > > >