News:

Wondering if this will always be free?  See why free is better.

Main Menu

Can someone tell me what this means....

Started by tk2012, November 07, 2008, 10:43:37 PM

Previous topic - Next topic

tk2012

SMF 2.0 b4.0
default theme

Started getting messages saying that the site was down a little while ago and went to visit it myself.  When I go there, I'm getting this on a white screen:

Table 'orstorm-rpms_org_community/motorstormrpms_org_community_messages' is marked as crashed and last (automatic?) repair failed

tk2012

When I go to my database, all the files have the normal utf-8 or other language next to it, but that one table says "In Use"

suggestions on what to do?

Deprecated

I never heard of that message.

You could go to your hosting cPanel and open phpMyAdmin on your database, and try the "repair table" actions. Sorry I don't recall the exact terminology.

tk2012

I did that and it is failing as stated in the message on the browser screen when trying to get to the URL

This is what I'm getting:

Deprecated

What table is that anyway? All the tables I know start out "smf_" ...

tk2012

If I would have used the database name as SMF it would be that.. At the time, I had three different forums and needed a way to differentiate them. 

I hit table structure and get the following:


Deprecated

Well my professional diagnosis is that you have a serious problem.

My official recommendation is that you should fix it so that it doesn't happen again!

No, seriously, and you can take this is my final answer: "I dunno." :)



You should mention if you have any other symptoms. There isn't much to go on here...

tk2012

Let's see.. the forum was working fine @ 9pm est.  I had a member join at 10pm est.. The forum is now crashed with that error.  I can't get anything else to show when going to the URL

Maybe you see something different?

www.motorstorm-rpms.org/community/index.php



I went into repair settings and everything matches up as normal.

tk2012

#8
I was able to make a back up of the table (I think that's what this is) that still says IN USE in phpmyadmin

I've attached it, so not sure if something there needs to be changed and/or even if something can be changed if I can just import the correct table back into the database?

Mod edit: Removed DB

tk2012

ok, I have a copy of it that table from a previous save and there is MUUCCCHHHH more info in the copy..  This table has like NOTHING in it... so

my question is...  do I delete the current one and then import the old one?

The old one is a back up in phpmyadmin itself

Adish - (F.L.A.M.E.R)

Never ever attach your database anywhere. Although that doesnt seem to be that as bascially the database would be like more than 1mb in most cases.

Remove it before anyone downloads it. (if its the database you are using)

tk2012

OK, I've made some progress on my own here...

I got the forum up and running, but the back up file of the "messages" table is from a month ago.  I would like to have a more recent back up of that file used which is from just over two weeks ago.

Here is my problem.

1- I created a new database in order to upload the more current back up  (no problems there)

2- When I import the backup, it says the admin table is in error which I don't need anyway.  I just want to get the "messages" table from that backup loaded to the new database.. that's all.  Then, I know what I need to do in order to bring it over to my current working database.

I know I'm going about this in an odd way probably, but...

Deprecated

Your new smf_messages won't work without your new smf_topics... and that's just the beginning of the problems.

Please be more specific, what is this "admin" table?

As an old timer engineer, I'll give you some advice. Whenever you are doing something in an "odd way" you are either way ahead of the curve or way behind the curve, and most of the time you're way way behind.

The way I see it (1) you have a reasonably current backup, (2) but it's broke, and (3) your forum won't work without it.

Please add any new information you have, or summarize what is keeping you from restoring your backup and moving on.

I may need to look at your table. I didn't download it when you posted it, probably because you removed it before I returned to the topic.

Tell me again which table it is. Please use the full correct name.

tk2012

#13
I have a forum which is working, but the "messages" table is not complete.

I have a complete back up which is more current, but can't get it to load...

so, why can't I just...

1- delete the current "messages" table (which I can put back if needed)

2- edit out the "messages" portion of the complete back up which won't load due to the admin table

3- import the "messages" section

...and considering I don't do anything with this type of thing for a living, I'll just be happy to be on a curve at all whether it be behind or ahead.   ;D

Deprecated

First of all, you can't just do that because it doesn't work. If you won't take my word for it, believe your own eyes.

Second, you didn't tell me what this mysterious "admin" table is. Please either answer the questions, or I can't help you.

tk2012

it says this when I import the complete backup it says this

No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

when I import the data backup it says this

#1146 - Table 'motorstorm-rpms_org_smf.motorstormrpms_org_community_admin_info_files' doesn't exist


Deprecated

This is getting very frustrating. Please PM me or otherwise direct me to your problem tomorrow (current time +12 hours) if you would like my continued assistance (i.e. bump your topic).

It's late and I'm tired and I seem to deal better with new problems when I'm tired, and deal poorly with old problems when I'm tired.

And don't neglect that somebody else may drop in and have your answer before I get back to your topic.

lax.slash

Posting mainly because I'm interested in this topic, and would like to be updated of replies.

Two cents - You mentioned that this happened after a registration. Could this have been something malicious? (Don't mean to scare you) Have you checked logs? Does your host make backups? If they do, would they be able to restore your database?

tk2012

@Deprecated

I'm sorry that you are frustrated.  I thought that I answered your previous question when I posted the error message as it says: admin_info_files

I will go through different channels to try and remedy my problem.  Thanks for your posts, but I wouldn't want to be cause more frustration as I've already admitted that I'm not fluent, or even highly knowledgeable in this type of thing.

I'll mark this as solved even though it isn't just to get it off your radar.

Thanks


@ lax.slash

I gave as much info as I have.  I've tried to get info from the host, but the person who is in charge of my work ticket is off until tomorrow.  I guess he started helping me on Friday night and I've been on hold ever since.

What is odd to me, is that two more people were able to register while the site was showing an error and not loading for anyone else.

lax.slash

Quote
What is odd to me, is that two more people were able to register while the site was showing an error and not loading for anyone else.

That is odd. Can you check to see if the IPs match? (I'm sticking with my malicious activity theory for now, until that is "debunked." Again, not trying to scare you.) IMO, it's always best to start with the more serious possibilities for something like this, so that it doesn't escalate while trying to solve the issue for other wrong and less threatening possibilities. (If that makes any sense, lol)

Deprecated

Dammit I don't give up. Maybe I was just whining... I was just trying to tell you we are going to whack at this problem again tomorrow! I'm tired after working support for 12 hours...

I've marked your topic "unsolved" and I'm not going to give up unless you refuse to reply to your topic. So do like I said and remind me in 12 hours or so if this topic has no activity before then.

You get the best damned support for SMF or it won't be because of me.

Topic marked unsolved. Don't give up. :)

lax.slash

Deprecated - what's your opinion on the malicious activity theory?

tk2012

Well, I had fixed all the errors that were in my error log earlier in the week.  The last error that I had was the PLUSHSEARCH2 or something like that where I was told to make changes to the search settings.  That's the only changes I made.  I've not really had any problems with databases other than that PLUSHSEARCH thing. 

Not sure if that is involved here or not.  I'll check the IPs in the am.  I have about had it tonight.  It is my first week of chemo and I have tried to stay up as long as I could tonight.

metallica48423

So let me wrap my head around this.  The original issue problem was a crashed messages table?  The table would not repair.  Is this table still crashed and in place?  Have you contacted your host?  If not, do so, and ask them to run myisamchk on the table.  If not, it is possible that it is corrupted and may be a total loss.

If you have an older copy of the messages table in a backup, you *MAY* be able to import it and utilize it, however you will LOSE any topics and messages between when the backup was made and now, and it may cause some errors -- you'll have topic entries that don't have corresponding messages.  But that is speculation on my part based on prior experience.  The find and repair errors function should be able to hopefully clean that up.

I highly doubt the malicious action theroy. Sorry.  malicious action generally drops and deletes tables or table data, not crashes them.  Table crashes are usually a server fault due to poor configuration or maintenance, or possibly even overloading.  Tables can also crash if not optimized regularly -- SMF has a utility to do this automatically from time to time for this purpose.  However, that can be disabled -- but shouldn't be unless its being handled elsewhere.
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

lax.slash

Quote from: metallica48423 on November 10, 2008, 11:06:06 PM
So let me wrap my head around this.  The original issue problem was a crashed messages table?  The table would not repair.  Is this table still crashed and in place?  Have you contacted your host?  If not, do so, and ask them to run myisamchk on the table.  If not, it is possible that it is corrupted and may be a total loss.
He did check with his host, but the ticket handler is off until tomorrow.

Quote
I highly doubt the malicious action theroy. Sorry.  malicious action generally drops and deletes tables or table data, not crashes them.  Table crashes are usually a server fault due to poor configuration or maintenance, or possibly even overloading.  Tables can also crash if not optimized regularly -- SMF has a utility to do this automatically from time to time for this purpose.  However, that can be disabled -- but shouldn't be unless its being handled elsewhere.

That's why I was confused when I suggested that.

metallica48423

Yeah.  If the control panel repair and/or the repair function through phpmyadmin fail, then the only other real option is for the host to use the root user to run myisamchk.

As i said, there is a possibility it is corrupted and can't be repaired, but we need them to check first.
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Deprecated

Quote from: lax.slash on November 10, 2008, 10:55:28 PM
Deprecated - what's your opinion on the malicious activity theory?

My opinion doesn't really count. Reality is reality irrespective of my opinion, and I just don't know. :)

Deprecated

Oh yeah, Metallica sent me a message on IRC about this topic... I couldn't figure it out until just now.

We'll solve your topic tomorrow. Met is East Coast if I remember correctly, and I'm a Los Angeles guy. It's nearing our U.S. end of day and I think I can speak for him too, that our attention and awareness are decreasing.

Let's continue this tomorrow. We'll get it right.

tk2012

The "messages" table had crashed and would not repair... when I went into phpmyadmin I checked the table and it said "in use".    I tried to repair it thru phpmyadmin and it would not change.

I've been on hold with the host since Friday.  Today, they said they would get my table back up, but it would take a lengthy time because it is a manual process.  The table is no longer there.  It has been deleted. 

The "messages" backup that was available in myphpadmin that I saw was from 9-17ish.  I went ahead myself and imported that one into the database as the usable one within 45 seconds.  I have the forum in maintenance mode currently to keep anyone from making new posts because I was hoping to use a more current copy of my database backup. 

I guess I'm confused here because of the following:

All my other tables are current as if nothing happened.  I imported the "messages" table that was from 9-17 into my forum with no problem.  The part I don't understand is that if I have a database from 10-17 which includes a more recent copy of the "messages" table in it, why can't I do the following?

a- create a new database directory and import the 10-17 database into it.
b- export the "messages" table from the 10-17 database onto my laptop
c- delete the "messages" table from my current database (because it was deleted already and I imported the 9-17 version with no problems)
d- import the "messages" (10-17) into my current database because it would give me an extra months worth of messages.





Like I said, the only database problems that I had originally were the Plushsearch2 problems. 

http://www.simplemachines.org/community/index.php?topic=262174.0

I did what was stated in the reply and then this happened.  They could be totally unrelated, but I would think Search and Messages do overlap in some way.




(FYI -The people who registered during the time the forum was down, have different ip addresses.)

Deprecated

Well your smf_messages table cannot be imported unless you import your smf_topics table too. They go together. If you add the messages table without the topics, any existing topics that were active between the dates of the two files will be screwed up, and any new topics will be missing even though the posts will be there but not accessible.

Yeah, could be related to that mod. Hard to say. Doesn't seem impossible though.


I don't know if I can help you without seeing that crashed table. Have you looked at source? It might be something obvious in just one place...

tk2012

#30
What mod?

ok, so I'll load the topics table, too and get it to at least to the 9-17 backup.

The crashed table was deleted, so don't think there is much to go on there... that's why I'm doing damage control at this point and trying to get it to a more current back up from 10-17

Deprecated

I was just referencing the Plushsearch2 mod that you mentioned.

tk2012

I don't have a mod that does anything like that.  LOL.  That's why I have been posting it to find out what help I can get.  I have no search mods installed on my forum at all.  I'm not aware of any either.  As far as I know, this is a function otherwise I wouldn't have been told by two different people to upgrade to b4.0 because they thought those problems had been taken care of in the upgrade. 

tk2012

@Deprecated

I did two different backups thru the forum administration center... (Because I'm not fluent with myphpadmin)  Next time, I'll do it thru there.  Anyway, I was told not to attach a database file on the forum here, but I'd like a 2nd opinion..

Can you tell me if what I have will actually work to use as a restore if I emailed it to you? 

Deprecated

Let me understand you first, you intend to mail just the faulty table, right? Please tell me what its size is.

But not the entire database!

tk2012

well, let me tell you this.  I have three files here from 10/17

two of them I receive this error when trying to import them into the database:

No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.


the third, file that I've tried, sends back a HUGE error about the Admin_Files table not existing...

Now, all of these files were downloaded via the administration center on the forum, so I don't understand why they won't work....


metallica48423

there is a utility out there called bigdump -- might have to google it -- that can import larger sql files.  It may help in your case
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

tk2012

motorstorm-rpms_org_community-complete_2008-10-17.sql   3.71MB

motorstorm-rpms_org_community-data_2008-10-17.sql   3.65MB

motorstorm-rpms_org_community-data_2008-10-17.sql.gz  1.01MB

These are the names of the files and sizes... is it the way in which they were downloaded?  I did one with the data and one as complete as instructed in a different thread here.

http://www.simplemachines.org/community/index.php?topic=184356.0

tk2012

Right now the forum is restored to 9-17.  I don't want to completely replace my database until I know for certain it is going to import completely.  That's why, I wanted to make a 2nd directory name and import it to that one first to make certain.

Deprecated

tk2012 please excuse me for saying that i'm signing off for tonight (soon) and please pm me or bump your topic tomorrow morning. gnite!

Advertisement: