# Sphinx as built-in SE causes server crashes?

**URL:** <https://forums.percona.com/t/sphinx-as-built-in-se-causes-server-crashes/2063>\
**Category:** Sphinx & Full-Text Search\
**Created:** [January 5, 2007, 1:27pm UTC](https://forums.percona.com/t/sphinx-as-built-in-se-causes-server-crashes/2063 "2007-01-05T13:27:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mushu](https://avatars.discourse-cdn.com/v4/letter/m/b5e925/32.png) [@mushu](https://forums.percona.com/u/mushu)\
**Post date:** [January 5, 2007, 1:27pm UTC](https://forums.percona.com/t/sphinx-as-built-in-se-causes-server-crashes/2063/1 "2007-01-05T13:27:08Z")

</div>

Hey,

I’ve been using MySQL 5.1.14 for last few weeks without any problems. Yesterday I compiled it with Sphinx storage engine (built-in, not as a pluggable module) and weird things started to show up. The server crashes randomly on deletes and updates to MyISAM(!) tables _if any_ Sphinx table has been accessed since mysqld startup. Does anyone else experience such behaviour? I’m not sure if it’s Sphinx SE falut or not, but that is the only thing that changed, so this would be the most obvious.

Another thing is the warning that server logs at each startup:  
[Warning] Storage engine ‘SPHINX’ has conflicting typecode. Assigning value 42.

Maciek

---

<div class="post-metadata">

**Author:** ![bluesaga](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@bluesaga](https://forums.percona.com/u/bluesaga)\
**Post date:** [January 9, 2007, 5:44pm UTC](https://forums.percona.com/t/sphinx-as-built-in-se-causes-server-crashes/2063/2 "2007-01-09T17:44:33Z")

</div>

Thank you for the replies, but unfortunatelly the posts are empty. Something ate their bodies. 😕

---

<div class="post-metadata">

**Author:** ![mushu](https://avatars.discourse-cdn.com/v4/letter/m/b5e925/32.png) [@mushu](https://forums.percona.com/u/mushu)\
**Post date:** [January 14, 2007, 4:52pm UTC](https://forums.percona.com/t/sphinx-as-built-in-se-causes-server-crashes/2063/3 "2007-01-14T16:52:01Z")

</div>

Thank you for the replies, but unfortunatelly the posts are empty. Something ate their bodies. 😕

Maciek

---

<div class="post-metadata">

**Author:** ![shodan](https://avatars.discourse-cdn.com/v4/letter/s/9f8e36/32.png) [@shodan](https://forums.percona.com/u/shodan)\
**Post date:** [January 15, 2007, 1:07am UTC](https://forums.percona.com/t/sphinx-as-built-in-se-causes-server-crashes/2063/4 "2007-01-15T01:07:44Z")

</div>

Long story short, this seems like a known bug in 0.9.6 SE vs 5.1.x MySQL, so please contact me for for a beta version of forthcoming 0.9.7.

Hope this one gets through…