Strange locking in Ingres 6.4/06

Hi Folks

Yes, I'm still using Ingres 6.4/06 on HP UX 10.20.

I have encountered a strange locking issue where a table is locked by
another process. Other users acessing this table eventually timeout
and their transactions rolled back.

In ISQL, my query against this table times out. Also setting the
"lockmode session where readlock = nolock" still does not allow me to
view the table. I thought we were able to access the table under all
condition when "readlock = nolock". Under IPM, everything looks fine.
No locking problem reported by IPM.

This is a single row, single column table containing the "last"
counter that generates next "unique" key to use. The system has been
running for the last 15 years with no problems and just lately we have
started to see this locking problem.

Thanks
.

Relevant Pages

  • RE: Web page not responding
    ... Thanks for the reply, although I dont think it is locking, as it can happen ... with only one active user on the system. ... Although I will try and ascertain what SQL is doing at the time of the ... > like a record locking problem during the update. ...
    (microsoft.public.dotnet.framework.aspnet)
  • contemporary -current panic: locking against myself
    ... 0xca2f7770: tag tmpfs, type VREG ... tag VT_TMPFS, tmpfs_node 0xd177f9d4, flags 0x0, links 9 ... It seems there is some locking problem in tmpfs. ...
    (freebsd-current)
  • Re: security
    ... Locking is independent of the security context so a common login won't ... SQL Server MVP ... people connect the database using that sql user name. ... i believe that won't case any locking problem right.. ...
    (microsoft.public.sqlserver.security)
  • Re: row vs page locking...
    ... the Hands-On SQL server 2000 Troubleshooting:Locking and Blocking. ... The last several times and specific for locking and blocking caused ... a select on a single row in one table could be 'causing' a deadlock. ...
    (microsoft.public.sqlserver.server)