Not logged inRybka Chess Community Forum
- - By Labyrinth (*****) Date 2012-06-20 11:35
Table './rybkaforum_net_@002d_mwf/posts' is marked as crashed and last (automatic?) repair failed

SELECT boardId, COUNT(*) AS newNum
FROM posts
WHERE boardId IN (:boardIds)
AND postTime > :prevOnTime
AND approved = 1
GROUP BY boardId

At 1:08 am MST
Parent - - By Uly (Gold) Date 2012-06-20 11:39
Continues? It has been going offline daily, as if downtime was scheduled. The problems have never stopped since they started.

I wonder if someone is doing something about it or if it's going to be a permanent problem (which would be fine as long as downtime is reliable, so one doesn't waste time checking the forum if one already knows it's going to be offline.)
Parent - - By Dadi Jonsson (Silver) Date 2012-06-20 11:50

> It has been going offline daily, as if downtime was scheduled.


I need more information about this and if other users are experiencing the same problem (I haven't seen it). Does it look like a network problem or a database problem (with an error message from the forum itself)? Does it always happen on or around the same time?
Parent - By Labyrinth (*****) Date 2012-06-20 13:11

>Does it always happen on or around the same time?


It happens roughly between 10 PM MST and 3 AM MST. I will try to narrow down the time.

On this occasion I time stamped it (1:08 AM MST), so I hope to keep better track of it this way.
Parent - By Uly (Gold) Date 2012-06-20 13:47
The forum doesn't load at all. Not even an error or anything.

The time it happens isn't very consistent, but it happens daily, and lasts from 30minutes to 2 hours, from about 4:30AM GMT to about 6:30AM GMT (or before as Garvin says).
Parent - - By Labyrinth (*****) Date 2012-07-02 11:52
Rybka forum down due to:

504 gateway timeout

Checked 9:28 pm MST (GMT - 7)
.. and again at 10:50 pm MST (GMT - 7)
Parent - - By Uly (Gold) Date 2012-07-03 07:31
And again today.

New server sucks.
Parent - - By Garvin Gray (****) Date 2012-07-03 09:30

> New server sucks.


A difficult task, but it sucks and blows at the same time.
Parent - By Uly (Gold) Date 2012-07-05 02:37

> A difficult task, but it sucks and blows at the same time.


AND stinks! Though I guess that's easy :lol:
Parent - - By Labyrinth (*****) Date 2012-07-04 11:46
Rybka forum down due to:

504 gateway timeout

7-3-12

Checked 9:54 pm MST (GMT - 7)
.. and again at 10:26 pm MST (GMT - 7)
Parent - - By Dadi Jonsson (Silver) Date 2012-07-04 12:29
I have found a possible reason for these problems. I have alerted the technical guys and they will be attempting a fix tonight (GMT time). During that time the server will probably be very slow.
Parent - By Dadi Jonsson (Silver) Date 2012-07-05 08:04
They believe that they found the issue. The DB instance is failing due to the naming convention of several databases on the server, so this is a global configuration problem with their setup. They are going to raise this with MySQL directly and hopefully we'll have a solution soon.
Parent - - By Labyrinth (*****) Date 2012-07-14 07:22
Rybka forum down due to:

Gateway timeout with 404

Checked 4:06 pm MST (GMT - 7) Jul 13 2012
..and again at 4:40 pm MST (GMT - 7) Jul 13 2012
Parent - By Uly (Gold) Date 2012-07-15 01:42
Yes, that was something new.
Parent - - By Labyrinth (*****) Date 2012-07-26 07:19
Forum was down for a long time, like from 8-9 PM MST, I don't know how long it was down after that I didn't check.
Parent - - By Uly (Gold) Date 2012-07-26 08:18
Hopefully for the last time!
Parent - - By Dadi Jonsson (Silver) Date 2012-07-26 21:24
Unfortunately not. I know the problem is related to a task which is run once a day, but I probably need to run it a few more times in order to understand why it causes these problems.
Parent - By Barnard (Bronze) Date 2012-07-26 23:38
can you virtualize the whole forum,so you will be able to do that task without the users having that problems more than 1 a day?
Parent - - By Labyrinth (*****) Date 2012-08-26 21:49
Forum was down again, around 2:30 pm MST.

http://img827.imageshack.us/img827/2673/namelessj.jpg
Parent - By Uly (Gold) Date 2012-08-27 01:21
I just hope this new server is much cheaper than the last one.
Parent - - By Labyrinth (*****) Date 2012-09-11 02:13
Forum down again, this time for a while:

9-10-12 3:11 pm MST

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@rybkaforum.net and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Then:

Query execution was interrupted

SELECT boardId, COUNT(*) AS newNum
FROM posts
WHERE boardId IN (:boardIds)
AND postTime > :prevOnTime
AND approved = 1
GROUP BY boardId

4:40 PM MST

Gateway Time-out

The gateway did not receive a timely response from the upstream server or application.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Parent - By Uly (Gold) Date 2012-09-11 02:19
At least, the downtimes now are random.
Parent - By Labyrinth (*****) Date 2012-10-30 01:11
5:36 PM MST "Nameless Forum" Too many connections
Parent - By Dadi Jonsson (Silver) Date 2012-06-20 11:48
The hosting company thought the problems were solved about a week ago, but the database crashed again today. They are analyzing the problem. Unfortunately there isn't much I can do about this, but at least they are taking this seriously and doing something about it.
- By Garvin Gray (****) Date 2012-06-20 13:15
About between 4am and 5am GMT each day.
- - By Garvin Gray (****) Date 2012-06-21 03:41
20 mins approx till 1 hour at least downtime
Parent - - By Barnard (Bronze) Date 2012-06-21 04:34
last downtime,yesterday,i was not able to log in here for 5 hours,from 6am (Spanish) to 11 am
Parent - - By Uly (Gold) Date 2012-06-21 04:42
The server crashed.
Parent - By Barnard (Bronze) Date 2012-06-21 08:08
yes,that is what i supossed

but from what im seeing,all the days is about 1 hour or 1 hour and a half down,6 am Spanish hour
- By Garvin Gray (****) Date 2012-07-04 08:08
Was down for about two hours, just came back online.
- - By Garvin Gray (****) Date 2012-07-23 04:17
Thought this should be reported. I have had no forum access issues for a few days now :smile:
Parent - - By Dadi Jonsson (Silver) Date 2012-07-24 22:50
I found the reason, but I need to do some more tests so you can expect the problem to reappear over the next few days.
Parent - By Uly (Gold) Date 2012-07-25 01:01
Out of curiosity, what was the reason?
Parent - By Uly (Gold) Date 2012-08-21 16:01
Just got a Gateway Time-out error when trying to access the forum at 3:27 PM GMT.
- By Garvin Gray (****) Date 2012-12-18 07:45
In the last couple of days I have been getting regular time outs, slow to load, or home page not loading at all when first trying to access. If the home page loads, then site gets slower and slower the more pages I try to access.

Powered by mwForum 2.27.4 © 1999-2012 Markus Wichitill