Welcome to Australia's only Vintage Radio and Television discussion forums. You are not logged in. Please log in below, apply for an account or retrieve your password.
Australian Vintage Radio Forums
  Home  ·  About Us  ·  Discussion Forums  ·  Glossary  ·  Outside Links  ·  Policies  ·  Services Directory  ·  Safety Warnings  ·  Tutorials

General Discussion

Forum home - Go back to General discussion

 Server problems
« Back · 1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · Next »
 Return to top of page · Post #: 106 · Written at 11:31:26 AM on 15 September 2017.
GTC's avatar
 GTC
 Location: Sydney, NSW
 Member since 28 January 2011
 Member #: 823
 Postcount: 4393

^^ I have seen that, too, but more often what I find is that I can read some posts and reply, but thereafter the sluggishness appears. I did ask Brad about locking mechanism he's using because I have a feeling that there maybe some sort of resource contention behind this, such as a resource lock in a loop (not being released) causing a transaction timeout at another level.

Or it could be something else altogether, like a combination of things, and what fun that is.


 
 Return to top of page · Post #: 107 · Written at 12:39:42 PM on 15 September 2017.
Brad's avatar
 Administrator
 Location: Greenwich, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 4658

Sorry, I didn't see the question. Record locking is done for writing to the database but is not needed for reading from it. There is normally an application lock for the 'concurrent users' meter in the footer of the page as this number is generated by the session manager, not the database. This has been disabled since the move to the new server for diagnosis reasons but it's obvious that function isn't the cause so both that and the visits counter will be re-installed on Sunday.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
Brad.

A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 108 · Written at 3:18:42 PM on 15 September 2017.
GTC's avatar
 GTC
 Location: Sydney, NSW
 Member since 28 January 2011
 Member #: 823
 Postcount: 4393

Are you using SQL Server?


 
 Return to top of page · Post #: 109 · Written at 5:00:02 PM on 15 September 2017.
Brad's avatar
 Administrator
 Location: Greenwich, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 4658

No, MS Access.

I've wanted to convert for about six years now but never had the time, despite installing SQL on a previous server.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
Brad.

A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 110 · Written at 5:34:09 PM on 15 September 2017.
Robbbert's avatar
 Location: Sydney, NSW
 Member since 18 September 2015
 Member #: 1801
 Postcount: 791

No, MS Access.

My eyes nearly popped out of my head with disbelief when I saw that.


Surely MySQL or similar could be used, like many other sites do.


 
 Return to top of page · Post #: 111 · Written at 6:38:29 PM on 15 September 2017.
GTC's avatar
 GTC
 Location: Sydney, NSW
 Member since 28 January 2011
 Member #: 823
 Postcount: 4393

Methinks this site may be pushing the limits of MS Access by now.


 
 Return to top of page · Post #: 112 · Written at 10:37:35 PM on 15 September 2017.
Brad's avatar
 Administrator
 Location: Greenwich, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 4658

MS Access is good for 4GB and we aren't close to that. The version of SQL Server I had running was SQL Express 2005, which is basically a free version of SQL Server with a 4GB limit applied. It would be perfect if I had the time to install it on the new server, set it so it was secure (there's a different setup process to Access) and then migrate and test. It won't happen any time soon unfortunately.

Robbbert: MySQL, whilst I understand there is a version for Windows, is native to the Unix environment. I've always been a believer in keeping apps designed for Unix on Unix servers and those for Windows only on Windows servers. Most share that view for live services.

The thought that the database may be corrupted or overloaded isn't a new one and it has been tested under a different version of this site which never went live and worked fine. At this point in time I am still convinced that an ASP file on the site is the cause and simply contains a coding error. The time taken is simply because there's a lot of files to work through.

I am hoping that I can vastly reduce the size and complexity of the file I plan on working on this Sunday.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
Brad.

A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 113 · Written at 11:22:12 PM on 15 September 2017.
Brad's avatar
 Administrator
 Location: Greenwich, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 4658

Talk about the database here reminded me to fix the open HTML tags in Pete's post in the Insurance thread. I've done this, applied some MS updates and rebooted the server - hence the brief outage that just happened.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
Brad.

A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 114 · Written at 11:43:11 AM on 16 September 2017.
Robbbert's avatar
 Location: Sydney, NSW
 Member since 18 September 2015
 Member #: 1801
 Postcount: 791

Hope it all works out on Sunday. Smile

Not sure if you saw my message elsewhere about unneeded /div tags in each page. Presumably they won't have an effect, but...


 
 Return to top of page · Post #: 115 · Written at 11:47:38 AM on 16 September 2017.
Brad's avatar
 Administrator
 Location: Greenwich, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 4658

The tags should all be even Steven. A large chunk of code was "absent" due to the formatting error in Pete's post. Should be okay now, though any excess code is under review when I go over each of the site's files.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
Brad.

A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 116 · Written at 12:26:46 PM on 16 September 2017.
GTC's avatar
 GTC
 Location: Sydney, NSW
 Member since 28 January 2011
 Member #: 823
 Postcount: 4393

I thought the database size limit is 2GB, although it's not that aspect I had in mind.

If you are using IIS, then this article on diagnosing 500 type errors suggests some approaches that may be useful if you haven't tried them already:

http://windowsitpro.com/web-development/iis-troubleshooting-tips-and-tricks

Hope you get a win.


 
 Return to top of page · Post #: 117 · Written at 7:52:59 AM on 17 September 2017.
Brad's avatar
 Administrator
 Location: Greenwich, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 4658

Just a reminder to everyone that I will be working on the site this morning and you may experience two or three short periods where you cannot access the site. All work will be done by about 11:00 NSW time.

GTC: The good news is that in the past I've combed through a few pages like that one and there were a few times when content on those pages brought me to a few pages here to check on things but all were in the clear unfortunately. Also, the database as it currently stands is only 202MB so we still have many years to go before headroom becomes a problem, and that's a good thing. About four years ago I went a bit further with this and split the database into two smaller ones. The one that stores the membership data and the forums (202MB) is separate to the one that takes care of site event logging, which is a bit larger at 756MB. This bigger one is refreshed every six months so it will never get so big that it can't handle things. Every December and June a copy of the logging database is archived and then the copy on the server is over-written with a blank one.

Whilst it is possible to store all content on the database, such as images and documents, I don't do this because if the database was ever corrupted there'd be a risk of losing everything on it.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
Brad.

A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 118 · Written at 10:24:36 AM on 17 September 2017.
Robbbert's avatar
 Location: Sydney, NSW
 Member since 18 September 2015
 Member #: 1801
 Postcount: 791

Should be okay now, though any excess code is under review when I go over each of the site's files.

Firefox still says there's excessive /div tags. But if you're happy, then it's not a problem. Only trying to help.


 
 Return to top of page · Post #: 119 · Written at 1:54:24 PM on 17 September 2017.
GTC's avatar
 GTC
 Location: Sydney, NSW
 Member since 28 January 2011
 Member #: 823
 Postcount: 4393

I guess something has changed in the Home... About Us... menu line. I intuitively click on the position where Discussion Forums used to be and now I get the Safety Warnings page.


 
 Return to top of page · Post #: 120 · Written at 2:46:19 PM on 17 September 2017.
Brad's avatar
 Administrator
 Location: Greenwich, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 4658

I did make a small.change there this morning. The announcement archive is now delinked as the front page forum is no longer with us. Believe it or not, I made the same mistake about an hour after the link was removed and ended up in the services directory.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
Brad.

A valve a day keeps the transistor away...

 
« Back · 1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · Next »
 You need to be a member to post comments on this forum.

Sign In

Username:
Password:
 Keep me logged in.
Do not tick box on a computer with public access.