|
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: 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
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Do you have any other MySQL scripts? If so, do they also get these errors when you update data?
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Also, what version of MySQL are you running?
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
I'm thinking it may be related to: http://bugs.mysql.com/bug.php?id=10075What does the available disk space on your machine look like?
|
|
|
|
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?
|
|
|
|
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 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-logRunning on OpenSUSE 11.1Size 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.
|
|
|
|
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.....
|
|
|
|
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.
|
|
|
|
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 |
|
|
|
|
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 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.
|
|
|
|
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.
|
|
|
|
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.
|
|
|
|
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 Thanks, Rob
|
|
|
1 members (Ruben),
1,277
guests, and
207
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|