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
Switch to threaded view of this topic Create a new topic Submit Reply
FUDForum very slow. Bad consistency check [message #25265] Fri, 03 June 2005 01:01 Go to next message
frank is currently offline  frank   United States
Messages: 3
Registered: June 2005
Karma: 0
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

Re: FUDForum very slow. Bad consistency check [message #25276 is a reply to message #25265] Fri, 03 June 2005 16:25 Go to previous messageGo to next message
frank is currently offline  frank   United States
Messages: 3
Registered: June 2005
Karma: 0
Junior Member
So, we ran vacuumdb and now we get this:

(/home/httpd/chemistry/FUDforum/include/theme/default/db.inc:148
/home/httpd/chemistry/html/adm/consist.php:66
/home/httpd/chemistry/html/adm/consist.php:280
) : ERROR: expression too complex DETAIL: Nesting depth exceeds maximum expression depth 10000. HINT: Increase the configuration parameter "max_expr_depth".
Query: DELETE FROM fud26_read WHERE id IN (643,664,7,692,699,8,11,706,727,19,EXTREMELY LONG LIST OF NUMBERS DELETED FOR BREVITY)
_POST: conf=Yes&S=964f052ce408cf5a11235e4830a27d23&SQ=4431aace334c8c709a70 182e2fdff8f2&
Server Version:
[Referring Page] DELETED

[Updated on: Fri, 03 June 2005 16:47]

Report message to a moderator

FWIW: Possible solution [message #25278 is a reply to message #25276] Fri, 03 June 2005 17:02 Go to previous messageGo to next message
frank is currently offline  frank   United States
Messages: 3
Registered: June 2005
Karma: 0
Junior Member
in postgresql.conf we uncommented and increased `max_expr_depth` to 15,000, then ran consistency check successfully.

It appears that vacuumdb needs to be run occasionally.

Hopefully, this will forestall any further issues.

Report message to a moderator

Re: FWIW: Possible solution [message #25283 is a reply to message #25278] Fri, 03 June 2005 19:18 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Yeah, the forum will actually run vacuum for you if you click the link @ the bottom of the report shown by the consistency checker. PostgreSQL can get pretty "hairy" if left non-vacuumed for a long time.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
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: Wed Dec 18 07:46:44 GMT 2024

Total time taken to generate the page: 0.02615 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software