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

Home » FUDforum Development » Bug Reports » Forum hangs with apparent locking problems (V2.5.2)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Forum hangs with apparent locking problems (V2.5.2) [message #15968 is a reply to message #15953] Sat, 10 January 2004 21:11 Go to previous messageGo to previous message
wfjmueller is currently offline  wfjmueller   Germany
Messages: 95
Registered: December 2003
Location: Darmstadt, Germany
Karma:
Member
I see your argument, but try to see our side. The forum went down, and stayed there. Obvious corruption, caused probably by a networking problem. So that sort of thing is not reproducible, but something similar will occur again sooner or later for sure. So we'd like to understand the mechanism which cause such failures as much as we like to get it fixed. So given the history and symptoms, we'd highly appreciate some hints. Where would you look first, into the database state or contents, or into FUD generated files ?

Here the full text of a typical error log entry:
(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.pm_notify, u.last_read,
u.pm_messages FROM ff_ses s INNER JOIN ff_users u ON u.id=(CASE
WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN
ff_themes t ON t.id=u.theme WHERE
s.ses_id='b890d962aab651a5c0b3a64a98b14449'
Server Version: 3.23.49-log 
[Message index]
 
Read Message icon5.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: RDF causes SQL error
Next Topic: Rebuild Theme uses wrong images?
Goto Forum:
  

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

Current Time: Sat Nov 09 05:07:02 GMT 2024

Total time taken to generate the page: 0.06295 seconds