Way to reveal record locks?

From: "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Way to reveal record locks?
Date: 2007-09-14 14:04:23
Message-ID: 46EA3277020000A700004CAC@groupwise.abag.ca.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I am using MS Access as a front end to a postgres database running on a Solaris Unix box, using odbc as the communication medium.

One of the main tools of my Access app is a process that runs at night to process student progress in an online training system.

A couple of nights ago the app started generating the error:
"Runtime error 3046: Could not save; currently locked by another user"
and it is on the app screen when I come in in the morning, locking up the program and keeping it from completing. I trap as many errors as I can think of, but this is escaping trap so I don't know where in the code it is happening.

I am sure that the error is not from an Access user A. because the process runs between 11pm and 1am and 2. because there are no .ldb files open, a file type created when a user opens an access application.

So, is there any way to determine what records are locked, if in fact that is the problem? (As you know, the error reported may not actually be the underlying problem).

Most of the program is designed with classes instantiated as objects, and in Access when I take the 'debug' option of the error message box, all that happens is the program goes to the first process of the first object, so that is useless.

If no one has an answer I will probably write a routine that steps through every record of every table and attempts to lock it to see if I can reproduce the error that way.

Thanks in advance for any suggestions anyone may offer.

Fred Parkinson

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrei Kovalevski 2007-09-14 15:30:47 Re: Way to reveal record locks?
Previous Message Ludek Finstrle 2007-09-12 07:54:35 Re: Any way to see parameters