Jump to content


Database Issue


30 replies to this topic

#1 Bonaparte

Bonaparte

  • Christmas Moose


    Posts: 14384
    Joined: 22-June 06
    Member: 822
    Country: Belgium

Posted 04 December 2012 - 12:25 AM

Some things didn't go as expected today...

The popularity of a certain review was slowing EB down, and while restarting the server (to take into account a few new settings) part of the database got corrupted. After several recovery attempts it was clear the corruption was in too many tables and I decided to fallback to the latest backup which was from noon time today (CET). So the backup was about 10 hours old when it was restored meaning that whatever happened in those 10 hours is gone. I can't even try to explain how bad this makes me feel.

Good news is that Asbjørn :wub: , super expert on Linux/PHP/Apache/MySQL and husband of our Fellow Cecile :wub: , has now done a proper tuning of our (powerful) server. He'll continue to monitor our server and re-tune parameters till we get everything out of it.

- A tired Bonaparte

Want to find out more about our Reviewers Academy? Just click the logo.



Posted Image



New Member? Read This | Questions? Need Help? Ask Here



Site Guidelines | Eurobricks FAQ | Visual User Guide






#2 Darkdragon

Darkdragon

  • Destroyed Dreams of Super-Santa


    Posts: 5109
    Joined: 22-November 10
    Member: 14331
    Country: USA

Posted 04 December 2012 - 12:36 AM

Get some sleep now Boney :classic:

Glad the site is back up quickly (and running so fast!).  Asbjørn :wub:

#3 TheLegoDr

TheLegoDr

  • Yellow Panel Expert


    Posts: 4350
    Joined: 18-July 11
    Member: 19128
    Country: USA

Posted 04 December 2012 - 01:01 AM

Thanks for the update. I noticed a few of my posts were missing, but nothing major.

Thanks to everyone at EB for working hard all the time for our viewing pleasure! I agree, take a break! haha
Posted Image   Posted Image  Posted Image   Posted Image   Posted Image  Posted Image

flickr
See my collection

#4 Niku

Niku

  • Wants two initials


    Posts: 1492
    Joined: 26-December 10
    Member: 14912
    Country: Guatemala

Posted 04 December 2012 - 01:15 AM

Thanks for the efforts guys, get a well deserved rest.

Posted Image


Spoiler


#5 Alasdair Ryan

Alasdair Ryan

  • Technic Hall of Fame Editor


    Posts: 5327
    Joined: 22-November 09
    Member: 8292
    Country: Scotland

Posted 04 December 2012 - 01:19 AM

I never know it happened since I was busy building,Good to see you got it fixed. :bonaparte:

A fellow member over in the technic forum said he had lost his post,this would explain why.
Posted Image

Updated 02/08/12
Posted Image

#6 lightningtiger

lightningtiger

  • Doing the Chicken Dance


    Posts: 19071
    Joined: 28-October 09
    Member: 7997
    Country: Australia

Posted 04 December 2012 - 02:00 AM

Yep and this explains why posting half the things this morning was very slow indeed.
Get some rest 'Bonaparte'.....you work is done for the day. :classic:

#7 just2good

just2good

  • Bothan Spy #8


    Posts: 5403
    Joined: 05-January 09
    Member: 4916
    Country: USA (Florida)

Posted 04 December 2012 - 02:02 AM

Yea, the 'New Content' feature hasn't been working for me all day. :sad:

#8 Zepher

Zepher

  • Green!


    Posts: 9106
    Joined: 04-June 08
    Member: 3241

Posted 04 December 2012 - 04:00 AM

Eh, it's better than what we had last time around!  Thanks for getting us back online so fast, staff!  :wub:

Lord Lawrence Boomingham


&


Lil' Zepher In Mafia School


#9 Brickdoctor

Brickdoctor

  • Look at my Post Count!


    Posts: 21326
    Joined: 06-June 10
    Member: 11254
    Country: California, USA

Posted 04 December 2012 - 04:45 AM

Thanks for the hard work you put into this forum, guys. :thumbup:

#10 kotaco

kotaco

    Posts: 66
    Joined: 27-October 11
    Member: 21203
    Country: United States

Posted 04 December 2012 - 05:43 AM

Are you running the latest forum software (3.4.0) ?
Posted Image
- - - - - - - - - - - - - - - - - Visit Us Today @ Emergency Bricks! - - - - - - - - - - - - - - - -

#11 PsyKater

PsyKater

  • I am Adriano. Please be nice.


    Posts: 2123
    Joined: 03-August 12
    Member: 30022
    Country: Germany

Posted 04 December 2012 - 06:00 AM

No database errors during Mafia!

As the site was up again after the crash all zhe posts were there, but a bit messed up. Did you save these tables so that one can recreate the posts in important threads (like news, mafia, heroica)
- PsyKater [psyː'kɑtɐ]

Posted ImagePosted ImagePosted Image

Stigveladi Kötturin, the Ghost Buster

in Sandy's Heroica! The RPG!

247 years old Dwarven Mage

[stats] | [story] | [intro] | [currently on the Fields of Glory]

Timezone: CEST (UTC/GMT+2)


Retak Yps, Nephilim Necromancer

in Sandy's Heroica RPG - Cruel Angel's Thesis

2013 years old male Fenerian Necromancer


Posted Image

We opened a new BrickLink Store for you: steinreich24.com - From fans for fans! Learn more about our idea in the Bazaar!


#12 Shadows

Shadows

  • Awesome, brilliant, not redundant.


    Posts: 14510
    Joined: 30-April 07
    Member: 1558
    Country: USA

Posted 04 December 2012 - 06:29 AM

Thanks Boney and Ace! :thumbup:

Shadows is looking for stalkers. Yep, you heard me right. CLICKY!



New Member? Read This | Questions? Need Help? Ask Here
Site Guidelines | Eurobricks FAQ | Visual User Guide | Tutorials


#13 Mencot

Mencot

  • No! This is Maersk


    Posts: 912
    Joined: 25-December 11
    Member: 23524
    Country: Finland

Posted 04 December 2012 - 06:35 AM

Thanks for the work to get us up again so quickly guys
MyBricklink store   Myflickr

EB Mafia history:

Aperture Academy Mafia. Silvercity Mafia. CMF Mafia I.  Hinckley´s Minimal Mafia. Ragnarök Now Redux. TrumpetKing´s CMF Mafia 2. Mafia Sunset, Jamesn´s Red Menace Mafia.


Now playing as:

Posted Image

Cosplay Gandolf the wiz  in Def´s The Cosplay (Mafia school)



Keliim the Cruel in Heroica RPG

Stats


#14 Palathadric

Palathadric

  • Makes other members' internet speeds seem ridiculously fast


    Posts: 5441
    Joined: 30-July 11
    Member: 19379
    Country: Great Unknown

Posted 04 December 2012 - 08:23 AM

Thank you, Boney! :wub:
They that love God will never meet for the last time.
This life isn't the end. We will meet again.
Posted Image     Posted Image     Posted Image
Brickshelf Account
See my work in the Official Lego sets made in LDraw topic

#15 herrJJ

herrJJ

    Posts: 775
    Joined: 02-November 12
    Member: 32797
    Country: Germany

Posted 04 December 2012 - 08:32 AM

Thanks for the work and all the time you all spent on bringing EB back to life. Though it's a pity that some posts are missing, but that is not as important as the whole system being up. Much will be restored by the users :sweet:
Posted ImagePosted ImagePosted Image
Playing Nessa Anárion in Heroica, trying to find the Hook on the Other Hand on Quest #69
[STATS] and [STORY]

Shooting session with Nessa on flickr

Posted Image
Playing Heron Jujube, killed on Night One, raised as an undead on Night Two but perished again on Day Three, then resurrected on Day Four and finally died on Night Six (so close) in Sandy's Cruel Angel's Thesis Mafia-MMORPG



We opened a new BrickLink Store: steinreich24.com - From fans for fans! Learn more about our idea in the Bazaar!


Timezone: CEST (UTC/GMT+2)


#16 Mr Spielbrick

Mr Spielbrick

  • Worse than iOS 6 Maps


    Posts: 426
    Joined: 01-November 07
    Member: 2148
    Country: The Netherlands

Posted 04 December 2012 - 08:35 AM

Many thanks to everyone who has worked and is working behind the scenes at Eurobricks. The site usually functions brilliantly, and it's the best-moderated forum out there, in my experience. You've had to face some technical hiccups recently - thanks for ironing these out as fast as possible. I don't think I want to imagine how much effort goes into the site at times like those.

Of course, it's too bad that some posts have disappeared. But if LEGO teaches us anything, it's that you can always use your imagination and rebuild, perhaps in a way that is even better than the original creation. And that's exactly what the Eurobricks staff are constantly doing. Thank you.
Big fan of licensed themes and collectable minifigures.
Still trying to get a short brickfilm out there at some point...

#17 Scorpiox

Scorpiox

  • All Systems Go!


    Posts: 3827
    Joined: 04-March 11
    Member: 16378
    Country: Great Britain

Posted 04 December 2012 - 08:37 AM

Excellent work, sirs! :wub:

Haldor Skovgaard in Sandy's Heroica RPG.
[STATS] and [PROFILE]


#18 Peppermint_M

Peppermint_M

  • Now With 100% More Adventure™


    Posts: 7670
    Joined: 21-December 08
    Member: 4757
    Country: Wales.

Posted 04 December 2012 - 09:22 AM

Golf champ and saviour of EB?

Go Ace!

And now go to sleep Boney and dream of the days when we don't get major 'splosions on the forum from CMFs!

If there was no such thing as science; you'd be right.


New Member? Read This | Questions? Need Help? Ask Here

Site Guidelines | Eurobricks FAQ | Visual User Guide | Tutorials


Tesni Hightribe


#19 Yooha

Yooha

  • Friends LDD MOCer Extraordinaire


    Posts: 936
    Joined: 31-December 10
    Member: 15037
    Country: Hungary

Posted 04 December 2012 - 09:22 AM

Oh, those CM bastards! :laugh:
(just kidding, thanks the effort)

#20 WhiteFang

WhiteFang

  • Beep beep!


    Posts: 15784
    Joined: 31-December 07
    Member: 2351
    Country: Singapore

Posted 04 December 2012 - 09:24 AM

Thank you both! :blush:

My BrickLink Store // Sign up for Reviewers Academy // Trains & Town Reviews // Black Knights Kingdom (EBRP) // Watch out EB News!

Click here to find out more about WhiteFang


New Member? Read This | Questions? Need Help? Ask Here

Site Guidelines | Eurobricks FAQ | Visual User Guide


My name is Wilhalm Bloodaxe and I am back to be part of the Ragnarök Now Redux.

Lord Kenneth Valise, Level 1 Knight, 28yrs old human
Power: 4 Health: 10/10 Gold: 10
Inventory: One potion, a Greatsword (WP: 3) and a Shield (SP: 2)


#21 roamingstudio

roamingstudio

  • Blue train track Guinness World Record pusher extraordinaire


    Posts: 1138
    Joined: 21-January 10
    Member: 9215
    Country: Switzerland

Posted 04 December 2012 - 09:31 AM

Were personal messages also lost during this episode?
Since our corporate IT / VoIP phones also died yesterday I dont blame you... and wish you luck for the future

#22 WhiteFang

WhiteFang

  • Beep beep!


    Posts: 15784
    Joined: 31-December 07
    Member: 2351
    Country: Singapore

Posted 04 December 2012 - 09:34 AM

View Postroamingstudio, on 04 December 2012 - 09:31 AM, said:

Were personal messages also lost during this episode?
I can't be sure, but I noticed some PMs which I have sent out during that period do not show at all. So, I believe these PMs are lost as well since they are no back up.

In fact, any simple actions done to the EB forum such as update of signature and voting in a poll, will not be revert,

My BrickLink Store // Sign up for Reviewers Academy // Trains & Town Reviews // Black Knights Kingdom (EBRP) // Watch out EB News!

Click here to find out more about WhiteFang


New Member? Read This | Questions? Need Help? Ask Here

Site Guidelines | Eurobricks FAQ | Visual User Guide


My name is Wilhalm Bloodaxe and I am back to be part of the Ragnarök Now Redux.

Lord Kenneth Valise, Level 1 Knight, 28yrs old human
Power: 4 Health: 10/10 Gold: 10
Inventory: One potion, a Greatsword (WP: 3) and a Shield (SP: 2)


#23 PsyKater

PsyKater

  • I am Adriano. Please be nice.


    Posts: 2123
    Joined: 03-August 12
    Member: 30022
    Country: Germany

Posted 04 December 2012 - 10:07 AM

I blame WhiteFang.  :grin:

Sorry my post tomorrow seems a bit rude to me now. Actually I was a bit annoyed as some posts I had put much effort in were posted yesterday. But all of this is not important. Let's enjoy this great community. And it is still unbelievable that this thing is run by volunteers and does not cost a penny (or a cent).

Many thanks to our hosts, admins and staff! You are doing a great job!

Finally a little question (to make the next crash even less nasty): How big is a database backup (not file backup)? Could it be made on a hourly basis? And to make the missing smartass line: Always expect the worst, backup before restart. :blush:

:wub: I love you guys! :wink:
- PsyKater [psyː'kɑtɐ]

Posted ImagePosted ImagePosted Image

Stigveladi Kötturin, the Ghost Buster

in Sandy's Heroica! The RPG!

247 years old Dwarven Mage

[stats] | [story] | [intro] | [currently on the Fields of Glory]

Timezone: CEST (UTC/GMT+2)


Retak Yps, Nephilim Necromancer

in Sandy's Heroica RPG - Cruel Angel's Thesis

2013 years old male Fenerian Necromancer


Posted Image

We opened a new BrickLink Store for you: steinreich24.com - From fans for fans! Learn more about our idea in the Bazaar!


#24 Calabar

Calabar

    Posts: 2198
    Joined: 11-April 10
    Member: 10232
    Country: Italy

Posted 04 December 2012 - 11:08 AM

Luckily this time the "damage" on the LDD forum has been very limited.
Thanks for the fasr resume of the forum.
"Official LEGO Sets made in LDD" topic: Read guidelines before posting!

#25 MstrOfPppts

MstrOfPppts

  • Lex Luthor, Bruce Wayne — what's the difference?


    Posts: 1105
    Joined: 18-December 10
    Member: 14752
    Country: Slovenia

Posted 04 December 2012 - 11:08 AM

So that's why I couldn't do anything yesterday evening before it all crashed ... I thought it was that good for nothing bluecoat Admiral tweaking my profile again :D

Thanks for fixing it and good job running this site!!!

Posted Image




Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users