cancel
Showing results for 
Search instead for 
Did you mean: 

General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

Hi,

Can anyone help me resolve this error on my magento website?

There has been an error processing your request
SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_27a0_0.MYI' (Errcode: 28 - No space left on device)

 

I have a dedicated server with go daddy with 1TB of space.

My site is inaccessible.

 

Vik

11 REPLIES

Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

hi,

looks like your server just ran out of space which is nothing to do with Magento.

Just clean some log files and restart mysql.

 

Anton Pachkine @ magento2.hosting : Magento Managed Package. Get your e-commerce health checkup at http://ecommerce.fitness

Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

I did clear up the log files and cache too. But it has something to do with
MySQL TMP folder which is full.

Any idea? Or can you help me clear this error

Vikram

Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

your mysql can be configured to use a different drive.

try to run this command in ssh:

df -h

it will show you which drive is full.

Switch to that drive and see what can be cleaned from there. 

try not to remove .MYI files because it will probably kill your database.

You do keep backups in a remote location for all your files and databases, right?

but the safest way is to have your server admin to fix this.

Anton Pachkine @ magento2.hosting : Magento Managed Package. Get your e-commerce health checkup at http://ecommerce.fitness

Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

When i ran df -h i get the following stats

Filesystem Size Used Avail Use% Mounted on
none 16G 4.0K 16G 1% /dev/shm

I have a dedicated server with 2 TB of space with godaddy out of which 38%
is still available.


Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

something is wrong with your drives configuration.

if you have 2TB drive, you should see that drive when you run "df -h", but instead you see only 16GB dev drive.

try to reboot the server - it may re-mount your drives correctly. if the reboot did not help - check with Godaddy support.

 

Anton Pachkine @ magento2.hosting : Magento Managed Package. Get your e-commerce health checkup at http://ecommerce.fitness

Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

Can you help me out here?

Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

Unfortunately, we can not work with the servers or stores which we do not host.

if your host does not manage your server, you should really get yourself a server admin. for for a one-time fix, search Google for "server administration service" - there are thousands of companies who can help. 

 

Anton Pachkine @ magento2.hosting : Magento Managed Package. Get your e-commerce health checkup at http://ecommerce.fitness

Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

I need a good hosting service. what r your charges for Hosting my store
which is more than 1.5tb in size

Re: General error: 1 Can't create/write to file '/tmp/#sql_c6a_0.MYI' (Errcode: 28)

we can not promote our services on this forum. I'll send you a PM with more details.

 

Anton Pachkine @ magento2.hosting : Magento Managed Package. Get your e-commerce health checkup at http://ecommerce.fitness