Previous Thread
Next Thread
Print Thread
Hop To
Page 3 of 3 1 2 3
#173127 01/11/2007 6:03 PM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
Quote
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?

Ian #173129 01/11/2007 6:25 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
Rick #173130 01/11/2007 6:38 PM
Joined: Jan 2007
Posts: 6
R
stranger
stranger
R Offline
Joined: Jan 2007
Posts: 6
yes except remember to put an I in the repair...

RichieRich #173131 01/11/2007 6:46 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Oopsie blush Edited my post wink

Rick #173132 01/11/2007 6:59 PM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
trying that - no luck so far frown

Ian #173133 01/11/2007 7:10 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Do you get any info back when you run the command?

Rick #173153 01/11/2007 11:06 PM
Joined: Jul 2006
Posts: 51
journeyman
journeyman
Joined: Jul 2006
Posts: 51
If you have shell access:
myisamchk -r ubbt_POSTS.MYI

Rick #173158 01/11/2007 11:15 PM
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?

Rick #173173 01/12/2007 1:22 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
Originally Posted by Rick
Do you get any info back when you run the command?


no just times out in phphmyadmin frown

Ian #173175 01/12/2007 2:12 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173177 01/12/2007 4:40 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
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....

frown

Ian #173201 01/12/2007 10:53 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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?

Rick #173325 01/12/2007 11:57 PM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173327 01/12/2007 11:59 PM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
just a case of keep repairing.... Fixed the posts, but then other tables were also corupted.

Ian #173333 01/13/2007 12:06 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Ahh, did you use my sugguestion of not using phpmyadmin to repair tables? lol


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173338 01/13/2007 12:14 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
after I tried....

Ian #173342 01/13/2007 12:17 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
lol, and did it work better? wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173345 01/13/2007 12:18 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
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....

Ian #173347 01/13/2007 12:19 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
expensive calls to whine wink... I hope they weren't calling your uk #...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173348 01/13/2007 12:22 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
yep... my mobile... (cell to you)

Ian #173349 01/13/2007 12:28 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173352 01/13/2007 12:32 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
hehe - my washington number would work for you wink Will either end up on my PC as VOIP or divert to my mobile....

Ian #173356 01/13/2007 12:51 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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 wink...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Ian #173383 01/13/2007 10:57 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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.

Rick #173393 01/13/2007 1:59 PM
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
I hope this never happens to me! smile

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

ntdoc #173402 01/13/2007 3:30 PM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
certainly not poor slow hardware - thank you! mad

Ian #173406 01/13/2007 3:32 PM
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.

ntdoc #173408 01/13/2007 3:35 PM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
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.

Ian #173414 01/13/2007 3:47 PM
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. blush

ntdoc #173415 01/13/2007 3:49 PM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
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 wink


Ian #173418 01/13/2007 6:31 PM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173608 01/15/2007 9:12 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
table has corrupted again...

frown

Ian #173610 01/15/2007 9:36 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
trying to repair from database tools within threads frown

Ian #173612 01/15/2007 10:20 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
not sure how long one table takes - but it is a good 45 minutes so far frown

Ian #173613 01/15/2007 10:23 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
timed out frown

I am walking away from this now...

Ian #173614 01/15/2007 10:49 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Which table is it this time, the posts table or the topics table?

Rick #173619 01/15/2007 11:05 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
posts again

Ian #173620 01/15/2007 11:18 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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.

Rick #173622 01/15/2007 11:23 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
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.

Ian #173624 01/15/2007 11:31 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Do you have server level access? If so, then the best bet would be to try and repair directly from the MySQL prompt.

If you can't reach the site, the repair you ran through threads might still be running. If you have direct access, then you can check if it's still running by typing in "show processlist" from the mysql command prompt.

What version of MySQL are you running? There are several versions of MySQL that are more prone to corruption, in their release notes they do mention a few versions that were updated for this reason, so a MySQL upgrade might be in order.


Ian #173625 01/15/2007 11:33 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
SQL Error: Can't open file: 'ubbt_POSTS.MYI' (errno: 144)

Ian #173627 01/15/2007 11:39 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
If you can try and repair directly from within MySQL , you'll actually get some useful information at the end of the repair. That will give some information on what happened if the repair failed.

It could be something as simple as out of hard drive space on the MySQL partition.

Ian #173628 01/15/2007 11:40 AM
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
I had the same problem, but only once so far.

I tried the repair table, etc. without any success.

The only way I was able to function again was to have the host server provider import a back-up that they had fortunately done.

Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Rick, his load from mysql at times shows 250 in the cpu column of TOP, it's insane the load being produced on his server lol...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173706 01/15/2007 7:17 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Yeah, I think we've narrowed it down to one of the users on the server. I saw a spike this morning where mysqld was showing 325% cpu usage.

Rick #173711 01/15/2007 7:25 PM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Theres also some command named "VV" that seems to be provided by some software installed "Linux Agent" that also takes up its share of resources:
20670 root 18 0 16284 3676 1960 R 67 0.2 5:21.46 VV

Lol you have a shell on his box too huh? wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173715 01/15/2007 7:31 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
I have a shell on everyone's box smile Ok, not everyone's, but if someones having a problem it's the easiest way to find the root cause.

Rick #173716 01/15/2007 7:31 PM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Lol, I think you have a shell on both my VPS and home dev machine lol... so I'll go with the idea that you have a shell on everyones box wink...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173781 01/16/2007 2:05 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
can't find this VV thing or agent linux - must be looking in the wrong place.... LOL

Rick #173784 01/16/2007 2:10 AM
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Originally Posted by Rick
Yeah, I think we've narrowed it down to one of the users on the server. I saw a spike this morning where mysqld was showing 325% cpu usage.

Wow so that's like a super computer ? How do you get more than 100% I might need that kind of magic on my system wink

.

ntdoc #173810 01/16/2007 5:11 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Not sure where it's hiding itself, but an example of the process name:
^[[m^O 7254 root 18 0 16284 3720 1960 D 2 0.2 14:08.89 VV

Above it's only using .2% of your memory, and 2% of your processor; but it's been MUCH higher (keep in mind i sat there and let it run for quite the while as i played FFV so i watched it pop up time and time again...



I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173816 01/16/2007 5:26 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
That is a backup - it should only run at night (GMT) - might be intensive for short periods.

Ian #173818 01/16/2007 5:33 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Originally Posted by Ian
That is a backup - it should only run at night (GMT) - might be intensive for short periods.
ahh... ok would make sense...

Myself, I just use a crontask to tell "tar" to backup space, then ncftp to send them to my machine


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173819 01/16/2007 5:34 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
backups have been a nightmare on my machine LOL They seem to grind threads to a halt at night LOL

Ian #173821 01/16/2007 5:36 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
tar and ncftp are two very basic systems that shouldn't be too resource intensive; i can't vouch for the utility that you currently use.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173822 01/16/2007 5:40 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
we have two systems - the once above works fine - it is an incremental backup that allows individual files to be restored easily. smile

Ian #173824 01/16/2007 5:43 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
ahh, likely why it can be system intensive then wink...

Myself what I'd do would be to have two backup cycles, one that does a full backup every month (or week) which tells mysql to dump all db's then tar up those dbs, then tar up your webspaces, then tar both of the tarred files together (easier to keep track of).

Then I'd have another which backs up MySQL every week (or day) then tar those files (compress with bzip to save space).

Then you'd have daily backups of sql data which generally constantly changes, and then monthly backups of your site space, basically similar to what i use.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173828 01/16/2007 5:46 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
far too complicated for my little mind LOL

Ian #173836 01/16/2007 5:54 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
for me its as easy as setting a crontask to run /home/gizmo/backup.c monthly and /home/gizmo/incrimental.c weekly wink...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173839 01/16/2007 5:56 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
crons are easy - it is the script they run tongue

Ian #173841 01/16/2007 5:57 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
yeh well customizing said script isn't the hardest task once you've played with all of the commands lol...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173843 01/16/2007 5:57 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Like i said, it's my hobby lol


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173845 01/16/2007 5:58 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
hobby away then LOL

Ian #173846 01/16/2007 5:58 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Originally Posted by Ian
hobby away then LOL
What do I get? :x...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #173862 01/16/2007 7:25 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
corrupted again frown

Trying to repair once more....

Ian #173865 01/16/2007 8:45 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
I know that repairing takes quite a while but I have done..

mysql> REPAIR TABLE ubbt_POSTS;

I assume it is correct just to sit on a blank line - I do not get any progress. Is this correct? Never done it via this method before, so unsure. But assume it is correct.

Ian #173867 01/16/2007 9:17 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
I guess that was wrong - just sat there for about 2 hours.

trying alternative method now....

Ian #173868 01/16/2007 9:30 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
right back up again...

Ian #173870 01/16/2007 9:53 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
gone again - this is getting beyond a joke....

frown

it really does look like threads from what I can see.

We now have numerous posts that do not exist - these are all numbered 0 - i.e. http://www.fansfocus.com/forums/ubbthreads.php?ubb=showflat&Number=0


When I look at the process list there are several instances for the forums, but they are all locked. At the same time the load increases to 15+ and that is when the database corrupts.



Ian #173871 01/16/2007 9:58 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
BTW - rick that other process has now been uninstalled, that was causing some spikes.

Ian #173874 01/16/2007 11:02 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
so far so good - fingers crossed...

Ian #173889 01/16/2007 2:04 PM
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
I went to your site and didn't have any problem accessing any I selected, except for the link you previously provided, therefore, it does seem to be a selective threads problem.

Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
I have had 919 posts in the last 24 hours, so any problematic ones tend to get pushed down on some forums.

There are still some.

Of course my main concern is the constant corrupting of the database. This has never happened before in several years, so why it should start now is a puzzler.

Anyway thanks for popping by to check smile

Ian #173896 01/16/2007 3:54 PM
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
Were you always using threads since threads was created?

Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
since perl days - or wwwthreads smile

Ian #173904 01/16/2007 4:59 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
For now I'd disable the option to show the number of new posts. Those are pretty intense queries, especially when you add in the all the subforums. It appears that every one of those queries are being written to your mysql_slow_query_log file, so that's not helping matters at all.

Rick #173921 01/16/2007 5:53 PM
Joined: Jun 2006
Posts: 626
Addict
Addict
Joined: Jun 2006
Posts: 626
My next question is, at what version did all the problems begin?

Daryl Fawcett #174021 01/17/2007 10:32 AM
Joined: Jun 2006
Posts: 3,839
Likes: 1
I
Ian
Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,839
Likes: 1
so far so good today....

Had 1078 posts in the last 24 hours, so things are fairly busy...

Many thanks to everyone who has helped on this issue.

Ian #174026 01/17/2007 11:20 AM
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
With any luck things stay "well" wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #174048 01/17/2007 1:50 PM
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Originally Posted by Gizmo
With any luck things stay "well" wink

Amen, good luck.

Page 3 of 3 1 2 3

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Not allowing attachment over 2m
by ehill - 12/03/2024 3:16 PM
New Admin Here
by SenecaFlyer - 12/02/2024 4:14 PM
Post Counts zeroed out
by Baldeagle - 11/03/2024 3:05 PM
Who's Online Now
0 members (), 1,448 guests, and 60 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)