• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Triple Posting and slow query

RobinHood

Well-known member
#1
I've had an issue one someone tripple posting and on the same day a couple of users complaining about speed.

I figured it may be to do with my server location? It's in Dallas, TX but most of our users are UK and Belgium based.

I didn't know if the server is more to do with this and if moving it might help resolve the issue?

My hosting company asked me to carry out a tracert which returned the following. They picked up that after 11 there's a pretty big increase and suggested moving my server might rectify this, but would it help speed the site up?

tracert -d -w 30 174.122.37.162
Tracing route to 174.122.37.162 over a maximum of 30 hops
1 1 ms 1 ms 1 ms 192.168.1.1
2 23 ms * 45 ms 213.123.106.122
3 24 ms 24 ms 24 ms 213.123.106.145
4 22 ms 23 ms 26 ms 213.1.69.10
5 24 ms 25 ms 23 ms 217.32.26.22
6 23 ms 37 ms 25 ms 217.32.26.178
7 24 ms 26 ms 26 ms 109.159.248.78
8 24 ms 27 ms 25 ms 109.159.248.10
9 64 ms 29 ms 32 ms 62.6.200.101
10 34 ms * 30 ms 195.66.224.76
11 37 ms 34 ms 32 ms 64.125.28.126
12 104 ms 105 ms 106 ms 64.125.27.57
13 99 ms * 102 ms 64.125.29.17
14 129 ms 130 ms 134 ms 64.125.31.213
15 144 ms * 144 ms 64.125.30.58
16 133 ms 136 ms 139 ms 64.125.26.210
17 134 ms * 137 ms 64.125.199.94
18 135 ms 138 ms 137 ms 70.87.253.86
19 137 ms * 138 ms 70.87.255.66
20 135 ms 139 ms 136 ms 70.87.254.226
21 138 ms * 138 ms 174.122.37.162
Trace complete.

TBH it's not a lot of money to get the site site moved to a server in London, but I was curious as to if you guys thought it would actually help and I thought through spam prevention features double/triple posting couldn't happen due to users not being able to post within so many seconds of a post?

Any advice appreciated :)
 

Jake Bunce

XenForo moderator
Staff member
#2
I believe the nature of your problem is that the browser isn't receiving a response before javascript times out, so the request is submitted again. That might result in double posts. An unreliable server connection can cause this breakdown in communication between client and server.

If the poor connection is a problem of geography then moving your server will probably fix this.

You can also try to work around the problem. If you increase the flood check that may prevent double posting in this circumstance:

Admin CP -> Home -> Options -> Messages -> Minimum Time Between Messages (Seconds)

But users with this permission may still have the problem (probably admins and mods):

Admin CP -> Users -> List User Groups -> [click a group] -> Bypass flood check
 

RobinHood

Well-known member
#3
Ahh, thanks for the info Jake. Looks like it was another admin and so they have the flood check bypassed. If I turn that off does it simply restrict us to the same time limit as everyone else as specified in the message options, say 30 seconds?
 

RobinHood

Well-known member
#6
I was just posting something on my forum and it was taking ages then this error came up

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@fffsquad.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 mod_fcgid/2.3.5 Phusion_Passenger/2.2.15 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at fffsquad.com Port 80
So I submitted the post again, same thing happened.

So I refreshed the page and both posts has been successfully submitted.

Any idea what the error means and if it's likely to do with my server or xenforo?
 

Jake Bunce

XenForo moderator
Staff member
#7
Is there any pattern to this error or is it intermittent?

An internal server error is something different. Anything in the logs?

Admin CP -> Tools -> Server Error Log

Otherwise you will need to check the logs on the server itself to see if they contain any useful information about the error.
 

RobinHood

Well-known member
#8
Intermittent, will do, the entire site has just broken as the MySQL is down according the control panel with my host so I'm guessing it's a server issue...will check the logs once it's back up
 

Dean

Well-known member
#9
I took the liberty of looking up your domain, it appears you are on shared hosting with many other sites.

I was also on shared hosting 2 years ago, at The Planet via Hostgator, and things were problematic at best.
 

RobinHood

Well-known member
#10
Indeed I am, I'm on the $14 a month package from here. I've contacted the hosts to see what they think about the server issues. Do you think I may have to change my plan?

Is there any pattern to this error or is it intermittent?

An internal server error is something different. Anything in the logs?

Admin CP -> Tools -> Server Error Log

Otherwise you will need to check the logs on the server itself to see if they contain any useful information about the error.
Hmmm...got 21 pages of server error logs. All from the chatbox on July 6th though so nothing recent. Is there an easy way to clear them all, I can't see a button?
 

Dean

Well-known member
#11
Indeed I am, I'm on the $14 a month package from here. I've contacted the hosts to see what they think about the server issues. Do you think I may have to change my plan?
I've no idea... depends on many things I have no knowledge of. Since you are here asking about the triple posting, the thought may have already been on your mind.

I can say that I am delighted we got a vps.
 

RobinHood

Well-known member
#12
Hmmm....maybe someone who knows about more about this can possibly advise me of the benefits of doing thing or if they think I should?
I've never had any real issues with the shared hosting, but it's only a few very basic static sites that are also hosted there, maybe I should research a VPS, I hadn't really planned on $50 a month outlay just for hosting though :(
 

RobinHood

Well-known member
#13
Site 5 said:
From the logs and I could see that error was related to script timing out, I have now raised the timeout value to 120 sec and have also increased the memory_limit.
This is the reply I received from them, lets see what happens :)
 

RobinHood

Well-known member
#15
Not had lots of issues since, but it's not a very active forum. I did have another user who should be flood check moderated quintuple post the other day which is odd.

I think it might be to do with my hosting though, I'm going to migrate to a VPS this week and share it with a mate to see if that helps.
 

kforo

Active member
#16
I've deleted somewhere north of a hundred, (2 all the way to 6) duplicate posts from a number of users in the last week or so. I'm on a VPS. Floodcheck bypass is set to never.
 

Jake Bunce

XenForo moderator
Staff member
#17
I've deleted somewhere north of a hundred, (2 all the way to 6) duplicate posts from a number of users in the last week or so. I'm on a VPS. Floodcheck bypass is set to never.
If not a flood check then perhaps some kind of server issue such as a spotty connection or proxy that initiates multiple requests. Have you noticed any connection problems with your forum lately? Do you have another server you can test?
 

kforo

Active member
#18
I've talked to my host and they tweaked a few things, but said things are good on their end and blame the software. No other server to test