concurrency problems
These errors are probably associated with trying to access rows that are
locked by another user.
When you create tables with OnLine, the default is to use page level locking
(page size is typcially 2K bytes). To get row level locking you must
explicitly specify in your CREATE TABLE statement. If you are using page
level locking for the tables associated with these errors, you can use the
ALTER TABLE statement to change them to row level locking which should
reduce or eliminate concurrency problems.
Scott Myers - Informix (uunet!infmx!scottm)
> -------------------------------------------------------------------------
> >From uunet!rmy.emory.edu!ilist Wed Sep 25 06:25:49 1991
> Received: from informix.com (infmx) by washington. (4.0/SMI-4.0)
> id AA19838; Wed, 25 Sep 91 06:25:45 EDT
> Received: from uunet.UUCP by informix.com (4.1/SMI-4.1)
> id AA27378; Wed, 25 Sep 91 03:25:27 PDT
> Received: from rmy.rmy.emory.edu by relay2.UU.NET with SMTP
> (5.61/UUNET-internet-primary) id AA28223; Wed, 25 Sep 91 06:21:08 -0400
> Received: by
> rmy.rmy.emory.edu (5.65/Emory_rmy.3.2.6) via MAILPROG
> id AA03890 ; Wed, 25 Sep 91 06:21:04 -0400
> Received: from emory.mathcs.emory.edu by
> rmy.rmy.emory.edu (5.65/Emory_rmy.3.2.6) via SMTP
> id AA02235 ; Tue, 24 Sep 91 19:28:39 -0400
> Received: by
> emory.mathcs.emory.edu (5.65/Emory_mathcs.3.2.10) via MAILPROG
> id AA21280 ; Tue, 24 Sep 91 19:28:36 -0400
> Return-Path: walt@mathcs.emory.edu
> Date: Tue, 24 Sep 91 19:28:36 -0400
> From: uunet!mathcs.emory.edu!walt (Walt Hultgren {rmy})
> Message-Id: <9109242328.AA21280@emory.mathcs.emory.edu>
> To: informix-news-gate@rmy
> Subject: Errors -245 and -346, Informix On-Line 4.1, HPUX 7.0
> X-Informix-List-Id: <newsgate.271>
> Status: R
>
> Path: emory!sol.ctr.columbia.edu!caen!sdd.hp.com!elroy.jpl.nasa.gov!ucla-cs!ucla-mic!agsm!ggordon
> From: ggordon@agsm.ucla.edu (Glen Gordon)
> Newsgroups: comp.databases,comp.sys.hp,comp.databases.informix
> Keywords: Run-time errors, Informix On-Line 4.1, HPUX 7.0, HP900/S855
> Message-ID: <ggordon.685715811@uclagsm>
> Date: 24 Sep 91 12:46:45 GMT
> Nntp-Posting-Host: risc.agsm.ucla.edu
>
> We just upgraded our HP900S855, HPUX 7.0, from Informix 2.11 (Standard Engine)
> to On-line 4.1 0 UC1. We are using, ESQLC, I4GL and ISQL.
>
> For the most part, all is fine. However, periodically, application programs
> which worked flawlessly under 2.11, receive one of two errors from the
> On-Line engine:
> -245 or -346. Unfortunately, these are very cryptic errors and
> appear on a random basis. When the programs are rerun with the
> identical queries, all works fine.
>
> Some additional information:
> On-Line is configured for 64 users . Forced residency is set to "Y".
> Tbcheck reports no errors.
> There are 2 page cleaners. No messages appear in turbo.log to
> accompany these errors.
> As many as 40 people may be doing concurrent selects and updates on the same
> group of tables.
>
> The text of the error messages is as follows:
>
> -245 Could not position within a file via an index.
>
> The database engine encountered an error looking up a row through
> an index. Check the accompanying ISAM error code for more
> information. The table file or the index file may have been corrupted.
> Unless the ISAM error code or an operating system message points
> to another cause, run the bcheck utility to verify file integrity.
>
> -346 Could not update a row in the table.
>
> While processing an UPDATE, the database engine received an
> unexpected error. Check the accompanying ISAM error code for
> more detailed information on the cause. Possible causes include
> hardware errors and locking conflicts.
>
> Any ideas would be most appreciated. Since I am desperate to solve
> this ASAP, mail is preferred. I will summarize for the list.
>
> --
> Glen Gordon | Internet: ggordon@agsm.ucla.edu
> Computing Services | Bitnet : ggordon@uclagsm.bitnet
> Anderson Graduate School of Management | AT&Tnet : (213) 206-6590
> University of California, Los Angeles | Fax : (213) 206-2002
>