Welcome to WebmasterWorld Guest from 23.22.136.56

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

What causes mysql 145 error?

     
1:52 pm on Aug 8, 2007 (gmt 0)

New User

10+ Year Member

joined:Mar 3, 2005
posts:27
votes: 0


I am getting the accursed: 1016 Can't open file: 'phpbb_topics.MYI' (errno: 145)

It's easy to fix through phpmyadmin as other threads have stated, but the error is recurring, at least every day, and now driving me nuts.

So I wonder if anyone knows the cause. What is corrupting the table? Has anyone else had this experience?

2:12 pm on Aug 8, 2007 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15756
votes: 0


I have had similar problems with phpbb, not really sure of the cause, I think we had issues with too few connections/high load and corruption connected with that and once it was switched to a dedicated server it was fine

I used to have to repair tables on a fairly regular basis but can't remember doing ti once the server switch happened.

1:19 am on Aug 9, 2007 (gmt 0)

New User

10+ Year Member

joined:Mar 3, 2005
posts:27
votes: 0


Thanks for the reply.

It's odd as it has been running happily for years. We have plenty of disk space left and the traffic to the site has not increased enough to cause a problem.

Could it be an issue with the version of MySQL? We are using version 4.1.21.

2:12 am on Aug 9, 2007 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15756
votes: 0


no not version, but I am not talking about disk space, more like traffic specifically to mysql, at some point when the number of writes get high enough there will be problems, where that line is depends on the setup
9:12 am on Aug 9, 2007 (gmt 0)

New User

10+ Year Member

joined:Mar 3, 2005
posts: 27
votes: 0


There must be mysql traffic that I am not seeing then. The phpbb traffic has not increased, but now I realise there could be an increase on other database I haven't noticed.

Is it possible that an attack on a Wiki search page could cause a spike in traffic? I've just noticed that that table has an error too.

Many thanks for the help by the way.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members