The Halloween Horror Strikes Again

Important forum announcements.
Post Reply
User avatar
Keith Robinson
Site Administrator
Posts: 723
Joined: 05 Apr 2005, 22:06
Location: Georgia, USA
Contact:

The Halloween Horror Strikes Again

Post by Keith Robinson »

I just wanted to drop in and let you all know what happened to the forums over the last few days.

Obviously they didn't work! Most of the database was fine except for one particular table named "posts," which not by coincidence contains all your posts and is naturally the biggest table in the entire database. Sometimes it breaks, crashes, etc, and normally it's a simple task of running a "repair table" command. Once I do that, the table is fixed in less than 5 seconds and everything is fine.

Once I was alerted to the problem on October 29th (thanks, Nigel!), I went ahead with the usual repair -- only this time it REALLY broke. I actually heard something rattle and snap, and a piiiing-zip! as a bolt flew off. Ooh, this was bad. I looked for the bolt but couldn't find it. Also, a serpentine belt had snapped, rendering the entire system useless. The only way to fix this was to bring in HostGator's tech support.

The problem was, HostGator had bigger problems to content with. They had an active "status update" post running to say that they were having MAJOR problems and many, many sites were down. This also meant they were deluged with tech support requests, and our forums problem would have to wait. I had no problem with their reasoning, and it was just a case of waiting patiently while they got around to it.

Today they responded with this:
Thank you for contacting HostGator! I understand that you are still seeing issues with one of your databases and you have not been able to repair it. First of all, I would like to offer my sincerest of apologies for the issues that have happened to your server.

I found that when this issue first started the system started automatically attempting to repair your database but it's likely that this was interrupted as we discovered the extent of the issue. I needed to remove the previous temporary file so that I could run the repair again. I've repaired that database but there is a possibility that there was some data loss during this process. If you find any missing posts or post information on your site then please reply back to let us know.

We have a backup of your database from Sat Oct 25 15:02:13 CDT 2014 which we could use to restore it if needed. Just let us know if this is needed.
As you can see, everything appears to be running normally now, and I believe we have more recent posts than October 25th, so I vote we leave things alone unless someone happens to come across something dodgy-looking. If there's a missing or corrupt post, then so be it. It's either that or we go back to the 25th.

Thanks for your patience. Now you can resume!

By the way, I noticed that this is not the first time we've had Halloween attacks:
http://www.enidblytonsociety.co.uk/foru ... =13&t=5095
User avatar
Anita Bensoussane
Forum Administrator
Posts: 26772
Joined: 30 Jan 2005, 23:25
Favourite book/series: Adventure series, Six Cousins books, Six Bad Boys
Favourite character: Jack Trent, Fatty and Elizabeth Allen
Location: UK

Re: The Halloween Horror Strikes Again

Post by Anita Bensoussane »

Thanks for the run-down of what happened, Keith. It's great to be able to access our lovely forum community once again - I missed it! :D
"Heyho for a starry night and a heathery bed!" - Jack, The Secret Island.

"There is no bond like the bond of having read and liked the same books."
- E. Nesbit, The Wonderful Garden.


Society Member
User avatar
sixret
Posts: 4130
Joined: 16 Aug 2006, 14:25
Favourite book/series: Five Find-Outers,Mr.Twiddle,Barney R
Favourite character: Mr.Twiddle,Fatty,Saucepan,Snubby

Re: The Halloween Horror Strikes Again

Post by sixret »

Thank you so much, Keith. :D
I stand with justice and the truth. Palestine will be free from the river to the sea.

Learn the history. Do research.

The hypocrisy, double standard, prejudice and bigotry own by some people is so obvious.Shame on them!
Jack400
Posts: 1933
Joined: 13 Jun 2012, 17:06
Favourite book/series: Famous Five / Five Find-Outers
Location: UK

Re: The Halloween Horror Strikes Again

Post by Jack400 »

And thanks from me too, Keith :D
I tried a site that checks whether it is "just me"- and it said that it was. Then realized that it was only checking the ' first page'- the one that I too could get. :roll:
Thanks again.
Jack
Society Member
User avatar
Poppy
Posts: 5725
Joined: 24 Apr 2012, 16:06
Favourite book/series: Famous Five/ Adventure Series/ Malory Towers
Favourite character: George Kirrin, Andy, Jack Trent & Diana.
Location: UK

Re: The Halloween Horror Strikes Again

Post by Poppy »

Thanks for the information, Keith. It's great to see the Forums back up and running again! :D :D
"Beware of young men with long hair - that's what dad says, isn't it?"
Pat, Holiday House


Poppy's Best of Books

Society Member
User avatar
John Pickup
Posts: 4876
Joined: 30 Oct 2013, 21:29
Favourite book/series: Barney mysteries
Favourite character: Snubby
Location: Notts

Re: The Halloween Horror Strikes Again

Post by John Pickup »

Thanks for the explanation, Keith. It's great to be back.
Society Member
User avatar
Eddie Muir
Posts: 14566
Joined: 13 Oct 2007, 22:28
Favourite book/series: Five Find-Outers and Dog
Favourite character: Fatty
Location: Brighton

Re: The Halloween Horror Strikes Again

Post by Eddie Muir »

Thanks indeed, Keith. It's great to be back! :D
'Go down to the side-shows by the river this afternoon. I'll meet you somewhere in disguise. Bet you won't know me!' wrote Fatty.

Society Member
User avatar
Lucky Star
Posts: 11485
Joined: 28 May 2006, 12:59
Favourite book/series: The Valley of Adventure
Favourite character: Mr Goon
Location: Surrey, UK

Re: The Halloween Horror Strikes Again

Post by Lucky Star »

Thanks Keith. It is lovely to see the lights back on here and everyone still around. I was having withdrawal symptons from this place. :D
"What a lot of trouble one avoids if one refuses to have anything to do with the common herd. To have no job, to devote ones life to literature, is the most wonderful thing in the world. - Cicero

Society Member
User avatar
Anita Bensoussane
Forum Administrator
Posts: 26772
Joined: 30 Jan 2005, 23:25
Favourite book/series: Adventure series, Six Cousins books, Six Bad Boys
Favourite character: Jack Trent, Fatty and Elizabeth Allen
Location: UK

Re: The Halloween Horror Strikes Again

Post by Anita Bensoussane »

Sorry - we've had problems with the forums again over the last hour, and with the main website too. All seems to be working at the moment but I've notified Keith in case anything needs doing.
"Heyho for a starry night and a heathery bed!" - Jack, The Secret Island.

"There is no bond like the bond of having read and liked the same books."
- E. Nesbit, The Wonderful Garden.


Society Member
User avatar
Daisy
Posts: 16632
Joined: 28 Oct 2006, 22:49
Favourite book/series: Find-Outers, Adventure series.
Location: Stoke-On-Trent, England

Re: The Halloween Horror Strikes Again

Post by Daisy »

Thanks Anita. I was on the site when it went strange - said too much traffic - or words to that effect. Fingers crossed it isn't a serious problem.
'Tis loving and giving that makes life worth living.

Society Member
User avatar
Anita Bensoussane
Forum Administrator
Posts: 26772
Joined: 30 Jan 2005, 23:25
Favourite book/series: Adventure series, Six Cousins books, Six Bad Boys
Favourite character: Jack Trent, Fatty and Elizabeth Allen
Location: UK

Re: The Halloween Horror Strikes Again

Post by Anita Bensoussane »

Yes, it said something about us exceeding the amount of traffic allowed per hour. I hope the problem isn't going to recur every hour!
"Heyho for a starry night and a heathery bed!" - Jack, The Secret Island.

"There is no bond like the bond of having read and liked the same books."
- E. Nesbit, The Wonderful Garden.


Society Member
User avatar
Moonraker
Posts: 22387
Joined: 31 Jan 2005, 19:15
Location: Wiltshire, England
Contact:

Re: The Halloween Horror Strikes Again

Post by Moonraker »

I would think that HostGator needs to review this, as I am sure our traffic wasn't that high at the time it went down. I too emailed Keith with a PrtSc of the error message. If ever the forums go down for a prolonged time, I will post any updates on our Facebook page.
Last edited by Moonraker on 06 Nov 2014, 12:59, edited 1 time in total.
Society Member
User avatar
Daisy
Posts: 16632
Joined: 28 Oct 2006, 22:49
Favourite book/series: Find-Outers, Adventure series.
Location: Stoke-On-Trent, England

Re: The Halloween Horror Strikes Again

Post by Daisy »

It's good to have an alternative route to find out what's happening - I found facebook useful last time too.
'Tis loving and giving that makes life worth living.

Society Member
User avatar
Moonraker
Posts: 22387
Joined: 31 Jan 2005, 19:15
Location: Wiltshire, England
Contact:

Re: The Halloween Horror Strikes Again

Post by Moonraker »

Great minds, Daisy! I suddenly though of our Facebook page, and thought that that might be more ethical than it appearing as if I was plugging my own forum, so I have edited the above post!
Society Member
User avatar
Courtenay
Posts: 19275
Joined: 07 Feb 2014, 01:22
Favourite book/series: The Adventure Series, Galliano's Circus
Favourite character: Lotta
Location: Both Aussie and British; living in Cheshire

Re: The Halloween Horror Strikes Again

Post by Courtenay »

Anita Bensoussane wrote:Sorry - we've had problems with the forums again over the last hour, and with the main website too. All seems to be working at the moment but I've notified Keith in case anything needs doing.
Oh good - glad to know it wasn't my computer or wi-fi connection.
Anita Bensoussane wrote:Yes, it said something about us exceeding the amount of traffic allowed per hour. I hope the problem isn't going to recur every hour!
Is this a discussion forum, or the M25?? :shock:

Image
Society Member

It was a nuisance. An adventure was one thing - but an adventure without anything to eat was quite another thing. That wouldn't do at all. (The Valley of Adventure)
Post Reply