Sudden MySQL errors

[Beowolf]

My vB board has been working fine for years until yesterday, when I started getting some errors, for example when I try to check private messages or log into the admin cp.

Admin CP error:

There seems to have been a slight problem with the Barracks Network Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.7:

Invalid SQL: 
		SELECT setting.*, settinggroup.grouptitle
		FROM settinggroup AS settinggroup
		LEFT JOIN setting AS setting USING(grouptitle)
		WHERE settinggroup.displayorder <> 0
		ORDER BY settinggroup.displayorder, setting.displayorder
	
mysql error: Can't create/write to file '/tmp/#sql_31f3_0.MYD' (Errcode: 17)

mysql error number: 1

Date: Friday 09th of December 2005 04:32:31 PM
Script: http://barracksnetwork.com/forum/admincp/options.php?null=0
Referer: http://barracksnetwork.com/forum/admincp/index.php?do=nav
Username: Beowolf
IP Address: 69.168.32.43

Private Messages error:

Database error in vBulletin 3.0.7:

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=1 AND pm.folderid=0
			ORDER BY pmtext.dateline DESC
			LIMIT 0, 50
		
mysql error: Can't create/write to file '/tmp/#sql_31f3_0.MYD' (Errcode: 17)

mysql error number: 1

Date: Friday 09th of December 2005 04:34:26 PM
Script: http://barracksnetwork.com/forum/private.php?
Referer: http://barracksnetwork.com/forum/
Username: Beowolf
IP Address: 69.168.32.43

How could this all of a sudden start happening? Maybe something my host did? I'm running 3.0.7, and I was just trying to upgrade to 3.5.2 but I can't get into my admin panel.

[Beowolf]

I ran repair/optimize, my admin panel is now working but checking PMs still are not :\

[Steve Machol]

This is the first time I'ver ever seen this error:

System error: 17 = File exists

For some reason your system is trying to create a tmp file that already exists. I'd ask your host to clear out the /tmp directory.

[Beowolf]

This is the first time I'ver ever seen this error:

System error: 17 = File exists

For some reason your system is trying to create a tmp file that already exists. I'd ask your host to clear out the /tmp directory.

Ok.