FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Table 's' was not locked
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Table 's' was not locked [message #12163] Wed, 30 July 2003 09:30 Go to previous message
ctbk is currently offline  ctbk   Italy
Messages: 142
Registered: April 2002
Location: Milan, Italy
Karma:
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&quote=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

[Message index]
 
Read Message
Read Message
Previous Topic: Login/cookies problem
Next Topic: datadump creation problem in 2.3.8
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Oct 31 23:07:46 GMT 2024

Total time taken to generate the page: 0.03929 seconds