| Author |
 Topic  |
|
cybersprite
Starting Member
8 Posts |
 Posted - 04 October 2006 : 12:16:29
|
I wonder if anyone can suggest any help for a problem I am currently having with my hosts server.
I have been running a forum for over five years on this site haven't changed any of the asp files and suddenly the site has locked up. This is the error message I am getting.
The database is hosted in a private directory on the server /private/ whenever I log in via FTP there is an .ldb file which is locked and cannot be removed, this is obviously part of the problem. I have asked the hosting company to remove the file as I can't they said this will involve rebooting the server and will affect too many customers. A few days later they said they had removed the .ldb file, but when I checked they hadn't
As it stands the forum is locked I can't delete the ldb file I have gone in and changed the database name and the config asp to point to the new database name hoping that the renaming would negate the ldb file being left open but it hasnt worked.
I complained again to the hosting company and this was THEIR response to me.
quote:
The only .ldb file in your private folder currently loaded.ldb. This file was created today. Please check your scripts to make sure that they are closing access database connections as soon as anything you need to select or update has been done. You should close the connections on each transaction. If this is not done, we may have to take action against your site to preserve performance for other users of the same server.
I have never had to manually close the connections on each transaction it is a very busy forum, stuck now no idea what to do, please can anyone offer any suggestions.
Thanks |
|
|
cybersprite
Starting Member
8 Posts |
Posted - 04 October 2006 : 12:17:45
|
| Sorry the link to the forum is http://www.todchat.com/forum/ It just hangs in IE but will open in Firefox with the (above jpg) error message. |
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 October 2006 : 12:37:58
|
having an ldb file is common and is part of it being access, however it should not prevent your forum from working under normal circumstances.
what version of the forum are you using, as we are very careful in trying to close all db connections as soon as we can. Do you have any MODS installed as these may not be closing connections when they should.
I would suspect that the problem lies somewhere other than your forum, since if you open your front page at http://www.todchat.com/ this is fetching data from your forum without any errors |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 October 2006 : 12:50:09
|
| the error line you have posted is actually nothing to do with your database, that line is trying to update an application variable which would indicate a problem with the webserver not your database, unless of course you have MODS installed and your line 246 is different to ours |
|
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 04 October 2006 : 12:55:04
|
it's SHN's V8 which was 3.4.03 with shn's usual mods:-
cal
poll
PM
avatar's
etc etc
Have u added any othe mods? |
 |
Edited by - Helterskelter on 04 October 2006 12:57:10 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 04 October 2006 : 12:55:21
|
From the screenshot above, it looks like a ServerHacker/Image forum.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Helterskelter
Junior Member
United Kingdom
331 Posts |
Posted - 04 October 2006 : 12:58:46
|
| also he has posted as SHN site but quicker responce here so i said for him to ask here, as i have know idea. |
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 October 2006 : 13:01:56
|
| I have tried to do a traceroute to the site but it does not even respond to a ping request which would indicate a problem with the server, you should contact your hosts since there is definately something wrong at their end |
|
|
|
cybersprite
Starting Member
8 Posts |
Posted - 04 October 2006 : 13:11:37
|
Thanks for your help.
I do have several Mods installed the usual server hacker mods, a charts mod flash games mods.
When I contacted the site hosts suggesting that there was a problem with the server they wrote this.
quote:
Unfortunately, to delete the lockfile you mentioned to our frontline support would require a restart of IIS, something we cannot do ad-hoc due to the impact for other customers.
The file-lock will dissapear naturally over time as IIS releases its hold on it.
It will have been caused by a script not closing it's connection to the database at some point.
The latest email has said they may take action against my site as it is affecting other sites on the server now?
I'll find the inc_func_common.asp and post it here, it may offer some insight into this problem.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 October 2006 : 13:19:28
|
| Now, their server is having a problem, they can't do anything not to interfere with other customers and now they're taking action against you? I wouldn't give them much of a chance to do that... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
cybersprite
Starting Member
8 Posts |
Posted - 04 October 2006 : 13:24:03
|
Their exact words were
quote:
Please check your scripts to make sure that they are closing access database connections as soon as anything you need to select or update has been done. You should close the connections on each transaction. If this is not done, we may have to take action against your site to preserve performance for other users of the same server.
The database is called TEST and the test.ldb file has been hanging around since 28 September (this is when the problem started) |
Edited by - cybersprite on 04 October 2006 13:24:35 |
|
|
|
cybersprite
Starting Member
8 Posts |
Posted - 04 October 2006 : 13:34:01
|
Here are the lines of code which seem to be causing the problem
sub deleteInactiveUsers()
strAUTimedOut = DateToStr(DateAdd("n",-strAUTimeout,strForumTimeAdjust))
strSql = "DELETE FROM " & strTablePrefix & "ACTIVE_USERS WHERE AU_LASTACTIVETIME < '" & strAUTimedOut & "'"
my_conn.execute (strSql)
end sub |
|
|
|
cybersprite
Starting Member
8 Posts |
Posted - 04 October 2006 : 13:49:04
|
Just a quick note to say I haven't been messing with any of the code this was a sudden thing that started happening out of the blue, just tried to get on the site forum again and got this message.
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'my_Conn.Open'
/forum/inc_header.asp, line 116
Any ideas please? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 October 2006 : 13:51:45
|
| Well that's another issue. If the problem showed up before, they would have a reason to say that, but if the code hasn't changed, I'd say this is a server glitch and they should do something about it. It's really on their end now. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
cybersprite
Starting Member
8 Posts |
Posted - 04 October 2006 : 13:54:48
|
Thanks the are refusing to co-operate, beginning to look like I'm going to have to back up the site and take it somewhere else  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
