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 2686 times)

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6648
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Yesterday at 05:53:23 PM
  • 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
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6648
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Yesterday at 05:53:23 PM
  • 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
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Offline suboxstitute

  • Jr. Member
  • **
  • Join Date: Jun 2015
  • Location: Upper Midwest
  • Posts: 199
  • 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: 6648
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Yesterday at 05:53:23 PM
  • 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
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

Offline Chip (OP)

  • Server Admin
  • Hero Member
  • *****
  • Administrator
  • *****
  • Join Date: Dec 2014
  • Location: Australia
  • Posts: 6648
  • Reputation Power: 0
  • Chip has hidden their reputation power
  • Gender: Male
  • Last Login:Yesterday at 05:53:23 PM
  • 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
Our Discord Server invitation link is https://discord.gg/jB2qmRrxyD

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
845 Views
Last post March 25, 2015, 07:46:37 AM
by andrew
0 Replies
4879 Views
Last post July 23, 2015, 09:43:28 PM
by Chip
13 Replies
11602 Views
Last post March 27, 2016, 01:07:16 PM
by Jega
9 Replies
8452 Views
Last post April 05, 2016, 12:00:23 PM
by Jethro
22 Replies
11974 Views
Last post April 26, 2016, 11:11:00 PM
by Taytoechip
0 Replies
5345 Views
Last post January 24, 2018, 03:09:51 PM
by Chip
0 Replies
4090 Views
Last post June 11, 2021, 05:30:04 PM
by Chip
1 Replies
4597 Views
Last post September 17, 2023, 09:12:04 PM
by smfadmin
0 Replies
673 Views
Last post January 15, 2024, 07:26:49 AM
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