Forums / General Questions / Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

Views: 4,117

Results 1 to 8 of 8
30 May 2013, 4:50 PM
#1
navido avatar

navido

Zen Follower

Join Date:
Sep 2008
Posts:
221
Plugin Contributions:
0

Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

I get the error:
Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28)

This appears at https://www.fotoexperten.no

As i have understood this has to do with filled up disc place. I have deleted the /tmp folder in my root folder but still i get this message. Can anyone help me? Do i have to contact my host to let theme free up space?

30 May 2013, 6:25 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

Yes. check with your hosting provider as they need to deal with the server tmp folder, which is different than the one you deleted ...

I am also assuming that by saying you deleted your /tmp directory you really mean you "cleaned it out" and it is still there ... :lookaroun

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

30 May 2013, 6:40 PM
#3
navido avatar

navido

Zen Follower

Join Date:
Sep 2008
Posts:
221
Plugin Contributions:
0

Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

Ajeh:

Yes. check with your hosting provider as they need to deal with the server tmp folder, which is different than the one you deleted ...

I am also assuming that by saying you deleted your /tmp directory you really mean you "cleaned it out" and it is still there ... :lookaroun

The folder itself is there but the content of the temp folder is empty. It shouldnt be any problem right? I took a backup of it though.

30 May 2013, 8:08 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

Zen Cart does not use the /tmp directory for anything ... it is more or less if there needs to be a /tmp then you want to ensure it is still there for something else on your site that does use it ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

31 May 2013, 2:25 PM
#5
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

navido:

Do i have to contact my host to let them free up space?

Yes. In fact this is the only thing you can do. The problem is entirely out of your control.

Cheers
Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

31 May 2013, 8:52 PM
#6
allthingsidleroy avatar

allthingsidleroy

New Zenner

Join Date:
May 2013
Posts:
38
Plugin Contributions:
0

Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

Sometimes hosting services that offer jailed access to the command line don't revoke the 'mount' command. If you need access and are doing this through the command-line, you might try creating a directory in your home folder and binding a different part of the filesystem (in this case /tmp) to that folder. Here's an example:

mkdir tempFolder/
mount --bind /tmp tempFolder/

Most likely you won't have permissions to do this, but it is worth a shot.

1 Jun 2013, 7:26 AM
#7
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

allthingsidLeroy:

Sometimes hosting services that offer jailed access to the command line don't revoke the 'mount' command. If you need access and are doing this through the command-line, you might try creating a directory in your home folder and binding a different part of the filesystem (in this case /tmp) to that folder. Here's an example:

mkdir tempFolder/
mount --bind /tmp tempFolder/

> 
> Most likely you won't have permissions to do this, but it is worth a shot.

Can I ```
mkdir tempFolder/
mount --bind /etc tempFolder/

So I can read the passwd file ?

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

3 Jun 2013, 1:18 PM
#8
allthingsidleroy avatar

allthingsidleroy

New Zenner

Join Date:
May 2013
Posts:
38
Plugin Contributions:
0

Re: Can't create/write to file '/tmp/#sql_85a56_1.MYI' (Errcode: 28) - need urgent help

RodG:

So I can read the passwd file ?

It really depends on how the permissions are set in the /etc folder. This whole scenario requires a hosting service which does not expect a user to have access to the root folders of a system. Most hosting services will properly jail a user to their home directory with little-to-no chance of accessing other parts of the system, but many will not.

Like I said, it's worth a shot, but it likely isn't going to happen.