Previous Thread
Next Thread
Print Thread
Hop To
#230108 10/18/2009 7:16 AM
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
My POSTS sql table still crashes (daily if i want to...)

When i edited an old post (2007) i got these errors and had to repair the table again but i could live with that. I just don't edit my old posts anymore.
But when i edit a post that's 5 days old it now crashes.

We replaced the server a few months ago and i thought the problem was solved but still i get these crashed table errors.
Running a new version of MySQL, new Linux version (OpenSUSE) and new hardware with much more memory, faster HDD's and many more improvements.

I run several database and never have such problems with other databases but now when i edit any post on our board the message is:

Quote
Script: /data/vhosts/www.freesat.nl/forum/scripts/modifypost.inc.php - Line: 391
update ubbt_POSTS
set POST_SUBJECT = 'Re: Ethernet kabel verlengen' ,
POST_BODY = 'Je kunt een ISDN koppelstuk gebruiken, bij een Phonehouse ofzo te halen voor 2 euries...' ,
POST_DEFAULT_BODY = 'Je kunt een ISDN koppelstuk gebruiken, bij een Phonehouse ofzo te halen voor 2 euries...',
POST_ICON = 'book.gif' ,
POST_LAST_EDITED_TIME= 0 ,
POST_LAST_EDIT_REASON = '' ,
POST_LAST_EDITED_BY = 'FreeSat' ,
POST_ADD_SIGNATURE = 1 ,
POST_HAS_FILE = '0',
POST_MARKUP_TYPE = 'markup'

where POST_ID = 42763
- Incorrect key file for table './freesat/ubbt_POSTS.MYI'; try to repair it

Why does this keep happening?

Thanks in advance,
Rob


My place to be: http://www.freesat.nl
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Do you have any other MySQL scripts? If so, do they also get these errors when you update data?


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!
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Also, what version of MySQL are you running?


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!
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I'm thinking it may be related to:
http://bugs.mysql.com/bug.php?id=10075

What does the available disk space on your machine look like?


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!
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
I posted a really long answer to this. Where did it go?


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
And again they're speaking about the fact that my server is getting out of diskspace. Well, i can asure you it isn't smile
Quote
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 130G 13G 111G 11% /
udev 4.4G 144K 4.4G 1% /dev
/dev/sdb1 1.4T 104G 1.3T 8% /data2
/dev/sdc1 931G 204G 728G 22% /data3

Running MySQL version: 5.0.67-log
Running on OpenSUSE 11.1

Size of the database:
-rw-rw---- 1 mysql mysql 44525072 Oct 19 09:16 ubbt_POSTS.MYD
-rw-rw---- 1 mysql mysql 20377600 Oct 19 09:20 ubbt_POSTS.MYI
-rw-rw---- 1 mysql mysql 9734 Oct 11 16:34 ubbt_POSTS.frm


Thanks for helping me out.


My place to be: http://www.freesat.nl
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
Checked the following:

Copied the data from my database (DBASE1) to a new database (DBASE2)
When i edit in phpMyAdmin record 9002 in DBASE1 the table crashes, when i do the same in DBASE2 it works.
Conclusion: Maybe the database should be flushed once in a while.
I guess because the visitors on the forums are using the database (DBASE1) and therefor it's impossible to edit the older posts because of writing a tmp dbase to a tmp directory and write it back.
DBASE2 is not in use so i was the only user for that database.

Just guessing.....


My place to be: http://www.freesat.nl
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
Oh, i tried removing all contents from DBASE1 and write it back with the same backup i used for DBASE2. It still ain't working.


My place to be: http://www.freesat.nl
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
I believe the permissions on the DB files should be 644. Yours are showing 640.

Last edited by JAISP; 10/19/2009 6:52 AM.
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
I'll try that...


My place to be: http://www.freesat.nl
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
Still:
myisamchk: MyISAM file /var/lib/mysql/vanden/ubbt_POSTS.MYI
myisamchk: warning: Table is marked as crashed

Quote
Script: /data/vhosts/www.freesat.nl/forum/scripts/modifypost.inc.php
Line#: 391
SQL Error: Incorrect key file for table './freesat/ubbt_POSTS.MYI'; try to repair it
SQL Error #: 126
Query: update ubbt_POSTS set POST_SUBJECT = '......... blablabla..........' , POST_LAST_EDITED_TIME= 1255959285 , POST_LAST_EDIT_REASON = '' , POST_LAST_EDITED_BY = 'FreeSat' , POST_ADD_SIGNATURE = 1 , POST_HAS_FILE = '0', POST_MARKUP_TYPE = 'markup' where POST_ID = 497

Sometimes when posting:
myisamchk: MyISAM file /var/lib/mysql/freesat/ubbt_POSTS.MYI
myisamchk: warning: Table is marked as crashed
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of indexfile is: 19932160 Should be: 19960832

Last edited by Robje01; 10/19/2009 9:41 AM.

My place to be: http://www.freesat.nl
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
Now backed up the entire database for my forums, wrote it back but under another name, edited the config.inc.php to point it to the new written database and now i can edit posts from 5 years back!

Incredible but now it's working.


My place to be: http://www.freesat.nl
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
Start the machine in single user mode, do a file system check, then boot back up again and try it. Something in that original database seems bad, but you did manage to get a sql dump and import, which is good.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
I'll next time it happens.
For now it's going like a train, smooth and fast smile

Thanks,
Rob


My place to be: http://www.freesat.nl

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 458 guests, and 91 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.0
(Preview build 20230217)