post+redirection dosn't work=double posts&maximal CPU

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
ellengorden
Registered User
Posts: 10
Joined: Mon Oct 02, 2006 7:17 pm

post+redirection dosn't work=double posts&maximal CPU

Post by ellengorden » Mon Oct 02, 2006 7:51 pm

What is problem?

Whenever users type up a post and click submit the server takes to load the redirection page. Sometimes it go very long and redirection dosn't work. Users get blank page or browser error, but the data from the form has been submitted to the database. Sometimes hasn't been submitted. Users go back to post page, keep clicking submit and they double, triple, even quadruple post their replies. On the server's side at this moment one of MySQL's child processes use maximal CPU. The restart of MySQL helps for the short time.

ellengorden
Registered User
Posts: 10
Joined: Mon Oct 02, 2006 7:17 pm

Post by ellengorden » Tue Oct 03, 2006 6:02 am

It's stuped problem, I don't know what can I do.

Forum work 3 years without problems. It problem starts some versions before phpBB 2.0.21

User avatar
Anon
Former Team Member
Posts: 7019
Joined: Fri Jan 02, 2004 7:33 am
Location: Christchurch, New Zealand

Post by Anon » Tue Oct 03, 2006 8:56 am

It sounds like the server isn't powerful enough to run the site. How large is it? Is it a shared or dedicated server? If dedicated, what are it's specifications?

ellengorden
Registered User
Posts: 10
Joined: Mon Oct 02, 2006 7:17 pm

Post by ellengorden » Tue Oct 03, 2006 2:10 pm


ellengorden
Registered User
Posts: 10
Joined: Mon Oct 02, 2006 7:17 pm

Post by ellengorden » Tue Oct 03, 2006 8:49 pm

Anon wrote: It sounds like the server isn't powerful enough to run the site. How large is it? Is it a shared or dedicated server? If dedicated, what are it's specifications?


Not so big... ~300 users, ~40000 messages, 1.7G disk usage (mostly images). The MySQL database ~93M. The server dedicated with the specifications listed below:

CPU:PIII-1G
Memory: 1G
Disk: 36G SCSI
OS: Linux
Connection to internet: ADSL 1.5Mbit/150Kbit

ellengorden
Registered User
Posts: 10
Joined: Mon Oct 02, 2006 7:17 pm

Post by ellengorden » Wed Oct 04, 2006 4:20 pm


ellengorden
Registered User
Posts: 10
Joined: Mon Oct 02, 2006 7:17 pm

Post by ellengorden » Wed Oct 04, 2006 4:24 pm

Has somebody an idea what is a problem?

Caedmon
Former Team Member
Posts: 855
Joined: Sat Mar 01, 2003 11:45 pm
Location: British Columbia, Canada
Name: Charles Flanders

Post by Caedmon » Wed Oct 04, 2006 4:28 pm

Do not bump your post until more than 6 hours have passed.
Former Moderator Team Member 2004 - 2012

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Post by espicom » Wed Oct 04, 2006 7:05 pm

You have a number of possible factors involved. If you have pruning enabled, try disabling it - whenever a moderator or admin enters a forum, phpbb checks to see if it needs pruning, and pruning can take a LOT of CPU time on a big forum. Endless loop while pruning messages covers changes that can be done to fix this. Posting while the system is purging cues the SQL request until the purge (with lots of CPU resources running) is completed, and PHP can time out waiting for the successful response. But the time-out does not remove the request.

If your word search tables are too big for the system resources (they can be rather taxing if not configured properly), posting can take a while, especially editing a post. The Knowledge Base article on Decreasing the size of your search tables helps you "tweak" the "stop words" list to match your forum's usage, which can speed things a LOT. There is also a MOD to rebuild search tables, which can help you deal with tables that have gotten out of hand.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

Locked

Return to “2.0.x Support Forum”