Zum Hauptinhalt springen

MySQL "writing file" error - Wissensdatenbank / Deskpro Legacy - Deskpro Support

WARNING: You're browsing documentation for an older version of Deskpro. Consider upgrading to Deskpro Horizon

MySQL "writing file" error

Autorenliste

Question:

I am getting MySQL errors from my Deskpro On-Premise install very few minutes. They say that 'an exception occurred while executing' various queries. After the query is the line:

SQLSTATE[HY000]: General error: 3 Error writing file X (Errcode: 28)

or

SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine

where X is a temporary file of some kind. What is causing this?

Answer:

This means MySQL is running out of disk space when it tries to write a temporary file.

Increase the disk space available to MySQL. Even if it appears that there is still space available on the disk, it's best to leave a minimum of 10GB free.

 

Hilfreich Nicht hilfreich

48 von 90 Personen fanden diese Seite hilfreich

Fügen Sie einen Kommentar hinzu

Bitte loggen Sie sich ein oder melden Sie sich an, um einen Kommentar zu hinterlassen.

Benötigen Sie eine Passwort-Erinnerung?