Issue in search data

kaushal

08 Sep, 2022 04:40 PM

Edit

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

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

#1 Posted by Pat Allan Support staff on 10 Sep, 2022 07:51 AM
- Edit
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 only staff will see it

Name

Markdown

Attaching KB article:

» »

Already uploaded files

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

Attach files

Up to 10MB each.

Spam protection: What color is the sun?

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

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

Flying Sphinx Support