Re: Locking

Posted in 1995

Spokey the Wheeler — Sat, 23 Sep 95 20:24:21 GMT — source: Informix-list mailing list archive (1991-1998)

In article <43ujg0$7uf$1@mhafn.production.compuserve.com> 75442.2115@CompuServe.COM "Stanley Katzenstein" writes: > I am working in Informix V4 SE. The error occurs within a > PowerBuilder application. My problem is that I can't delete a row > from a table. The error I get is -263 with ISAM -107. Could not > lock row for UPDATE. I am not sure how to resolve this problem. > > When in ISQL on UNIX I get a message that the row is currently in > use by another user. > > Any advice is appreciated Another missing followup? Here we go again: At a guess I'd say you had index corruption (provided you haven't got a rogue sqlexec process which *has* locked the row!) Try running a bcheck -y on the affected table. HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregend andere kondom! Carter - the Unstoppable Sex Machine / Wheeler - the Unstoppable Mail Machine!