or Create a profile

Home → Problems →

Connection Error with Sphinx

Sergey Pozhidaev's Avatar

Sergey Pozhidaev

24 Feb, 2022 10:09 AM

Hello, I am getting an error when I try to search -
ThinkingSphinx::ConnectionError (Error connecting to Sphinx via the MySQL protocol. Error connecting to Sphinx via the MySQL protocol. Lost connection to MySQL server at 'reading authorization packet'
At the same time, restarting the sphinx with the ts:stop ts:start command does not help. If you reboot the dyno, then the search works for a while. Can you suggest what is the problem?
App - stark-cloud-2613-pr-90 with Wooden Sphinx

Thanks.

  1. Support Staff 1 Posted by Pat Allan on 24 Feb, 2022 10:24 AM

    Pat Allan's Avatar

    Hi Sergey,

    I’m not quite sure what the cause is, but I’ve restarted the Sphinx proxy to see if that helps. I can connect to the daemon without any issues, I would expect your app now can as well. If you find the problem returns, though, please do let me know.

    Kind regards,

    —
    Pat Allan

Reply to this discussion

Internal reply

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

Attaching KB article:

»

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

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
10 Apr, 2022 07:06 PM Unknown MySQL error
10 Apr, 2022 12:01 AM Error deploying Flying Sphinx

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