Help with errors coming from Mysql02

[jimnyc]

I've gotten 10 auto generated emails at around 7pm (EST). They referenced the follwing 2 errors. Has anyone found out the exact cause of this one yet, which I've been getting on and off for over 2 moths?:

Invalid SQL: SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
ORDER BY user.username
mysql error: Got error 12 from table handler

mysql error number: 1030

And this is a new one to me:

Link-ID == false, connect failed
mysql error: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug

mysql error number: 1135

I know it's not my board, as it is now functioning properly and has been for quite some time (without any intervention from me at all). Are these due to server overloads from other users? I've seen these errors popping up on the forums for quite some time but have yet to see any type of official response as to what action has or will be taken.

[HalfaBee]

Try repairing the tables.

REPAIR TABLE moderator

or if you use mysql-front

tools->table-diagnostics

HalfaBee

[jimnyc]

Thanks, Halfabee!

The "Got error 12 from table handler" has been talked about in length both here and at vBulletins forum. The problem was supposed to be fixed with the Apache upgrade (and it was a huge boost). The errors went from maybe 10-20 a day to one or 2 every couple of days. It's been ruled out by vBulletin developers who looked over my tables and verified all is fine. I restored my exact database to my other domain hosted elsewhere and tested it out with a small following of mine and had zero errors. (before anyone states it, I love powweb and the other provider isn't suitable for my needs!)

The 2nd error (Link-ID == false, connect failed) is clearly just the www server not communication effectively with the Sql server for whatever reason. Powweb has acknowledged this server is the cause by asking if I would like to be moved to an alternate server, that they don't have a solution as of yet.

Thanks for the response, as it helps since I do use mysql front for my administration! I'm just trying to get a grasp on these errors, in case there is something I can do on my end as well to minimize the problem.

[Cabinetmaker]

I have the same problem/same errors on my site. :(

[xclicks]

Getting the same, or similar error on my site. I'm
new to php and figured it was something wrong in the
script. I am running a traffic exchange script, not vBulletin.

Ironically, I came here for help on the same problem and
this was the first post I read ... Powweb's communically rocks!

Ran diagnostics, checked and repaired. I have to
wait and see if that helps (thanks HalfaBee).

Should I request to be moved to an alternate server?

Thanks

[HalfaBee]

I did a modification to a traffic exchange that repaired the tables when the error occured.
Stopped a lot of problems.

HalfaBee

[xclicks]

Originally posted by HalfaBee
I did a modification to a traffic exchange that repaired the tables when the error occured.
Stopped a lot of problems.

HalfaBee

Is that a very difficult modification? I don't have a clue.