|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
We encountered a problem. The reason reported was Script: /var/path/forums/scripts/cfrm.inc.php Line#: 333 SQL Error: Can't open file: 'ubbt_POSTS.MYI' (errno: 145) SQL Error #: 1016 Query: select COUNT(*) as posts, sum(t1.POST_IS_TOPIC) as topics from ubbt_POSTS as t1, ubbt_TOPICS as t2 where t2.FORUM_ID = 45 and t1.TOPIC_ID = t2.TOPIC_ID and t1.POST_IS_APPROVED = '1' and t1.POST_POSTED_TIME > 1167693637
Please use your back button to return to the previous page. Any thoughts?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
errno: 145 is a corrupt table. You'll want to run the following SQL command:
REPAIR TABLE ubbt_POSTS
Last edited by Rick; 01/11/2007 6:46 PM. Reason: because I can't spell
|
|
|
|
Joined: Jan 2007
Posts: 6
stranger
|
stranger
Joined: Jan 2007
Posts: 6 |
yes except remember to put an I in the repair...
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Oopsie Edited my post
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
trying that - no luck so far
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Do you get any info back when you run the command?
|
|
|
|
Joined: Jul 2006
Posts: 51
journeyman
|
journeyman
Joined: Jul 2006
Posts: 51 |
If you have shell access: myisamchk -r ubbt_POSTS.MYI
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
@Rick
Didn't you make a change to one of the cache tables or something like that in 7.1b?? for similar issue?
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
Do you get any info back when you run the command? no just times out in phphmyadmin
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
You should run commands through the command line; the php script (phpmyadmin) likely times out because your tables are so large.
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
I would if I knew the syntax LOL I am now throwing money at it, in the vain hope of getting them back up..... Not looking to good at the moment....
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Looks like You're back up now. Were you able to get this fixed yourself or did your host need to do it?
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
Yes, i'm quite curious how it got fixed as well as repair didnt seem to do much...
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
just a case of keep repairing.... Fixed the posts, but then other tables were also corupted.
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
Ahh, did you use my sugguestion of not using phpmyadmin to repair tables? lol
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
lol, and did it work better?
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
nah - only after I took down mysql and had all my clients calling me here in Hong Kong saying their email was down....
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
expensive calls to whine ... I hope they weren't calling your uk #...
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
yep... my mobile... (cell to you)
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
'eh you sent me a list of a ton of numbers, i looked at them and shrugged lol
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
hehe - my washington number would work for you Will either end up on my PC as VOIP or divert to my mobile....
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
I always love when peopel talk about Washington, generally they referr to Washington DC, but with Washington (state) being above me I sometimes get confused ...
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
If multiple tables were corrupted it definitely sounds like an issue that could be trouble. Single table corruption can happen, but when it's multiple tables this points to a larger problem.
|
|
|
|
Joined: Jun 2006
Posts: 626
Addict
|
Addict
Joined: Jun 2006
Posts: 626 |
I hope this never happens to me! What would, or could, cause such a problem?
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Poor slow hardware normally. If it tries to do a read and can't get a response it's not too bad, but if it can't write because it's too busy or too slow then you have problems.
There are thousands of MySQL databases out in the World and Business running very large sites with no problems.
Wikipedia which is big runs on MySQL
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
certainly not poor slow hardware - thank you!
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Not trying to anger you or step on your toes but slow hardware most certainly can cause corruption. There are certainly other things that can cause it though.
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
I think initially looking at the error log it was just the massive posts table - then the users table became corrupted once the posts had been fixed.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Sorry Ian, I was only replying to Daryl's question, not meaning your db issue.
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
oops - my apologies - it is 04:30 here and I have a plane to catch, so I will use that as my excuse
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
You know, I've been logged into his server all night checking sar often; the iowait isn't half bad so it's likely not a hw issue; though he does have occasional spikes...
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
table has corrupted again...
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
trying to repair from database tools within threads
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
not sure how long one table takes - but it is a good 45 minutes so far
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
timed out I am walking away from this now...
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Which table is it this time, the posts table or the topics table?
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Hmm, what version of MySQL are you currently running? There are certain versions that are more prone to corruption than others and since the posts table is actually written to less often in this version than prior versions there is definitely something funky going on.
You might try and check the uptime of MySQL to see how long it's actually been running, possibly stopped and restarted during a write? It could be anything like memory, cpu or a hard drive issue.
One thing, make sure you close your forums while trying to repair it. Since it's the post table it can take awhile because it is one of the larger tables. But if your forum is still open while working on it, it can actually corrupt it further.
|
|
|
|
Joined: Jun 2006
Posts: 3,839 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,839 Likes: 1 |
I think the forums were closed, and still are.
repaired the table - can't reach the site though.
getting no mysql errors in the logs for the site.
|
|
|
0 members (),
1,448
guests, and
60
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|