| SQL error log [message #18809] |
Thu, 10 June 2004 15:48  |
davew
Messages: 78
Registered: June 2002
Location: West Beach, South Austral...
Karma: 0
|
Member |
|
|
My Error log has entries like that below every few days..
I'm running 2.6.3 on Redhat 9..
Is this anything to worry about?
------------------------------------
(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 fud21_ses s INNER JOIN fud21_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN fud21_themes t ON t.id=u.theme WHERE s.ses_id='fc915570d19d5d2bfa85b1f5e1aa08d3'
Server Version: 3.23.54
---------------------------------------
Regards,
Dave
|
|
|
|
| Re: SQL error log [message #18813 is a reply to message #18809] |
Thu, 10 June 2004 17:00  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Yes, this should not happen. This used to happen with old 2.3/2.5 releases in very rare instances for some people. But with 2.6 the query you've shown never occurs inside a lock. Are you sure upgrade procedure went through ok?
Also the error report should've included the line # where the query was executed, but no such line is present. This implies you have a partially completed upgrade or modified 2.6.X sources.
FUDforum Core Developer
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]