dopetalk does not endorse any advertised product nor does it accept any liability for it's use or misuse

This website has run out of funding so feel free to contribute if you can afford it (see footer)

Author Topic: site died and needed a database restore.  (Read 210 times)

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6509
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:October 20, 2021, 05:43:37 AM
  • Deeply Confused Learner
  • Profession: IT Engineer
site died and needed a database restore.
« on: November 04, 2015, 08:51:27 AM »
i have no idea why the site died and the DB crashed.

some data may have been lost. check this. i take backups often so hopefully any loss will be between 0-6 hours.

these are the only log entries i can find (mysqld):

151103 16:58:46
/usr/libexec/mysqld: Incorrect key file for table './smf209/smf209_sessions.MYI'; try to repair it
151103 16:58:46
Got error 127 when reading table './smf209/smf209_sessions'
[/color]

opened a problem report with SMF, FWIW: http://www.simplemachines.org/community/index.php?topic=540927.0
« Last Edit: November 04, 2015, 09:03:13 AM by Chipper »
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
I do not condone or support any illegal activities. All information is for theoretical discussion and wonder.
All activities discussed are considered fictional and hypothetical. Information of all discussion has been derived from online research and in the spirit of personal Freedom.

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6509
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:October 20, 2021, 05:43:37 AM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: site died and needed a database restore.
« Reply #1 on: November 04, 2015, 09:01:26 AM »
from: http://serverfault.com/questions/183725/error-not-found-or-unable-to-stat-in-apache-logs-and-difference-in-httpd-conf

When this error starts populating your logs, you will be unable to access any information from your MySQL table. The fix is easy,

simply run a REPAIR TABLE on the affected table and your issue should be solved.

mysql>REPAIR TABLE <database>.<tablename>

But simply fixing the table wasn’t enough. I wanted to know what caused the table corruption in the first place. After a bit of research it looks like there are a number of possible reasons:

MySQL process is killed unexpectedly
Hardware issues
MySQL code or MyISAM/InnoDB code is suffering from bugs
An external program and server is modifying the same table at the same time
Unexpected system shutdown

... so i really have no real idea of why we failed.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
I do not condone or support any illegal activities. All information is for theoretical discussion and wonder.
All activities discussed are considered fictional and hypothetical. Information of all discussion has been derived from online research and in the spirit of personal Freedom.

Offline suboxstitute

  • Full Member
  • ***
  • Join Date: Jun 2015
  • Location: Upper Midwest
  • Posts: 219
  • Reputation Power: 12
  • suboxstitute is new on the scene.
  • Gender: Female
  • Last Login:April 06, 2021, 01:44:25 PM
Re: site died and needed a database restore.
« Reply #2 on: November 04, 2015, 11:38:32 AM »
I posted a reply in the "royals" thread (it was a fairly stupid reply so no biggie) but that post is gone... it was right before the site went down.  If that helps you, Chipper....
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
"It is no measure of health to be well adjusted to a profoundly sick society."

Jiddu Krishnamurti, Indian philosopher 1895-1986

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6509
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:October 20, 2021, 05:43:37 AM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: site died and needed a database restore.
« Reply #3 on: November 04, 2015, 12:09:16 PM »
I wish I could work with that but I'm at a loss as to why the system died.

sorry you lost data but next time, I will try to repair the table in question before I restore the whole DB.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
I do not condone or support any illegal activities. All information is for theoretical discussion and wonder.
All activities discussed are considered fictional and hypothetical. Information of all discussion has been derived from online research and in the spirit of personal Freedom.

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6509
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:October 20, 2021, 05:43:37 AM
  • Deeply Confused Learner
  • Profession: IT Engineer
Re: site died and needed a database restore.
« Reply #4 on: November 04, 2015, 04:57:07 PM »
it may be memory related. shirobug suggests I check running processes and free memory every 30 mins. good idea.

sorry about this guys.
friendly
0
funny
0
informative
0
agree
0
disagree
0
like
0
dislike
0
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
No reactions
I do not condone or support any illegal activities. All information is for theoretical discussion and wonder.
All activities discussed are considered fictional and hypothetical. Information of all discussion has been derived from online research and in the spirit of personal Freedom.

Tags:
 

Related Topics

  Subject / Started by Replies Last post
3 Replies
158 Views
Last post March 09, 2015, 03:57:56 PM
by Chip
1 Replies
844 Views
Last post March 25, 2015, 07:46:37 AM
by andrew
0 Replies
141 Views
Last post July 23, 2015, 09:43:28 PM
by Chip
10 Replies
293 Views
Last post October 28, 2015, 09:02:18 PM
by Anti-hero
0 Replies
2363 Views
Last post January 28, 2016, 03:48:27 AM
by candy
13 Replies
7052 Views
Last post March 27, 2016, 01:07:16 PM
by Jega
9 Replies
4993 Views
Last post April 05, 2016, 12:00:23 PM
by Jethro
22 Replies
6292 Views
Last post April 26, 2016, 11:11:00 PM
by Taytoechip
0 Replies
2300 Views
Last post January 24, 2018, 03:09:51 PM
by Chip
0 Replies
196 Views
Last post June 11, 2021, 05:30:04 PM
by Chip


dopetalk does not endorse any advertised product nor does it accept any liability for it's use or misuse





TERMS AND CONDITIONS

In no event will d&u or any person involved in creating, producing, or distributing site information be liable for any direct, indirect, incidental, punitive, special or consequential damages arising out of the use of or inability to use d&u. You agree to indemnify and hold harmless d&u, its domain founders, sponsors, maintainers, server administrators, volunteers and contributors from and against all liability, claims, damages, costs and expenses, including legal fees, that arise directly or indirectly from the use of any part of the d&u site.


TO USE THIS WEBSITE YOU MUST AGREE TO THE TERMS AND CONDITIONS ABOVE


Founded December 2014
SimplePortal 2.3.6 © 2008-2014, SimplePortal