Gå till huvudinnehåll

MySQL "writing file" error

i General Issues
Författarlista
Publicerad: 16 aug. 2022|Senast Uppdaterad: 16 aug. 2022

Question:

I am getting MySQL errors from my Deskpro On-Premise install every few minutes. It says 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.

Deskpro On-Premise monitors disk space usage and is configured to alert at the following levels:

Severity

Usage

Low

75% full

Medium

85% full

High

95% full

If you need instruction as to how to query the disk space, see this page for more information.

HjälpfullOanvändbar
nästa sidaHow do I reset the OPC master password in Deskpro On-Premise?
föregående sidaI've lost admin permissions and I'm locked out of Deskpro On-Premise

Logga in eller registrera dig för att lämna en kommentar.