tag:support.flying-sphinx.com,2011-01-05:/discussions/problems/3331-lost-connectionsFlying Sphinx: Discussion 2017-05-11T23:09:39Ztag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-03T13:55:29Z2017-02-03T13:55:29ZLost Connections<div><p>Hi Forrest,</p>
<p>There aren't any known issues with rusina, nor with FS
generally, so this is certainly surprising. I'll have a hunt around
on the server right now to see if there are any clues there.</p>
<p>Are any searches working at the moment? Is the problem
intermittent, or everything's failing consistently?</p>
<p>Regards,</p>
<p>Pat</p></div>Pat Allantag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-03T14:00:38Z2017-02-03T14:00:38ZLost Connections<div><p>I haven't been able to get a successful query through since
opening the ticket, but it appears to be intermittent. Looks like
the first error was ~1.5hrs ago but the error count doesn't
<em>look</em> high enough that it's failing on every request.</p></div>forresttag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-03T14:03:41Z2017-02-03T14:03:41ZLost Connections<div><p>Seems like similar errors were flagged during this outage ~11
months ago:<br>
<a href="http://support.flying-sphinx.com/discussions/problems/2084-having-issues-with-flying-sphinx-connections">
http://support.flying-sphinx.com/discussions/problems/2084-having-i...</a></p>
<p><a href="http://status.flying-sphinx.com/incidents/6g18cc3cgcnl">http://status.flying-sphinx.com/incidents/6g18cc3cgcnl</a></p></div>forresttag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-03T14:05:59Z2017-02-03T14:05:59ZLost Connections<div><p>New error: ThinkingSphinx::ConnectionError: Error connecting to
Sphinx via the MySQL protocol. Error connecting to Sphinx via the
MySQL protocol. Can't connect to MySQL server on
'ec2-54-242-154-181.compute-1.amazonaws.com' (111) - SELECT * FROM
<code>matter_core</code>, <code>matter_delta</code> WHERE
<code>sphinx_deleted</code> = 0 ORDER BY <code>updated_at</code>
DESC LIMIT 0, 20; SHOW META</p></div>forresttag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-03T14:11:41Z2017-02-03T14:11:41ZLost Connections<div><p>The Sphinx proxy seems to suddenly have gained an issue on the
primary Rusina server (restarting the proxy didn't help, but that
was the cause of the second error).</p>
<p>Have just switched over to the failover Rusina server, can you
confirm whether that's working as expected now?</p></div>Pat Allantag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-03T14:12:50Z2017-02-03T14:12:50ZLost Connections<div><p>Yes it's back - thanks for the prompt response!</p></div>forresttag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-03T14:59:56Z2017-02-03T14:59:56ZLost Connections<div><p>Just further to this: the Sphinx proxy is now working again on
what was the primary server (which is now the new failover).
Considering this issue resolved, but if you see a return of it, do
let me know!</p></div>Pat Allantag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-03T16:25:00Z2017-02-03T16:25:00ZLost Connections<div><p>Thanks, Pat. Will you be able to add better monitoring for these
types of issues going forward or should I assume that a ticket will
need to be opened?</p>
<p>I disregarded the first round of errors I saw (at 4:30am my
time) because <em>usually</em> sphinx will recover itself.</p></div>forresttag:support.flying-sphinx.com,2011-01-05:Comment/418824662017-02-04T01:35:55Z2017-02-04T01:35:55ZLost Connections<div><p>Hi Forrest</p>
<p>I’ve just rolled out some better error monitoring for the
Sphinx proxy, so I should definitely have visibility on this issue
if/when it crops up again.</p>
<p>Cheers,</p>
<p>— Pat</p></div>Pat Allan