Sphinx as built-in SE causes server crashes?

Polyglot Projects Sphinx & Full-Text Search
1

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

2

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

3

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

Maciek

4

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…