| Author |
 Topic  |
|
|
Alaundo
Starting Member
22 Posts |
 Posted - 02 May 2007 : 13:10:45
|
Hi
I had problems last year with Snitz using Access database and subsequently converted to MySQL.
However, I am finding an increase of ASP script timeout messages (such as below):
quote:
Active Server Pages error 'ASP 0113'
Script timed out
/active.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
This ALWAYS occurs when signing in and trying to navigate to Active Topics (which is oddly the case for Moderator accounts only - may be an uncanny coincidence) but the same type of errors are quite commonplace and response times are very slow.
The total size of my SQL database is around 125MB for all tables; which I don't think is particularly large and SQL queries should be quite efficient on this size.
This is making the forum very frustrating and quite unusable. There are around 25 users on the forum at any one time. Again, this seems quite acceptable.
Any help or advice is appreciated. |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 02 May 2007 : 13:19:01
|
First question would be how did you do the conversion? If you didn't use setup.asp to create the tables, the indexes may not have been set up right, which has been known to cause a problem.
Edit: it would also help to know if this is only happening with the moderators.
The more I think about it, the more I've got an inkling that this has been discussed before, but don't quote me on that. |
Edited by - AnonJr on 02 May 2007 13:30:55 |
 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 02 May 2007 : 15:42:19
|
| Try using a MySQL client of some sort (eg Aqua Data Studio) to run some of the queries against the db, see what the performance is like. My guess is a db/stats/indexing issue, but you may find archiving a heap of content sets it all good |
|
|
|
Alaundo
Starting Member
22 Posts |
Posted - 03 May 2007 : 04:09:01
|
Thanks all.
The conversion was done using the advice and steps from this forum and all indices were created as normal.
Speaking with other moderators (and using test account), this is definately a scenario where moderators always time out after having signed in, but there is no delay and problem with normal members.
Could a piece of common moderator-specfic code be inefficient or causing this issue? Any ideas?  |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 03 May 2007 : 06:03:47
|
Hmm. That does make it interesting.
Do you have a large number of forums and/or Moderators? I ask because as near as I can remember this early in the morning active.asp does a check for privileges for each topic listed on active.asp. I swear the more I think about this there was a topic a long time ago about this very issue. Have a search in the archives. After I wake up a little more I'll try the same and see if I can't dig it up. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 May 2007 : 08:05:15
|
| Yeah, the pages usually do a lot more work for mods and admins. I'd say this is either an issue with the database server itself, or a problem with the indexing structure. Try rebuilding the indexes and see if it helps. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Alaundo
Starting Member
22 Posts |
Posted - 04 May 2007 : 03:50:29
|
Thanks. That's settling to hear, in a way, and makes sense.
ruirib, how do I do an index rebuild? Is there a danger of this operation messing up the data? Should I close down all access to the forum before doing so? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 May 2007 : 05:19:02
|
You need to run a quick repair of each table, and that will rebuild the indexes. I usually do that from SQLYog, but you can run a statement like: REPAIR TABLE tbl_name QUICK;
Of course, you need to do this for each table.
The forum may get slower while you do this, but there is no risk. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Alaundo
Starting Member
22 Posts |
Posted - 06 May 2007 : 08:54:11
|
quote:
Originally posted by ruirib
You need to run a quick repair of each table, and that will rebuild the indexes. I usually do that from SQLYog, but you can run a statement like: REPAIR TABLE tbl_name QUICK;
Of course, you need to do this for each table.
The forum may get slower while you do this, but there is no risk.
ruirib, you're a star  This is certainly solved the problem, it seems. Speedy forum with no ASP timeouts. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Alaundo
Starting Member
22 Posts |
Posted - 30 June 2007 : 05:51:22
|
Hi again
Well this worked for a while but the issue is back again. I've tried rebuilding all tables once more but it's not really had an effect. THis is driving me (and the forum members) crazy! Furthermore, when a post submmission times out, it can sometimes actually post the entry but then the timeout stops the update of the post count and the "last poster" information. This is becoming quite common now and i'm finding that a lot of threads are saying such as "40 pages" when in fact there are 41\42, as more recent posts aren't being counted.
Firstly, anymore help on how to combat the timeout issue would be very much appreciated.
Secondly, is there a way to refresh all the post counts and such (the Update Counts option in Admin just times out and ceases in Step 2 every time). |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 30 June 2007 : 07:01:44
|
I posted a script to update counts that you can run from a tool such as SQLYog or even phpMyAdmin:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=61685
This script should not timeout, but on your circumstances I can't guarantee that it won't.
I do agree that a 125 MB shouldn't cause those problems. I know of a 800 MB MySQL DB that has no such problems and I haven't rebuild indexes for quite a while.
You can have several causes for that. It may be the database server, but it may be the web server too... You should talk to your host about that and see what, if anything, they have to say.
I know this does not help much, but it's hard to help without knowing the cause for the issues. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Alaundo
Starting Member
22 Posts |
Posted - 30 June 2007 : 15:32:13
|
Thanks ruirib.
Regarding the script, is the "TEMPORARY" necessary, as I get an error when executing this. Creating a table without the keyword is ok, however. I just thought i'd check if it's there for a reason or particular function before running the whole lot.
As to your other point, my host is being (surprise, surprise) quite unhelpful and merely respondes with stating that everything is ok at their end. Typical.
Thanks |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
