Re: Got error 243 : Could not position within a table table-name
This is a multi-part message in MIME format.
------=_NextPart_000_0028_01BD8559.51AE4180
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
The 243 error is not so strange if you inspect the associated ISAM error =
also. A 243 just says that you couldn't get to the row requested. The =
ISAM error will tell you why (ex. record is locked). Check the ISAM to =see what's really going on. Without it you can only guess why.
Scott Kolaya
Wolfgang Beutner wrote in message <19980521.7055915@100024.1520>...
>>>>>>>>>>>>>>>>>> Urspr=FCngliche Nachricht <<<<<<<<<<<<<<<<<<
Am 18.05.98, 09:43:30, schrieb PCGRP Yakov Berkovitch 5055 =
<berko@cpm.elex.co.il> zum Thema Got error 243 : Could not position =
within a table table-name:
> Hi,
>=20
> when several processes are trying to update the same row in the same
> table, i got the error 243.
>=20
> It's very strange, because this error seems related to an hardware =
error
> (see finderr). But the table seems Ok because the oncheck utility =
didn't
> detect a problem.
> Also the program is designed like this:
> - set lock mode to wait 100
> - select for update
> - update row,
> BUT the process got the error immediately. It didn't wait 100 seconds.
>=20
> My questions are:
> - why the process didn't wait ?
> - what can cause the error 243.
>=20
> My configuration is : Informix 7.20 on AIX 4.1.5.
>=20
> Thanks for any responses.
> --=20
>=20
> Regards.
> ________________________________________________
> yakov.berkovitch@telrad.co.il
> (972)-89134414
Hello Yarkov,
what about the isolation level? If there are several processes that =
concurrently read the row they may have placed a shared lock on the row =
that is to be updated.
I am not sure whether a lock timeout has to expire in that situation. =
Nevertheless it may as well be a problem with adjacent key locking. That =
should not happen anymore with version 7... but we have encounterd =
situations that cannot be explained i a different way.
Hope it's helpful.
Wolfgang
------=_NextPart_000_0028_01BD8559.51AE4180
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type><TITLE>Re: Got error 243 : Could not position =
within a table table-name</TITLE><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML =
3.2//EN">
<META content=3D'"MSHTML 4.72.2106.6"' name=3DGENERATOR>
<META content=3D19980521;8521395 name=3DCREATED>
<META content=3D"Wolfgang Beutner" name=3DCHANGEDBY>
<META content=3D19980521;9045308 name=3DCHANGED>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>The 243 error is not so strange if =
you inspect=20
the associated ISAM error also. A 243 just says that you =
couldn't=20
get to the row requested. The ISAM error will tell you why (ex. =
record is=20
locked). Check the ISAM to see what's really going on. =
Without it=20
you can only guess why.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Scott Kolaya</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: =
5px">
<DIV>Wolfgang Beutner<WBEUTNER@CSI.COM> wrote in message <<A=20
=
href=3D"mailto:19980521.7055915@100024.1520">19980521.7055915@100024.1520=
</A>>...</DIV><PRE>
>>>>>>>>>>>>>>>>>> =
Ursprüngliche Nachricht =
<<<<<<<<<<<<<<<<<<
Am 18.05.98, 09:43:30, schrieb PCGRP Yakov Berkovitch 5055 =
<berko@cpm.elex.co.il> zum Thema Got error 243 : Could not =
position within a table table-name:
> Hi,
>=20
> when several processes are trying to update the same row in the =
same
> table, i got the error 243.
>=20
> It's very strange, because this error seems related to an hardware =
error
> (see finderr). But the table seems Ok because the oncheck utility =
didn't
> detect a problem.
> Also the program is designed like this:
> - set lock mode to wait 100
> - select for update
> - update row,
> BUT the process got the error immediately. It didn't wait 100 =
seconds.
>=20
> My questions are:
> - why the process didn't wait ?
> - what can cause the error 243.
>=20
> My configuration is : Informix 7.20 on AIX 4.1.5.
>=20
> Thanks for any responses.
> --=20
>=20
> Regards.
> ________________________________________________
> yakov.berkovitch@telrad.co.il
> (972)-89134414
Hello Yarkov,
what about the isolation level? If there are several processes that =
concurrently read the row they may have placed a shared lock on the row =
that is to be updated.
I am not sure whether a lock timeout has to expire in that situation. =
Nevertheless it may as well be a problem with adjacent key locking. That =
should not happen anymore with version 7... but we have encounterd =
situations that cannot be explained i a different way.
Hope it's helpful.
Wolfgang</PRE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0028_01BD8559.51AE4180--