or Create a profile

Home → Problems →

Issue in search data

kaushal's Avatar

kaushal

08 Sep, 2022 04:40 PM

Facing below issue on indexing

indexing index 'contact_core'...
ERROR: index 'contact_core': sql_fetch_row: Out of sort memory, consider increasing server sort buffer size.
total 0 docs, 0 bytes

  1. Support Staff 1 Posted by Pat Allan on 10 Sep, 2022 07:51 AM

    Pat Allan's Avatar

    Hi there,

    As best as I can tell, this is due to memory limits on your MySQL database. I would recommend increasing the sort_buffer_size setting there and see if that helps resolve the problem.

    I’ve discussed this issue with others using Thinking Sphinx here:
    https://github.com/pat/thinking-sphinx/issues/819

    Please do let me know if that doesn’t fix the issue!

    Kind regards,

    — Pat

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Screenshot_2022-09-08_at_10.10.18_PM.png 90.3 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

  • New Issue

  • Conversation Started

    A conversation has been started with the Flying Sphinx staff to resolve this discussion.

  • Close the discussion

Private Permissions

This discussion is private. Only you and Flying Sphinx support staff can see and reply to it.

Public Permissions

This discussion is public. Everyone can see and reply to it.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

01 Sep, 2024 04:04 PM delayed job index issue
24 Aug, 2024 07:45 AM configuration issue
30 Aug, 2023 01:42 PM Heroku Flying Sphinx changes status to Not Running randomly
10 Sep, 2022 07:51 AM Issue in search data
20 Jun, 2022 05:10 AM ts:rebuild/ts:stop/ts:start not working on heroku

Recent Articles

Setting your Sphinx version
Reducing index data size
Daemon failing to start: bind() failed on 0.0.0.0
Installing with Rails 2.3
Installing with Rails 3