Lots of database errors

[borbole]

Originally Posted by Floyd R Turbo

Snakes, I ran a repair on all tables actually before you said to optimize. Is there any harm done in repairing vs optimizing?

borbole, I believe it is a shared server. I'm not big enough for a dedicated server or vps (I'm guessing that means virtual private server). I have read that running vb on a shared server can cause issues with temporary tables created during queries, could that be what is going on? I need to have them bump up my allowable table size or shared space?

I also heard godaddy is a PITA for this stuff.

Indeed, hence why I asked about your hosting plan. If the table keep crashing repeatedly then it would be best to contact your host. If they will not be able to fix it then maybe it is time to start looking for a new host.

[Floyd R Turbo]

My site is not that active. I have less than 100 users, and I do have people register successfully, just not that often, only a couple a month.

So it seems to me that someone is trying to 'ping' the database or something. Maybe someone can explain to me what actually causes the error. Because to me it does not make sense that I get this error message

Invalid SQL:
SHOW COLUMNS FROM user LIKE 'username';

MySQL Error   : Incorrect key file for table '/tmp/mysqltmp/#sql_1851_0.MYI'; try to repair it

for Usernames that are not registered!! Like these, all received in the last 24 hours

IP Address    : 118.101.4.158
Username      : HumbertoC

IP Address    : 91.207.8.157
Username      : tzhang216

IP Address    : 188.123.248.25
Username      : Flapidolilt

IP Address    : 108.61.95.217
Username      : ShanaZSS

IP Address    : 222.76.80.244
Username      : turejrn

IP Address    : 109.169.82.12
Username      : DanuncoqH

IP Address    : 75.136.23.77
Username      : DonaldRHW

IP Address    : 113.212.68.20
Username      : MartaMont

IP Address    : 5.9.251.139
Username      : Antoinett

So it's not like someone is trying to register and failing. They are trying to do SOMETHING that seems to set off this error. It seems like bot or spammer activity or something.

[snakes1100]

This error doesnt mean the table crashed.

MySQL Error : Incorrect key file for table '/tmp/mysqltmp/#sql_XXXX_0.MYI'; try to repair it

[Floyd R Turbo]

Ok...so what is going on here? I get this error message randomly throughout the day. It always has a Username listed that is not registered.

[snakes1100]

As i posted before, it can be triggered a few different ways, this is a issue with the low resource over sold server your on.

If the query is triggered & sql reaches a timeout or if it by chance crashes, that tmp file will be created, then marked invalid, as the key is no longer valid.

That could come from a simple large join query/order by, tat your site is running, i doubt your going to get away from it.

Do you get any other error fro msql, like the server has gone away?

[Floyd R Turbo]

Yes, I do occasionally get the 'server has gone away' error, and yesterday the site was down for a period of time.

Help me out here. What is a 'large join query' or 'order by'?

Also I still don't understand why this error keeps happening and flags a username that does not exist.

--------------- Added [DATE]1363715363[/DATE] at [TIME]1363715363[/TIME] ---------------

From yesterday, while the forum was down (like a server was unplugged!!)

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'turboforum.db.XXXXXXXXX.hostedresource.com' (0)
/home/content/XX/XXXXXXXXX/html/vb4/includes/class_core.php on line 317

another one from a few days ago

Database error in vBulletin 4.2.0:

Invalid SQL:
SHOW COLUMNS FROM user LIKE 'username';

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Friday, March 15th 2013 @ 10:54:49 PM
Error Date    : Friday, March 15th 2013 @ 10:54:49 PM
Script        : http://www.turbosaquatics.com/vb4//register.php?do=addmember
Referrer      : http://www.turbosaquatics.com/vb4//register.php?
IP Address    : 27.153.231.63
Username      : frierobia
Classname     : vB_Database
MySQL Version :

Again, a user that does not exist

Another that I have seen once or twice

Database error in vBulletin 4.2.0:

Invalid SQL:

			SELECT title, template
			FROM template
			WHERE templateid IN (14,78,79,67,51,60,0,20,80,81,109,4,3,576,605,566,567,569,575,574,402,403,404,405,158,159,406,411,407,408,409,412,413,414,415,416,467,469,471,473,475,522,521,524,525,528,529,771,941,947,580,578,581,583,582,584,585,586,587,588,589,590,595,592,594,591,593,604,606,607,616,598,609,610,611,612,614,577,603,608,617,613,619,618,615,695,1030,1040,981,1051,0,0,429,423,422,427,428,426,425,430,431,432,737,1033,683,687,684,685,686,1049,0,0,1012,1014,707,708,710,711,934,976,975,1025,977,534,533,537,85,361);

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Wednesday, March 13th 2013 @ 09:26:00 AM
Error Date    : Wednesday, March 13th 2013 @ 09:27:30 AM
Script        : http://www.turbosaquatics.com/vb4/member.php?7-halfmoon&tab=activitystream&type=friends&page=105
Referrer      : 
IP Address    : 66.249.74.210
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

[snakes1100]

I think you have 420 on the brain, i said JOIN

It doesnt matter what the username is, its the query thats being called that is most likely the culprit.

As ive already explained what im thinking it is, this is a server issue & i dont believe your gonna be able to get them to correct it, as its a over sold poopie vhost server.

[Floyd R Turbo]

Ok I understand your position on GoDaddy.

I am still trying to understand something here. When a query is called, does it have to have a username attached to it? So obviously SOMEthing is calling the query. Whatever is calling the query is choosing a username. What kind of program does this sort of thing?

Is it POSSIBLE that people are trying to register, and are not being successful? Or is this likely Bot and/or spammer activity?

I have an announcement on my site stating to contact me via the contact us link if anyone is having a problem registering. So far, no one has. That only happened once, a while back, and the error message I received included their e-mail address.

[snakes1100]

Its hard to say what is causing it as i dont have access to the server logs.

I didnt specify godaddy, i was talking about the server itself, which many hosts like them do just that, over sell a server & severly limit resource usage, especially for a db driven site.

If your getting both those errors error 28 & 2006, id get off that server.

--------------- Added [DATE]1363716457[/DATE] at [TIME]1363716457[/TIME] ---------------

Im guessing there is going to be a gone away error here with a time stamp earlier than the following tmp error.

Time stamp from the original post for the tmp error:
Request Date : Wednesday, March 13th 2013 @ 09:19:55 AM
Error Date : Wednesday, March 13th 2013 @ 09:20:05 AM

Gone away error:
Request Date : Wednesday, March 13th 2013 @ 09:26:00 AM
Error Date : Wednesday, March 13th 2013 @ 09:27:30 AM

[Floyd R Turbo]

I haven't received the ^ error recently... but here is a new one,

atabase error in vBulletin 4.2.0:

Invalid SQL:

			SELECT  pm.*, pmtext.*
				, icon.title AS icontitle, icon.iconpath
			
			FROM pm AS pm
			LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
			LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
			
			WHERE pm.userid=77 AND pm.folderid=-1
			
			
			ORDER BY pmtext.dateline DESC
			LIMIT 0, 50;

MySQL Error   : Got error -1 from storage engine
Error Number  : 1030
Request Date  : Sunday, March 24th 2013 @ 02:44:00 PM
Error Date    : Sunday, March 24th 2013 @ 02:44:00 PM
Script        : http://www.turbosaquatics.com/vb4/private.php?folderid=-1
Referrer      : https://www.turbosaquatics.com/vb4/private.php?folderid=0
IP Address    : 65.128.243.236
Username      : **********
Classname     : vB_Database
MySQL Version :

Tagged to a recently registered user whom I have communicated with, so I don't think he's a bot. What's this one?

Also I did call GoDaddy and I'm on a shared server with a database size limit of 2GB. Even though my current database is not even 200MB I have a feeling that will not be enough space, and soon.