IDS Forum

RE: Error message 243 - need help"Could not po....

Posted By: Olson, Kenneth \(GE Cons Fin\)
Date: Tuesday, 6 June 2006, at 2:25 p.m.

In Response To: RE: Error message 243 - need help"Could not po.... (Walter Milan)

You are updating sequentially on a table. Someone has a lock on a row you are about to update. This would/could cause this message.

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
Walter Milan
Sent: Tuesday, June 06, 2006 11:04 AM
To: ids@iiug.org
Subject: RE: Error message 243 - need help"Could not po.... [6893]

Have you set Lock mode ?

You could use Lock mode to wait <Seconds> to avoid contention in those
cases.
No, is not going to wait 10 seconds after the it fails the first time,
that is the max time it will be retrying before giving up and return
that error.

Hospitably yours,

Walter Milan
DBA

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Marcus Haarmann
Sent: Tuesday, June 06, 2006 2:03 AM
To: ids@iiug.org
Subject: RE: Error message 243 - need help"Could not po.... [6886]

Hi,

My understanding of this error is that the index is locked or damaged.
Use
oncheck -cI to see if all the indices are stable.
Our mechanism to prevent this is as follows:
If the error occurs while reading data, you can easily prevent it by
using
"set isolation to dirty read".
For inserts and updates, use "set lock mode to wait".
This will give you the best performance for reading (but keep in mind
that
you will read uncommitted data) and no such errors on writing (but you
might
have lock waits, depending on your transaction length).
All this might not be sufficient in case any index is damaged, so check
this
first. There will probably an error in your online.log.

Marcus

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Murray
Wood....
Sent: Tuesday, June 06, 2006 5:51 AM
To: ids@iiug.org
Subject: RE: Error message 243 - need help"Could not po.... [6883]

OK. Do an explain on the SQL (set explain on) to confirm that it is
reading
by the primary key.

Which version of Informix and which OS?

What is the ISAM error code - does it point to anything different?

MW

_____

From: DD MISHRA [mailto:mishra.dd@gmail.com]
Sent: Tuesday, 6 June 2006 3:48 p.m.
To: ids@iiug.org; ifxmaillist@quanta.co.nz
Subject: Re: Error message 243 - need help"Could not po.... [6881]

Hi

Thanks for your reply

but i am reading the table through a part of primary key.

will it be still reading the whole table for it.

Regards

On 6/6/06, Murray Wood.... <ifxmaillist@quanta.co.nz> wrote:

The SQL that is the victim of the error is not reading 1 row in the
table -
there is not an index for it - but probably reading all the table. Add
the
correct index or update statistics.

MW

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org
<mailto:ids-bounces@iiug.org> ] On Behalf Of DD MISHRA
Sent: Tuesday, 6 June 2006 3:18 p.m.
To: ids@iiug.org
Subject: Error message 243 - need help"Could not positi.... [6880]

Hi

I am getting the error 243 during my updating to database tables.
The prblem is i have some parallel programs running updating different
rows
of the same table.
my program logic ensures that they will never update the same row. and
the
locking mode is row.

So i am still not able to understand how come i am getting this error
time
and again.

Please let me know if there might other reasons for this error to
appear.

Regards
Debadatta

************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.

************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.

************************************************************************
****
***
Forum Note: Use "Reply" to post a response in the discussion forum.

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Error message 243 - need help"Could not position w
  DD MISHRA -- Monday, 5 June 2006, at 11:18 p.m.
  • RE: Error message 243 - need help"Could not positi
    Murray Wood \(IList\) \(Murray Wood \(IList\)\) -- Monday, 5 June 2006, at 11:27 p.m.
    • Re: Error message 243 - need help"Could not po....
      DD MISHRA -- Monday, 5 June 2006, at 11:44 p.m.
      • Re: Error message 243 - need help"Could not po....
        DD MISHRA -- Tuesday, 6 June 2006, at 10:10 p.m.
    • RE: Error message 243 - need help"Could not po....
      Murray Wood \(IList\) \(Murray Wood \(IList\)\) -- Monday, 5 June 2006, at 11:51 p.m.
      • Re: Error message 243 - need help"Could not po....
        DD MISHRA -- Tuesday, 6 June 2006, at 12:15 a.m.
      • RE: Error message 243 - need help"Could not po....
        Marcus Haarmann -- Tuesday, 6 June 2006, at 3:02 a.m.
        • RE: Error message 243 - need help"Could not po....
          Walter Milan -- Tuesday, 6 June 2006, at 12:03 p.m.
          • RE: Error message 243 - need help"Could not po....
            Olson, Kenneth \(GE Cons Fin\) -- Tuesday, 6 June 2006, at 2:25 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.