Database error

  • Imagegasmas75

    (@gasmas75)


    3 weeks, 3 days ago

    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 ImageMikko Saari

    (@msaari)

    3 weeks, 3 days ago

    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 Imagegasmas75

    (@gasmas75)

    3 weeks, 3 days ago

    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 ImageMikko Saari

    (@msaari)

    3 weeks, 3 days ago

    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 to reply to this topic.

Tags