Title: Database error
Last modified: January 1, 2026

---

# Database error

 *  [gasmas75](https://wordpress.org/support/users/gasmas75/)
 * (@gasmas75)
 * [3 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-427/)
 * Hello,
 * Thank you for this plugin, it helps a lot with a large website. The only issue
   I have is, since I installed it I get periodically errors in the log.
 * `[01-Jan-2026 08:48:25 UTC] WordPress database error Error writing file '/tmp/
   MYfd=585' (OS errno 28 - No space left on device) for query SELECT DISTINCT(relevanssi.
   doc), relevanssi.*, relevanssi.title * 5 + relevanssi.content * 1 + relevanssi.
   comment * 0.75 + relevanssi.tag * 0.75 + relevanssi.link * 0 + relevanssi.author
   + relevanssi.category * 0.75 + relevanssi.excerpt + relevanssi.taxonomy + relevanssi.
   customfield + relevanssi.mysqlcolumn AS tf FROM wp_relevanssi AS relevanssi WHERE(
   relevanssi.term LIKE 'bull%' OR relevanssi.term_reverse LIKE CONCAT(REVERSE('
   bull'), '%')) AND ( relevanssi.doc IN ( SELECT DISTINCT(posts.ID) FROM wp_posts
   AS posts WHERE posts.post_type IN ('post') ) ) ORDER BY tf DESC LIMIT 500 made
   by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query,
   WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters,
   relevanssi_query, relevanssi_do_query, relevanssi_search`
 * I can assure you that the space or inodes are not an issue, since the hosting
   server is managed my myself and it’s a dedicated WHM that hosts also other websites
   managed my me. I have tried to recreate the index, which it does without problems,
   but the errors are still appearing.
 * PHP version 8.2, MySQL 8.0

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Mikko Saari](https://wordpress.org/support/users/msaari/)
 * (@msaari)
 * [3 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-427/#post-18772090)
 * Unfortunately, I know very little of the technical side of databases. I don’t
   know what else could cause this except a lack of space on the `/tmp/` partition.
   If that cannot be the problem, I would recommend asking about this on a forum
   focused on MySQL server stuff, as this doesn’t sound like a Relevanssi problem–
   this very much looks like a database server problem.
 *  Thread Starter [gasmas75](https://wordpress.org/support/users/gasmas75/)
 * (@gasmas75)
 * [3 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-427/#post-18772102)
 * Thank you for your fast reply. I would understand if that was a MySQL problem
   if there were more database errors for other queries irrelevant to Relevanssi.
   But all errors are from this plugin.
 * It doesn’t affect the website, the only concern is that it fills up the error
   log.
 *  Plugin Author [Mikko Saari](https://wordpress.org/support/users/msaari/)
 * (@msaari)
 * [3 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-427/#post-18772150)
 * Well, the error message says twice it’s a database error, and doesn’t really 
   say anything about it being a Relevanssi error except that it’s triggered from
   a Relevanssi query, so based on that that’s all I can say.
 * But as I said, I don’t know anything about debugging MySQL server error states,
   so a forum dedicated for that is guaranteed to be more helpful here.

Viewing 3 replies - 1 through 3 (of 3 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-427%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/relevanssi/assets/icon-256x256.png?rev=2025044)
 * [Relevanssi - A Better Search](https://wordpress.org/plugins/relevanssi/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/relevanssi/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/relevanssi/)
 * [Active Topics](https://wordpress.org/support/plugin/relevanssi/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/relevanssi/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/relevanssi/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 3 replies
 * 2 participants
 * Last reply from: [Mikko Saari](https://wordpress.org/support/users/msaari/)
 * Last activity: [3 months, 2 weeks ago](https://wordpress.org/support/topic/database-error-427/#post-18772150)
 * Status: not resolved