Re: Database's machine DOWN

2012-06-04 Thread Vincent Untz
Le dimanche 03 juin 2012, à 21:19 +0200, Olav Vitters a écrit :
 On Sun, Jun 03, 2012 at 06:02:38PM +0200, Andrea Veri wrote:
  we applied today a few updates on our main Mysql host (drawable) and a 
  faulty reboot prevents the machine to get up again.
  
  We've contacted the Red Hat IT already and hopefully the issue will be 
  fixed anytime soon. (no ETA though)
 
 Hardware (RAID) problems. This is going to take a while. Meaning:
 setting up mysql and restoring backups. People are still working on it.

Is the sql database for the elections impacted by this? If yes, is there
a risk that some votes got lost?

Cheers,

Vincent

-- 
Les gens heureux ne sont pas pressés.
___
foundation-list mailing list
foundation-list@gnome.org
https://mail.gnome.org/mailman/listinfo/foundation-list


Re: Database's machine DOWN

2012-06-04 Thread Olav Vitters
On Mon, Jun 04, 2012 at 09:02:13AM +0200, Vincent Untz wrote:
 Le dimanche 03 juin 2012, à 21:19 +0200, Olav Vitters a écrit :
  On Sun, Jun 03, 2012 at 06:02:38PM +0200, Andrea Veri wrote:
   we applied today a few updates on our main Mysql host (drawable) and a 
   faulty reboot prevents the machine to get up again.
   
   We've contacted the Red Hat IT already and hopefully the issue will be 
   fixed anytime soon. (no ETA though)
  
  Hardware (RAID) problems. This is going to take a while. Meaning:
  setting up mysql and restoring backups. People are still working on it.
 
 Is the sql database for the elections impacted by this? If yes, is there
 a risk that some votes got lost?

Took a while to figure out, but it is using a database on
button.gnome.org. One of the various machines without any service plan
in place, though more reliable than drawable (the machine that went down
for 2nd time due to hardware problems).

So no, not affected.

-- 
Regards,
Olav
___
foundation-list mailing list
foundation-list@gnome.org
https://mail.gnome.org/mailman/listinfo/foundation-list


Re: Database's machine DOWN

2012-06-04 Thread Olav Vitters
On Sun, Jun 03, 2012 at 09:19:43PM +0200, Olav Vitters wrote:
 On Sun, Jun 03, 2012 at 06:02:38PM +0200, Andrea Veri wrote:
  we applied today a few updates on our main Mysql host (drawable) and a 
  faulty reboot prevents the machine to get up again.
  
  We've contacted the Red Hat IT already and hopefully the issue will be 
  fixed anytime soon. (no ETA though)
 
 Hardware (RAID) problems. This is going to take a while. Meaning:
 setting up mysql and restoring backups. People are still working on it.

Back up:
* bugzilla.gnome.org
* extensions.gnome.org
* blogs.gnome.org

I haven't looked into the other databases that were running on the
affected machine (drawable).

To be clear:
- I just changed some easy settings
- Andrea Veri got various people involved, etc
- Stephen Smoogen from Fedora sysadmin team assisted
- Owen Taylor assisted in the 10min he had between flights

-- 
Regards,
Olav
___
foundation-list mailing list
foundation-list@gnome.org
https://mail.gnome.org/mailman/listinfo/foundation-list


Re: Database's machine DOWN

2012-06-04 Thread Richard Hughes
On 4 June 2012 08:02, Vincent Untz vu...@gnome.org wrote:
 Is the sql database for the elections impacted by this? If yes, is there
 a risk that some votes got lost?

Some bugs appear to have been lost, e.g.
https://bugzilla.gnome.org/show_bug.cgi?id=677387

Richard.
___
foundation-list mailing list
foundation-list@gnome.org
https://mail.gnome.org/mailman/listinfo/foundation-list


Re: Database's machine DOWN

2012-06-04 Thread Andrea Veri
On Mon, 04 Jun 2012, Richard Hughes wrote:

 On 4 June 2012 08:02, Vincent Untz vu...@gnome.org wrote:
  Is the sql database for the elections impacted by this? If yes, is there
  a risk that some votes got lost?
 
 Some bugs appear to have been lost, e.g.
 https://bugzilla.gnome.org/show_bug.cgi?id=677387

The backup we restored was one-day-older, so a few changes got indeed 
lost.

cheers,

Andrea


signature.asc
Description: Digital signature
___
foundation-list mailing list
foundation-list@gnome.org
https://mail.gnome.org/mailman/listinfo/foundation-list


Re: Database's machine DOWN

2012-06-04 Thread Olav Vitters
On Mon, Jun 04, 2012 at 08:46:50AM +0100, Richard Hughes wrote:
 On 4 June 2012 08:02, Vincent Untz vu...@gnome.org wrote:
  Is the sql database for the elections impacted by this? If yes, is there
  a risk that some votes got lost?
 
 Some bugs appear to have been lost, e.g.
 https://bugzilla.gnome.org/show_bug.cgi?id=677387

Sorry, forgot to put that in the announcement. We backup once per day,
so indeed all changes after that are gone. We might at one point get
that back, but reintegrating this is pretty difficult.

-- 
Regards,
Olav
___
foundation-list mailing list
foundation-list@gnome.org
https://mail.gnome.org/mailman/listinfo/foundation-list