• tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Topic: Always corrupt table posts.MYI

Hi,

I have got a multi forum server. One week ago I change server to the new one. I change also MySQL form 4.xx to 5.0.24a and php4 to php5. From this days I have got problem with data base. Few times a day I have got corrupt table posts.MYI in few forumus. Always corrupted is posts.MYI roll Why ?

Have you any ideas what is going on ?

Darmowe forum - Polish free forum hosting

tomekf's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Always corrupt table posts.MYI

Sounds like a problem with the MySQL server

  • tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Re: Always corrupt table posts.MYI

This is my MySQL log

061025 13:33:05 [ERROR] /usr/libexec/mysqld: Table './pun_l2/posts' is marked as crashed and last (automatic?) repair failed
061025 16:20:20 [ERROR] /usr/libexec/mysqld: Table './pun_l2/posts' is marked as crashed and last (automatic?) repair failed
061025 16:20:20 [ERROR] /usr/libexec/mysqld: Table './pun_l2/posts' is marked as crashed and last (automatic?) repair failed
061025 20:10:08 [ERROR] Got error 12 when reading table './pun_seductionpoland/posts'
061025 20:10:17 [ERROR] Got error 12 when reading table './pun_seductionpoland/posts'
061025 20:11:57 [ERROR] Got error 12 when reading table './pun_seductionpoland/posts'
061025 20:46:51 [ERROR] /usr/libexec/mysqld: Got error 12 from storage engine
061025 20:46:51 [ERROR] /usr/libexec/mysqld: Sort aborted
061025 20:52:06 [ERROR] Got error 12 when reading table './pun_seductionpoland/posts'
061025 21:15:25 [ERROR] Got error 12 when reading table './pun_mrr/posts'
061025 22:00:31 [ERROR] Got error 12 when reading table './pun_seductionpoland/posts'
061025 22:00:57 [ERROR] Got error 12 when reading table './pun_seductionpoland/posts'
Darmowe forum - Polish free forum hosting

tomekf's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Always corrupt table posts.MYI

I'd ask your host or in the MySQL forums. It could be that the server runs out of physical memory. Not sure though.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • tomekf
  • Senior Member
  • Offline
  • From: Poland
  • Registered: 2005-10-30
  • Posts: 104

Re: Always corrupt table posts.MYI

It's my own server with enough physical memory smile I wonder why posts.MYI is always corrupted. Maybe it is happens because I have in post table message TEXT NOT NULL DEFAULT roll

Darmowe forum - Polish free forum hosting

tomekf's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Always corrupt table posts.MYI

Nah, that shouldn't affect anything. I'm sorry, but I don't know. I'd ask in the MySQL forums.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Always corrupt table posts.MYI

Last time I saw tables randomly crash I believe it was due to some bad MySQL libs: I'd try compiling it again