On Tue 2003-03-11 at 12:37:23 +0100, [EMAIL PROTECTED] wrote: > Le Mardi 11 Mars 2003 12:32, Warly a �crit : > > Jure Repinc <[EMAIL PROTECTED]> writes: > > > When I try to change my votes in bugzilla I get an error like this: > > > > > > Software error: > > > > > > SELECT fieldid FROM fielddefs WHERE name = 'bug_status': Table > > > 'fielddefs' was not locked with LOCK TABLES at globals.pl line 252. > > > > > > For help, please send mail to the webmaster ([EMAIL PROTECTED]), giving this > > > error message and the time and date of the error. > > > > I could not reproduce, could you explain more clearly what you are doing? > > warly, > > I had this error sometimes too, but when I post comments to bugs. When it > happens, reposting the same page works. Might be a concurrency access in the > database which is not handled correctly.
If you mean the error is triggered due to concurrency in the RDBMS,
then no, it has nothing to do with that. It simply means that the
script has issued a LOCK TABLES beforehand and table fielddefs was not
included.
Two possible, probable reasons are:
- The scripts issues LOCK statements on conditions which may change
between accesses (could include concurrency issues of the script)
- Or the script failed to issue an intended UNLOCK command for some
reason, which would make the next command outside the block
protected by the LOCK fail in the observed way.
Warly, is there an easy way to get to / see the source of your
bugzilla installation? If so, I would take the time to have a look at
possible sources for this behaviour. I am not sure how different your
version is from the official bugzilla. If using the latter one makes
sense, just say so.
HTH,
Benjamin.
pgp00000.pgp
Description: PGP signature
