ADJACENT ROW DELETE BUG

Posted in 1995

Brian Green — 12 Apr 1995 22:13:08 -0400 — source: Informix-list mailing list archive (1991-1998)

KX> All ... we are having a bit of a time with the adjacent row delete ... KX> -245 Could not position within a file via an index. KX> -144 ISAM error: key value locked. KX> We are now seeing the problem with NON-adjacent rows. I am assuming we If you are using page level locking, that may be the culprit. Another possibility is that you may need to update statistics. We had a similar problem where a table with row level locking would suddenly begin locking on a page level. The problem went away if we did an update statistics. Eventually, we added it to cron. --- ~ SPEED 1.40 [NR] ~