Print Page - http://stats.gp-bikes.com/ SQL Down

Title: http://stats.gp-bikes.com/ SQL Down | *FIXED*
Post by: Napalm Nick on August 07, 2015, 07:55:44 PM

Stats server seems to be down/SQL database error :(

http://stats.gp-bikes.com/servers.php

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Jensler on August 07, 2015, 08:01:44 PM

Comes Beta 7?????!!! :o 8) 8) 8) ::) ::) ::)

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 07, 2015, 08:15:15 PM

hahahaha OMG is it Groundhog day ? Lool. ;D

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: matty0l215 on August 07, 2015, 08:17:29 PM

Shhh! i might be about to win 10 euros :-X

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 07, 2015, 08:18:56 PM

Lol. ;D

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Jensler on August 07, 2015, 08:26:10 PM

I 'm drive tomorrow in Holiday and had so been looking forward to the final round GPB :'( :'( :'( :'(

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: yan24 on August 07, 2015, 08:38:27 PM

Here is when I want to connect >:(

(http://img15.hostingpics.net/pics/121672screen059.jpg) (http://www.hostingpics.net/viewer.php?id=121672screen059.jpg)

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: HornetMaX on August 07, 2015, 08:38:53 PM

All Piboso servers seem to be down: GPB, KRP, WRS and MXB, both web and game/stats servers.

@Matty: don't count too much on those 10E :) Not yet at least.

MaX.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: yan24 on August 07, 2015, 08:54:56 PM

There has been already this problem not so long ago that his(her,its), but that to post(show) not this message

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: JJS209 on August 08, 2015, 08:03:16 AM

nice, we aint got beta7 and now we cant play 6c anymore.
what next?

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: PiBoSo on August 08, 2015, 10:47:07 AM

The hard disk drive of the master server is a goner.
Please have patience... The operative system must be reinstalled, configured, then the needed software installed, configured, and then the backups restored, data updated, servers restarted...

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: HornetMaX on August 08, 2015, 11:24:30 AM

Ouch ! It makes for an unusual week-end :)

MaX.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 08, 2015, 01:11:12 PM

Happened to me with the GPBOC server when I went away too! Nightmare.

I blame all this GPB next gen physics ;)

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: PiBoSo on August 08, 2015, 09:42:45 PM

Update.
Unfortunately, even the replacement disk failed. It seems that it's the motherboard to blame.
Tomorrow the dedicated server will be moved to a new PC.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 08, 2015, 10:04:58 PM

Thanks for update.

I suggest RAID 10 this time if possible 8)

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Corrie on August 09, 2015, 01:04:57 PM

Glad to hear that the problem was identified and that it wasn't a total loss! Will we need to register our license keys again or has all the information been retained? Thanks for the update, PiBoSo!

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: PiBoSo on August 09, 2015, 04:52:26 PM

There are daily backups.
All info has been saved, except for a few licenses sold between the last backup and the crash.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 09, 2015, 05:01:24 PM

Good news. 8)

Do you have any idea of a time for the servers being back please?

In 2 hours we hope to have the next round of our championship I would like to know if we should cancel for tonight if possible so I can tell the participants. :-\

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Corrie on August 09, 2015, 06:14:12 PM

Great news! Thanks for working to solve the issue so quickly.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: PiBoSo on August 10, 2015, 11:58:55 AM

An update: the new machine has been setup and all the data restored: http://stats.gp-bikes.com/records.php
Now the "only" task left is to recompile, upload and start the master servers.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 10, 2015, 11:59:53 AM

Thank you for the Update. Well done.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: PiBoSo on August 10, 2015, 05:19:57 PM

The master server is back up.
Please report if everything is working correctly.
As an added twist, the system is now 64 bits!
A partial rewrite of the code was needed to port the master servers from x86 to x64.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: matty0l215 on August 10, 2015, 05:58:50 PM

Working well for me :D

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: dibu on August 10, 2015, 06:09:42 PM

Respect! :)

During the weekend I often had to think about your stress with this crash.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Hawk on August 10, 2015, 06:19:17 PM

Agree with what Dibu says here Piboso.... Well done for what could not have been an easy job to sort out. Thank You! ;D 8)

Hawk.
PS: Does "64 bit" mean it will run faster and more efficient now?

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Davide74 on August 10, 2015, 07:08:08 PM

gogogogo thanks!

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: PiBoSo on August 10, 2015, 07:14:05 PM

Quote from: Hawk UK on August 10, 2015, 06:19:17 PM
PS: Does "64 bit" mean it will run faster and more efficient now?

Not really. The master server uses very little memory and handles very little data.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 10, 2015, 08:00:26 PM

All seems fine here.
Thank you for fast fix.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: HornetMaX on August 10, 2015, 08:18:29 PM

Quote from: Hawk UK on August 10, 2015, 06:19:17 PM
PS: Does "64 bit" mean it will run faster and more efficient now?

Hawk and his 64 bit fetish :)

MaX.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Hawk on August 10, 2015, 09:29:57 PM

Quote from: HornetMaX on August 10, 2015, 08:18:29 PM
Quote from: Hawk UK on August 10, 2015, 06:19:17 PM
PS: Does "64 bit" mean it will run faster and more efficient now?
Hawk and his 64 bit fetish :)

MaX.

LOL..... I have GPB on 64 bit too in the hope that it runs better and more efficient. ;D

I love my 64 bit world Max. ;D

Hawk.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: HornetMaX on August 10, 2015, 10:06:37 PM

Quote from: Hawk UK on August 10, 2015, 09:29:57 PM
Quote from: HornetMaX on August 10, 2015, 08:18:29 PM
Quote from: Hawk UK on August 10, 2015, 06:19:17 PM
PS: Does "64 bit" mean it will run faster and more efficient now?
Hawk and his 64 bit fetish :)

MaX.
LOL..... I have GPB on 64 bit too in the hope that it runs better and more efficient. ;D

That's like putting a "Turbo" sticker on a fiat panda and hope it goes faster.
Actually the sticker is probably more effective :)

MaX.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Hawk on August 10, 2015, 10:19:38 PM

I'm having a problem when I try to see the world servers:

I get an "Invalid login. Please register" message.

I have done a fresh install of GPB and entered my license key..... anyone know what's happening?

Hawk
PS: Thought it may have something to do with the main server crash so I posted this here. ;)

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 10, 2015, 10:25:20 PM

Are you sure your nickname is exactly right - not just the profile name?

Sorry egg sucking no doubt ::)

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Hawk on August 10, 2015, 10:34:09 PM

Quote from: Napalm Nick on August 10, 2015, 10:25:20 PM
Are you sure your nickname is exactly right - not just the profile name?

Sorry egg sucking no doubt ::)

Oooops!! I think you may have a point there. I originally registered my name as "Hawk_UK", when I reinstalled I created the first profile as "Hawk", then realised I need to create my original profile as "Hawk_UK" but I forgot to change the nickname section too..... I think? I'll take a quick look and get back to you on this one. :-\

EDIT: Yeah. You were exactly right Nick! I had left my nickname as "Hawk" and it should have been "Hawk_UK" as I originally registered with. Thanks for the reminder! ;D 8)

Hawk.

Title: Re: http://stats.gp-bikes.com/ SQL Down
Post by: Napalm Nick on August 10, 2015, 10:48:01 PM

I've never been so useful before it is scary ;D

PiBoSo Official Forum

GP Bikes => Support => Topic started by: Napalm Nick on August 07, 2015, 07:55:44 PM