Strange Errors
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21369
Printed Date: 29 March 2026 at 9:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Strange Errors
Posted By: CinemaemCena
Subject: Strange Errors
Date Posted: 22 September 2006 at 7:57pm
|
I loved the new version and even bought the license key less than an hour after installing it (yes, I was THAT happy with the forum).
But I'm getting some strange erros now and then.
For instance, while trying to post, some members complained they occasionally get this:
Server Error in Forum Application An error has occured while writing to the database
Please contact the forum administrator Support Error Code:- err_SQLServer_getUserData()_update_last_visit File Name:- functions_loginasp Error details:- Microsoft OLE DB Provider for SQL Server Timeout expired And a few moments ago, when I clicked on a topic, I got this:
Microsoft OLE DB Provider for SQL Server error '80004005'
Transaction (Process ID 81) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. /forum/forum_posts.asp, line 429
What's going on???
|
Replies:
Posted By: CinemaemCena
Date Posted: 22 September 2006 at 8:05pm
| AND it's slow (v 7.97 was running perfectly!) AND it's affecting my website, which is located at the same server and became slow after I installed v 8.04. |
Posted By: WebWiz-Bruce
Date Posted: 22 September 2006 at 10:49pm
|
Version 8 is much, much, faster than version 7.x and uses far less server resources, with many pages loading over 2000% faster and database hits also reduced by the same amount. It sounds to me that it just a coincidence that this happened soon after the upgrade and the errors you are getting are usually associated with the server running the SQL Server running out of resources and being overloaded. You should get onto your web host and get them to look into the issue, as this is an SQL Server issue. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date Posted: 22 September 2006 at 11:18pm
| What about the errors I mentioned above??? |
Posted By: CinemaemCena
Date Posted: 22 September 2006 at 11:30pm
|
Also: even when it's running fast in most of the forum, it slows down when dealing with large topics. We have a topic with 1189 pages and it takes up to 3 minutes to load a page of this topic (with v7.97, it was normal).
Another message error:
Server Error in Forum Application
An error has occured while reading user data from the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_getUserData()_get_member_data File Name:- functions_login.asp Error details:- Microsoft VBScript runtime error An exception occurred Before it was update last visit; now it's member data
|
Posted By: WebWiz-Bruce
Date Posted: 23 September 2006 at 9:23am
Yes this is what I was answering in my post. The errors are due to issues with the SQL Server. You will get timeout and connection errors when the SQL Server is overloaded and doesn't respond in a reasonable time. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
CinemaemCena wrote:Posted By: CinemaemCena
Date Posted: 23 September 2006 at 9:29am
|
Ok, borg, I'll look into that.
Thanks.
|
Posted By: WebWiz-Bruce
Date Posted: 23 September 2006 at 11:17am
|
Also if you look at the following topic on this forum it has 3,938 posts and takes less than 0.4 seconds to load, which is the type of performance you should see form version 8 with most pages loading in under 0.05 seconds:- forum_posts.asp?TID=5493 - The Neverending Thread ?!? ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date Posted: 23 September 2006 at 11:36am
|
Ok. :) But the topic I mentioned has 23,844 posts, which is a considerable difference. But if you say that's not a problem, great! :)
|
Posted By: CinemaemCena
Date Posted: 23 September 2006 at 9:28pm
|
Well... just as a test, I closed that huge topic.
Guess what? The forum came back to normal. Everything is working just fine.
But still, if I try to enter the huge topic, the answer is very slow - it takes up to 60 seconds to load a single page within the topic.
So... I guess it IS a problem in the new version of the forum, since it worked just fine in the old one.
|
Posted By: WebWiz-Bruce
Date Posted: 23 September 2006 at 9:47pm
|
Version 8 will perform much faster than version 7, but it was never designed for a topic with 23,000 posts in it. I wouldn't have even imagined that anyone would have had a topic with 23,000 posts in it, in a forum yes, but not in a single topic. Version 8 has had many weeks spent optimising each SQL Query to get the maximum speed out of it for what it is used for, so forums are optimised to handle hundreds of thousands of posts, even millions, but the topics have only been optimised to handle upto hundreds of posts, as I have never herd of a topic with over a thousand posts, let alone 23,000 The forum could be optimised to handle 1000's of posts in topics, but this would be at a cost to slower performance on normal topics with upto 50 posts. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Mikey
Date Posted: 23 September 2006 at 9:53pm
|
Lol must be a very intresting topic, have you got a link to it?
------------- Handyman man? |
Posted By: WebWiz-Bruce
Date Posted: 23 September 2006 at 10:13pm
|
It maybe best if I explain how the optimisation works on the page displaying posts in version 8 compared to version 7. In version 7 a couple of less complex SQL Queries were run on the database, then as each post is displayed 2 or 3 other queries were run to get additional data. This means that for a topic with say 50 posts over 102+ database queries are run which eats up allot of server resources. Not very good as you would imagine. In version 8 database hits are kept to a minimum, so for extra performance only 2 database queries are run for the page displaying the posts for the topic using more complex table joins to get all the required data and feeding it into an array. As you can imagine 2 database hits for a topic no matter the number of posts is much better than over 100 for a 50 post topic and thus the page loads faster under normal circumstances, even if there are only 1 or 2 posts in the topic. This is great till you get to a topic with 23,000 posts, table joins do place a bit more strain on the DBMS when you get to this type of level, as the DBMS needs to build up a table of the joined records, which is fine on normal topics, but having to build a table that uses complex joins for 23,000 records can place a tremendous strain on the database, thus getting the problems you mention. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: WebWiz-Bruce
Date Posted: 23 September 2006 at 10:13pm
|
By the way what on earth do you have in a topic with 23,000 posts?
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date Posted: 23 September 2006 at 10:17pm
|
It was an idea that one of our users suggested to control flood in the forum. We created a single topic within the whole forum in which the flood was permitted.
It worked. All the other topics were finally rid of flood.
The one in which it was permitted, though... :)
http://www.cinemaemcena.com.br/forum/forum_posts.asp?TID=10240 - http://www.cinemaemcena.com.br/forum/forum_posts.asp?TID=10240
|
Posted By: WebWiz-Bruce
Date Posted: 23 September 2006 at 10:26pm
|
Maybe a suggestion is I'm afraid to delete this massive topic. Then instead have your flood control topic, but every month lock it and start a new one. This should keep the topic size down and keep the performance up of your forum. Another option is to make a flood control forum in which anyone can post whatever they like. I know this is a work around, but to keep performance up under normal circumstances this is the only suggestion I can think of, unless you want the expense of moving to a very powerful dedicated server. If you do this I think you will be impressed at the speed improvements over version 7, as long as topics are at a reasable size  ,.------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date Posted: 23 September 2006 at 10:45pm
|
I locked the topic and the forum came back to normal. And we already opened a "Part 2" of said topic. :) (Do you recommend I delete the old topic? Locking it isn't enough?)
By the way, thanks for your detailed explanation, borg. I appreciate it.
And I already noticed the improvement in speed!
Three FINAL questions (I hope):
1) If I create a SUBFORUM for flood, does it count as one topic or each topic within the SUBFORUM will count separately? I mean: it would be an even better solution for the thread I mentioned above: transforming it in a subforum. :)
2) Which is the maximum limit of posts you recomend we allow for each topic?
3) Oh, In the administrative panel, I can't find the option to see the database and log files size. It was excluded?
|
Posted By: WebWiz-Bruce
Date Posted: 24 September 2006 at 11:19am
|
I would recommend actually deleting the topic as it will still course problems when people try to read it. To answer your other questions:- 1. Sun forums work in the same way as a main forum so can handle any amount of topics and posts. Placing the 23,000 post topic into another forum will still course speed issues when read. 2. This is a difficult question as it would depend on a number of things such as database type, and for SQL Server like you are using it would depend on things like, how many other databases on the SQL Server, network speed, web server load. This site uses SQL Server Express 2005 installed locally on the dedicated server for this site and seems to not have any issues with a topic of 3,000+ posts. The advice I could give, is keep an eye on large topics, and if the processing time at the bottom of the page starts to get high (eg. 2+ seconds to precess under normal load) 3. The database stats was removed in version 8 as they didn't work under SQL Server 2005, but all these details are available if you login into your SQL Server database using the free SQL Management Studio Express, it's free form Microsoft for SQL Server 2005 but will also work with SQL Server 2000 ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |