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

Home » FUDforum » How To » FUDForum very slow. Bad consistency check
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
FUDForum very slow. Bad consistency check [message #25265] Fri, 03 June 2005 01:01 Go to previous message
frank is currently offline  frank   United States
Messages: 3
Registered: June 2005
Karma:
Junior Member
Don't know if these are related, or what to do with the information. All suggestions appreciated.

1. Forum is extremely slow - prior to deleting over 1/2 of the content, it was taking upwards of 60 seconds to access just the front page.

2. Consistency check shows the following error. What is the cause? What is the solution?

Disabling the forum for the duration of maintenance run
Locking the database for checking
(/home/httpd/chemistry/FUDforum/include/theme/default/db.inc:148
/home/httpd/chemistry/FUDforum/include/theme/default/db.inc:109
/home/httpd/chemistry/html/adm/consist.php:134
) : ERROR: deadlock detected DETAIL: Process 14679 waits for AccessExclusiveLock on relation 24816 of database 17143; blocked by process 14672. Process 14672 waits for AccessShareLock on relation 24690 of database 17143; blocked by process 14679.
Query: LOCK TABLE fud26_users, fud26_user_ignore, fud26_title_index, fud26_thread_view, fud26_thread_rate_track, fud26_thread_notify, fud26_thread, fud26_thr_exchange, fud26_themes, fud26_stats_cache, fud26_smiley, fud26_ses, fud26_search_cache, fud26_search, fud26_replace, fud26_read, fud26_poll_opt_track, fud26_poll_opt, fud26_poll, fud26_nntp, fud26_msg_report, fud26_msg, fud26_mod_que, fud26_mod, fud26_mlist, fud26_mime, fud26_level, fud26_ip_block, fud26_index, fud26_groups, fud26_group_resources, fud26_group_members, fud26_group_cache, fud26_forum_read, fud26_forum_notify, fud26_forum, fud26_fc_view, fud26_ext_block, fud26_email_block, fud26_custom_tags, fud26_cat, fud26_buddy, fud26_blocked_logins, fud26_avatar, fud26_attach, fud26_announce, fud26_ann_forums, fud26_action_log, fud26_fl_1, fud26_fl_2, fud26_fl_3, fud26_fl_4, fud26_fl_5, fud26_fl_6, fud26_fl_7, fud26_fl_8, fud26_fl_9, fud26_fl_10, fud26_fl_11, fud26_fl_12, fud26_fl_13, fud26_fl_14, fud26_fl_15, fud26_pmsg,fud26_users,fud26_forum,fud26_thread,fud26_poll,fud26_poll_opt,f ud26_poll_opt_track,fud26_msg,fud26_pmsg,fud26_mod,fud26_thread_rate_track, fud26_msg_report,fud26_cat,fud26_forum_notify,fud26_thread_notify,fud26_bud dy,fud26_user_ignore,fud26_msg,fud26_msg,fud26_users,fud26_users,fud26_atta ch,fud26_thr_exchange,fud26_read,fud26_mime,fud26_group_members,fud26_group _resources,fud26_groups,fud26_group_members,fud26_group_members,fud26_theme s IN ACCESS EXCLUSIVE MODE
_POST: conf=Yes&S=964f052ce408cf5a11235e4830a27d23&SQ=8dc347854c5a38307904 29b2d264fc56&
Server Version:
[Referring Page] DELETED

[Updated on: Fri, 03 June 2005 10:09]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: email as login
Next Topic: use real name in notification subject line
Goto Forum:
  

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

Current Time: Sat Nov 30 21:23:23 GMT 2024

Total time taken to generate the page: 0.08722 seconds