| Table 's' was not locked [message #12163] |
Wed, 30 July 2003 09:30  |
ctbk
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma: 0
|
Senior Member |
|
|
Probably this has been fixed in 2.5.1, but I couldn't test it yes.
In 2.5.0, the SQL Error log is full of this kind of errors:
(index.php) 1100: Table 's' was not locked with LOCK TABLES
Query: SELECT s.id AS sid, s.ses_id, s.data, s.returnto, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, u.alias, u.append_sig, u.show_sigs, u.show_avatars, u.show_im, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.email_conf, u.last_read, u.default_view, u.is_mod, u.cat_collapse_status, u.ignore_list, u.acc_status, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.coppa, u.blocked, u.email, u.login, u.notify, u.last_read, u.pm_messages FROM fud2_ses s INNER JOIN fud2_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN fud2_themes t ON t.id=u.theme WHERE s.ses_id='1b996623ca96bf7862db8d002f657ef6'
Server Version: 3.23.55-log
[Referring Page] http://www.xxxxx.it/forum/index.php?t=post&reply_to=1074117"e=t rue&rid=8463&S=1b996623ca96bf7862db8d002f657ef6
If I don't reset periodically the log, it rapidly grows up to several megs in a few days.
P.S.:I'm trying to understand where the deadlock problem may hide in the code, at the moment without success.
~
~
:wq
[Updated on: Wed, 30 July 2003 09:30] Report message to a moderator |
|
|
|
| Re: Table 's' was not locked [message #12176 is a reply to message #12163] |
Wed, 30 July 2003 19:49  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Strange error, as far as I can tell the query you've displayed does not happen within a bounds of the SQL lock, meaning that LOCK TABLES should not affect it in any way.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]