Re: [Cooker] Bugzilla - Error when voting for a bug
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
Re: [Cooker] Bugzilla - Error when voting for a bug
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. -- Pascal Cavy - VMF __ Running 3 days, 16:28, 4 users, load average: 0.26, 0.22, 0.27 (gcc version 3.2.2 (Mandrake Linux 9.1 3.2.2-3mdk)) Kernel Linux version 2.4.21-0.12mdkenterprise
Re: [Cooker] Bugzilla - Error when voting for a bug
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. pgp0.pgp Description: PGP signature
[Cooker] Bugzilla - Error when voting for a bug
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.