Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
5 registered (Dunny, Outdoorking, Pilgrim, SteveS, JPFolks), 31 Guests and 6 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/22/12
Posts: 2
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 9 1 2 3 4 5 6 7 8 9 >
Topic Options
#173127 - 01/11/07 06:03 PM Forums Down
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
 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?
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#173129 - 01/11/07 06:25 PM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
errno: 145 is a corrupt table. You'll want to run the following SQL command:

REPAIR TABLE ubbt_POSTS


Edited by Rick (01/11/07 06:46 PM)
Edit Reason: because I can't spell
Top
#173130 - 01/11/07 06:38 PM Re: Forums Down [Re: Rick]
RichieRich Offline
stranger
Registered: 01/02/07
Posts: 6
yes except remember to put an I in the repair...
Top
#173131 - 01/11/07 06:46 PM Re: Forums Down [Re: RichieRich]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Oopsie \:o Edited my post ;\)
Top
#173132 - 01/11/07 06:59 PM Re: Forums Down [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
trying that - no luck so far \:\(
Top
#173133 - 01/11/07 07:10 PM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Do you get any info back when you run the command?
Top
#173153 - 01/11/07 11:06 PM Re: Forums Down [Re: Rick]
Mtier Offline
journeyman
Registered: 07/09/06
Posts: 59
Loc: Germany, Mainz
If you have shell access:
myisamchk -r ubbt_POSTS.MYI
Top
#173158 - 01/11/07 11:15 PM Re: Forums Down [Re: Rick]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
@Rick

Didn't you make a change to one of the cache tables or something like that in 7.1b?? for similar issue?
Top
#173173 - 01/12/07 01:22 AM Re: Forums Down [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
 Originally Posted By: Rick
Do you get any info back when you run the command?


no just times out in phphmyadmin \:\(
Top
#173175 - 01/12/07 02:12 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
You should run commands through the command line; the php script (phpmyadmin) likely times out because your tables are so large.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173177 - 01/12/07 04:40 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
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....

\:\(
Top
#173201 - 01/12/07 10:53 AM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Looks like You're back up now. Were you able to get this fixed yourself or did your host need to do it?
Top
#173325 - 01/12/07 11:57 PM Re: Forums Down [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Yes, i'm quite curious how it got fixed as well as repair didnt seem to do much...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173327 - 01/12/07 11:59 PM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
just a case of keep repairing.... Fixed the posts, but then other tables were also corupted.
Top
#173333 - 01/13/07 12:06 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Ahh, did you use my sugguestion of not using phpmyadmin to repair tables? lol
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173338 - 01/13/07 12:14 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
after I tried....
Top
#173342 - 01/13/07 12:17 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
lol, and did it work better? ;\)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173345 - 01/13/07 12:18 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
nah - only after I took down mysql and had all my clients calling me here in Hong Kong saying their email was down....
Top
#173347 - 01/13/07 12:19 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
expensive calls to whine ;)... I hope they weren't calling your uk #...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173348 - 01/13/07 12:22 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
yep... my mobile... (cell to you)
Top
#173349 - 01/13/07 12:28 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
'eh you sent me a list of a ton of numbers, i looked at them and shrugged lol
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173352 - 01/13/07 12:32 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
hehe - my washington number would work for you ;\) Will either end up on my PC as VOIP or divert to my mobile....
Top
#173356 - 01/13/07 12:51 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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 ;)...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173383 - 01/13/07 10:57 AM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#173393 - 01/13/07 01:59 PM Re: Forums Down [Re: Rick]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
I hope this never happens to me! \:\)

What would, or could, cause such a problem?
Top
#173397 - 01/13/07 03:21 PM Re: Forums Down [Re: Daryl Fawcett]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
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
Top
#173402 - 01/13/07 03:30 PM Re: Forums Down [Re: ntdoc]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
certainly not poor slow hardware - thank you!
Top
#173406 - 01/13/07 03:32 PM Re: Forums Down [Re: Ian]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
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.
Top
#173408 - 01/13/07 03:35 PM Re: Forums Down [Re: ntdoc]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
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.
Top
#173414 - 01/13/07 03:47 PM Re: Forums Down [Re: Ian]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
Sorry Ian, I was only replying to Daryl's question, not meaning your db issue. \:o
Top
#173415 - 01/13/07 03:49 PM Re: Forums Down [Re: ntdoc]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
oops - my apologies - it is 04:30 here and I have a plane to catch, so I will use that as my excuse ;\)
Top
#173418 - 01/13/07 06:31 PM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173608 - 01/15/07 09:12 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
table has corrupted again...

\:\(
Top
#173610 - 01/15/07 09:36 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
trying to repair from database tools within threads \:\(
Top
#173612 - 01/15/07 10:20 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
not sure how long one table takes - but it is a good 45 minutes so far \:\(
Top
#173613 - 01/15/07 10:23 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
timed out \:\(

I am walking away from this now...
Top
#173614 - 01/15/07 10:49 AM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Which table is it this time, the posts table or the topics table?
Top
#173619 - 01/15/07 11:05 AM Re: Forums Down [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
posts again
Top
#173620 - 01/15/07 11:18 AM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#173622 - 01/15/07 11:23 AM Re: Forums Down [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
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.
Top
#173624 - 01/15/07 11:31 AM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#173625 - 01/15/07 11:33 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
SQL Error: Can't open file: 'ubbt_POSTS.MYI' (errno: 144)
Top
#173627 - 01/15/07 11:39 AM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#173628 - 01/15/07 11:40 AM Re: Forums Down [Re: Ian]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
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.
Top
#173702 - 01/15/07 07:10 PM Re: Forums Down [Re: Daryl Fawcett]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173706 - 01/15/07 07:17 PM Re: Forums Down [Re: Gizmo]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#173711 - 01/15/07 07:25 PM Re: Forums Down [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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? ;\)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173715 - 01/15/07 07:31 PM Re: Forums Down [Re: Gizmo]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
I have a shell on everyone's box \:\) Ok, not everyone's, but if someones having a problem it's the easiest way to find the root cause.
Top
#173716 - 01/15/07 07:31 PM Re: Forums Down [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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 ;)...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173781 - 01/16/07 02:05 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
can't find this VV thing or agent linux - must be looking in the wrong place.... LOL
Top
#173784 - 01/16/07 02:10 AM Re: Forums Down [Re: Rick]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
 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 ;\)

.
Top
#173810 - 01/16/07 05:11 AM Re: Forums Down [Re: ntdoc]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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...

_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173816 - 01/16/07 05:26 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
That is a backup - it should only run at night (GMT) - might be intensive for short periods.
Top
#173818 - 01/16/07 05:33 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
 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
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173819 - 01/16/07 05:34 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
backups have been a nightmare on my machine LOL They seem to grind threads to a halt at night LOL
Top
#173821 - 01/16/07 05:36 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
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.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173822 - 01/16/07 05:40 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
we have two systems - the once above works fine - it is an incremental backup that allows individual files to be restored easily. \:\)
Top
#173824 - 01/16/07 05:43 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
ahh, likely why it can be system intensive then ;)...

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.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173828 - 01/16/07 05:46 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
far too complicated for my little mind LOL
Top
#173836 - 01/16/07 05:54 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
for me its as easy as setting a crontask to run /home/gizmo/backup.c monthly and /home/gizmo/incrimental.c weekly ;)...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173839 - 01/16/07 05:56 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
crons are easy - it is the script they run \:p
Top
#173841 - 01/16/07 05:57 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
yeh well customizing said script isn't the hardest task once you've played with all of the commands lol...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173843 - 01/16/07 05:57 AM Re: Forums Down [Re: Gizmo]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Like i said, it's my hobby lol
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173845 - 01/16/07 05:58 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
hobby away then LOL
Top
#173846 - 01/16/07 05:58 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
 Originally Posted By: Ian
hobby away then LOL
What do I get? :x...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#173862 - 01/16/07 07:25 AM Re: Forums Down [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
corrupted again \:\(

Trying to repair once more....
Top
#173865 - 01/16/07 08:45 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
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.
Top
#173867 - 01/16/07 09:17 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
I guess that was wrong - just sat there for about 2 hours.

trying alternative method now....
Top
#173868 - 01/16/07 09:30 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
right back up again...
Top
#173870 - 01/16/07 09:53 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
gone again - this is getting beyond a joke....

\:\(

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.
Top
#173871 - 01/16/07 09:58 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
BTW - rick that other process has now been uninstalled, that was causing some spikes.
Top
#173874 - 01/16/07 11:02 AM Re: Forums Down [Re: Ian]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
so far so good - fingers crossed...
Top
#173889 - 01/16/07 02:04 PM Re: Forums Down [Re: Ian]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
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.
Top
#173893 - 01/16/07 03:27 PM Re: Forums Down [Re: Daryl Fawcett]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
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 \:\)
Top
#173896 - 01/16/07 03:54 PM Re: Forums Down [Re: Ian]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
Were you always using threads since threads was created?
Top
#173897 - 01/16/07 03:56 PM Re: Forums Down [Re: Daryl Fawcett]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
since perl days - or wwwthreads \:\)
Top
#173904 - 01/16/07 04:59 PM Re: Forums Down [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
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.
Top
#173921 - 01/16/07 05:53 PM Re: Forums Down [Re: Rick]
Daryl Fawcett Offline
addict
Registered: 06/05/06
Posts: 469
Loc: Canada
My next question is, at what version did all the problems begin?
Top
#174021 - 01/17/07 10:32 AM Re: Forums Down [Re: Daryl Fawcett]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
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.
Top
#174026 - 01/17/07 11:20 AM Re: Forums Down [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
With any luck things stay "well" ;\)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#174048 - 01/17/07 01:50 PM Re: Forums Down [Re: Gizmo]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
 Originally Posted By: Gizmo
With any luck things stay "well" ;\)


Amen, good luck.
Top
Page 1 of 9 1 2 3 4 5 6 7 8 9 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image