[SOLVED][Drupal] database error "Got error 28 from storage engine query: SELECT DISTINCT(p.perm)"

| | 1 min read

Many Drupal users have encountered a lot of instances of the following error in the dblog of their site "Got error 28 from storage engine query: SELECT DISTINCT(p.perm)". If you found yourself encountering the same error in your Drupal website then read on to find out the solution.

Most of the time this occurs in shared hosting sites with the MySQL server running out of disk space. So the following tips will help to solve the issue.

  • Clean up your /var/log/mysql
  • Clear your /tmp directory or request your host to do so. (This solved it for a lot of users).

Hope that helps.

The easiest way to solve a Drupal issue is to hand it to the Drupal experts. We can provide a wide range of Drupal services to help you maintain and manage your Drupal websites. Get in touch with us to know more.