Forum hangs with apparent locking problems (V2.5.2) [message #15926] |
Fri, 09 January 2004 16:57 |
wfjmueller
Messages: 95 Registered: December 2003 Location: Darmstadt, Germany
Karma: 0
|
Member |
|
|
This is a Problem, not a Bug report !
In a V2.5.2 installation (using mySQL) we have the following problem:
- we had some general networking problems, causing various effects, among them maybe some bad and/or aborted FUDforum transactions
- after a reboot the forum worked only intermittently, it hung after a few transactions, or returned blank pages.
- we run the consistency check, no problems
- the forum still doesn't work (see 2.). The error log shows entries like
(index.php) 1100: Table 's' was not locked with LOCK TABLES
Query: SELECT s.id AS sid, s.ses_id,....
FROM ff_ses s INNER JOIN ff_users u ON....
So apparently there are locking problems, even though the system was rebooted. Since the consistency checker doesn't complain, it's not clear what to do to recover.
|
|
|
|
|
|
Re: Forum hangs with apparent locking problems (V2.5.2) [message #15968 is a reply to message #15953] |
Sat, 10 January 2004 21:11 |
wfjmueller
Messages: 95 Registered: December 2003 Location: Darmstadt, Germany
Karma: 0
|
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
|
|
|
Re: Forum hangs with apparent locking problems (V2.5.2) [message #15971 is a reply to message #15968] |
Sat, 10 January 2004 22:08 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
The first thing I'd do is disable persistent connections (if you got them enabled). Then switching to unix domain socket interface instead of TCP/IP if the mysql server is the webserver as well.
FUDforum Core Developer
|
|
|
|
|
|
|