Unknown database error
- Thread starter Matt_B
- Start date
- Status
Yep. Sorry about that.
An automatic software update overnight for some reason turned off the database server. It also turned off the monitor that checks the database server is running and restarts it if it's not.
As a result the site was down from 03:42 until 08:57.
An automatic software update overnight for some reason turned off the database server. It also turned off the monitor that checks the database server is running and restarts it if it's not.
As a result the site was down from 03:42 until 08:57.
homer
Well-Known Member
Not as many as Foxestalk, though, and all those great posters....
Nothing to do with the number of people on the site, but a problem elsewhere on the internet is causing a bottleneck for some sites on this server and overloading it. I'm trying to find a solution.
The server has 32GB RAM, plus a swap file, which is normally way more than enough for the sites that are hosted on it.
Problems on other sites meant the memory was all used, and the database server crashed and had to restart. That's what caused the error message.
I've been able to free up over 20GB RAM, so even if the problems on the other sites persist it should be a while before the memory is all used up again.
Problems on other sites meant the memory was all used, and the database server crashed and had to restart. That's what caused the error message.
I've been able to free up over 20GB RAM, so even if the problems on the other sites persist it should be a while before the memory is all used up again.
The site has been showing the database error message for the last hour or so - sorry about that.
I rebooted the server and when it started again, the database server refused to work. None of the obvious things would fix it so I had to trawl the web looking for a solution. Got there in the end.
I rebooted the server and when it started again, the database server refused to work. None of the obvious things would fix it so I had to trawl the web looking for a solution. Got there in the end.
- Status
Championship
| P | Pld | Pts | |
| 1 | Leicester | 44 | 94 |
| 2 | Leeds Utd | 44 | 90 |
| 3 | Ipswich | 43 | 89 |
| 4 | Southampton | 44 | 84 |
| 5 | West Brom | 44 | 72 |
| 6 | Norwich City | 44 | 72 |
| 7 | Hull City | 44 | 69 |
| 8 | Coventry City | 43 | 63 |
| 9 | Middlesbro | 44 | 63 |
| 10 | Preston | 44 | 63 |
| 11 | Cardiff City | 44 | 62 |
| 12 | Bristol City | 44 | 59 |
| 13 | Sunderland | 44 | 56 |
| 14 | Swansea City | 44 | 56 |
| 15 | Watford | 44 | 53 |
| 16 | Millwall | 44 | 53 |
| 17 | Stoke City | 44 | 50 |
| 18 | QPR | 44 | 50 |
| 19 | Blackburn | 44 | 49 |
| 20 | Plymouth | 44 | 48 |
| 21 | Sheffield W | 44 | 47 |
| 22 | Birmingham | 44 | 46 |
| 23 | Huddersfield | 44 | 44 |
| 24 | Rotherham Utd | 44 | 24 |
