tag:support.flying-sphinx.com,2011-01-05:/discussions/problems/2080-thinkingsphinxsphinxerror-lost-connection-to-mysql-server-at-reading-authorization-packetFlying Sphinx: Discussion 2016-07-27T23:44:34Ztag:support.flying-sphinx.com,2011-01-05:Comment/392913372016-02-29T20:20:21Z2016-02-29T20:20:21ZThinkingSphinx::SphinxError: Lost connection to MySQL server at 'reading authorization packet',<div><p>Hi,<br>
I am using heroku and I got this exception about 100 times for the
last few hours:</p>
<p>" Lost connection to MySQL server at 'reading authorization
packet', system error: 0 - SELECT * FROM <code>episode_core</code>
WHERE MATCH('ev3 color sensor') AND <code>tag_ids</code> = 52 AND
<code>published_at</code> BETWEEN 0 AND 1456774436 AND
<code>sphinx_deleted</code> = 0 LIMIT 0, 20 OPTION
field_weights=(name=20, description=15, long_description=10,
materials=5, tag_names=10, subtitles_html_content=5,
categories_names=20); SHOW META
app/controllers/episodes_controller.rb:32:in `index' " It has never
happen before.</p>
<p>What could I do?</p></div>kiril mitovtag:support.flying-sphinx.com,2011-01-05:Comment/392913372016-02-29T22:04:25Z2016-02-29T22:04:25ZThinkingSphinx::SphinxError: Lost connection to MySQL server at 'reading authorization packet',<div><p>Hi Kiril</p>
<p>This issue should be resolved:<br>
<a href="http://status.flying-sphinx.com/incidents/6g18cc3cgcnl">http://status.flying-sphinx.com/incidents/6g18cc3cgcnl</a></p>
<p>But, if you're still seeing problems, can you let me know the
app's name and I'll investigate further.</p>
<p>Thanks for your patience, and very sorry for this outage!</p>
<p>Kind regards,</p>
<p>Pat</p></div>Pat Allan