It is currently 27 Apr 2024, 16:56

All times are UTC [ DST ]




 Page 1 of 1 [ 8 posts ] 
Author Message
 Post subject: LDDb.com was offline for about 6 hours this morning  Topic is solved
PostPosted: 27 Mar 2012, 08:52 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4551
Location: Tokyo
Has thanked: 295 times
Been thanked: 1147 times
Root cause seems to be the gnutls library I was playing with (versus the mod_ssl) for Apache2.
PANIC: fatal region error detected; run recovery


It filled up the /var/log/apache2/error.log up to 900GB and made the system unresponsive. Removing the error.log didn't fix the filesystem (still 100% used).

A reboot led to more problems:
sd 0:1:0:0: [sda] Got wrong page
sd 0:1:0:0: [sda] Assuming drive cache: write through


A full system check and recovery mode found even more problems:
EXT3-fs (sda2): orphan cleanup on readonly fs


System is back online now with a fixed filesystem. I also suspect VirtualBox to be somehow responsible for this.

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: LDDb.com was offline for about 6 hours this morning
PostPosted: 27 Mar 2012, 08:55 
Genuinely interested
Genuinely interested
User avatar

Joined: 06 Jun 2005, 06:04
Posts: 56
Location: Los Angeles
Has thanked: 14 times
Been thanked: 2 times
:x
_________________
SKT 400 LDR 600 CLD-D604 9Z5-00013 CLD-52 CLD-2080 CLD-D606 CLD-D501
Offline
 Profile  
 
 Post subject: Re: LDDb.com was offline for about 6 hours this morning
PostPosted: 27 Mar 2012, 09:00 
Absolute fan
Absolute fan
User avatar

Joined: 11 Jun 2008, 06:10
Posts: 1617
Location: Milky Way-Sol System-Terra-USA-North Carlolina.
Has thanked: 561 times
Been thanked: 239 times
Ah.....So nice to have ya back !!!!!!!!!!!!!!!1
_________________
Acta Non Verba .....
Si Vis Pacem Para Bellum ....
Si Gorgiamus Allos Subjectatos Nunc ......
Offline
 Profile  
 
 Post subject: Re: LDDb.com was offline for about 6 hours this morning
PostPosted: 27 Mar 2012, 23:13 
Jedi Candidate
Jedi Candidate
User avatar

Joined: 29 Jan 2006, 20:05
Posts: 2266
Location: United Kingdom
Has thanked: 0 time
Been thanked: 23 times
Hi Julien - what type of disaster recovery system do you have in place for LDDB currently?
I work in the IT industry so I know all about systems going down!!
Offline
 Profile  
 
 Post subject: Re: LDDb.com was offline for about 6 hours this morning
PostPosted: 27 Mar 2012, 23:54 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4551
Location: Tokyo
Has thanked: 295 times
Been thanked: 1147 times
laserdisc_fan wrote:
Hi Julien - what type of disaster recovery system do you have in place for LDDB currently?


I have:

  • a remote daily full backup (about 500MB, backup'ing all the covers would go almost to 3GB) stored in a separate backup server, keeping 10 days worth of backup. That includes all the /etc config files needed to reinstall a new server quickly, the webmail mailboxes, user accounts, MySQL full dump (database by database), /boot, etc.
  • a local daily backup (same) keeping 15 days at hand.
  • a laptop-based development site 100% identical to the main server on my Win 7 laptop (the code will adapt to Linux and Windows transparently)
  • weekly backup also pulled from remote to my laptop
  • all modifying (insert/update/delete) MySQL queries are stored in a local binary log (1 year)
  • all modifying (insert/update/delete) MySQL queries are stored in a local text log (1 month)

The target is to lose at most 24h of activity if the server turns brain dead, down to only a few minutes if I can still retrieve the text MySQL log files from the harddrives.

Most of the backup in binary/text form was added when the first free hosting I was using went south (locking user data) and over the years moving from VIA servers to DELL servers.

I feel safe enough to be able to rebuild a whole server from scratch within hours.

In case you didn't notice, I'm a little paranoid. Got that from an old story where the 80MB HDD on a 386SX16 PC died on me while I was almost finishing Ultima Underworld. The HDD also had the family accounting and several other projects. After that I have been keeping backups of things important to me in different locations. Saved me quite a few times.

Regards,
Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: LDDb.com was offline for about 6 hours this morning
PostPosted: 01 Apr 2012, 22:57 
True fan
True fan
User avatar

Joined: 04 May 2010, 22:25
Posts: 378
Location: United States
Has thanked: 0 time
Been thanked: 2 times
Did you ever finish Ultima Underworld?
Offline
 Profile  
 
 Post subject: Re: LDDb.com was offline for about 6 hours this morning
PostPosted: 01 Apr 2012, 23:59 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4551
Location: Tokyo
Has thanked: 295 times
Been thanked: 1147 times
flcl4evr wrote:
Did you ever finish Ultima Underworld?


YES! I re-did it all on a brand new HDD 8-)

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: LDDb.com was offline for about 6 hours this morning
PostPosted: 18 Apr 2012, 07:18 
Confirmed Padawan
Confirmed Padawan
User avatar

Joined: 10 Oct 2006, 17:10
Posts: 3742
Location: United Kingdom
Has thanked: 5 times
Been thanked: 4 times
I've noticed site down for a brief few minutes this morning while posting pm. I gave it a while and site was back up.
Time was around 7am it did it again! Just before post this post.
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 8 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: