RE: ERROR -244 HELP!!!
Chances are you are running into trouble acquiring a lock.
Every time I have seen this occur the program which recieved the
error did not use SET LOCK MODE TO WAIT
This means that if a program requests a row and there is a lock on it the program will get an error. You might want to use
SET LOCK MODE TO WAIT nn;where nn is the length of time to wait for a lock. If a lock is not acquired
in nn you will recieve an error.
if nn is not specified you will wait forever if the lock you are waiting on is
never released.
Will Rice
-----Original Message-----
From: Judah Libin [SMTP:judah@www.pagetalk.net]
Sent: Wednesday, May 19, 1999 10:28 AM
To: informix-list@iiug.org
Subject: ERROR -244 HELP!!!
hi
I am having some trouble with am error -244. Finderr wants me to use
bcheck or scheck, does anyone know what
these utilities are? I am running on Solaris 2.5 and Informix ONLINE-DS
7.2.1 here is the error below
Thanks Judah
<---BEGIN ERROR--->
Can not fetch row on cursor E [SQLSTATE=IX 000 SQLCODE=-244] (cursor15)
in something.inc on line 102
# finderr -244
-244 Could not do a physical-order read to fetch next row.
The database server cannot read the disk page that contains a row of a
table. Check the accompanying ISAM error code for more information. A
hardware problem might exist, or the table or index file might have
been corrupted. Unless the ISAM error code or an operating-system
message points to another cause, run the bcheck or secheck utility to
verify file integrity.
Thanks in advance